private void insertHoaDon()
{
hoaDon hd = new hoaDon();
hd.MaHD = txt_mahd.Text;
hd.MaKH = txt_makhachhang.Text;
hd.MaNV = txt_mnv.Text;
hd.Tongtien = txt_tien.Text;
hd.Ngaynhap = txt_date.Text;
hoadon.insert(hd);
}
//Xóa hóa đơn khỏi database
public bool deleteBill(int id)
{
hoaDon b = db.hoaDons.Where(x => x.maHoaDon == id).FirstOrDefault();
if (b != null)
{
db.hoaDons.DeleteOnSubmit(b);
db.SubmitChanges(); //cập nhật việc xóa vào CSDL
return(true); //xóa thành công
}
return(false);
}
public int insertOrders(eBill or) //Thêm hóa đơn
{
hoaDon ortempt = new hoaDon();
ortempt.ngayLapHD = or.OrderDate;
ortempt.maKH = or.CustomerID;
ortempt.maNV = or.EmployeeID;
db.hoaDons.InsertOnSubmit(ortempt);
db.SubmitChanges();
return(ortempt.maHoaDon);
}
public eBill getBillFromID(int id)
{
hoaDon hd = db.hoaDons.Where(x => x.maHoaDon == id).FirstOrDefault();
eBill temp = new eBill();
temp.BillID = hd.maHoaDon;
temp.CustomerID = hd.maKH;
temp.EmployeeID = hd.maNV;
temp.OrderDate = (DateTime)hd.ngayLapHD;
return(temp);
}
public void delete(hoaDon h)
{
openC();
SqlCommand cmd = new SqlCommand("sp_delete_hoaDon", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@maHD", h.MaHD));
cmd.ExecuteNonQuery();
closeC();
}
public void update(hoaDon h)
{
openC();
SqlCommand cmd = new SqlCommand("sp_update_hoaDon", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@maHD", h.MaHD));
cmd.Parameters.Add(new SqlParameter("@maKH", h.MaKH));
cmd.Parameters.Add(new SqlParameter("@maNV", h.MaNV));
cmd.Parameters.Add(new SqlParameter("@tongtien", h.Tongtien));
cmd.ExecuteNonQuery();
closeC();
}
public void delete(hoaDon h)
{
hd.delete(h);
}
public void update(hoaDon h)
{
hd.update(h);
}
public void insert(hoaDon h)
{
hd.insert(h);
}
