First, solve the problem. Then, write the code.

Wednesday, 21 June 2017

single textbox search multiple column like- name and city in angular,

Single textbox search multiple properties - name and city.

ControlerScript.js :

var app = angular
.module("myModule", [])
.controller("myController", function ($scope) {

var employees = [
{ name: "Ben", gender: "Male", salary: 55000, city: "London" },
{ name: "Sara", gender: "Female", salary: 68000, city: "Chennai" },
{ name: "Mark", gender: "Male", salary: 57000, city: "London" },
{ name: "Pam", gender: "Female", salary: 53000, city: "Chennai" },
{ name: "Todd", gender: "Male", salary: 60000, city: "London" },
];

$scope.employees = employees;

$scope.search = function (item) {
if ($scope.searchText == undefined) {
return true;
}
else {
if (item.city.toLowerCase()
.indexOf($scope.searchText.toLowerCase()) != -1 ||
item.name.toLowerCase()
.indexOf($scope.searchText.toLowerCase()) != -1) {
return true;
}
}

return false;
};
});

HtmlPage1.html :

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<script src="Scripts/angular.min.js"></script>
<script src="Scripts/Script.js"></script>
<link href="Styles.css" rel="stylesheet" />
</head>
<body ng-app="myModule">
<div ng-controller="myController">
Search : <input type="text" placeholder="Search city & name"
ng-model="searchText" />
<br /><br />
<table>
<thead>
<tr>
<th>Name</th>
<th>Gender</th>
<th>Salary</th>
<th>City</th>
</tr>
</thead>
<tbody>
<tr ng-repeat="employee in employees | filter: search">
<td> {{ employee.name }} </td>
<td> {{ employee.gender }} </td>
<td> {{ employee.salary }} </td>
<td> {{ employee.city }} </td>
</tr>
</tbody>
</table>
</div>
</body>
</html>

Styles.css

body {
font-family: Arial;
}

table {
border-collapse: collapse;
}

td {
border: 1px solid black;
padding: 5px;
}

th {
border: 1px solid black;
padding: 5px;
text-align: left;

}

search filter by multiple column in AngularJS.

how to search filter by multiple properties in AngularJS. :

Controler Script.js :

var app = angular
.module("myModule", [])
.controller("myController", function ($scope) {

var employees = [
{ name: "Ben", gender: "Male", salary: 55000, city: "London" },
{ name: "Sara", gender: "Female", salary: 68000, city: "Chennai" },
{ name: "Mark", gender: "Male", salary: 57000, city: "London" },
{ name: "Pam", gender: "Female", salary: 53000, city: "Chennai" },
{ name: "Todd", gender: "Male", salary: 60000, city: "London" },
];

$scope.employees = employees;
});

HtmlPage1.html :

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<script src="Scripts/angular.min.js"></script>
<script src="Scripts/Script.js"></script>
<link href="Styles.css" rel="stylesheet" />
</head>
<body ng-app="myModule">
<div ng-controller="myController">
<input type="text" placeholder="Search name" ng-model="searchText.name" />
<input type="text" placeholder="Search city" ng-model="searchText.city" />
<input type="checkbox" ng-model="exactMatch" /> Exact Match
<br /><br />
<table>
<thead>
<tr>
<th>Name</th>
<th>Gender</th>
<th>Salary</th>
<th>City</th>
</tr>
</thead>
<tbody>
<tr ng-repeat="employee in employees | filter: searchText : exactMatch">
<td> {{ employee.name }} </td>
<td> {{ employee.gender }} </td>
<td> {{ employee.salary }} </td>
<td> {{ employee.city }} </td>
</tr>
</tbody>
</table>
</div>
</body>
</html>

Styles.css

body {
font-family: Arial;
}

table {
border-collapse: collapse;
}

td {
border: 1px solid black;
padding: 5px;
}

th {
border: 1px solid black;
padding: 5px;
text-align: left;

}

Implement search filter in angular

