public bool Delete(DTO.HoaDonDTO data)
{
string query = "";
int result = DataProvider.Instance.ExecuteNonQuery(query);
return(result > 0);
}
public bool Insert(DTO.HoaDonDTO data)
{
string query = string.Format("EXEC dbo.INSERT_HOADON_TUSINHMA '{0}', '{1}', '{2}'", data.NgayLapHD, data.MaKH, data.MaNV);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return(result > 0);
}
public bool UpdateData(DTO.HoaDonDTO hoaDon)
{
string query = string.Format("EXEC dbo.UPDATE_HOADON @MAHD = '{0}',@NGAYLAPHD = '{1}',@TRANGTHAI = {2},@USERNAME = '******', @MABAN = '{4}'",
hoaDon.MaHD, hoaDon.NgayLapHD, hoaDon.TrangThai, hoaDon.UserName, hoaDon.MaBan);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return(result > 0);
}
public bool InsertData(DTO.HoaDonDTO hoaDon)
{
//string query = string.Format("INSERT INTO dbo.HOADON( MAHD ,NGAYLAPHD ,TRANGTHAI ,USERNAME ,MABAN)VALUES ( '{0}' ,GETDATE() ,{1} ,'{2}' ,'{3}')",
// hoaDon.MaBan,hoaDon.TrangThai,hoaDon.UserName,hoaDon.MaBan);
string query = string.Format("EXEC dbo.INSERT_HOADON_TUSINHMA @NGAYLAPHD = '{0}',@TRANGTHAI = {1},@USERNAME = '******', @MABAN = '{3}'",
hoaDon.NgayLapHD, hoaDon.TrangThai, hoaDon.UserName, hoaDon.MaBan);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return(result > 0);
}
public bool Delete(DTO.HoaDonDTO data)
{
return(DAL.HoaDonDAL.Instance.Delete(data));
}
public bool Insert(DTO.HoaDonDTO data)
{
return(DAL.HoaDonDAL.Instance.Insert(data));
}
public bool Update(DTO.HoaDonDTO data)
{
return(DAL.HoaDonDAL.Instance.Update(data));
}
