public async Task <IActionResult> Post([FromBody] Models.Core.ContractEnterprise 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() }));
}
if (db.Connection.isExist("contract_enterprise", "ma_hd", data.ma_hd))
{
return(Json(new { msg = TM.Core.Common.Message.exist.ToString() }));
}
data.id = Guid.NewGuid().ToString("N");
data.nguoi_tao = nd.ma_nd;
data.ngay_tao = DateTime.Now;
data.ip_tao = TM.Core.HttpContext.Header("LocalIP");
data.trang_thai = 1;
data.donvi_id = nd.donvi_id;
await db.Connection.InsertOraAsync(data);
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> Delete([FromBody] List <Models.Core.ContractEnterprise> 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 qry = "BEGIN ";
foreach (var item in data)
{
qry += $"update contract_enterprise set trang_thai={item.trang_thai},nguoi_xoa='{nd.ma_nd}',ngay_xoa={DateTime.Now.ParseDateTime()} where id='{item.id}';\r\n";
}
qry += "END;";
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() })); }
}
public async Task <IActionResult> Put([FromBody] Models.Core.ContractEnterprise 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() }));
}
// _data.customer_name = data.customer_name;
// _data.customer_address = data.customer_address;
// _data.tax_code = data.tax_code;
// _data.start_at = data.start_at;
// _data.end_at = data.end_at;
// _data.quantity = data.quantity;
// _data.price = data.price;
// _data.details = data.details;
// _data.contents = data.contents;
// _data.attach = data.attach;
data.nguoi_cn = nd.ma_nd;
data.ip_cn = TM.Core.HttpContext.Header("LocalIP");
data.ngay_cn = DateTime.Now;
await db.Connection.UpdateAsync(data);
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> Put([FromBody] Models.Core.APP_KEY 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 _data = await db.Connection.GetAsync <Models.Core.APP_KEY>(data.app_key);
if (_data != null)
{
_data.title = data.title;
_data.flag = data.flag;
}
await db.Connection.UpdateAsync(_data);
return(Json(new { data = _data, 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> Post([FromBody] Models.Core.Permissions 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() }));
}
if (db.Connection.isExist("Permissions", "code", data.code))
{
return(Json(new { msg = TM.Core.Common.Message.exist.ToString() }));
}
// data.id = Guid.NewGuid().ToString("N");
data.created_by = nd.ma_nd;
data.created_at = DateTime.Now;
await db.Connection.InsertOraAsync(data);
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> GetNguoidung([FromQuery] Paging paging)
{
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 qry = "select dnd.donvi_id,dnd.ma_nd,dnd.ten_nd,dnd.ma_nd,dnd.ten_nv,dnd.ten_nd||' - '||dnd.ma_nd||' - '||dv.ma_dv ten_nd_dv,dnd.gioitinh,dnd.so_dt,dv.ma_dv,dv.ten_dv,r.name ten_quyen ";
qry += "from db_nguoidung dnd,nguoidung nd,db_donvi dv,roles r ";
qry += "where dnd.nguoidung_id=nd.nguoidung_id and dnd.donvi_id=dv.donvi_id and nd.roles_id=r.id and r.levels=4 ";
if (!nd.inRoles("donvi.select"))
{
qry += $" and dv.donvi_id in({nd.donvi_id})";
}
else
if (paging.donvi_id > 0)
{
qry += $" and dv.donvi_id in({paging.donvi_id})";
}
qry += "order by dnd.donvi_id,dnd.ma_nd";
var data = await db.Connection.QueryAsync <nguoi_dung>(qry);
return(Json(new { data = data, 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> Post([FromBody] Models.Core.ContractCustomer 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() }));
}
//if (db.Connection.isExist("contract_customer", "ma_gd", data.khachhang.ma_gd)) return Json(new { msg = "exist" });
//data.khachhang.cc_id = Guid.NewGuid().ToString();
//data.khachhang.app_key = "cc_2";
data.id = Guid.NewGuid().ToString("N");
data.created_by = nd.ma_nd;
data.created_at = DateTime.Now;
data.flag = 1;
await db.Connection.InsertOraAsync(data);
//
var qry = $"select * from CONTRACT_CUSTOMER_KH where hdkh_id='{data.hdkh_id}' and flag=1";
var rs = db.Connection.QueryFirstOrDefault <ContractCustomerKH>(qry);
return(Json(new { data = rs, 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> Put([FromBody] Models.Core.Groups data)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var _data = await db.Connection.GetAsync <Models.Core.Groups>(data.id);
if (_data != null)
{
_data.title = data.title;
_data.descs = data.descs;
_data.content = data.content;
// _data.parent_id = data.parent_id;
// _data.parents = data.parents;
_data.levels = data.levels;
_data.image = data.image;
_data.icon = data.icon;
_data.quantity = data.quantity;
_data.position = data.position;
_data.orders = data.orders;
_data.updated_by = TM.Core.HttpContext.Header();
_data.updated_at = DateTime.Now;
}
await db.Connection.UpdateAsync(_data);
return(Json(new { data = _data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public JsonResult UpdateDBDT(Common.DefaultObj obj)
{
var HNIVNPTBACKAN1 = new TM.Core.Connection.Oracle("HNIVNPTBACKAN1");
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
try {
//Get Data HNI
var qry = $"SELECT * FROM DB_DUONGTHU_BKN";
var data_hni = HNIVNPTBACKAN1.Connection.Query <Models.DB_DUONGTHU_BKN>(qry).ToList();
//Update Data
foreach (var i in data_hni)
{
i.ID = Guid.NewGuid();
i.FIX = 0;
i.FLAG = 1;
i.MA_DT = i.MA_DT.Trim().ToUpper();
}
//Delete Old
qry = "DELETE DB_DUONGTHU_BKN WHERE FIX=0";
_Con.Connection.Query(qry);
//Insert Data
_Con.Connection.Insert(data_hni);
return(Json(new { success = $"DB_DUONGTHU_BKN - Cập nhật thành công!" }));
} catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index })); } finally { HNIVNPTBACKAN1.Close(); }
}
public JsonResult UpdateTTHD(Common.DefaultObj obj)
{
var HNIVNPTBACKAN1 = new TM.Core.Connection.Oracle("HNIVNPTBACKAN1");
var index = 0;
obj.DataSource = Common.Directories.HDDataSource;
obj = getDefaultObj(obj);
var TYPE_BILL = "4";
var TTHD_ID_HUY = "10,12,13,14,16,17";
try {
//Cập nhật tổng
var qry = $"select a.*,b.TTHD_ID from DB_THUEBAO_BKN a,HD_THUEBAO_BKN b,LOAIHINH_TB_BKN lhtb where a.MA_TB=b.MA_TB and a.LOAIHINHTB_ID=lhtb.LOAIHINHTB_ID and lhtb.DICHVUVT_ID=4";
var dbpttb = HNIVNPTBACKAN1.Connection.Query <Models.TTHD_TSL>(qry);
qry = $"SELECT * FROM HD_TSL WHERE TYPE_BILL={TYPE_BILL} AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'";
var data = _Con.Connection.Query <Models.HD_TSL>(qry);
foreach (var i in data)
{
var _tmp = dbpttb.FirstOrDefault(d => d.MA_TB == i.MA_TB);
if (_tmp != null)
{
i.TTHD_ID = _tmp.TTHD_ID;
}
}
_Con.Connection.Update(data);
//
qry = $"UPDATE HD_TSL SET TYPE_BILL=-1 WHERE TYPE_BILL={TYPE_BILL} AND (TTHD_ID IN({TTHD_ID_HUY}) OR TTHD_ID IS NULL) AND FORMAT(TIME_BILL,'MM/yyyy')='{obj.month_year_time}'";
_Con.Connection.Query(qry);
return(Json(new { success = $"HD_TSL - Cập nhật trạng thái hợp đồng thành công!" }));
} catch (Exception ex) { return(Json(new { danger = ex.Message + " - Index: " + index })); } finally { HNIVNPTBACKAN1.Close(); }
}
public async Task <IActionResult> Put([FromBody] Models.Core.DBDonvi data)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var _data = await db.Connection.GetAsync <Models.Core.DBDonvi>(data.donvi_id);
if (_data != null)
{
// _data.app_key = data.app_key;
// _data.full_name = data.full_name;
// _data.mobile = data.mobile;
// _data.email = data.email;
// _data.address = data.address;
// _data.descs = data.descs;
// _data.images = data.images;
// _data.donvi_id = data.donvi_id;
// _data.roles_id = data.roles_id;
// _data.updated_by = TM.Core.HttpContext.Header();
// _data.updated_at = DateTime.Now;
}
await db.Connection.UpdateAsync(_data);
return(Json(new { data = _data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> Delete([FromBody] List <Models.Core.Groups> data)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var _data = new List <Models.Core.Groups>();
foreach (var item in data)
{
var tmp = await db.Connection.GetAsync <Models.Core.Groups>(item.id);
if (tmp != null)
{
tmp.flag = item.flag;
_data.Add(tmp);
}
}
if (_data.Count > 0)
{
await db.Connection.UpdateAsync(_data);
}
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> Post([FromBody] Models.Core.Dictionary 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 qry = $"select * from Dictionary where lower(lang_code)='{data.lang_code.ToLower()}' and lower(module_code)='{data.module_code.ToLower()}' and lower(key)='{data.key.ToLower()}'";
// var qry = $"select * from Dictionary where lower(lang_code)='{data.lang_code.ToLower()}'";
var _data = await db.Connection.QueryFirstOrDefaultAsync <Models.Core.Dictionary>(qry);
if (_data != null)
{
_data.module_code = data.module_code;
_data.key = data.key;
_data.value = data.value;
//_data.lang_data = data.lang_data;
await db.Connection.UpdateAsync(_data);
}
else
{
data.id = db.Connection.getID("Dictionary");
await db.Connection.InsertOraAsync(data);
}
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> updateNVTB(string ma_nd, [FromBody] List <Models.Core.Kehoach_TB> tb)
{
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 now = DateTime.Now;
var qry = "BEGIN ";
foreach (var item in tb)
{
qry += $"update kehoach_tb set ma_nd='{ma_nd}',ip_cn='{TM.Core.HttpContext.Header("LocalIP")}',nguoi_cn='{nd.ma_nd}',ngay_cn={now.ParseDateTime()} where id='{item.id}';\r\n";
}
qry += "END;";
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> Thuchien([FromBody] Models.Core.Kehoach_TH 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 qry = $"select * from kehoach_tb where id='{data.kehoachtb_id}'";
var _data = await db.Connection.QueryFirstOrDefaultAsync <Models.Core.Kehoach_TB>(qry);
if (_data == null)
{
return(Json(new { msg = TM.Core.Common.Message.exist.ToString() }));
}
_data.trang_thai = 2;
data.id = Guid.NewGuid().ToString("N");
data.ma_nd = _data.ma_nd;
data.ngay_th = DateTime.Now;
data.nguoi_cn = nd.ma_nd;
data.ngay_cn = DateTime.Now;
data.ip_cn = TM.Core.HttpContext.Header("LocalIP");
await db.Connection.InsertOraAsync(data);
await db.Connection.UpdateAsync(_data);
return(Json(new { data = _data, 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> getThuebao(string key, [FromQuery] Models.Core.QueryString query)
{
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 tmp = key.Trim(',').Split(',');
key = "";
foreach (var item in tmp)
{
key += $"{item},";
}
var qry = $"select * from CONTRACT_CUSTOMER_TB where hdkh_id in({key.Trim(',')})";
var data = await db.Connection.QueryAsync <Models.Core.HD_THUEBAO>(qry);
return(Json(new { data = data, 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> Put([FromBody] Models.Core.Permissions 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 _data = await db.Connection.GetAsync <Models.Core.Permissions>(data.id);
if (_data != null)
{
//_data.code = data.code;
_data.title = data.title;
_data.orders = data.orders;
_data.descs = data.descs;
_data.updated_by = nd.ma_nd;
_data.updated_at = DateTime.Now;
_data.flag = data.flag;
}
await db.Connection.UpdateAsync(_data);
return(Json(new { data = _data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> Delete([FromBody] List <dynamic> 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 qry = "BEGIN ";
foreach (var item in data)
{
qry += $"update Permissions set flag={item.flag},deleted_by='{nd.ma_nd}',deleted_at={DateTime.Now.ParseDateTime()} where id='{item.id}';\r\n";
}
qry += "END;";
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() })); }
}
public async Task <IActionResult> TransferDataPortal(string dataVal, string database = "SQL_Portal")
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var SQLServer = new TM.Core.Connection.SQLServer(database);
var Oracle = new TM.Core.Connection.Oracle("PORTAL");
var qry = $"SELECT * FROM {dataVal}";
var table = await SQLServer.Connection.QueryAsync <Authentication.Core.Users>(qry);
foreach (var i in table)
{
i.id = i.id.ToUpper();
i.full_name = string.IsNullOrEmpty(i.full_name) ? i.full_name : i.full_name;
i.created_by = string.IsNullOrEmpty(i.created_by) ? "Admin" : i.created_by;
i.created_at = i.created_at.HasValue ? i.created_at.Value : DateTime.Now;
}
Oracle.Connection.Insert(table);
return(Json(new { msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> Post([FromBody] Authentication.Core.nguoidung_login data)
{
try
{
using (var db = new TM.Core.Connection.Oracle("DHSX"))
{
// var Authorization = TM.Core.HttpContext.Http.Request.Headers.TryGetValue("Authorization", out authorizationToken);
// var Author = TM.Core.HttpContext.Http.Request.Headers["Author"].ToString();
// db_nguoidung
var qry = "select nd.nguoidung_id \"nguoidung_id\",";
qry += "nd.ma_nd \"ma_nd\",";
qry += "nd.matkhau \"matkhau\",";
qry += "css_bkn.giaima_mk(nd.matkhau) \"giaima_mk\",";
qry += "nd.trangthai \"trangthai\" ";
qry += "from admin_bkn.nguoidung nd,";
qry += "ttkd_bkn.nguoidung tnd,";
qry += "ttkd_bkn.roles r ";
qry += "where nd.nguoidung_id=tnd.nguoidung_id(+) ";
qry += "and tnd.roles_id=r.id(+) ";
qry += $"and nd.ma_nd=:ma_nd";
var nguoidung = await db.Connection.QueryFirstOrDefaultAsync(qry, new { ma_nd = data.ma_nd });
if (nguoidung == null)
{
return(Json(new { msg = TM.Core.Common.Message.exist.ToString() }));
}
// Password wrong
// if (user.matkhau != TM.Core.Encrypt.MD5.CryptoMD5TM(data.matkhau + user.salt))
// return Json(new { msg = TM.Core.Common.Message.wrong.ToString() });
if (nguoidung.giaima_mk != data.matkhau)
{
return(Json(new { msg = TM.Core.Common.Message.wrong.ToString() }));
}
//Account is locked
if (nguoidung.trangthai < 1)
{
return(Json(new { msg = TM.Core.Common.Message.locked.ToString() }));
}
// Roles
// qry = $"select * from user_role where user_id='{user.user_id}'";
// var roles = await db.Connection().QueryAsync(qry);
// Token
nguoidung.token = BuildToken();
//Update last login
// nguoidung.last_login = DateTime.Now;
qry = $"update ttkd_bkn.nguoidung set last_login={DateTime.Now.ParseDateTime()},token='{nguoidung.token}' where nguoidung_id={nguoidung.nguoidung_id}";
await db.Connection.QueryAsync(qry);
var user = await db.Connection.QueryFirstOrDefaultAsync(userQuery(), new { nguoidung_id = nguoidung.nguoidung_id });
//await db.Connection().UpdateAsync(user);
return(Json(user));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
finally { }
}
public JsonResult Login(AuthObj obj)
{
try {
var Con = new TM.Core.Connection.Oracle("ORA_PORTAL");
var qry = "";
//var collection = HttpContext.Request.ReadFormAsync();
//string username = collection["username"].ToString();
//string password = collection["password"].ToString();
//AuthStatic
var AuthStatic = Authentication.Core.Auth.isAuthStatic(obj.username, obj.password);
if (AuthStatic != null)
{
Authentication.Core.Auth.SetAuth(AuthStatic);
return(Json(new { success = "Đăng nhập thành công!", url = TM.Core.Helper.Url.RedirectContinue() }));
}
//AuthDB
qry = $"SELECT * FROM users WHERE username='******'";
var user = Con.Connection.QueryFirstOrDefault <Authentication.Core.Users>(qry); // db.users.SingleOrDefault(u => u.username == username);
//Account not Exist
if (user == null)
{
return(Json(new { danger = "Sai tên tài khoản hoặc mật khẩu!" }));
}
//Password wrong
obj.password = TM.Core.Encrypt.MD5.CryptoMD5TM(obj.password + user.salt);
if (user.password != obj.password)
{
return(Json(new { danger = "Sai tên tài khoản hoặc mật khẩu!" }));
}
//Account is locked
if (user.flag < 1)
{
return(Json(new { danger = "Tài khoản đã bị khóa. Vui lòng liên hệ admin!" }));
}
//Update last login
user.lastlogin = DateTime.Now;
Con.Connection.Update(user);
//Set Auth Account
Authentication.Core.Auth.SetAuth(user, AuthRoles(user), AuthAllowRoles());
var b = Authentication.Core.Auth.AuthUser;
var c = Authentication.Core.Auth.isAuth;
//return Redirect(TM.Url.RedirectContinue());
} catch (Exception) {
return(Json(new { danger = "Đăng nhập không thành công, vui lòng liên hệ admin!" }));
}
return(Json(new { success = "Đăng nhập thành công!", url = TM.Core.Helper.Url.RedirectContinue(obj.currentUrl, true) }));
}
public async Task <IActionResult> RemoveOne(int id)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
await db.Connection.GetAllAsync <Models.Core.Modules>();
return(Json(new { data = id, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> Post([FromBody] Models.Core.DBDonvi data)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
await db.Connection.InsertOraAsync(data);
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> Get(int id)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var data = await db.Connection.GetAsync <Models.Core.Permissions>(id);
return(Json(new { data = id, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> Get()
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var data = await db.Connection.GetAllAsync <Authentication.Core.Roles>();
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> Get(int id)
{
try
{
using (var db = new TM.Core.Connection.Oracle("DHSX"))
{
var user = await db.Connection.QueryFirstOrDefaultAsync(userQuery(), new { nguoidung_id = id });
return(Json(user));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
finally { }
}
public async Task <IActionResult> GetDictionary(string key)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var qry = $"select module_code,key,value from Dictionary where lower(lang_code)='{key.ToLower()}' order by lang_code,module_code,key";
var data = await db.Connection.QueryAsync <Dictionary>(qry);
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> GetNavigation()
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var qry = $"select * from Navigation";
var data = await db.Connection.QueryAsync <Navigation>(qry);
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
public async Task <IActionResult> GetByFlag(int key)
{
try
{
using (var db = new TM.Core.Connection.Oracle())
{
var qry = $"select * from Modules where flag in({key})";
var data = await db.Connection.QueryAsync <Models.Core.Modules>(qry);
return(Json(new { data = data, msg = TM.Core.Common.Message.success.ToString() }));
}
}
catch (System.Exception) { return(Json(new { msg = TM.Core.Common.Message.danger.ToString() })); }
}
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 { }
}