how to implement search in Angular using search filter.

As we type in the search textbox, all the columns in the table must be searched and only the matching rows should be displayed.
Controller:

var app = angular
.module("myModule", [])
.controller("myController", function ($scope) {

var employees = [
{ name: "Ben", gender: "Male", salary: 55000, city: "London" },
{ name: "Sara", gender: "Female", salary: 68000, city: "Chennai" },
{ name: "Mark", gender: "Male", salary: 57000, city: "London" },
{ name: "Pam", gender: "Female", salary: 53000, city: "Chennai" },
{ name: "Todd", gender: "Male", salary: 60000, city: "London" },
];

$scope.employees = employees;
});

HtmlPage1.html :

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<script src="Scripts/angular.min.js"></script>
<script src="Scripts/Script.js"></script>
<link href="Styles.css" rel="stylesheet" />
</head>
<body ng-app="myModule">
<div ng-controller="myController">
Search : <input type="text" placeholder="Search employees"
ng-model="searchText" />
<br /><br />
<table>
<thead>
<tr>
<th>Name</th>
<th>Gender</th>
<th>Salary</th>
<th>City</th>
</tr>
</thead>
<tbody>
<tr ng-repeat="employee in employees | filter:searchText">
<td> {{ employee.name }} </td>
<td> {{ employee.gender }} </td>
<td> {{ employee.salary }} </td>
<td> {{ employee.city }} </td>
</tr>
</tbody>
</table>
</div>
</body>
</html>

Styles.css :

body {
font-family: Arial;
}

table {
border-collapse: collapse;
}

td {
border: 1px solid black;
padding: 5px;
}

th {
border: 1px solid black;
padding: 5px;
text-align: left;
}

At the moment, the search is being done across all columns. If you want to search only one specific column, then change ng-model directive value on the search textbox as shown below. With this change only city column is searched.

<input type="text" ng-model="searchText.city" placeholder="Search employees" />

Filter ( lowercase,uppercase,number Formats,currency and date )components in angulajs

All Angular filter format documentation

https://docs.angularjs.org/api/ng/filter

Filters in angular can do 3 different things
Format data
Sort data
Filter data

Filters can be used with a binding expression or a directive

To apply a filter use pipe (|) character

Syntax : {{ expression | filterName:parameter }}

Angular filters for formatting data
lowercase - Formats all characters to lowercase
uppercase - Formats all characters to uppercase
number - Formats a number as text. Includes comma as thousands separator and the number of decimal places can be specified
currency - Formats a number as a currency. $ is default. Custom currency and decimal places can be specified
date - Formats date to a string based on the requested format

Component :

var app = angular
.module("myModule", [])
.controller("myController", function ($scope) {

var employees = [
{
name: "Ben", dateOfBirth: new Date("November 23, 1980"),
gender: "Male", salary: 55000.788
},
{
name: "Sara", dateOfBirth: new Date("May 05, 1970"),
gender: "Female", salary: 68000
},
{
name: "Mark", dateOfBirth: new Date("August 15, 1974"),
gender: "Male", salary: 57000
},
{
name: "Pam", dateOfBirth: new Date("October 27, 1979"),
gender: "Female", salary: 53000
},
{
name: "Todd", dateOfBirth: new Date("December 30, 1983"),
gender: "Male", salary: 60000
}
];

$scope.employees = employees;
$scope.rowCount = 3;
});

HtmlPage1.html

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<script src="Scripts/angular.min.js"></script>
<script src="Scripts/Script.js"></script>
<link href="Styles.css" rel="stylesheet" />
</head>
<body ng-app="myModule">
<div ng-controller="myController">
Rows to display : <input type="number" step="1"
ng-model="rowCount" max="5" min="0" />
<br /><br />
<table>
<thead>
<tr>
<th>Name</th>
<th>Date of Birth</th>
<th>Gender</th>
<th>Salary (number filter)</th>
<th>Salary (currency filter)</th>
</tr>
</thead>
<tbody>
<tr ng-repeat="employee in employees | limitTo:rowCount">
<td> {{ employee.name | uppercase }} </td>
<td> {{ employee.dateOfBirth | date:"dd/MM/yyyy" }} </td>
<td> {{ employee.gender }} </td>
<td> {{ employee.salary | number:2 }} </td>
<td> {{ employee.salary | currency : "£" : 1 }} </td>
</tr>
</tbody>
</table>
</div>
</body>
</html>

