public static DataTable GetCustomerList(eSolutionDataContext db, Boolean argAll = false)
{
//EMSdb = new eSolutionDataContext();
DataTable dt = new DataTable();
DataColumn colValue = new DataColumn();
DataColumn colText = new DataColumn();
DataRow newRow;
try
{
colText.ColumnName = HelperClass.DisplayName;
colValue.ColumnName = HelperClass.CodeName;
colText.DataType = typeof(System.String);
colValue.DataType = typeof(System.String);
dt.Columns.Add(colText);
dt.Columns.Add(colValue);
var sqlQuery = db.stp_CustomerList().ToList();
//var sqlQuery = from obj in db.Customers
// group obj by new
// {
// obj.CustomerCode
// ,
// obj.CustomerName
// }
// into grouping
// select new { grouping.Key, grouping };
if (argAll == true)
{
newRow = dt.NewRow();
newRow[HelperClass.DisplayName] = "ALL";
newRow[HelperClass.CodeName] = "";
dt.Rows.Add(newRow);
}
foreach (var row in sqlQuery)
{
newRow = dt.NewRow();
//newRow[HelperClass.DisplayName] = row.Key.CustomerName;
//newRow[HelperClass.CodeName] = row.Key.CustomerCode;
newRow[HelperClass.DisplayName] = row.DisplayName;
newRow[HelperClass.CodeName] = row.CodeName;
dt.Rows.Add(newRow);
}
}
catch
{
dt = null;
}
finally
{
}
return(dt);
}
