public async Task <ServiceResponse <CustomerModel> > GetCustomerList(int type, Int16 active) { CustomerModel CM = new CustomerModel(); DataTable dt; var objSR = new ServiceResponse <CustomerModel>(); List <CustomerModel> objList = new List <CustomerModel>(); try { CM.type = type; CM.Active = active; objSR.List = bal.LoadGrid(CM).AsEnumerable().Select(row => new CustomerModel() { Id = row["Id"] == DBNull.Value ? 0 : Convert.ToInt32(row["Id"]), CustomerCode = row["CustomerCode"] == DBNull.Value ? string.Empty : Convert.ToString(row["CustomerCode"]), AadharNo = row["AadharNo"] == DBNull.Value ? string.Empty : Convert.ToString(row["AadharNo"]), Address = row["Address"] == DBNull.Value ? string.Empty : Convert.ToString(row["Address"]), City = row["City"] == DBNull.Value ? string.Empty : Convert.ToString(row["City"]), DateOfBirth = row["DateOfBirth"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(row["DateOfBirth"]), Email = row["Email"] == DBNull.Value ? string.Empty : Convert.ToString(row["Email"]), FirstName = row["FirstName"] == DBNull.Value ? string.Empty : Convert.ToString(row["FirstName"]), FirstVisit = row["FistVisitDate"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(row["FistVisitDate"]), Gender = row["Gender"] == DBNull.Value ? string.Empty : Convert.ToString(row["Gender"]), LastName = row["LastName"] == DBNull.Value ? string.Empty : Convert.ToString(row["LastName"]), GSTN = row["GSTN"] == DBNull.Value ? string.Empty : Convert.ToString(row["GSTN"]), MaritalStatus = row["MaritalStatus"] == DBNull.Value ? string.Empty : Convert.ToString(row["GSTN"]), MobileNo = row["MobileNo"] == DBNull.Value ? string.Empty : Convert.ToString(row["MobileNo"]), PAN = row["PAN"] == DBNull.Value ? string.Empty : Convert.ToString(row["PAN"]), StateId = row["StateId"] == DBNull.Value ? 0 : Convert.ToInt32(row["StateId"]), StateName = row["State"] == DBNull.Value ? string.Empty : Convert.ToString(row["State"]), Zip = row["Zip"] == DBNull.Value ? string.Empty : Convert.ToString(row["Zip"]), VisitCount = row["VisitCount"] == DBNull.Value ? 0 : Convert.ToInt32(row["VisitCount"]), LastVisit = row["LastVisitDate"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(row["LastVisitDate"]) }).ToList(); objSR.StatusCode = 1; } catch (Exception ex) { objSR.StatusCode = 2; objSR.Messages.Add("Error occurred while login, " + ex.Message); } return(await Task.Run(() => objSR)); }