public bool DeleteReceipt(string bookID, string receiptID)
{
string query = string.Empty;
object[] para = { receiptID, bookID };
query += "DELETE FROM PHIEUMUON WHERE MAPM = @MAPM AND MASACH = @MASACH";
return(dataprovider.excuteNonQuery(query, para));
}
public bool CreateReturnReceipt(PhieuTraDTO returnreceipt)
{
string query = string.Empty;
object[] listpara = { returnreceipt.Mapm, returnreceipt.Masach, returnreceipt.Madg, returnreceipt.Ngaytra, returnreceipt.Tienphat };
query += "INSERT INTO PHIEUTRA (MAPM, MASACH, MADG, NGAYTRA, TIENPHAT)";
query += " VALUES ( @MaPM , @MaSach , @MaDG , @NgayTra , @TienPhat )";
return(dataprovider.excuteNonQuery(query, listpara));
}
public bool Edit(SachDTO sachDTO)
{
string query = string.Empty;
object[] listpara = { sachDTO.Tensach, sachDTO.Tacgia, sachDTO.Theloai, sachDTO.Nxb, sachDTO.Namxb, sachDTO.Ngaynhap, sachDTO.Dongia, sachDTO.Soluong, sachDTO.Luotmuon, sachDTO.Masach };
query += "UPDATE SACH ";
query += "SET TENSACH = @Tensach , TACGIA = @Tacgia , MATHELOAI = @Matheloai , NXB = @Nxb , NAMXB = @Namxb , ";
query += "NGAYNHAP = @Ngaynhap , DONGIA = @Dongia , SACH.SOLUONG = @Soluong , LUOTMUON = @Luotmuon ";
query += "WHERE MASACH = @Masach ";
return(dataprovider.excuteNonQuery(query, listpara));
}