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)); }