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