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 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?KiemTraDangNhap(TAIKHOAN taikhoan)
{
try
{
using (QLDLEntities db = new QLDLEntities())
{
var all = from tk in db.TAIKHOANs
select tk;
foreach (var item in all)
{
if (item.TENDANGNHAP.Trim() == taikhoan.TENDANGNHAP &&
item.PASSWORD == taikhoan.PASSWORD)
{
return(item.MANV);
}
}
return(null);
}
}
catch (Exception e)
{
System.Console.Out.WriteLine(e.ToString());
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 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 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 vwDAILY_LOAIDL_QUAN GetDaiLyByMADL(int madl)
{
using (QLDLEntities context = new QLDLEntities())
{
vwDAILY_LOAIDL_QUAN daily =
context.vwDAILY_LOAIDL_QUAN.FirstOrDefault(dl => dl.MADL == madl);
return(daily);
}
}
public vwCHUCVU_NHANVIEN_TAIKHOAN GetNhanVienByMANV(int manv)
{
using (QLDLEntities context = new QLDLEntities())
{
vwCHUCVU_NHANVIEN_TAIKHOAN nhanvien =
context.vwCHUCVU_NHANVIEN_TAIKHOAN.FirstOrDefault(nv => nv.MANV == manv);
return(nhanvien);
}
}
public ObservableCollection <CHUCVU> GetALLChucVu()
{
ObservableCollection <CHUCVU> allChucVu = new ObservableCollection <CHUCVU>();
using (QLDLEntities context = new QLDLEntities())
{
var all = from chucvu in context.CHUCVUs
select chucvu;
foreach (var item in all)
{
allChucVu.Add(item);
}
}
return(allChucVu);
}
public ObservableCollection <vwCHUCVU_NHANVIEN_TAIKHOAN> GetAllNhanVien()
{
ObservableCollection <vwCHUCVU_NHANVIEN_TAIKHOAN> allNV = new ObservableCollection <vwCHUCVU_NHANVIEN_TAIKHOAN>();
using (QLDLEntities context = new QLDLEntities())
{
var allnhanvien = from vw in context.vwCHUCVU_NHANVIEN_TAIKHOAN
select vw;
foreach (var item in allnhanvien)
{
allNV.Add(item);
}
return(allNV);
}
}
public ObservableCollection <vw_PhieuXuat_NhanVien_DaiLy> GetAllPhieuXuat()
{
ObservableCollection <vw_PhieuXuat_NhanVien_DaiLy> allPX = new ObservableCollection <vw_PhieuXuat_NhanVien_DaiLy>();
using (QLDLEntities context = new QLDLEntities())
{
var allphieuxuat = from vw in context.vw_PhieuXuat_NhanVien_DaiLy
select vw;
foreach (var item in allphieuxuat)
{
allPX.Add(item);
}
}
return(allPX);
}
public ObservableCollection <MATHANG> GetAllMatHang()
{
ObservableCollection <MATHANG> allMH = new ObservableCollection <MATHANG>();
using (QLDLEntities context = new QLDLEntities())
{
var alldmathang = from mh in context.MATHANGs
select mh;
foreach (var item in alldmathang)
{
allMH.Add(item);
}
}
return(allMH);
}
public ObservableCollection <DVT> GetAllDVT()
{
ObservableCollection <DVT> allDVT = new ObservableCollection <DVT>();
using (QLDLEntities db = new QLDLEntities())
{
var all = from dvt in db.DVTs
select dvt;
foreach (var item in all)
{
allDVT.Add(item);
}
return(allDVT);
}
}
public ObservableCollection <QUAN> GetAllQuan()
{
ObservableCollection <QUAN> allQuan = new ObservableCollection <QUAN>();
using (QLDLEntities context = new QLDLEntities())
{
var all = from quan in context.QUANs
select quan;
foreach (var item in all)
{
allQuan.Add(item);
}
}
return(allQuan);
}
public ObservableCollection <vwDAILY_LOAIDL_QUAN> GetAllDaiLy()
{
ObservableCollection <vwDAILY_LOAIDL_QUAN> allDL = new ObservableCollection <vwDAILY_LOAIDL_QUAN>();
using (QLDLEntities context = new QLDLEntities())
{
var alldaily = from vw in context.vwDAILY_LOAIDL_QUAN
select vw;
foreach (var item in alldaily)
{
allDL.Add(item);
}
}
return(allDL);
}
public ObservableCollection <LOAIDL> GetAllLoaiDL()
{
ObservableCollection <LOAIDL> allLoai = new ObservableCollection <LOAIDL>();
using (QLDLEntities context = new QLDLEntities())
{
var all = from loai in context.LOAIDLs
select loai;
foreach (var item in all)
{
allLoai.Add(item);
}
}
return(allLoai);
}
public ObservableCollection <vw_PhieuXuat_NhanVien_DaiLy> GetPhieuXuatByDaiLy(int madl)
{
ObservableCollection <vw_PhieuXuat_NhanVien_DaiLy> PXs = new ObservableCollection <vw_PhieuXuat_NhanVien_DaiLy>();
using (QLDLEntities context = new QLDLEntities())
{
var allphieuxuat = from vw in context.vw_PhieuXuat_NhanVien_DaiLy
where vw.MADL == madl
select vw;
foreach (var item in allphieuxuat)
{
PXs.Add(item);
}
}
return(PXs);
}
public ObservableCollection <vw_PhieuXuat_CTPX_MatHang> GetCTPXPhieuXuatByMaPhieu(int maphieu)
{
ObservableCollection <vw_PhieuXuat_CTPX_MatHang> PXs = new ObservableCollection <vw_PhieuXuat_CTPX_MatHang>();
using (QLDLEntities context = new QLDLEntities())
{
var allphieuxuat = from vw in context.vw_PhieuXuat_CTPX_MatHang
where vw.MAPHIEU == maphieu
select vw;
foreach (var item in allphieuxuat)
{
PXs.Add(item);
}
}
return(PXs);
}
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 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 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);
}
}
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);
}
}
