//public static Branch GetBranchId(string maPhongBan) //{ // var db = new SaleOnlineDbContext(); // var branch = db.Branches.FirstOrDefault(x => x.BranchCode.Equals(maPhongBan) & // x.IsAgentLink == false); // if (branch != null) // { // return branch; // } // db.Dispose(); // return null; //} public static Branch GetBranch(string maPhongBan) { var db = new SaleOnlineDbContext(); return(db.Branches.FirstOrDefault(x => x.BranchCode.Equals(maPhongBan) & x.IsAgentLink == false)); }
public static string LockUser(string userName) { string strOut = "N/A"; var db = new SaleOnlineDbContext(); var lstNvs = db.NhanViens.Where(x => x.MaSo == userName); if (lstNvs.Any()) { var user = lstNvs.FirstOrDefault(); if (user?.Lock != null && !user.Lock.Value) { user.Lock = true; db.SaveChanges(); strOut = "Đã lock"; } } else { strOut = "Không tồn tại"; } return(strOut); }
public static void CreateUserSale(NhanVien nhanVien) { var db = new SaleOnlineDbContext(); db.NhanViens.Add(nhanVien); db.SaveChanges(); }
public static void UpdateBranch() { var db = new SaleOnlineDbContext(); var dbHrm = new HrmDbContext(); var dbApb = new AbpHplDbContext(); var listPbs = dbApb.HplPhongBans; foreach (var pb in listPbs) { var branch = db.Branches.FirstOrDefault(x => x.BranchCode == pb.MaPhongBan); if (branch != null) { pb.BranchId = branch.BranchId; pb.BranchName = branch.BranchName; pb.BranchCode = branch.BranchCode; } var pbHrm = dbHrm.PhongBans.FirstOrDefault(x => x.MaPhongBan == pb.MaPhongBan); if (pbHrm != null) { pb.PhongBanId = pbHrm.PhongBanId; pb.PhongBanParentId = pbHrm.PhongBanChaId; pb.TenPhongBan = pbHrm.Ten; } pb.LastSyncToAd = DateTime.Now; } //SaleOnlineServices dbApb.SaveChanges(); dbApb.Dispose(); db.Dispose(); }
public static int FlattenAllHplPhongBan() { var db = new SaleOnlineDbContext(); var dbHrm = new HrmDbContext(); var dbApb = new AbpHplDbContext(); return(dbApb.FlattenAllHplPhongBan()); }
public static NhanVien GetNhanVienByUserName(string userName) { var db = new SaleOnlineDbContext(); var lstNvs = db.NhanViens.Where(x => x.MaSo == userName); if (lstNvs.Any()) { return(lstNvs.FirstOrDefault()); } return(null); }
public static PhongBan GetPhongBan(string maPhongBan) { var db = new SaleOnlineDbContext(); return(db.PhongBans.FirstOrDefault(x => x.TenPb.Equals(maPhongBan))); }