private void btnAdd_Click(object sender, RoutedEventArgs e)
{
DateTime time = DateTime.Now;
if (!CheckNull()) return;
var record = new DocGia()
{
TenDocGia = txtTenDocGia.Text,
SDT = txtSDT.Text,
Email = txtEmail.Text,
DiaChi = txtDiaChi.Text,
NgayCap = time,
NgayHetHan = new DateTime(time.Year + 1, time.Month, time.Day),
VienChuc = chkVienChuc.IsChecked
};
if (!chkVienChuc.IsChecked.Value)
record.NamTotNgiep = (int)cbxNamTotNghiep.SelectedValue;
if (db.Add(record))
{
MessageBox.Show("Thêm thành công");
btnResetS_Click(null, null);
docGiaDataGrid.SelectedIndex = docGiaDataGrid.Items.Count - 1;
docGiaDataGrid.ScrollIntoView(record);
btnAdd.IsEnabled = false;
}
else MessageBox.Show("Thêm thất bại");
}
public TKDocGia(DocGia value)
{
this.MaDocGia = value.MaDocGia;
this.TenDocGia = value.TenDocGia;
this.SDT = value.SDT;
this.Email = value.Email;
this.DiaChi = value.DiaChi;
this.VienChuc = value.VienChuc;
this.PhieuMuon = value.PhieuMuon;
this.NamTotNgiep = value.NamTotNgiep;
this.NgayCap = value.NgayCap;
this.NgayHetHan = value.NgayHetHan;
}
// Thêm độc giả
public bool Add(DocGia value)
{
try
{
_db.DocGia.Add(value);
_db.SaveChanges();
return true;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return false;
}
}
// Cập nhật độc giả
public bool Update(DocGia value)
{
try
{
DocGia record = _db.DocGia.SingleOrDefault(v => v.MaDocGia == value.MaDocGia);
record.TenDocGia = value.TenDocGia;
record.SDT = value.SDT;
record.DiaChi = value.DiaChi;
record.Email = value.Email;
record.NamTotNgiep = value.NamTotNgiep;
record.NgayCap = value.NgayCap;
record.NgayHetHan = value.NgayHetHan;
record.VienChuc = value.VienChuc;
_db.SaveChanges();
return true;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return false;
}
}
private int DangMuonCout(DocGia value)
{
int number = 0;
foreach(var muon in value.PhieuMuon)
{
foreach(var ct in muon.CTPhieuMuon)
{
if (!ct.DaTra.Value)
number++;
}
}
return number;
}
