public bool InsertData(DTO.BanDTO ban)
{
string query = string.Format("EXEC dbo.INSERT_BAN @MABAN = '{0}', @TRANGTHAI = {1}", ban.MaBan, ban.TrangThai);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return(result > 0);
}
public bool UpdateData(DTO.BanDTO ban)
{
//string query = string.Format("UPDATE dbo.BAN SET TRANGTHAI = '{0}' WHERE MABAN = '{1}'",ban.TrangThai,ban.MaBan);
string query = string.Format("EXEC dbo.UPDATE_TRANGTHAI_BAN @MABAN = '{0}',@TRANGTHAI = {1}", ban.MaBan, ban.TrangThai);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return(result > 0);
}
public bool LoadTrangThaiBanByMaBan(string maBan)
{
string query = string.Format("EXEC LOAD_TRANGTHAI_BY_MABAN @MABAN = '{0}'", maBan);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
DTO.BanDTO ban = new DTO.BanDTO(item);
return(ban.TrangThai);
}
return(false);
}
public List <DTO.BanDTO> LoadTableList()
{
List <DTO.BanDTO> tableList = new List <DTO.BanDTO>();
string query = string.Format("EXEC dbo.LOAD_DANHSACH_BAN");
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
DTO.BanDTO table = new DTO.BanDTO(item);
tableList.Add(table);
}
return(tableList);
}
public bool UpdateBanKhiThanhToan(string maBan)
{
DTO.BanDTO ban = new DTO.BanDTO(maBan, false);
return(DAL.BanDAL.Instance.UpdateData(ban));
}
public bool UpdateBanKhiLapHoaDon(string maBan)
{
DTO.BanDTO ban = new DTO.BanDTO(maBan, true);
return(DAL.BanDAL.Instance.UpdateData(ban));
}
