public List <ManageUsersViewModel> GetAllUserRegistrations(string registrationType, string sDate, string eDate) { DataTable dt = _userProcessor.GetAllUserRegistrations(registrationType, sDate, eDate); List <ManageUsersViewModel> users = new List <ManageUsersViewModel>(); for (int i = 0; i < dt.Rows.Count; i++) { ManageUsersViewModel user = new ManageUsersViewModel { Userid = Convert.ToInt32(dt.Rows[i]["Userid"]), FirstName = Convert.ToString(dt.Rows[i]["FirstName"]), LastName = Convert.ToString(dt.Rows[i]["LastName"]), Email = Convert.ToString(dt.Rows[i]["Email"]), RoleName = Convert.ToString(dt.Rows[i]["RoleName"]), MobileNo = Convert.IsDBNull(dt.Rows[i]["MobileNo"]) ? "" : Convert.ToString(dt.Rows[i]["MobileNo"]), City = Convert.IsDBNull(dt.Rows[i]["City"]) ? "" : Convert.ToString(dt.Rows[i]["City"]), State = Convert.IsDBNull(dt.Rows[i]["State"]) ? "" : Convert.ToString(dt.Rows[i]["State"]), Gender = Convert.IsDBNull(dt.Rows[i]["Gender"]) ? "" : Convert.ToString(dt.Rows[i]["Gender"]), MaritalStatus = Convert.IsDBNull(dt.Rows[i]["MaritalStatus"]) ? "" : Convert.ToString(dt.Rows[i]["MaritalStatus"]), CreatedDate = Convert.ToDateTime(dt.Rows[i]["CreatedOn"]), TPName = Convert.ToString(dt.Rows[i]["TPName"]), IsActive = Convert.ToBoolean(dt.Rows[i]["IsActive"]), }; users.Add(user); } return(users); }