Styles.css

body {
font-family: Arial;
}

table {
border-collapse: collapse;
}

td {
border: 1px solid black;
padding: 5px;
}

th {
border: 1px solid black;
padding: 5px;
text-align: left;
}

Apply sorting on table column name in angularjs

AngularJS sort rows by table header

Here is what we want to do
1. The data should be sorted when the table column header is clicked
2. The user should be able to sort in both the directions - ascending and descending. Clicking on the column for the first time should sort the data in ascending order. Clicking on the same column again should sort in descending order.
3. An icon should be displayed next to the column showing the sort column and direction

Script.js : The controller function in the script does the following
Sets up the model sortColumn and reverseSort properties are attached to the $scope object. These 2 properties are used to control the column by which the data should be sorted and the sort direction.
sortColumn is set to name and reverseSort is set to false. This will ensure that when the form is initially loaded, the table data will be sorted by name column in ascending order.Depending on the column header the user has clicked, sortData() function sets the sortColumn and reverseSort property values.
Based on the sort column and the sort direction, getSortClass() function returns the CSS class name to return. The CSS class controls the sort icon that will be displayed next to the sort column.

Controller:

var app = angular

.module("myModule", [])

.controller("myController", function ($scope)

{

var employees = [

{ name: "Ben", dateOfBirth: new Date("November 23, 1980"), gender: "Male", salary: 55000 }, { name: "Sara", dateOfBirth: new Date("May 05, 1970"), gender: "Female", salary: 68000 },

{ name: "Mark", dateOfBirth: new Date("August 15, 1974"), gender: "Male", salary: 57000 },

{ name: "Pam", dateOfBirth: new Date("October 27, 1979"), gender: "Female", salary: 53000 }, { name: "Todd", dateOfBirth: new Date("December 30, 1983"), gender: "Male", salary: 60000 } ];

$scope.employees = employees;

$scope.sortColumn = "name";

$scope.reverseSort = false;

$scope.sortData = function (column)

{

$scope.reverseSort = ($scope.sortColumn == column) ? !$scope.reverseSort : false; $scope.sortColumn = column;

}

$scope.getSortClass = function (column)

{

if ($scope.sortColumn == column) { return $scope.reverseSort ? 'arrow-down' : 'arrow-up'; } return '';

}

});

HtmlPage1.html : sortData() function is called when any table header is clicked, passing the name of the column by which the data should be sorted. The div element's, ng-class directive calls getSortClass() function, which returns the CSS class to be applied. The CSS displays the UP or DOWN arrow depending on the sort direction. Finally, with the orderBy filter sortColumn and reverseSort properties of the $scope object are used to control the column by which the data should be sorted and the sort direction.

Html:

<table>

<thead>

<tr>

<th ng-click="sortData('dateOfBirth')"> Date of Birth <div

ng-class="getSortClass('dateOfBirth')"></div>

</th> <th ng-click="sortData('gender')"> Gender <div ng-class="getSortClass('gender')"></div> </th> <th ng-click="sortData('salary')"> Salary <div ng-class="getSortClass('salary')"></div> </th>

</tr>

</thead>

<tbody>

<td> {{ employee.name }} </td>

<td> {{ employee.dateOfBirth | date:"dd/MM/yyyy" }} </td>

<td> {{ employee.gender }} </td>

<td> {{ employee.salary }} </td>

</tr>

</tbody>

</table>

</div>
</body>
</html>

CSS:

