public async Task <IActionResult> SetRoles([FromBody] List <Authentication.Core.nguoidung_role> data)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var nd = db.Connection.getUserFromToken(TM.Core.HttpContext.Header("Authorization"));
if (nd == null)
{
return(Json(new { msg = TM.Core.Common.Message.error_token.ToString() }));
}
var nguoidung = await db.Connection.GetAllAsync <Authentication.Core.nguoidung>();
var index = 0;
var qry = "BEGIN ";
foreach (Authentication.Core.nguoidung_role item in data)
{
// var _data = await db.Connection.GetAsync<Authentication.Core.nguoidung>(item.nguoidung_id);
if (nguoidung.Any(x => x.nguoidung_id == item.nguoidung_id))
{
qry += $"update nguoidung set roles_id='{item.roles_id}' where nguoidung_id={item.nguoidung_id};\r\n";
index++;
}
else
{
var matkhau = "vnptbkn@123";
var tmp = new Authentication.Core.nguoidung();
tmp.nguoidung_id = item.nguoidung_id;
tmp.salt = Guid.NewGuid().ToString("N");
tmp.matkhau = TM.Core.Encrypt.MD5.CryptoMD5TM(matkhau + tmp.salt);
tmp.updated_by = nd.ma_nd;
tmp.updated_at = DateTime.Now;
tmp.roles_id = item.roles_id;
await db.Connection.InsertOraAsync(tmp);
}
}
qry += "END;";
if (index > 0)
{
await db.Connection.QueryAsync(qry);
await db.Connection.QueryAsync("COMMIT");
}
return(Json(new { msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
finally { }
}
public async Task <IActionResult> ResetPassword(int id)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var nd = db.Connection.getUserFromToken(TM.Core.HttpContext.Header("Authorization"));
if (nd == null)
{
return(Json(new { msg = TM.Core.Common.Message.error_token.ToString() }));
}
var matkhau = "vnptbkn@123";
var _data = await db.Connection.GetAsync <Authentication.Core.nguoidung>(id);
if (_data != null)
{
// _data.app_key = data.app_key;
_data.matkhau = TM.Core.Encrypt.MD5.CryptoMD5TM(matkhau + _data.salt);
_data.change_pass_by = nd.ma_nd;
_data.change_pass_at = DateTime.Now;
await db.Connection.UpdateAsync(_data);
}
else
{
var tmp = new Authentication.Core.nguoidung();
tmp.nguoidung_id = id;
tmp.salt = Guid.NewGuid().ToString("N");
tmp.matkhau = TM.Core.Encrypt.MD5.CryptoMD5TM(matkhau + tmp.salt);
tmp.change_pass_by = nd.ma_nd;
tmp.change_pass_at = DateTime.Now;
await db.Connection.InsertOraAsync(tmp);
}
return(Json(new { data = matkhau, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
finally { }
}
