public bool them(PHIEUNHAP pmh) { try { data.PHIEUNHAPs.InsertOnSubmit(pmh); data.SubmitChanges(); return(true); } catch { return(false); } }
public bool themPhieuNhap(PHIEUNHAP pn) { try { qlhh.PHIEUNHAPs.InsertOnSubmit(pn); qlhh.SubmitChanges(); return(true); } catch { return(false); } }
public bool xoa(PHIEUNHAP pmh) { try { PHIEUNHAP mh = data.PHIEUNHAPs.Where(t => t.MAPN == pmh.MAPN.ToString()).FirstOrDefault(); data.PHIEUNHAPs.DeleteOnSubmit(mh); data.SubmitChanges(); return(true); } catch { return(false); } }
public bool thanhToanCongNoNCC(string mapn) { try { PHIEUNHAP pn = qlcn.PHIEUNHAPs.Where(t => t.MaPN == mapn).FirstOrDefault(); pn.TienNo = 0; qlcn.SubmitChanges(); return(true); } catch { return(false); } }
public bool suaPhieuNhap(string mapn, float tonggt, float tongsl, float tienno) { try { PHIEUNHAP pn = qlhh.PHIEUNHAPs.Where(t => t.MaPN == mapn).FirstOrDefault(); pn.TongGiaTriNhap = tonggt; pn.TongSoLuongNhap = tongsl; pn.TienNo = tienno; qlhh.SubmitChanges(); return(true); } catch { return(false); } }
public bool sua(PHIEUNHAP pmh) { try { PHIEUNHAP thanhvien = data.PHIEUNHAPs.Where(t => t.MAPN == pmh.MAPN.ToString()).FirstOrDefault(); data.Refresh(RefreshMode.OverwriteCurrentValues, thanhvien); thanhvien.SODONHANG = pmh.SODONHANG; thanhvien.NGAYNHAP = pmh.NGAYNHAP; thanhvien.TONGTIENNHAP = pmh.TONGTIENNHAP; data.SubmitChanges(); return(true); } catch (Exception e) { return(false); } }
public bool ktkc(PHIEUNHAP ma) { int r = data.PHIEUNHAPs.Count(t => t.MAPN == ma.MAPN.ToString()); try { if (r == 0) { return(true); } return(false); } catch { return(false); } }