public bool ThemPhieuDatBan(int mapd, DateTime ngaylap, int tongtien, int manv, int maban, int makh) { try { using (DatBanAnMonAnDataContext context = new DatBanAnMonAnDataContext()) { PhieuDatBanAn pd = new PhieuDatBanAn(); pd.MaPD = mapd; pd.NgayLap = ngaylap; pd.TongTien = tongtien; pd.MaNV = manv; pd.MaBan = maban; pd.MaKH = makh; context.PhieuDatBanAns.InsertOnSubmit(pd); context.SubmitChanges(); return(true); } } catch (Exception) { return(false); throw; } }
public bool SuaPhieuDatBan(int mapdsua, DateTime ngaylap, int tongtien, int manv, int maban, int makh) { try { using (DatBanAnMonAnDataContext context = new DatBanAnMonAnDataContext()) { PhieuDatBanAn pd = context.PhieuDatBanAns.FirstOrDefault(x => x.MaPD == mapdsua); pd.NgayLap = ngaylap; pd.TongTien = tongtien; pd.MaNV = manv; pd.MaBan = maban; pd.MaKH = makh; context.SubmitChanges(); return(true); } } catch (Exception) { return(false); throw; } }
public bool XoaPhieuDatBan(int mapdxoa) { try { using (DatBanAnMonAnDataContext context = new DatBanAnMonAnDataContext()) { PhieuDatBanAn pd = context.PhieuDatBanAns.FirstOrDefault(x => x.MaPD == mapdxoa); context.PhieuDatBanAns.DeleteOnSubmit(pd); context.SubmitChanges(); return(true); } } catch (Exception) { return(false); throw; } }