public bool InsertOrUpdateQuan(QUAN[] quans)
{
try
{
using (QLDLEntities db = new QLDLEntities())
{
foreach (QUAN quan in quans)
{
if (quan.MAQUAN == 0)
{
QUAN item = new QUAN()
{
TENQUAN = quan.TENQUAN,
SODLTOIDA = quan.SODLTOIDA
};
db.QUANs.Add(item);
}
else
{
QUAN item = db.QUANs.FirstOrDefault(x => x.MAQUAN == quan.MAQUAN);
item.TENQUAN = quan.TENQUAN;
item.SODLTOIDA = quan.SODLTOIDA;
}
}
db.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public int?InsertDaiLy(string tendl, string diachi, string dienthoai, int maquan, int loaidl)
{
try
{
using (QLDLEntities context = new QLDLEntities())
{
DAILY dl = new DAILY
{
TENDL = tendl,
DIACHI = diachi,
DIENTHOAI = dienthoai,
NGAYTIEPNHAN = DateTime.Now,
MAQUAN = maquan,
LOAIDL = loaidl,
TINHTRANG = 1, // 1: đang hoạt động, 0: đã dẹp tiệm
SONO = 0
};
context.DAILies.Add(dl);
context.SaveChanges();
return(dl.MADL);
}
}
catch
{
return(null);
}
}
public bool InsertOrUpdateMatHang(MATHANG[] mathangs)
{
try
{
using (QLDLEntities db = new QLDLEntities())
{
foreach (MATHANG mathang in mathangs)
{
if (mathang.MAHANG == 0)
{
MATHANG item = new MATHANG()
{
TENHANG = mathang.TENHANG,
DONGIA = mathang.DONGIA,
MADVT = mathang.MADVT,
};
db.MATHANGs.Add(item);
}
else
{
MATHANG item = db.MATHANGs.FirstOrDefault(x => x.MAHANG == mathang.MAHANG);
item.TENHANG = mathang.TENHANG;
item.DONGIA = mathang.DONGIA;
item.MADVT = mathang.MADVT;
}
}
db.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public bool InsertOrUpdateDonViTinh(DVT[] DVTs)
{
try
{
using (QLDLEntities db = new QLDLEntities())
{
foreach (DVT dvt in DVTs)
{
if (dvt.MADVT == 0)
{
DVT item = new DVT()
{
DVT1 = dvt.DVT1
};
db.DVTs.Add(item);
}
else
{
DVT item = db.DVTs.FirstOrDefault(x => x.MADVT == dvt.MADVT);
item.DVT1 = dvt.DVT1;
}
}
db.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public bool InsertOrUpdateLoaiDL(LOAIDL[] loaiDLs)
{
try
{
using (QLDLEntities db = new QLDLEntities())
{
foreach (LOAIDL loaiDL in loaiDLs)
{
if (loaiDL.MALOAI == 0)
{
LOAIDL item = new LOAIDL()
{
TENLOAI = loaiDL.TENLOAI,
SONOTOIDA = loaiDL.SONOTOIDA
};
db.LOAIDLs.Add(item);
}
else
{
LOAIDL item = db.LOAIDLs.FirstOrDefault(x => x.MALOAI == loaiDL.MALOAI);
item.TENLOAI = loaiDL.TENLOAI;
item.SONOTOIDA = loaiDL.SONOTOIDA;
}
}
db.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public int?AddNhanVien_TaiKhoan(NHANVIEN nhanvien, TAIKHOAN taikhoan)
{
try
{
using (QLDLEntities db = new QLDLEntities())
{
db.NHANVIENs.Add(nhanvien);
db.SaveChanges();
taikhoan.MANV = nhanvien.MANV;
db.TAIKHOANs.Add(taikhoan);
db.SaveChanges();
return(nhanvien.MANV);
}
}
catch (Exception e)
{
System.Console.Out.WriteLine(e.ToString());
return(null);
}
}
public bool InsertPhieuXuat(CTPX[] arr_ctpx, PHIEUXUATHANG pxh)
{
try
{
using (QLDLEntities context = new QLDLEntities())
{
// do EF ko hỗ trợ auto increase primary key khi bị chiếu tới nên dùng thủ công
context.Database.ExecuteSqlCommand("insert into phieuxuathang(madl,ngaylap,tongtien,sotientra,conlai,nguoixuat) values({0},{1},{2},{3},{4},{5});",
pxh.MADL, DateTime.Now, pxh.TONGTIEN, pxh.SOTIENTRA, pxh.CONLAI, pxh.NGUOIXUAT);
DAILY daily = context.DAILies.FirstOrDefault(dl => dl.MADL == pxh.MADL);
daily.SONO += (pxh.TONGTIEN - pxh.SOTIENTRA);
context.SaveChanges();
/// lấy mã phiếu cuối cùng (dòng mới vừa nhập) nếu hệ thống chạy song song là tạch :((
int value = int.Parse(context.PHIEUXUATHANGs
.OrderByDescending(p => p.MAPHIEU)
.Select(r => r.MAPHIEU)
.First().ToString());
// tạo các chi tiết phiếu xuất
foreach (CTPX ct in arr_ctpx)
{
ct.MAPHIEU = value;
context.CTPXes.Add(ct);
}
context.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Console.WriteLine("---------------------------------------------------------");
Console.WriteLine("{0}", e);
return(false);
}
}
public bool RemoveDaiLy(int madl)
{
try
{
using (QLDLEntities context = new QLDLEntities())
{
DAILY daily = context.DAILies.FirstOrDefault(dl => dl.MADL == madl);
context.DAILies.Remove(daily);
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public bool InsertPhieuThu(PHIEUTHUTIEN pt)
{
try
{
using (QLDLEntities context = new QLDLEntities())
{
DAILY daily = context.DAILies.FirstOrDefault(dl => dl.MADL == pt.MADL);
daily.SONO -= pt.SOTIEN;
context.PHIEUTHUTIENs.Add(pt);
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public bool UpdateNhanVien(vwCHUCVU_NHANVIEN_TAIKHOAN nhanvien)
{
try
{
using (QLDLEntities db = new QLDLEntities())
{
NHANVIEN nv = db.NHANVIENs.Where(p => p.MANV == nhanvien.MANV).Single();
nv.TENNV = nhanvien.TENNV.Length > 10 ? nhanvien.TENNV.Substring(0, 10) : nhanvien.TENNV;
nv.NGAYSINH = nhanvien.NGAYSINH;
nv.DIACHI = nhanvien.DIACHI.Length > 50 ? nhanvien.DIACHI.Substring(0, 50) : nhanvien.DIACHI; //.Substring(0, 50);
nv.MACHUCVU = nhanvien.MACHUCVU;
db.SaveChanges();
return(true);
}
}
catch (Exception e)
{
System.Console.Out.WriteLine(e.ToString());
return(false);
}
}
public bool UpdateDaiLy(int madl, string tendl, string diachi, string dienthoai, int maquan, int loaidl)
{
try
{
using (QLDLEntities context = new QLDLEntities())
{
DAILY daily = context.DAILies.FirstOrDefault(dl => dl.MADL == madl);
daily.TENDL = tendl;
daily.DIACHI = diachi;
daily.DIENTHOAI = dienthoai;
daily.MAQUAN = maquan;
daily.LOAIDL = loaidl;
context.SaveChanges();
return(true);
}
}
catch (Exception e)
{
System.Console.Out.WriteLine(e.ToString());
return(false);
}
}