public bool addSP(string mahd, string masp, string sl, string dongia)
{
db = new CMART8Entities();
try
{
try {
CTHOADON cthd = db.CTHOADONs.Single(st => st.SOHD.Equals(mahd) && st.MASP.Equals(masp));
int dem = int.Parse(cthd.SOLUONG.ToString()) + int.Parse(sl);
cthd.SOLUONG = dem;
db.SaveChanges();
return(true);
}
catch
{
CTHOADON cthd = new CTHOADON();
cthd.SOHD = mahd;
cthd.MASP = masp;
cthd.DONGIA = float.Parse(dongia);
cthd.SOLUONG = int.Parse(sl);
db.CTHOADONs.Add(cthd);
db.SaveChanges();
return(true);
}
}
catch
{ return(false); }
}
public bool editSP(string id, string ten, string hinhanh, string maloai, string mancc)
{
db = new CMART8Entities();
SANPHAM SP = db.SANPHAMs.Single(st => st.MASP.Equals(id));
try
{
if (maloai != SP.MALOAI)
{
LOAISANPHAM lsp1 = db.LOAISANPHAMs.Single(st => st.MALOAI.Equals(maloai));
LOAISANPHAM lsp2 = db.LOAISANPHAMs.Single(st => st.MALOAI.Equals(SP.MALOAI));
SP.TENSP = ten;
SP.HINHANH = hinhanh;
SP.MALOAI = maloai;
SP.MANCC = mancc;
lsp2.SOLUONGSP = lsp2.SOLUONGSP - 1;
lsp1.SOLUONGSP = lsp1.SOLUONGSP + 1;
db.SaveChanges();
}
else
{
SP.TENSP = ten;
SP.HINHANH = hinhanh;
SP.MANCC = mancc;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public string autoID()
{
db = new CMART8Entities();
string s = "";
string yy = DateTime.Now.Year.ToString();
yy = yy.Substring(yy.Length - 2, 2);
string mm = "0" + DateTime.Now.Month.ToString();
mm = mm.Substring(mm.Length - 2, 2);
string dd = "0" + DateTime.Now.Day.ToString();
dd = dd.Substring(dd.Length - 2, 2);
List <PHIEUNHAPHANGCHINHANH> hd = db.PHIEUNHAPHANGCHINHANHs.Where(st => st.SOPHIEU.Substring(3, 6).Equals(yy + mm + dd)).ToList();
hd = db.PHIEUNHAPHANGCHINHANHs.ToList().Where(h => h.SOPHIEU.Contains(yy + mm + dd)).ToList();
if (hd.Count == 0)
{
s = "CN-" + yy + mm.Substring(mm.Length - 2, 2) + dd.Substring(dd.Length - 2, 2) + "-0001";
}
else
{
string mahd = "000" + hd.Select(h => h.SOPHIEU.Substring(10)).OrderBy(so => so).Last();
mahd = mahd.Substring(mahd.Length - 4, 4);
int ma = int.Parse(mahd) + 1;
mahd = "000" + ma.ToString();
mahd = mahd.Substring(mahd.Length - 4, 4);
s = "CN-" + yy + mm + dd + "-" + mahd;
}
return(s);
}
public bool addTTKM(string masp, float giakm, DateTime tgbd, DateTime tgkt, string noidung, string hinhanh)
{
db = new CMART8Entities();
KHUYENMAI TTKM = new KHUYENMAI();
try
{
TTKM.MAKM = DateTime.Now.ToString();
TTKM.MASP = masp;
TTKM.GIAKM = giakm;
TTKM.HINHANH = hinhanh;
//TTKM.THOIGIANBD = DateTime.Parse(tgbd);
//TTKM.THOIGIANKT = DateTime.Parse(tgkt);
TTKM.THOIGIANBD = tgbd;
TTKM.THOIGIANKT = tgkt;
TTKM.NOIDUNG = noidung;
db.KHUYENMAIs.Add(TTKM);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool deleteTK(string ID)
{
db = new CMART8Entities();
TAIKHOAN TK = db.TAIKHOANs.ToList().Single(st => st.MATK.Equals(ID));
db.TAIKHOANs.Remove(TK);
db.SaveChanges();
return(true);
}
public bool deleteTTKM(String id)
{
db = new CMART8Entities();
KHUYENMAI TTKM = db.KHUYENMAIs.Single(st => st.MAKM.Contains(id));
db.KHUYENMAIs.Remove(TTKM);
db.SaveChanges();
return(true);
}
public bool deleteLSG(string ID, string gia, string ngayhl)
{
db = new CMART8Entities();
LICHSUGIA LSG = db.LICHSUGIAs.ToList().Single(st => st.MASP.Equals(ID) && st.GIABAN.ToString().Equals(gia) && st.NGAYHIEULUC.ToString().Equals(ngayhl));
db.LICHSUGIAs.Remove(LSG);
db.SaveChanges();
return(true);
}
public bool checkExit(string username)
{
db = new CMART8Entities();
List <TAIKHOAN> tmp = db.TAIKHOANs.Where(st => st.TENDANGNHAP.Equals(username)).ToList();
if (tmp.Count != 0)
{
return(false);
}
return(true);
}
public bool checkExist(string sTmp)
{
db = new CMART8Entities();
List <KHUYENMAI> tmp = db.KHUYENMAIs.Where(st => st.MAKM.Equals(sTmp)).ToList();
if (tmp.Count != 0)
{
return(false);
}
return(true);
}
public bool checkExist(string sTmp)
{
db = new CMART8Entities();
List <NHACUNGCAP> tmp = db.NHACUNGCAPs.Where(st => st.TENNCC.Equals(sTmp) || st.MANCC.Equals(sTmp)).ToList();
if (tmp.Count != 0)
{
return(false);
}
return(true);
}
public bool checkExist(string sTmp)
{
db = new CMART8Entities();
List <SANPHAM> tmp = db.SANPHAMs.Where(st => st.TENSP.Equals(sTmp) || st.MASP.Equals(sTmp)).ToList();
if (tmp.Count != 0)
{
return(false);
}
return(true);
}
public void deleteListCTNHTS(string sophieuts)
{
db = new CMART8Entities();
List <CTPHIEUNHAPHANGTRUSO> tmp = db.CTPHIEUNHAPHANGTRUSOes.Where(x => x.SOPHIEUNHTS.Equals(sophieuts)).ToList();
foreach (CTPHIEUNHAPHANGTRUSO p in tmp)
{
db.CTPHIEUNHAPHANGTRUSOes.Remove(p);
}
db.SaveChanges();
}
public bool checkExit(string soPhieu)
{
db = new CMART8Entities();
List <PHIEUNHAPHANGTRUSO> tmp = db.PHIEUNHAPHANGTRUSOes.Where(st => st.SOPHIEUDX.Equals(soPhieu)).ToList();
if (tmp.Count != 0)
{
return(false);
}
return(true);
}
public PHIEUNHAPHANGCHINHANH createNHCN(TAIKHOAN tk)
{
db = new CMART8Entities();
PHIEUNHAPHANGCHINHANH pnh = new PHIEUNHAPHANGCHINHANH();
pnh.SOPHIEU = autoID();
pnh.NGAYNHAP = DateTime.Now;
pnh.MATK = tk.MATK;
db.PHIEUNHAPHANGCHINHANHs.Add(pnh);
db.SaveChanges();
return(pnh);
}
public PHIEUNHAPHANGTRUSO createNHTS(string matk)
{
db = new CMART8Entities();
string id = autoID();
PHIEUNHAPHANGTRUSO nhts = new PHIEUNHAPHANGTRUSO();
nhts.SOPHIEU = id;
nhts.MATK = matk;
nhts.NGAYNHAP = DateTime.Now;
db.PHIEUNHAPHANGTRUSOes.Add(nhts);
db.SaveChanges();
return(nhts);
}
public bool deleteSP(string sohd, string masp)
{
db = new CMART8Entities();
try
{
CTHOADON cthd = db.CTHOADONs.Single(st => st.SOHD.Equals(sohd) && st.MASP.Equals(masp));
db.CTHOADONs.Remove(cthd);
db.SaveChanges();
return(true);
}
catch {
return(false);
}
}
//Load combobox
public List <PHIEUDEXUAT> loadListPDX()
{
db = new CMART8Entities();
List <PHIEUDEXUAT> pdx = db.PHIEUDEXUATs.ToList();
for (int i = pdx.Count - 1; i >= 0; i--)
{
if (!checkExit(pdx.ElementAt(i).SOPHIEUDX))
{
pdx.RemoveAt(i);
}
}
return(pdx);
}
//Delete PN
public bool deletePN(PHIEUNHAPHANGTRUSO PN)
{
try
{
db = new CMART8Entities();
PHIEUNHAPHANGTRUSO pn = db.PHIEUNHAPHANGTRUSOes.Find(PN.SOPHIEU);
db.PHIEUNHAPHANGTRUSOes.Remove(pn);
db.SaveChanges();
return(true);
}
catch {
return(false);
}
}
//load dữ liệu cho combobox
public List <PHIEUNHAPHANGTRUSO> loadListNHTS()
{
db = new CMART8Entities();
List <PHIEUNHAPHANGTRUSO> pdx = db.PHIEUNHAPHANGTRUSOes.ToList();
for (int i = pdx.Count - 1; i >= 0; i--)
{
if (!checkExit(pdx.ElementAt(i).SOPHIEU))
{
pdx.RemoveAt(i);
}
}
return(pdx);
}
public bool deleteLSP(String id)
{
try
{
db = new CMART8Entities();
LOAISANPHAM LSP = db.LOAISANPHAMs.Single(st => st.MALOAI.Contains(id));
db.LOAISANPHAMs.Remove(LSP);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool deleteNCC(String id)
{
try
{
db = new CMART8Entities();
NHACUNGCAP ncc = db.NHACUNGCAPs.Single(st => st.MANCC.Contains(id));
db.NHACUNGCAPs.Remove(ncc);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
//update Phieu nhap hang tru so
public bool updatePNHTS(PHIEUNHAPHANGTRUSO PN, string tongTien, string soPhieuDX)
{
try
{
db = new CMART8Entities();
PHIEUNHAPHANGTRUSO pn = db.PHIEUNHAPHANGTRUSOes.Find(PN.SOPHIEU);
pn.TONGTIEN = ulong.Parse(tongTien);
pn.SOPHIEUDX = soPhieuDX;
db.Entry(pn).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(true);
}
catch {
return(false);
}
}
//add list Chi tiết phiếu nhập hàng trụ sở
public bool addListCTNHTS(List <CTPHIEUNHAPHANGTRUSO> list)
{
try
{
db = new CMART8Entities();
foreach (CTPHIEUNHAPHANGTRUSO item in list)
{
db.CTPHIEUNHAPHANGTRUSOes.Add(item);
}
db.SaveChanges();
return(true);
}
catch {
return(false);
}
}
public bool deleteSP(String id)
{
try
{
db = new CMART8Entities();
SANPHAM SP = db.SANPHAMs.Single(st => st.MASP.Contains(id));
LOAISANPHAM lsp = db.LOAISANPHAMs.Single(st => st.MALOAI.Equals(SP.MALOAI));
db.SANPHAMs.Remove(SP);
lsp.SOLUONGSP = lsp.SOLUONGSP - 1;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool editLSP(string id, string ten)
{
db = new CMART8Entities();
LOAISANPHAM LSP = db.LOAISANPHAMs.Single(st => st.MALOAI.Equals(id));
try
{
LSP.TENLOAI = ten;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
//Update Phiếu nhập hàng chi nhánh
public bool updatePNHTS(PHIEUNHAPHANGCHINHANH PN, string sophieuTS, string chinhanh)
{
try
{
db = new CMART8Entities();
PHIEUNHAPHANGCHINHANH pn = db.PHIEUNHAPHANGCHINHANHs.Find(PN.SOPHIEU);
pn.SOPHIEUNHTS = sophieuTS;
pn.CHINHANH = chinhanh;
db.Entry(pn).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public GUI_LichSuGia(TAIKHOAN tmp)
{
TK = tmp;
ctl = new BUS_LichSuGia();
ctlSP = new BUS_SanPham();
db = new CMART8Entities();
vl = new ValidationExtension();
InitializeComponent();
controlFunction(TK.QUYEN);
btnAdd.Click += btnAdd_Click;
btnEdit.Click += btnEdit_Click;
lstLSG.Click += lstLSG_Click;
btnSearch.Click += btnSearch_Click;
btnCancel.Click += btnCancel_Click;
btnSave.Click += btnSave_Click;
btnDelete.Click += btnDelete_Click;
}
public bool updateHD(string id, string tongtien, string tienkh, string tientra, string tongsl)
{
try
{
db = new CMART8Entities();
HOADON hd = db.HOADONs.Single(st => st.SOHD.Equals(id));
hd.TONGTIEN = tongtien;
hd.TIENKHACHDUA = tienkh;
hd.TIENKHATRA = tientra;
hd.TONGSL = int.Parse(tongsl);
db.SaveChanges();
return(true);
}
catch {
return(false);
}
}
public void addCTNHTS(string tmp, PHIEUNHAPHANGTRUSO PN, TAIKHOAN TK)
{
db = new CMART8Entities();
var ctpdx = db.CTPHIEUDEXUATs.Where(x => x.SOPHIEU.Equals(tmp)).ToList();
foreach (var item in ctpdx)
{
CTPHIEUNHAPHANGTRUSO nhts = new CTPHIEUNHAPHANGTRUSO();
nhts.SOPHIEUNHTS = PN.SOPHIEU;
nhts.MASP = item.MASP;
nhts.SOLUONG = item.SOLUONG;
nhts.GIANHAP = 0;
nhts.HANSD = DateTime.Now.AddMonths(6);
nhts.TINHTRANG = "Đủ";
db.CTPHIEUNHAPHANGTRUSOes.Add(nhts);
db.SaveChanges();
}
}
public HOADON createHD(string POS, string maTK)
{
db = new CMART8Entities();
string id = autoID();
HOADON hd = new HOADON();
hd.SOHD = id;
hd.NGAYBAN = DateTime.Now;
hd.MATK = maTK;
hd.POS = POS;
hd.TONGSL = 0;
hd.TONGTIEN = "0";
hd.TIENKHACHDUA = "0";
hd.TIENKHATRA = "0";
db.HOADONs.Add(hd);
db.SaveChanges();
return(hd);
}