body {

font-family: Arial;

}

table {

border-collapse: collapse;

}

td {

border: 1px solid black;

padding: 5px;

}

th {

border: 1px solid black;

padding: 5px;

text-align: left;

/*cursor property displays hand symbol

when hovered over the th element*/

cursor: pointer;

}

/*This class displays the UP arrow*/

.arrow-up {

width: 0;

height: 0;

border-left: 5px solid transparent;

border-right: 5px solid transparent;

border-bottom: 10px solid black;

display:inline-block;

}

/*This class displays the DOWN arrow*/

.arrow-down {

width: 0;

height: 0;

border-left: 5px solid transparent;

border-right: 5px solid transparent;

border-top: 10px solid black;

display:inline-block;

}

link:
http://csharp-video-tutorials.blogspot.in/2015/11/angularjs-sort-rows-by-table-header.html

Thursday, 27 April 2017

Send mail using webconfig mailSettings SMTP details

Web config
====================
<system.net>
<mailSettings>
<smtp deliveryMethod="Network">
<network host="mail.seologistics.com" enableSsl="false" port="587" userName="test_flexsin@seologistics.com" password="Ybv0B'mJKLIU*%$" />
</smtp>
</mailSettings>
</system.net>

-----------

<add key="FromEmailId" value="test_flexsin@seologistics.com" />
<add key="DisplayName" value="Wafroo" />
==============================================

Code
============

public string SendMail(string FromEmail, string ToEmail, string subjectsend, string messagesend)
{
string Result = string.Empty;
try
{
var fromAddress = new MailAddress(FromEmail);
var toAddress = new MailAddress(ToEmail);
string subject = subjectsend;
string body = messagesend;

var smtp = new SmtpClient();
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body,

})
{
message.IsBodyHtml = true;
smtp.Send(message);
}

Result = "1";
}
catch (Exception ex)
{
Result = ex.Message;
}
return Result;
}

Send Email and Attachment or uni code support in email

static string displayName = System.Configuration.ConfigurationManager.AppSettings["DisplayName"];

#region send mail without attchment
/// <summary> send mail without attchment
/// <para>EmailMessageID</para> pass to emailMessage id
/// <para>MailSubject</para> pass mail subject name
/// <para>MailBody</para> pass Mail decription
/// <para>cc</para> pass cc mail id
/// <para>bc</para> pass bc mail id
/// <para>FromMail</para> pass Network Credential from emailMessage id (user name)
/// <para>password</para> pass Network Credential Password (user password)
/// <para>host</para> pass Network Credential host for send mailMessage
/// <para>port</para> pass Network Credential port for send mailMessage
/// <DevelopedBy>Neelkamal bansal</DevelopedBy>
/// </summary>
public static void SendMail(string emailMessageId, string mailMessageSubject, string mailMessageBody, string cC, string bC, string fromMail, string password, string host, int port)
{
try
{
string username = Convert.ToString(ConfigurationManager.AppSettings["Username"]);
MailMessage mailMessage = new MailMessage();
mailMessage.To.Add(emailMessageId);

if (!string.IsNullOrEmpty(cC))
{
mailMessage.CC.Add(cC);
}

if (!string.IsNullOrEmpty(bC))
{
mailMessage.Bcc.Add(bC);
}

mailMessage.From = new MailAddress(fromMail, displayName);
mailMessage.IsBodyHtml = true;
mailMessage.SubjectEncoding = System.Text.Encoding.UTF8;
mailMessage.Subject = mailMessageSubject;
mailMessage.BodyEncoding = System.Text.Encoding.UTF8;
mailMessage.Body = mailMessageBody;

SmtpClient smtpClient = new SmtpClient();
smtpClient.Port = port;
smtpClient.Host = host;
smtpClient.EnableSsl = false;
smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network;
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = new NetworkCredential(username, password);
smtpClient.Send(mailMessage);
smtpClient.Dispose();
}
catch (Exception ex)
{
throw ex;
}
}

