public static bool edit(PhieuNhap phieu) { try { using (EntitiesDataContext db = new EntitiesDataContext()) { PHIEUNHAP px; px = (from p in db.PHIEUNHAPs where p.masophieunhap.Equals(phieu.MaSoPhieuNhap) select p).SingleOrDefault(); if (px == null) { return(false); } px.masonxb = phieu.MaSoNXB; px.ngaylap = phieu.NgayLap; px.nguoigiaosach = phieu.NguoiGiao; px.trangthai = phieu.TrangThai; px.tongtien = phieu.ChiTiet.Sum(ct => ct.SoLuong * ct.DonGia); // tính tổng tiền các chi tiết db.CHITIETPHIEUNHAPs.DeleteAllOnSubmit(px.CHITIETPHIEUNHAPs); db.SubmitChanges(); foreach (ChiTietPhieuNhap ct in phieu.ChiTiet) { ct.MaSoPhieuNhap = phieu.MaSoPhieuNhap; ChiTiet.add(ct); } return(true); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } }
public static int add(HoaDonNXB hoadon) { try { using (EntitiesDataContext db = new EntitiesDataContext()) { var hd = new HOADONNXB { masonxb = hoadon.MaSoNXB, ngaylap = hoadon.NgayLap, tongtien = hoadon.ChiTiet.Sum(ct => ct.SoLuong * ct.DonGia), trangthai = 0 }; db.HOADONNXBs.InsertOnSubmit(hd); db.SubmitChanges(); foreach (ChiTietHoaDonNXB ct in hoadon.ChiTiet) { ChiTiet.add(ct, hd.masohoadon); } return(hd.masohoadon); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(0); } }
public static int add(PhieuNhap phieunhap) { try { using (EntitiesDataContext db = new EntitiesDataContext()) { var phieu = new PHIEUNHAP() { masonxb = phieunhap.NXB.MaSoNXB, ngaylap = phieunhap.NgayLap, nguoigiaosach = phieunhap.NguoiGiao, tongtien = phieunhap.ChiTiet.Sum(ct => ct.SoLuong * ct.DonGia), trangthai = 0 }; db.PHIEUNHAPs.InsertOnSubmit(phieu); db.SubmitChanges(); ChiTiet.add(phieunhap.ChiTiet, phieu.masophieunhap); return(phieu.masophieunhap); } }catch (Exception ex) { Console.WriteLine(ex.Message); return(0); } }
public static bool edit(HoaDonNXB hoadon) { try { using (EntitiesDataContext db = new EntitiesDataContext()) { HOADONNXB hd; hd = (from p in db.HOADONNXBs where p.masohoadon.Equals(hoadon.MaSoHoaDon) select p).SingleOrDefault(); if (hd == null) { return(false); } hd.masonxb = hoadon.MaSoNXB; hd.ngaylap = hoadon.NgayLap; hd.trangthai = hoadon.TrangThai; hd.tongtien = hoadon.ChiTiet.Sum(ct => ct.SoLuong * ct.DonGia); // tính tổng tiền các chi tiết db.CHITIETHOADONNXBs.DeleteAllOnSubmit(hd.CHITIETHOADONNXBs); db.SubmitChanges(); foreach (ChiTietHoaDonNXB ct in hoadon.ChiTiet) { ChiTiet.add(ct, hoadon.MaSoHoaDon); } return(true); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } }