public bool Add(ClassBill.Bill bill)
{
string query = "INSERT INTO HoaDon VALUES ( @MaHD , @NgayLap , @NguoiLap , @KhachHang )";
object[] para = new object[] { bill.MaHD, bill.NgayLap, bill.MaNV, bill.MaKH };
if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0)
{
return(true);
}
return(false);
}
public bool Edit(ClassBill.Bill bill)
{
string MaHD = bill.MaHD;
string query = "UPDATE HoaDon SET NgayLap = @NgayLap , NguoiLap = @MaNV , KhachHang = @MaKH WHERE MaHD = @MaHD ";
object[] para = new object[] { bill.NgayLap, bill.MaNV, bill.MaKH, bill.MaHD };
if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0)
{
return(true);
}
return(false);
}
