// private static async Task<CommonClass.MapEditor.Position> internal async Task GetCatege(Random rm) { var index = rm.Next(0, roomUrls.Count); var roomUrl = roomUrls[index]; var sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject( new { c = "GetCatege", }); var json = await Startup.sendInmationToUrlAndGetRes(roomUrl, sendMsg); Console.WriteLine(json); var obj = Newtonsoft.Json.JsonConvert.DeserializeObject <List <string> >(json); // return obj; // throw new NotImplementedException(); for (var i = 0; i < obj.Count; i += 2) { aModel am = new aModel(obj[i], obj[i + 1]); material.Add(am); } var x = (from item in material orderby item.modelType, item.modelName ascending select item).ToList(); material = x.ToList(); }
public static void InitDatabase() { aModel db = new aModel(); Database.SetInitializer(new MigrateDatabaseToLatestVersion <aModel, MyConfiguration>()); db.Database.Initialize(false); }
public async override Task <ActionResult> GetAll() { aModel db = new aModel(); try { List <eNhapHangNhaCungCapChiTiet> lstDetail = await db.eNhapHangNhaCungCapChiTiet.ToListAsync(); var qDT = from a in lstDetail group a by a.IDNhapHangNhaCungCap into b select new { IDNhapHangNhaCungCap = b.Key, NhapHangNhaCungCapChiTiets = b.ToList() }; List <eNhapHangNhaCungCap> lstMaster = await db.eNhapHangNhaCungCap.ToListAsync(); lstMaster.ForEach(a => { var b = qDT.FirstOrDefault(c => c.IDNhapHangNhaCungCap == a.KeyID); if (b != null) { b.NhapHangNhaCungCapChiTiets.ForEach(c => { a.eNhapHangNhaCungCapChiTiet.Add(c); }); } }); List <eNhapHangNhaCungCap> lstResult = new List <eNhapHangNhaCungCap>(lstMaster); return(Ok(lstResult)); } catch { return(BadRequest(new List <eNhapHangNhaCungCap>())); } }
async Task <IActionResult> SaveData(xFeature[] features) { aModel db = new aModel(); try { await db.Database.BeginTransactionAsync(); IEnumerable <xFeature> lstRemoves = await db.xFeature.ToListAsync(); db.xFeature.RemoveRange(lstRemoves.ToArray()); await db.AddRangeAsync(features.ToArray()); await db.SaveChangesAsync(); db.Database.CommitTransaction(); return(Ok(features)); } catch (Exception ex) { db.Database.RollbackTransaction(); ModelState.AddModelError("Exception_Message", ex.Message); return(BadRequest(ModelState)); } }
public virtual async Task <ActionResult> DeleteEntries(Object[] ids) { aModel db = new aModel(); try { ids = ids ?? new object[] { }; db.BeginTransaction(); foreach (object id in ids) { T Item = await db.Set <T>().FindAsync(id); db.Set <T>().Remove(Item); } await db.SaveChangesAsync(); db.CommitTransaction(); return(NoContent(ids)); } catch (Exception ex) { db.RollbackTransaction(); return(BadRequest(ex)); } }
public async Task <Boolean> DeleteEntries(Object[] ids) { try { Context = new aModel(); ids = ids ?? new object[] { }; await Context.Database.BeginTransactionAsync(); foreach (object id in ids) { T Item = await Context.Set <T>().FindAsync(id); Context.Set <T>().Remove(Item); } await Context.SaveChangesAsync(); Context.Database.CommitTransaction(); return(true); } catch { Context.Database.RollbackTransaction(); return(false); } }
public IList <eTinhThanh> DanhSachTinhThanh() { aModel db = new aModel(); try { IList <eTinhThanh> lstResult = db.eTinhThanh.ToList(); return(lstResult); } catch { return(new List <eTinhThanh>()); } }
public async Task <T> GetByID(Object id) { try { Context = new aModel(); T item = await Context.Set <T>().FindAsync(id.ConvertType <T>()); return(item ?? new T()); } catch { return(new T()); } }
public async Task <IList <eTinhThanh> > DanhSach63TinhThanh() { aModel db = new aModel(); try { IList <eTinhThanh> lstResult = await db.eTinhThanh.Where(x => x.IDLoai >= 1 && x.IDLoai <= 2).ToListAsync(); return(lstResult); } catch { return(new List <eTinhThanh>()); } }
public async Task <IEnumerable <T> > GetAll() { try { Context = new aModel(); IEnumerable <T> lstTemp = await Context.Set <T>().ToListAsync(); IList <T> lstResult = lstTemp.OrderBy <T, String>("Ten").ToList(); return(lstResult); } catch { return(new List <T>()); } }
HttpStatusCode CheckRole(ActionExecutingContext context) { try { Controller controller = (Controller)context.Controller; //IPAddress address = context.HttpContext.Connection.RemoteIpAddress; //ControllerActionDescriptor descriptor = (ControllerActionDescriptor)context.ActionDescriptor; //string MethodName = context.HttpContext.Request.Method.ToLower(); //string ControllerName = descriptor.ControllerName.ToLower(); //string ActionName = descriptor.ActionName.ToLower(); //string TemplateName = descriptor.AttributeRouteInfo.Template.ToLower(); ControllerActionDescriptor descriptor = (ControllerActionDescriptor)context.ActionDescriptor; string MethodName = context.HttpContext.Request.Method.ToLower(); string ControllerName = descriptor.ControllerName.ToLower(); string ActionName = descriptor.ActionName.ToLower(); string TemplateName = descriptor.AttributeRouteInfo.Template.ToLower(); aModel db = new aModel(); xAccount account = db.xAccount.Find(Convert.ToInt32(controller.Request.Headers["IDAccount"].ToList()[0])); if (account == null) { return(HttpStatusCode.BadRequest); } xUserFeature userFeature = db.xUserFeature .FirstOrDefault(x => x.IDPermission == account.IDPermission && x.Controller.Equals(ControllerName) && x.Action.Equals(ActionName) && x.Method.Equals(MethodName) && x.Path.Equals(TemplateName)); if (userFeature == null) { return(HttpStatusCode.BadRequest); } if (userFeature.TrangThai == 3) { return(HttpStatusCode.BadRequest); } return(HttpStatusCode.OK); } catch { return(HttpStatusCode.BadRequest); } }
public async Task AddModel(aModel m, WebSocket webSocket) { this.ID = "n" + Guid.NewGuid().ToString("N"); var sn = new { c = "AddModel", WebSocketID = 0, aModel = m, id = this.ID }; var sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(sn); var sendData = Encoding.ASCII.GetBytes(sendMsg); await webSocket.SendAsync(new ArraySegment <byte>(sendData, 0, sendData.Length), WebSocketMessageType.Text, true, CancellationToken.None); }
public async override Task <ActionResult> UpdateEntries(eNhapHangNhaCungCap[] Items) { aModel db = new aModel(); try { db.BeginTransaction(); db.eNhapHangNhaCungCap.AddOrUpdate(Items); Items.ToList().ForEach(async x => { IEnumerable <eNhapHangNhaCungCapChiTiet> lstDetail = await db.eNhapHangNhaCungCapChiTiet.Where(y => y.IDNhapHangNhaCungCap == x.KeyID).ToListAsync(); lstDetail.ToList().ForEach(y => { eNhapHangNhaCungCapChiTiet obj = x.eNhapHangNhaCungCapChiTiet.FirstOrDefault(z => z.KeyID == y.KeyID); if (obj == null) { db.eNhapHangNhaCungCapChiTiet.Remove(y); } else { db.Entry(y).CurrentValues.SetValues(obj); } }); x.eNhapHangNhaCungCapChiTiet.ToList().ForEach(y => { if (y.KeyID <= 0) { y.IDNhapHangNhaCungCap = x.KeyID; db.eNhapHangNhaCungCapChiTiet.Add(y); } }); }); await CapNhatCongNo(db, Items); await CapNhatTonKho(db, Items); await db.SaveChangesAsync(); db.CommitTransaction(); return(Ok(Items)); } catch (Exception ex) { db.RollbackTransaction(); return(BadRequest(ex)); } }
public async override Task <ActionResult> GetByID(Object id) { aModel db = new aModel(); try { eNhapHangNhaCungCap Item = await db.eNhapHangNhaCungCap.FindAsync(id); IEnumerable <eNhapHangNhaCungCapChiTiet> lstItemDetail = await db.eNhapHangNhaCungCapChiTiet.Where(x => x.IDNhapHangNhaCungCap == Item.KeyID).ToListAsync(); lstItemDetail.ToList().ForEach(x => Item.eNhapHangNhaCungCapChiTiet.Add(x)); return(Ok(Item)); } catch { return(BadRequest(new eNhapHangNhaCungCap())); } }
async static void InitDonViTinh() { aModel db = new aModel(); await Task.Factory.StartNew(() => { if (db.eDonViTinh.Count() == 0) { try { string Query = File.ReadAllText($@"{Directory.GetCurrentDirectory()}\wwwroot\InitData\DATA_eDonViTinh.sql"); db.Database.ExecuteSqlCommandAsync(Query, new SqlParameter[] { }).Wait(); } catch { } } }); }
public async Task <ActionResult> CongNoHienTai(int IDMaster, int IDNhaCungCap, DateTime NgayHienTai) { aModel db = new aModel(); try { IEnumerable <eCongNoNhaCungCap> lstCongNo = await db.eCongNoNhaCungCap.Where(x => x.IDNhaCungCap == IDNhaCungCap).ToListAsync(); lstCongNo = lstCongNo.Where(x => x.Ngay.Date <= NgayHienTai.Date); eCongNoNhaCungCap congNo = lstCongNo.FirstOrDefault(x => x.IDMaster == IDMaster) ?? new eCongNoNhaCungCap(); congNo.ConLai = lstCongNo.Where(x => x.IDMaster != IDMaster).ToList().Sum(x => x.ConLai); return(Ok(congNo)); } catch { return(BadRequest(new eCongNoNhaCungCap())); } }
void GetPrimaryKey() { aModel db = new aModel(); ModuleHelper.ListKeys = new List <IKey>(); var eTypes = db.Model.GetEntityTypes(); foreach (var eType in eTypes) { var keys = eType.GetKeys(); foreach (var key in keys) { ModuleHelper.ListKeys.Add(key); } } }
public virtual async Task <ActionResult> GetByID(Object id) { aModel db = new aModel(); try { //T item = await db.Set<T>().FindAsync(id.ConvertType<T>()); T Item = await db.Set <T>().FindAsync(id); return(Ok(Item ?? new T())); } catch { return(BadRequest(new T())); } }
async Task <IActionResult> InitTinhThanh() { aModel db = new aModel(); if (db.eTinhThanh.Count() == 0) { try { string Query = System.IO.File.ReadAllText($@"{Directory.GetCurrentDirectory()}\wwwroot\InitData\DATA_eTinhThanh.sql"); await db.Database.ExecuteSqlCommandAsync(Query, new SqlParameter[] { }); return(Ok($"Init data {(typeof(eTinhThanh).Name)} success.")); } catch (Exception ex) { return(BadRequest($"Init data {(typeof(eTinhThanh).Name)} fail: {ex}")); } } return(Ok($"No init {(typeof(eTinhThanh).Name)} data")); }
async Task <ActionResult> InitDonViTinh() { aModel db = new aModel(); if (db.eDonViTinh.Count() == 0) { try { string Query = System.IO.File.ReadAllText($@"{HttpRuntime.AppDomainAppPath}\wwwroot\InitData\DATA_eDonViTinh.sql"); await db.Database.ExecuteSqlCommandAsync(Query, new SqlParameter[] { }); return(Ok($"Init data {(typeof(eDonViTinh).Name)} success.")); } catch (Exception ex) { return(BadRequest($"Init data {(typeof(eDonViTinh).Name)} fail: {ex}")); } } return(Ok($"No init {(typeof(eDonViTinh).Name)} data")); }
public virtual async Task <ActionResult> GetAll() { aModel db = new aModel(); try { IEnumerable <T> lstTemp = await db.Set <T>().ToListAsync(); //IList<T> lstResult = lstTemp.OrderBy<T, String>("Ten").ToList(); List <T> lstResult = lstTemp.ToList(); return(Ok(lstResult)); } catch { return(BadRequest(new List <T>())); } }
private static void GetPrimaryKeys(aModel db) { string qSelectKey = "SELECT DISTINCT " + " PK_TableName = PK.TABLE_NAME, " + " PK_ColumnName = CU.COLUMN_NAME, " + " PK_Indentity = CAST(p.IS_IDENTITY as bit), " + " FK_TableName = '', " + " FK_ColumnName = '', " + " FK_Indentity = CAST(0 as bit) " + "FROM " + " INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK " + " LEFT JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CU ON CU.Table_Name = PK.Table_Name " + " LEFT JOIN( " + " SELECT c.name COLUMN_NAME, t.name TABLE_NAME, c.is_identity IS_IDENTITY " + " FROM " + " sys.tables t " + " left join sys.columns c on c.object_id= t.object_id) p ON p.COLUMN_NAME = CU.COLUMN_NAME and p.TABLE_NAME = PK.TABLE_NAME " + "WHERE " + " CU.Constraint_Name = PK.Constraint_Name AND Constraint_Type = 'PRIMARY KEY' " + "UNION " + "SELECT DISTINCT " + " PK_TableName = PK.TABLE_NAME, " + " PK_ColumnName = PT.COLUMN_NAME, " + " PK_Indentity = CAST(0 as bit), " + " FK_TableName = FK.TABLE_NAME, " + " FK_ColumnName = CU.COLUMN_NAME, " + " FK_Indentity = CAST(0 as bit) " + "FROM " + " INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C " + " LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME " + " LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME " + " LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME " + " LEFT JOIN( " + " SELECT DISTINCT " + " i1.TABLE_NAME, " + " i2.COLUMN_NAME " + " FROM " + " INFORMATION_SCHEMA.TABLE_CONSTRAINTS i1 " + " LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2 ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME " + " WHERE " + " i1.CONSTRAINT_TYPE = 'PRIMARY KEY') PT ON PT.TABLE_NAME = PK.TABLE_NAME"; lstSchemaKeys = new List <ColumnKey>(db.Database.SqlQuery <ColumnKey>(qSelectKey).ToList()); }
public async Task DrawModel(aModel m, CommonClass.databaseModel.detailmodel dm, WebSocket webSocket) { //this.ID = "n" + Guid.NewGuid().ToString("N"); var sn = new { c = "DrawModel", WebSocketID = 0, aModel = m, id = dm.modelID, x = dm.x, y = dm.y, z = dm.z, r = dm.rotatey }; var sendMsg = Newtonsoft.Json.JsonConvert.SerializeObject(sn); var sendData = Encoding.ASCII.GetBytes(sendMsg); await webSocket.SendAsync(new ArraySegment <byte>(sendData, 0, sendData.Length), WebSocketMessageType.Text, true, CancellationToken.None); }
async Task CapNhatTonKho(aModel db, eNhapHangNhaCungCap[] Items) { foreach (eNhapHangNhaCungCap item in Items) { foreach (eNhapHangNhaCungCapChiTiet itemDT in item.eNhapHangNhaCungCapChiTiet) { eTonKho tonKho = await db.eTonKho.FirstOrDefaultAsync(x => x.IsNhapHang && x.IDMaster == item.KeyID && x.IDDetail == itemDT.KeyID); if (tonKho == null) { tonKho = new eTonKho(); tonKho.IDSanPham = itemDT.IDSanPham; tonKho.IDNhomSanPham = itemDT.IDNhomSanPham; tonKho.IDDonViTinh = itemDT.IDDonViTinh; tonKho.IDMaster = item.KeyID; tonKho.IDDetail = itemDT.KeyID; tonKho.NguoiTao = item.NguoiTao; tonKho.MaNguoiTao = item.MaNguoiTao; tonKho.TenNguoiTao = item.TenNguoiTao; tonKho.NgayTao = item.NgayTao; tonKho.IsNhapHang = true; db.eTonKho.AddOrUpdate(tonKho); } else { tonKho.NguoiCapNhat = item.NguoiCapNhat; tonKho.MaNguoiCapNhat = item.MaNguoiCapNhat; tonKho.TenNguoiCapNhat = item.TenNguoiCapNhat; tonKho.NgayCapNhat = item.NgayCapNhat; } tonKho.Ngay = item.NgayNhap; tonKho.MaSanPham = itemDT.MaSanPham; tonKho.TenSanPham = itemDT.TenSanPham; tonKho.MaNhomSanPham = itemDT.MaNhomSanPham; tonKho.TenNhomSanPham = itemDT.TenNhomSanPham; tonKho.MaDonViTinh = itemDT.MaDonViTinh; tonKho.TenDonViTinh = itemDT.TenDonViTinh; tonKho.HanSuDung = itemDT.HanSuDung; tonKho.SoLuongSi = itemDT.SoLuongSi; tonKho.SoLuongLe = itemDT.SoLuongLe; tonKho.SoLuong = itemDT.SoLuong; } } }
public async Task <Boolean> UpdateEntry(T Item) { try { Context = new aModel(); await Context.Database.BeginTransactionAsync(); Context.Set <T>().Update(Item); await Context.SaveChangesAsync(); Context.Database.CommitTransaction(); return(true); } catch { Context.Database.RollbackTransaction(); return(false); } }
public virtual async Task <ActionResult> UpdateEntry(T Item) { aModel db = new aModel(); try { db.BeginTransaction(); db.Set <T>().AddOrUpdate(Item); await db.SaveChangesAsync(); db.CommitTransaction(); return(Ok(Item)); } catch (Exception ex) { db.RollbackTransaction(); return(BadRequest(ex)); } }
public async Task <ActionResult> Login() { aModel db = new aModel(); try { string Username = Request.Headers["Username"]; string Password = Request.Headers["Password"]; if (string.IsNullOrWhiteSpace(Username) || string.IsNullOrWhiteSpace(Password)) { throw new Exception("Username hoặc Password không hợp lệ"); } xTaiKhoan account = await db.xTaiKhoan.FirstOrDefaultAsync(x => x.Username.ToLower().Equals(Username.ToLower()) && x.Password.ToLower().Equals(Password.ToLower())); if (account == null) { throw new Exception("Tài khoản không tồn tại"); } xNhanVien personnel = await db.xNhanVien.FindAsync(account.KeyID); if (personnel == null) { throw new Exception("Nhân viên không tồn tại"); } ThongTinNguoiDung user = new ThongTinNguoiDung() { xPersonnel = personnel, xAccount = account }; return(Ok(user)); } catch (Exception ex) { ModelState.AddModelError("Exception_Message", ex.Message); return(BadRequest(ModelState)); } }
public virtual async Task <ActionResult> DeleteEntry(T Item) { aModel db = new aModel(); try { db.BeginTransaction(); db.Set <T>().Attach(Item); db.Set <T>().Remove(Item); await db.SaveChangesAsync(); db.CommitTransaction(); return(NoContent(Item)); } catch (Exception ex) { db.RollbackTransaction(); return(BadRequest(ex)); } }
async Task CapNhatCongNo(aModel db, eNhapHangNhaCungCap[] Items) { foreach (eNhapHangNhaCungCap item in Items) { eCongNoNhaCungCap congNo = await db.eCongNoNhaCungCap.FirstOrDefaultAsync(x => x.IsNhapHang && x.IDMaster == item.KeyID); if (congNo == null) { congNo = new eCongNoNhaCungCap(); congNo.IDNhaCungCap = item.IDNhaCungCap; congNo.IDMaster = item.KeyID; congNo.NguoiTao = item.NguoiTao; congNo.MaNguoiTao = item.MaNguoiTao; congNo.TenNguoiTao = item.TenNguoiTao; congNo.NgayTao = item.NgayTao; congNo.IsNhapHang = true; db.eCongNoNhaCungCap.AddOrUpdate(congNo); } else { congNo.NguoiCapNhat = item.NguoiCapNhat; congNo.MaNguoiCapNhat = item.MaNguoiCapNhat; congNo.TenNguoiCapNhat = item.TenNguoiCapNhat; congNo.NgayCapNhat = item.NgayCapNhat; } congNo.MaNhaCungCap = item.MaNhaCungCap; congNo.TenNhaCungCap = item.TenNhaCungCap; congNo.TrangThai = item.TrangThai; congNo.Ngay = item.NgayNhap; congNo.ThanhTien = item.ThanhTien; congNo.VAT = item.VAT; congNo.TienVAT = item.TienVAT; congNo.CK = item.ChietKhau; congNo.TienCK = item.TienChietKhau; congNo.TongTien = item.TongTien; congNo.NoCu = item.NoCu; congNo.ThanhToan = item.ThanhToan; congNo.ConLai = item.ConLai; congNo.GhiChu = item.GhiChu; } }
public async Task <Boolean> DeleteEntry(Object id) { try { Context = new aModel(); await Context.Database.BeginTransactionAsync(); T Item = await Context.Set <T>().FindAsync(id); Context.Set <T>().Remove(Item); await Context.SaveChangesAsync(); Context.Database.CommitTransaction(); return(true); } catch { Context.Database.RollbackTransaction(); return(false); } }