public static List <SachDTO> loadByMaLoai(string MaLoai)
{
string sCommand = string.Format("select sach.* from sach join theloai on (sach.maloai = theloai.maloai) where theloai.maloai = {0}", int.Parse(MaLoai));
con = DataProvider.openConnection();
DataTable dt = DataProvider.getDataTable(sCommand, con);
int n = dt.Rows.Count;
if (n <= 0)
{
DataProvider.closeConnection(con);
return(null);
}
List <SachDTO> result = new List <SachDTO>();
for (int i = 0; i < n; i++)
{
SachDTO sach = new SachDTO();
sach.MaSach = int.Parse(dt.Rows[i]["MaSach"].ToString());
sach.TenSach = dt.Rows[i]["tenSach"].ToString();
sach.TacGia = dt.Rows[i]["tacGia"].ToString();
sach.DonGiaNhap = double.Parse(dt.Rows[i]["DonGiaNhap"].ToString());
sach.DonGiaBan = double.Parse(dt.Rows[i]["DonGiaBan"].ToString());
sach.SoLuong = int.Parse(dt.Rows[i]["soLuong"].ToString());
sach.MaLoai = int.Parse(dt.Rows[i]["MaLoai"].ToString());
sach.NgaySX = dt.Rows[i]["NgaySanXuat"].ToString();
sach.NgayNhap = dt.Rows[i]["NgayNhap"].ToString();
byte[] hinhAnh = (byte[])(dt.Rows[i]["hinhAnh"]);
if (hinhAnh == null)
{
sach.HinhAnh = null;
}
else
{
sach.HinhAnh = SachDTO.BitmapImageFromBytes(hinhAnh);
}
byte[] hinhAnhCover = (byte[])(dt.Rows[i]["HinhAnhCover"]);
if (hinhAnhCover == null)
{
sach.HinhAnhCover = null;
}
else
{
sach.HinhAnhCover = SachDTO.BitmapImageFromBytes(hinhAnhCover);
}
result.Add(sach);
}
DataProvider.closeConnection(con);
return(result);
}
public static List <SachDTO> loadLastedBook()
{
string sCommand = "select top 5 * from SACH order by NGAYNHAP desc ";
con = DataProvider.openConnection();
DataTable dt = DataProvider.getDataTable(sCommand, con);
int n = dt.Rows.Count;
if (n <= 0)
{
DataProvider.closeConnection(con);
return(null);
}
List <SachDTO> result = new List <SachDTO>();
for (int i = 0; i < n; i++)
{
SachDTO sach = new SachDTO();
sach.MaSach = int.Parse(dt.Rows[i]["MaSach"].ToString());
sach.TenSach = dt.Rows[i]["tenSach"].ToString();
sach.TacGia = dt.Rows[i]["tacGia"].ToString();
sach.DonGiaNhap = double.Parse(dt.Rows[i]["DonGiaNhap"].ToString());
sach.DonGiaBan = double.Parse(dt.Rows[i]["DonGiaBan"].ToString());
sach.SoLuong = int.Parse(dt.Rows[i]["soLuong"].ToString());
sach.MaLoai = int.Parse(dt.Rows[i]["MaLoai"].ToString());
sach.NgaySX = dt.Rows[i]["NgaySanXuat"].ToString();
sach.NgayNhap = dt.Rows[i]["NgayNhap"].ToString();
byte[] hinhAnh = (byte[])(dt.Rows[i]["hinhAnh"]);
if (hinhAnh == null)
{
sach.HinhAnh = null;
}
else
{
sach.HinhAnh = SachDTO.BitmapImageFromBytes(hinhAnh);
}
byte[] hinhAnhCover = (byte[])(dt.Rows[i]["HinhAnhCover"]);
if (hinhAnhCover == null)
{
sach.HinhAnhCover = null;
}
else
{
sach.HinhAnhCover = SachDTO.BitmapImageFromBytes(hinhAnhCover);
}
result.Add(sach);
}
DataProvider.closeConnection(con);
return(result);
}
private void btnAddImgAvatar_Click(object sender, RoutedEventArgs e)
{
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.DefaultExt = ".png";
dlg.Filter = "JPEG Files (*.jpeg)|*.jpeg|PNG Files (*.png)|*.png|JPG Files (*.jpg)|*.jpg|GIF Files (*.gif)|*.gif";
if (dlg.ShowDialog() == true)
{
imgLoc = dlg.FileName.ToString();
bytes = SachDTO.FileToByteArray(imgLoc);
Img__addBook_cover.ImageSource = SachDTO.BitmapImageFromBytes(bytes);
isImageChange = true;
}
}
public static SachDTO loadByID(string id)
{
string sCommand = "select* from sach where MaSach = " + int.Parse(id);
con = DataProvider.openConnection();
DataTable dt = DataProvider.getDataTable(sCommand, con);
int n = dt.Rows.Count;
if (n <= 0)
{
DataProvider.closeConnection(con);
return(null);
}
SachDTO sach = new SachDTO();
sach.MaSach = int.Parse(dt.Rows[0]["MaSach"].ToString());
sach.TenSach = dt.Rows[0]["tenSach"].ToString();
sach.TacGia = dt.Rows[0]["tacGia"].ToString();
sach.DonGiaNhap = double.Parse(dt.Rows[0]["DonGiaNhap"].ToString());
sach.DonGiaBan = double.Parse(dt.Rows[0]["DonGiaBan"].ToString());
sach.SoLuong = int.Parse(dt.Rows[0]["soLuong"].ToString());
sach.MaLoai = int.Parse(dt.Rows[0]["MaLoai"].ToString());
sach.NgaySX = dt.Rows[0]["NgaySanXuat"].ToString();
sach.NgayNhap = dt.Rows[0]["NgayNhap"].ToString();
byte[] hinhAnh = (byte[])(dt.Rows[0]["hinhAnh"]);
if (hinhAnh == null)
{
sach.HinhAnh = null;
}
else
{
sach.HinhAnh = SachDTO.BitmapImageFromBytes(hinhAnh);
}
byte[] hinhAnhCover = (byte[])(dt.Rows[0]["HinhAnhCover"]);
if (hinhAnhCover == null)
{
sach.HinhAnhCover = null;
}
else
{
sach.HinhAnhCover = SachDTO.BitmapImageFromBytes(hinhAnhCover);
}
DataProvider.closeConnection(con);
return(sach);
}
