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