private void button1_Click(object sender, EventArgs e) { PHIEUNHAPHANGTRUSO PN = db.PHIEUNHAPHANGTRUSOes.Find(lstNHTS.SelectedRows[0].Cells[0].Value); GUI_CTTS_Update ts = new GUI_CTTS_Update(TK, PN); this.Hide(); ts.ShowDialog(); this.Close(); }
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_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(); }
//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); }
public bool updatePNHTS(PHIEUNHAPHANGTRUSO PN, string sophieudx, string tongtien, string maTK, DateTime ngay) { try { db = new CMART8Entities(); PHIEUNHAPHANGTRUSO pn = db.PHIEUNHAPHANGTRUSOes.Find(PN.SOPHIEU); pn.SOPHIEUDX = sophieudx; pn.TONGTIEN = ulong.Parse(tongtien); pn.MATK = maTK; pn.NGAYNHAP = ngay; db.Entry(pn).State = System.Data.EntityState.Modified; db.SaveChanges(); return(true); } catch { return(false); } }
//Cập nhật chi tiết nhập hàng trụ sở public bool updateListCTTS(List <CTPHIEUNHAPHANGTRUSO> list, PHIEUNHAPHANGTRUSO PN) { db = new CMART8Entities(); try { List <CTPHIEUNHAPHANGTRUSO> tmp = db.CTPHIEUNHAPHANGTRUSOes.Where(st => st.SOPHIEUNHTS.Equals(PN.SOPHIEU)).ToList(); foreach (CTPHIEUNHAPHANGTRUSO it in tmp) { db.CTPHIEUNHAPHANGTRUSOes.Remove(it); db.SaveChanges(); } db = new CMART8Entities(); foreach (CTPHIEUNHAPHANGTRUSO item in list) { db.CTPHIEUNHAPHANGTRUSOes.Add(item); } db.SaveChanges(); return(true); } catch { return(false); } }
public List <CTPHIEUNHAPHANGTRUSO> loadListCTNHTS(PHIEUNHAPHANGTRUSO PN) { db = new CMART8Entities(); return(db.CTPHIEUNHAPHANGTRUSOes.Where(x => x.SOPHIEUNHTS.Equals(PN.SOPHIEU)).ToList()); }