public List <SachDTO> LoadListBooks()
{
List <SachDTO> ans = new List <SachDTO>();
string query = "SELECT MASACH, TENSACH, TACGIA, TENTHELOAI, NXB, NAMXB, NGAYNHAP, DONGIA, SACH.SOLUONG, LUOTMUON";
query += " FROM SACH, THELOAISACH";
query += " WHERE SACH.MATHELOAI=THELOAISACH.MATHELOAI";
query += " ORDER BY THELOAISACH.MATHELOAI ASC";
DataTable temp = dataprovider.Excutequery(query);
for (int i = 0; i < temp.Rows.Count; ++i)
{
SachDTO tmp = new SachDTO();
tmp.NewBook(temp.Rows[i]);
ans.Add(tmp);
}
return(ans);
}
public List <PhieuMuonDTO> LoadListReceipt()
{
List <PhieuMuonDTO> ans = new List <PhieuMuonDTO>();
string query = string.Empty;
query += "SELECT temp.MAPM, MASACH, PHIEUMUON.MADG, NGAYMUON, HANTRA, DOCGIA.HOTEN, temp.SOLUONG, MUCPHAT ";
query += "FROM PHIEUMUON, DOCGIA, (SELECT MAPM, count(MASACH) as SOLUONG FROM PHIEUMUON GROUP BY MAPM) as temp ";
query += "WHERE DOCGIA.MADG = PHIEUMUON.MADG and PHIEUMUON.MAPM = temp.MAPM";
DataTable temp = dataprovider.Excutequery(query);
if (temp == null)
{
return(ans);
}
for (int i = 0; i < temp.Rows.Count; ++i)
{
PhieuMuonDTO receipt = new PhieuMuonDTO(temp.Rows[i]);
ans.Add(receipt);
}
return(ans);
}
public List <TheLoaiSachDTO> LoadTheLoai()
{
List <TheLoaiSachDTO> ans = new List <TheLoaiSachDTO>();
string query = "SELECT *";
query += " FROM THELOAISACH";
DataTable temp = dataprovider.Excutequery(query);
for (int i = 0; i < temp.Rows.Count; ++i)
{
TheLoaiSachDTO tmp = new TheLoaiSachDTO();
tmp.NewCategory(temp.Rows[i]);
ans.Add(tmp);
}
return(ans);
}
public DataTable CheckAccount(string accountID, string password)
{
string query = "SELECT MATK FROM TAIKHOANNV WHERE TENTK='" + accountID + "' and MATKHAU='" + password + "'";
return(dataprovider.Excutequery(query));
}
