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)));
}