public static void ForgotPassSendMail(string emailMessageId, string mailMessageSubject, string mailMessageBody, string cC, string bC, string fromMail, string password, string host, int port)
{
try
{
string username = Convert.ToString(ConfigurationManager.AppSettings["FUsername"]);
MailMessage mailMessage = new MailMessage();
mailMessage.To.Add(emailMessageId);

if (!string.IsNullOrEmpty(cC))
{
mailMessage.CC.Add(cC);
}

if (!string.IsNullOrEmpty(bC))
{
mailMessage.Bcc.Add(bC);
}

mailMessage.From = new MailAddress(fromMail, displayName);
mailMessage.Subject = mailMessageSubject;
mailMessage.IsBodyHtml = true;
mailMessage.BodyEncoding = System.Text.Encoding.UTF8;
mailMessage.Body = mailMessageBody;
mailMessage.SubjectEncoding = System.Text.Encoding.UTF8;

SmtpClient smtpClient = new SmtpClient();
smtpClient.Port = port;
smtpClient.Host = host;
smtpClient.EnableSsl = false;
smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network;
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = new NetworkCredential(username, password);
smtpClient.Send(mailMessage);
smtpClient.Dispose();
}
catch (Exception ex)
{
throw ex;
}
}

#endregion

#region send mail with single attchment
/// <summary> send mailMessage with single attchment
/// <para>EmailMessageID</para> pass to emailMessage id
/// <para>MailSubject</para> pass mailMessage subject name
/// <para>MailBody</para> pass Mail decription
/// <para>cc</para> pass cc mailMessage id
/// <para>bc</para> pass bc mailMessage id
/// <para>FromMail</para> pass Network Credential from emailMessage id (user name)
/// <para>password</para> pass Network Credential Password (user password)
/// <para>host</para> pass Network Credential host for send mailMessage
/// <para>port</para> pass Network Credential port for send mailMessage
/// <para>attachmentfile</para> pass attchment (ex- doc, image, pdf and any other)
/// <DevelopedBy>Neelkamal bansal</DevelopedBy>
/// </summary>
public static void SendMail(string emailMessageId, string mailMessageSubject, string mailMessageBody, string cC, string bC, string fromMail, string password, string host, int port, byte[] attachmentFile, string filename)
{
try
{
MailMessage mailMessage = new MailMessage();
string username = Convert.ToString(ConfigurationManager.AppSettings["Username"]);
mailMessage.To.Add(emailMessageId);

if (!string.IsNullOrEmpty(cC))
{
mailMessage.CC.Add(cC);
}

if (!string.IsNullOrEmpty(bC))
{
mailMessage.Bcc.Add(bC);
}

mailMessage.From = new MailAddress(fromMail, displayName);
mailMessage.SubjectEncoding = System.Text.Encoding.UTF8;
mailMessage.Subject = mailMessageSubject;
mailMessage.IsBodyHtml = true;
mailMessage.BodyEncoding = System.Text.Encoding.UTF8;
mailMessage.Body = mailMessageBody;

// Attachment attachment = new Attachment(attachmentFile, MediaTypeNames.Application.Octet);
Attachment attachment = new Attachment(new MemoryStream(attachmentFile), filename);
mailMessage.Attachments.Add(attachment);
SmtpClient smtpClient = new SmtpClient();
smtpClient.Port = port;
smtpClient.Host = host;
smtpClient.EnableSsl = false;
smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network;
smtpClient.UseDefaultCredentials = false;
// smtpClient.ServicePoint.MaxIdleTime = 1;
smtpClient.Credentials = new NetworkCredential(username, password);
smtpClient.Send(mailMessage);
smtpClient.Dispose();
}
catch (Exception ex)
{
throw ex;
}
}
#endregion

