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