public int UpdateUser(sys_User request) { using (IDbConnection sqlConn = SQLDBHelper.CreateConnection()) { return(sqlConn.Update(request)); } }
public IHttpActionResult getByID(int id) { RetMsg ret = new RetMsg(); try { sys_User r = MySQLDB.QueryById <sys_User, int>(id); ret.flag = true; ret.data = r; } catch (Exception ex) { ret.msg = ex.Message; } return(Json(ret)); }
public int AddUser(sys_User request) { using (IDbConnection sqlConn = SQLDBHelper.CreateConnection()) { for (int i = 0; i < 200; i++) { request = new sys_User() { Name = "liwx" + i, Account = "Account" + i, Password = "******" + i.ToString(), Gender = i % 2, Status = 1, IsLimitIP = true, MaxIPCount = 1, Email = "358948567" + i.ToString() + "@qq.com", Mobile = (15821121139 + i).ToString() }; sqlConn.Insert(request); } return(1); } }
public int UpdateUser(sys_User request) { return(_userRepository.UpdateUser(request)); }
public int AddUser(sys_User request) { return(_userRepository.AddUser(request)); }
protected override void Seed(HRIS.Data.HRISContext context) { var hris = new HRISContext(); var unitOfWork = new UnitOfWork(hris); var repo = new { Country = new Repository <mf_Country>(hris), Company = new Repository <sys_Company>(hris), User = new Repository <sys_User>(hris), Setting = new Repository <sys_Setting>(hris), CompanySetting = new Repository <sys_CompanySetting>(hris), }; var settingDefaultPass = repo.Setting.Insert(new sys_Setting() { name = "DEFAULT_PASSWORD", description = "Default Password for New and Reset User" }); var settingHashsha = repo.Setting.Insert(new sys_Setting() { name = "HRIS_HASHSHA_KEY", description = "HRIS_HASHSHA_KEY" }); var philippines = new mf_Country() { code = "PH", description = "Philippines" }; repo.Country.Insert(philippines); var user_admin = new sys_User() { username = "******", password = "******", hashKey = "29b373cae1fb59b32052386063fb100", vector = "R9_XFXT2U7CaaP_5", email = "*****@*****.**", status = 1, superAdmin = true, }; repo.User.Insert(user_admin); unitOfWork.Save(); philippines.updatedBy = user_admin.id; repo.Country.Update(philippines); user_admin.updatedBy = user_admin.id; repo.User.Update(user_admin); unitOfWork.Save(); var company = new sys_Company() { code = "TEST-001", businessName = "Test Company", updatedBy = user_admin.id, }; repo.Company.Insert(company); unitOfWork.Save(); repo.CompanySetting.Insert(new sys_CompanySetting() { companyId = company.id, settingId = settingDefaultPass.id, value = "P@ssw0rd", updatedBy = user_admin.id }); repo.CompanySetting.Insert(new sys_CompanySetting() { companyId = company.id, settingId = settingHashsha.id, value = "HRIS_KEY1", updatedBy = user_admin.id }); unitOfWork.Save(); user_admin.companyId = company.id; repo.User.Update(user_admin); unitOfWork.Save(); AddEnumReference(unitOfWork, context, company.id); PreparePermission(unitOfWork, context, company.id, user_admin.id); PrepareRole(unitOfWork, context, company.id, user_admin.id); }
public Response <int> UpdateUser([FromBody] sys_User request) { return(new Response <int>(_userService.UpdateUser(request))); }