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