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 <PHIEUDEXUAT> hd = db.PHIEUDEXUATs.Where(st => st.SOPHIEUDX.Substring(3, 6).Equals(yy + mm + dd)).ToList();
hd = db.PHIEUDEXUATs.ToList().Where(h => h.SOPHIEUDX.Contains(yy + mm + dd)).ToList();
if (hd.Count == 0)
{
s = "DX-" + yy + mm.Substring(mm.Length - 2, 2) + dd.Substring(dd.Length - 2, 2) + "-0001";
}
else
{
string mahd = "000" + hd.Select(h => h.SOPHIEUDX.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 = "DX-" + 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.AddObject(TTKM);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
//Add CTPDX
public bool addCTPDX(string masp, string soluong, PHIEUDEXUAT pdx)
{
db = new CMART8Entities();
try
{
try
{
CTPHIEUDEXUAT ctdx = db.CTPHIEUDEXUATs.Single(st => st.SOPHIEU.Equals(pdx.SOPHIEUDX) && st.MASP.Equals(masp));
int dem = int.Parse(ctdx.SOLUONG.ToString()) + int.Parse(soluong);
ctdx.SOLUONG = dem;
db.SaveChanges();
return(true);
}
catch
{
CTPHIEUDEXUAT ctdx = new CTPHIEUDEXUAT();
ctdx.SOPHIEU = pdx.SOPHIEUDX;
ctdx.MASP = masp;
ctdx.SOLUONG = int.Parse(soluong);
db.CTPHIEUDEXUATs.Add(ctdx);
db.SaveChanges();
return(true);
}
}
catch {
return(false);
}
}
public List <LOAISANPHAM> searchListLSP(string sTmp)
{
db = new CMART8Entities();
//int tmp = int.Parse(sTmp.Trim());
//st.MALOAI.Contains(sTmp) ||st.TENLOAI.Contains(sTmp) || st.SOLUONGSP.Equals(int.Parse(sTmp))
//return db.LOAISANPHAMs.Where(st => st.MALOAI.Contains(sTmp) || st.TENLOAI.Contains(sTmp)|| st.SOLUONGSP.ToString().Contains(sTmp)).ToList();
return(db.LOAISANPHAMs.Where(st => st.MALOAI.Contains(sTmp) || st.TENLOAI.Contains(sTmp)).ToList());
}
public GUI_DX(TAIKHOAN tk)
{
TK = tk;
db = new CMART8Entities();
ctl = new BUS_DX();
InitializeComponent();
controlFunction(TK.QUYEN);
}
public GUI_Report(DateTime ngayBD, DateTime ngayKT, string sTmp)
{
BD = ngayBD;
KT = ngayKT;
THk = sTmp;
db = new CMART8Entities();
InitializeComponent();
}
public GUI_NHTS(TAIKHOAN tmp)
{
ctl = new BUS_NHTS();
TK = tmp;
db = new CMART8Entities();
InitializeComponent();
controlFunction(TK.QUYEN);
}
public GUI_CTTS(TAIKHOAN tmp, PHIEUNHAPHANGTRUSO tmp2)
{
TK = tmp;
PN = tmp2;
ctl = new BUS_NHTS();
db = new CMART8Entities();
InitializeComponent();
txtNg.Text = TK.HOTEN;
}
public GUI_DoiMK(TAIKHOAN tmp)
{
db = new CMART8Entities();
vl = new ValidationExtension();
TK = tmp;
InitializeComponent();
controlFunction(TK.QUYEN);
txtTen.Text = TK.HOTEN;
}
public bool deleteTTKM(String id)
{
db = new CMART8Entities();
KHUYENMAI TTKM = db.KHUYENMAIs.Single(st => st.MAKM.Contains(id));
db.KHUYENMAIs.DeleteObject(TTKM);
db.SaveChanges();
return(true);
}
public GUI_QLHD(TAIKHOAN tmp, string pos)
{
ctl = new BUS_QLHD();
db = new CMART8Entities();
TK = tmp;
POS = pos;
InitializeComponent();
controlFunction(TK.QUYEN);
}
public bool deleteSP(String id)
{
db = new CMART8Entities();
SANPHAM SP = db.SANPHAMs.Single(st => st.MASP.Contains(id));
db.SANPHAMs.DeleteObject(SP);
db.SaveChanges();
return(true);
}
public bool deleteNCC(String id)
{
db = new CMART8Entities();
NHACUNGCAP ncc = db.NHACUNGCAPs.Single(st => st.MANCC.Contains(id));
db.NHACUNGCAPs.DeleteObject(ncc);
db.SaveChanges();
return(true);
}
public bool deleteLSP(String id)
{
db = new CMART8Entities();
LOAISANPHAM LSP = db.LOAISANPHAMs.Single(st => st.MALOAI.Contains(id));
db.LOAISANPHAMs.DeleteObject(LSP);
db.SaveChanges();
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 GUI_CTDX(PHIEUNHAPHANGCHINHANH pn, TAIKHOAN tk)
{
TK = tk;
PN = pn;
ctl = new BUS_NHCN();
db = new CMART8Entities();
InitializeComponent();
txtNgay.Text = PN.NGAYNHAP.ToString();
txtNg.Text = TK.HOTEN;
cbCN.SelectedIndex = 0;
}
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);
}
private bool checkexitCTPDX(PHIEUDEXUAT pdx, string masp)
{
db = new CMART8Entities();
List <CTPHIEUDEXUAT> tmp = db.CTPHIEUDEXUATs.Where(st => st.SOPHIEU.Equals(pdx.SOPHIEUDX) && st.MASP.Equals(masp)).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);
}
//tao mới phiếu đề xuất
public PHIEUDEXUAT createPDX(string maTK)
{
db = new CMART8Entities();
PHIEUDEXUAT pdx = new PHIEUDEXUAT();
pdx.SOPHIEUDX = autoID();
pdx.NGAYDEXUAT = DateTime.Now;
pdx.MATK = maTK;
db.PHIEUDEXUATs.Add(pdx);
db.SaveChanges();
return(pdx);
}
public GUI_CTTS_Update(TAIKHOAN tmp, PHIEUNHAPHANGTRUSO tmp2)
{
TK = tmp;
PN = tmp2;
ctl = new BUS_NHTS();
udt = new BUS_NHTS_Update();
db = new CMART8Entities();
InitializeComponent();
txtNg.Text = TK.HOTEN;
cbSP.Text = PN.SOPHIEUDX;
txtNgay.Text = PN.NGAYNHAP.ToString();
}
public GUI_CTDX_Update(TAIKHOAN tk, PHIEUNHAPHANGCHINHANH pn)
{
PN = pn;
TK = tk;
db = new CMART8Entities();
udt = new BUS_NHCN_Update();
ctl = new BUS_NHCN();
InitializeComponent();
txtNgay.Text = PN.NGAYNHAP.ToString();
cbTS.Text = PN.SOPHIEUNHTS;
cbCN.Text = PN.CHINHANH;
txtNg.Text = TK.HOTEN;
}
public GUI_CTDX(TAIKHOAN tk, PHIEUDEXUAT pdx, string tmp)
{
TK = tk;
PDX = pdx;
tt = tmp;
ctl = new BUS_DX();
db = new CMART8Entities();
InitializeComponent();
controlFunction(tt);
TAIKHOAN tk2 = db.TAIKHOANs.Find(PDX.MATK);
txtNg.Text = tk2.HOTEN;
txtNgay.Text = PDX.NGAYDEXUAT.ToString();
loadlistCTDX();
}
public GUI_CTHD(string gui, TAIKHOAN tmp, HOADON tmp2, string pos)
{
TK = tmp;
HD = tmp2;
GUI = gui;
POS = pos;
ctlSP = new BUS_SanPham();
ctl = new BUS_QLHD();
db = new CMART8Entities();
vl = new ValidationExtension();
InitializeComponent();
controlFunction(GUI);
lstCTHD.Click += lstCTHD_Click;
}
//Delete CTPDX
public bool deleteCTPDX(string masp, PHIEUDEXUAT pdx)
{
db = new CMART8Entities();
try
{
CTPHIEUDEXUAT ctdx = db.CTPHIEUDEXUATs.Single(st => st.SOPHIEU.Equals(pdx.SOPHIEUDX) && st.MASP.Equals(masp));
db.CTPHIEUDEXUATs.Remove(ctdx);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
//Load combobox
public List <PHIEUDEXUAT> loadListPDX(PHIEUNHAPHANGTRUSO PN)
{
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);
}
}
pdx.Add(db.PHIEUDEXUATs.Single(st => st.SOPHIEUDX.Equals(PN.SOPHIEUDX)));
return(pdx);
}
//Update PDX
public bool updatePDX(PHIEUDEXUAT pdx, string mancc)
{
try
{
db = new CMART8Entities();
PHIEUDEXUAT dx = db.PHIEUDEXUATs.Find(pdx.SOPHIEUDX);
dx.MANCC = mancc;
db.Entry(dx).State = System.Data.EntityState.Modified;
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);
}
}
public bool updatePNHCN(PHIEUNHAPHANGCHINHANH PN, string sophieuTS, string chinhanh, DateTime ngay)
{
try
{
db = new CMART8Entities();
PHIEUNHAPHANGCHINHANH pn = db.PHIEUNHAPHANGCHINHANHs.Find(PN.SOPHIEU);
pn.SOPHIEUNHTS = sophieuTS;
pn.CHINHANH = chinhanh;
pn.NGAYNHAP = ngay;
db.Entry(pn).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
