//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)));
}
