コード例 #1
0
        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);
        }