public List <ManageUsersViewModel> GetAllUsers(int userId) { DataTable dt = _userProcessor.GetAllUsersList(userId); 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"]), Password = Convert.ToString(dt.Rows[i]["Password"]), IsApproved = Convert.IsDBNull(dt.Rows[i]["IsApproved"]) ? 0 : Convert.ToInt32(dt.Rows[i]["IsApproved"]), RoleName = Convert.ToString(dt.Rows[i]["RoleName"]), CreatedDate = Convert.ToDateTime(dt.Rows[i]["CreatedOn"]), IsViewed = Convert.ToBoolean(dt.Rows[i]["IsViewed"]), RoleId = Convert.IsDBNull(dt.Rows[i]["RoleId"]) ? 0 : Convert.ToInt32(dt.Rows[i]["RoleId"]), Address = Convert.IsDBNull(dt.Rows[i]["Address1"]) ? "" : Convert.ToString(dt.Rows[i]["Address1"]), 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"]), Country = Convert.IsDBNull(dt.Rows[i]["Country"]) ? "" : Convert.ToString(dt.Rows[i]["Country"]), 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"]), }; users.Add(user); } //List<ManageUsersModel> users = ConvertDatatableToModelList.ConvertDataTable<ManageUsersModel>(dt); return(users); }