public CTDauSachView(DauSach value) { InitializeComponent(); lblMaDauSach.Content = value.MaDauSach; lblTenDauSach.Content = value.TenDauSach; lblMaLoai.Content = value.LoaiSach.TenLoai; lblMaNXB.Content = value.NXB.TenNXB; lblMaTacGia.Content = value.TacGia.TenTacGia; lblMaTrangThai.Content = value.TrangThaiDauSach.TenTrangThai; lblTomTat.Text = value.TomTat; }
// Thêm đầu sách public bool Add(DauSach value) { try { _db.DauSach.Add(value); _db.SaveChanges(); return true; } catch (Exception e) { Console.WriteLine(e.Message); return false; } }
private bool WriteExcel(DauSach record) { try { COMExcel.Application exApp = new COMExcel.Application(); string workbookPath = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), @"Resource\BCCuonSach.xlsx"); COMExcel.Workbook exBook = exApp.Workbooks.Open(workbookPath, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false); COMExcel.Worksheet exSheet = (COMExcel.Worksheet)exBook.Worksheets[1]; ((Microsoft.Office.Interop.Excel._Worksheet)exSheet).Activate(); exSheet.Cells[3, 3] = record.MaDauSach.ToString(); exSheet.Cells[4, 3] = record.TenDauSach; exSheet.Cells[5, 3] = record.LoaiSach.TenLoai; exSheet.Cells[6, 3] = record.NXB.TenNXB; exSheet.Cells[7, 3] = record.TacGia.TenTacGia; exSheet.Cells[8, 3] = record.CuonSach.Count; // Xuất danh sách int i = 1; foreach(CuonSach item in record.CuonSach) { exSheet.Cells[11 + i, 1] = i; exSheet.Cells[11 + i, 2] = item.MaCuonSach; exSheet.Cells[11 + i, 3] = item.TinhTrangCuonSach.TenTinhTrang; i++; } // i = i + 10; COMExcel.Range r = (COMExcel.Range)exSheet.get_Range("A12", "C" + i); r.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous; r.Borders.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Black); // Lưu file SaveFileDialog dialog = new SaveFileDialog { FileName = "BCCuonSach.xls", Filter = "Excel files|*.xls", DefaultExt = "xls", Title = "Chọn nơi lưu tệp báo cáo" }; if (dialog.ShowDialog() == true) { exBook.SaveAs(dialog.FileName, COMExcel.XlFileFormat.xlWorkbookNormal, null, null, false, false, COMExcel.XlSaveAsAccessMode.xlExclusive, false, false, false, false, false); MessageBox.Show("Xuất báo cáo thành công"); } // exBook.Close(false, false, false); exApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(exBook); System.Runtime.InteropServices.Marshal.ReleaseComObject(exApp); return true; } catch (Exception ex) { Console.WriteLine(ex.Message); return false; } }
// Cập nhật đầu sách public bool Update(DauSach value) { try { DauSach record = _db.DauSach.SingleOrDefault(v => v.MaDauSach == value.MaDauSach); record.TenDauSach = value.TenDauSach; record.MaLoai = value.MaLoai; record.MaNXB = value.MaNXB; record.MaTrangThai = value.MaTrangThai; record.TomTat = value.TomTat; _db.SaveChanges(); return true; } catch (Exception e) { Console.WriteLine(e.Message); return false; } }
private void btnAdd_Click(object sender, RoutedEventArgs e) { if (!CheckNull()) return; var record = new DauSach() { TenDauSach = txtTenDauSach.Text, MaLoai = (int)cbxMaLoai.SelectedValue, MaNXB = (int)cbxMaNXB.SelectedValue, MaTacGia = (int)cbxMaTacGia.SelectedValue, MaTrangThai = (int)cbxMaTrangThai.SelectedValue, TomTat = txtTomTat.Text }; if (db.Add(record)) { MessageBox.Show("Thêm thành công"); btnResetS_Click(null, null); dauSachDataGrid.SelectedIndex = dauSachDataGrid.Items.Count - 1; dauSachDataGrid.ScrollIntoView(record); btnAdd.IsEnabled = false; } else MessageBox.Show("Thêm thất bại"); }