public static void DeleteHoaDon(string mahd, string masach)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from h in dbMain.PhieuBans where h.MaPhieuBan == mahd && h.MaSach == masach select h;
PhieuBan pb = query.SingleOrDefault();
dbMain.PhieuBans.DeleteOnSubmit(pb);
dbMain.SubmitChanges();
}
}
public static void InsertHoaDon(string mahd, string masach, int soluong)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
PhieuBan pb = new PhieuBan();
pb.MaPhieuBan = mahd;
pb.MaSach = masach;
pb.SoLuong = soluong;
dbMain.PhieuBans.InsertOnSubmit(pb);
dbMain.SubmitChanges();
}
}
public static void UpdateHoaDon(string mahd, string masach, int soluong)
{
using (dbMainDataContext dbMain = new dbMainDataContext())
{
var query = from h in dbMain.PhieuBans where h.MaPhieuBan == mahd && h.MaSach == masach select h;
PhieuBan pb = query.SingleOrDefault();
// pb.MaPhieuBan = mahd;
pb.MaSach = masach;
pb.SoLuong = soluong;
dbMain.SubmitChanges();
}
}
public PhieuBan LayPhieuBan(String id)
{
DataTable tbl = factory.LayPhieuBan(id);
PhieuBan ph = null;
if (tbl.Rows.Count > 0)
{
ph = new PhieuBan();
ph.Id = Convert.ToString(tbl.Rows[0]["ID"]);
ph.NgayBan = Convert.ToDateTime(tbl.Rows[0]["NGAY_BAN"]);
ph.TongTien = Convert.ToInt64(tbl.Rows[0]["TONG_TIEN"]);
ph.DaTra = Convert.ToInt64(tbl.Rows[0]["DA_TRA"]);
ph.ConNo = Convert.ToInt64(tbl.Rows[0]["CON_NO"]);
KhachHangController ctrlKH = new KhachHangController();
ph.KhachHang = ctrlKH.LayKhachHang(Convert.ToString(tbl.Rows[0]["ID_KHACH_HANG"]));
ChiTietPhieuBanController ctrl = new ChiTietPhieuBanController();
ph.ChiTiet = ctrl.ChiTietPhieuBan(ph.Id);
}
return(ph);
}
