/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Customer> GetCustomerData()
{
List <Customer> custlist = new List <Customer>();
DataTable dtCust = new DataTable();
Customer cobj = new Customer();
try
{
dtCust = CustDAL.GetCustomerData();
//We can use below query
//custlist = (from DataRow dr in dtCust.Rows
// select new Customer()
// {
// CountryCode = Convert.ToString(dr["COUNTRY_CODE"]),
// CountryName = Convert.ToString(dr["COUNTRY_DESC"].ToString())
// }).ToList();
foreach (DataRow dr in dtCust.Rows)
{
cobj.CustomerID = Convert.ToString(dr["CustomerID"].ToString());
cobj.Name = dr["Name"].ToString();
cobj.Address = dr["Address"].ToString();
cobj.Mobileno = dr["Mobileno"].ToString();
cobj.EmailID = dr["EmailID"].ToString();
cobj.Birthdate = Convert.ToDateTime(dr["Birthdate"].ToString());
custlist.Add(cobj);
}
}
catch (Exception ex)
{
ErrorLog.ExceptionWriteIntoTextFile(ex, "GetCustomerData", "Business layer", "CUstomer module");
}
return(custlist);
}