#region send mail with multiple attchment
/// <summary> send mailMessage with multiple attchment
/// <para>EmailMessageID</para> pass to emailMessage id
/// <para>MailSubject</para> pass mailMessage subject name
/// <para>MailBody</para> pass Mail decription
/// <para>cc</para> pass cc mailMessage id
/// <para>bc</para> pass bc mailMessage id
/// <para>FromMail</para> pass Network Credential from emailMessage id (user name)
/// <para>password</para> pass Network Credential Password (user password)
/// <para>host</para> pass Network Credential host for send mailMessage
/// <para>port</para> pass Network Credential port for send mailMessage
/// <para>attachmentfile</para> pass multiple attchment in array (ex- doc, image, pdf and any other)
/// <DevelopedBy>Neelkamal bansal</DevelopedBy>
/// </summary>
public static void SendMail(string emailMessageIDd, string mailMessageSubject, string mailMessageBody, string cC, string bC, string fromMail, string password, string host, int port, string[] attachmentFile)
{
try
{
MailMessage mailMessage = new MailMessage();
mailMessage.To.Add(emailMessageIDd);

if (!string.IsNullOrEmpty(cC))
{
mailMessage.CC.Add(cC);
}

if (!string.IsNullOrEmpty(bC))
{
mailMessage.Bcc.Add(bC);
}

mailMessage.From = new MailAddress(fromMail, displayName);
mailMessage.Subject = mailMessageSubject;
mailMessage.IsBodyHtml = true;
mailMessage.Body = mailMessageBody;

if (attachmentFile.Length > 0)
{
for (int i = 0; i < attachmentFile.Length; i++)
{
Attachment attachment = new Attachment(attachmentFile[i], MediaTypeNames.Application.Octet);
ContentDisposition disposition = attachment.ContentDisposition;
disposition.CreationDate = File.GetCreationTime(attachmentFile[i]);
disposition.ModificationDate = File.GetLastWriteTime(attachmentFile[i]);
disposition.ReadDate = File.GetLastAccessTime(attachmentFile[i]);
disposition.FileName = Path.GetFileName(attachmentFile[i]);
disposition.Size = new FileInfo(attachmentFile[i]).Length;
disposition.DispositionType = DispositionTypeNames.Attachment;
mailMessage.Attachments.Add(attachment);
}
}

SmtpClient smtpClient = new SmtpClient();
smtpClient.Port = port;
smtpClient.Host = host;
smtpClient.EnableSsl = false;
smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network;
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = new NetworkCredential(fromMail, password);
smtpClient.Send(mailMessage);
smtpClient.Dispose();
}
catch (Exception ex)
{
throw ex;
}
}
#endregion

<appSettings>
<add key="DisplayName" value="تحدي القراءة العربي"/>
<add key="EmailUname" value="test_flexsin@seologistics.com"/>
<add key="Username" value="test_flexsin@seologistics.com"/>
<add key="EmailPassword" value="Ybv0B'mJKLIU*%$"/>
<add key="Host" value="mail.seologistics.com"/>
<add key="Port" value="25"/>
<add key="CC" value=""/>
<add key="BC" value="neelkamal_bansal@seologistics.com"/>
<add key="FDisplayName" value="Arab Reading Challenge"/>
<add key="FEmailUname" value="test_flexsin@seologistics.com"/>
<add key="FUsername" value="test_flexsin@seologistics.com"/>
<add key="FEmailPassword" value="Ybv0B'mJKLIU*%$"/>
<add key="FHost" value="mail.seologistics.com"/>
<add key="FPort" value="25"/>
<add key="FCC" value=""/>
<add key="FBC" value="avdhesh_kumar12@seologistics.com"/>
<add key="UserNameLength" value="8"/>
<add key="pagingsize" value="25"/>
<add key="PasswordLength" value="6"/>
<add key="PageUrl" value="http://localhost:49787/index.aspx"/>
<add key="BackupFolder" value="C:/ARC/"/>
<add key="IndexredirectUrl" value="http://localhost:49787/index.aspx"/>
</appSettings>