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 { } }