private void btnluu_Click(object sender, EventArgs e) { try { THAMSO songaymuon = new THAMSO(); songaymuon.tenthamso = "songaymuon"; songaymuon = dataThamSo.timThamSo(songaymuon); MUONSACH after = new MUONSACH(); if (cbxmdg.SelectedItem != null) after.madocgia = cbxmdg.SelectedItem.ToString(); if (cbxmacuonsach.SelectedItem != null) after.macuonsach = cbxmacuonsach.SelectedItem.ToString(); after.ngaygiomuon = dtngaygiomuon.Value; after.ngayhethan = after.ngaygiomuon.Date.AddDays(Convert.ToInt32(songaymuon.giatri)); if (dtngaygiotra.Enabled == true) after.ngaygiotra = dtngaygiotra.Value.Date; data.suaMuonTraSach(temp, after); MessageBox.Show("Đã lưu!"); noticeUpdateBackBook(); Close(); } catch(SqlException) { MessageBox.Show("Dữ liệu không hợp lệ!"); } }
public int themMuonTraSach(MUONSACH inf) { DataTable phieuMuon = timMuonTraSach(inf, 1); int chuaTra = 0; for (int i = 0; i < phieuMuon.Rows.Count; i++) { if (phieuMuon.Rows[i]["ngaygiotra"].ToString() == String.Empty) chuaTra++; } THAMSO sosachmuon = new THAMSO(); sosachmuon.tenthamso = "sosachmuon"; sosachmuon = dataThamSo.timThamSo(sosachmuon); THAMSO songaymuon = new THAMSO(); songaymuon.tenthamso = "songaymuon"; songaymuon = dataThamSo.timThamSo(songaymuon); /*for (int i = 0; i < Form1.thamSo.Count; i++) { if (Form1.thamSo[i].tenthamso == "sosachmuon") { sosachmuon = Form1.thamSo[i]; break; } } for (int i = 0; i < Form1.thamSo.Count; i++) { if (Form1.thamSo[i].tenthamso == "songaymuon") { songaymuon = Form1.thamSo[i]; break; } }*/ if (sosachmuon.tinhtrang == true) { if (chuaTra >= Convert.ToInt32(sosachmuon.giatri)) { return 0; } } DateTime hethan = new DateTime(); hethan = inf.ngaygiomuon.AddDays(Convert.ToInt32(songaymuon.giatri)); hethan = hethan.Date.AddHours(0).AddMinutes(0).AddSeconds(0); /*inf.ngayhethan = inf.ngaygiomuon.AddDays(Convert.ToInt32(songaymuon.giatri)); inf.ngayhethan.*/ inf.ngayhethan = hethan; try { data.MUONSACHes.Add(inf); data.SaveChanges(); } catch (DbUpdateException) { return -1; } return 1; }
public void suaThamSo(THAMSO inf) { var temp = data.THAMSOes.Find(inf.tenthamso); if (temp != null) { data.Entry(temp).CurrentValues.SetValues(inf); data.SaveChanges(); } }
public List<THAMSO> loadThamSo() { List<THAMSO> thamSo = new List<THAMSO>(); DataTable dt = loadTableThamSo(); THAMSO temp; for (int i = 0; i < dt.Rows.Count; i++) { temp = new THAMSO(); temp.tenthamso = dt.Rows[i]["tenthamso"].ToString(); temp.kieu = dt.Rows[i]["kieu"].ToString(); temp.giatri = dt.Rows[i]["giatri"].ToString(); temp.tinhtrang = (bool)dt.Rows[i]["tinhtrang"]; thamSo.Add(temp); } return thamSo; }
public THAMSO timThamSo(THAMSO inf) { return data.timThamSo(inf); }
public void suaThamSo(THAMSO inf) { data.suaThamSo(inf); }
private void btnsua_Click(object sender, EventArgs e) { try { int x = Convert.ToInt32(txthandungthe.Text); int y = Convert.ToInt32(txtsolantrehen.Text); int z = Convert.ToInt32(txtsongaykhoathe.Text); int t = Convert.ToInt32(txtsongaymuon.Text); int w = Convert.ToInt32(txtsosachmuon.Text); THAMSO songaymuon = new THAMSO(); songaymuon.tenthamso = "songaymuon"; songaymuon = data.timThamSo(songaymuon); songaymuon.giatri = txtsongaymuon.Text; data.suaThamSo(songaymuon); THAMSO handungthe = new THAMSO(); handungthe.tenthamso = "handungthe"; handungthe = data.timThamSo(handungthe); handungthe.giatri = txthandungthe.Text; data.suaThamSo(handungthe); THAMSO solantrehen = new THAMSO(); solantrehen.tenthamso = "solantrehen"; solantrehen = data.timThamSo(solantrehen); if (cbsolantrehen.Checked == true) { solantrehen.tinhtrang = true; solantrehen.giatri = txtsolantrehen.Text; } else { solantrehen.giatri = txtsolantrehen.Text; solantrehen.tinhtrang = false; } data.suaThamSo(solantrehen); THAMSO songaykhoathe = new THAMSO(); songaykhoathe.tenthamso = "songaykhoathe"; songaykhoathe = data.timThamSo(songaykhoathe); if (cbsolantrehen.Checked == true) { songaykhoathe.tinhtrang = true; songaykhoathe.giatri = txtsongaykhoathe.Text; } else { songaykhoathe.giatri = txtsolantrehen.Text; songaykhoathe.tinhtrang = false; } data.suaThamSo(songaykhoathe); THAMSO sosachmuon = new THAMSO(); sosachmuon.tenthamso = "sosachmuon"; sosachmuon = data.timThamSo(sosachmuon); if (cbsosachmuon.Checked == true) { sosachmuon.giatri = txtsosachmuon.Text; } else { sosachmuon.giatri = txtsosachmuon.Text; sosachmuon.tinhtrang = false; } data.suaThamSo(sosachmuon); string matkhau = dataMatKhau.layMatKhau(); MATKHAU mkcu = new MATKHAU(); mkcu.matkhau1 = matkhau; mkcu = dataMatKhau.tim(mkcu); MATKHAU mkmoi = new MATKHAU(); mkmoi.matkhau1 = matkhau; if (cbcandangnhap.Checked == true) mkmoi.candangnhap = true; else mkmoi.candangnhap = false; dataMatKhau.suaMatKhau(mkcu, mkmoi); MessageBox.Show("Đã lưu!"); Close(); noticeUpdateThamSo(); } catch (FormatException) { MessageBox.Show("Chỉnh sửa không hợp lệ!"); } }
private void Setting_Load(object sender, EventArgs e) { THAMSO songaymuon = new THAMSO(); songaymuon.tenthamso = "songaymuon"; songaymuon = data.timThamSo(songaymuon); THAMSO sosachmuon = new THAMSO(); sosachmuon.tenthamso = "sosachmuon"; sosachmuon = data.timThamSo(sosachmuon); THAMSO handungthe = new THAMSO(); handungthe.tenthamso = "handungthe"; handungthe = data.timThamSo(handungthe); THAMSO solantrehen = new THAMSO(); solantrehen.tenthamso = "solantrehen"; solantrehen = data.timThamSo(solantrehen); THAMSO songaykhoathe = new THAMSO(); songaykhoathe.tenthamso = "songaykhoathe"; songaykhoathe = data.timThamSo(songaykhoathe); txthandungthe.Text = handungthe.giatri; txtsongaymuon.Text = songaymuon.giatri; if (sosachmuon.tinhtrang != true) { cbsosachmuon.Checked = false; } else { txtsosachmuon.Text = sosachmuon.giatri; } if (solantrehen.tinhtrang != true) { cbsolantrehen.Checked = false; } else { txtsolantrehen.Text = solantrehen.giatri; txtsongaykhoathe.Text = songaykhoathe.giatri; } bool canDangNhap = dataMatKhau.canDangNhap(); if (canDangNhap == true) cbcandangnhap.Checked = true; else cbcandangnhap.Checked = false; }
//cập nhật bảng vi phạm void updateViPham(string madocgia) { ViPham dataViPham = new ViPham(); ThamSo dataThamSo = new ThamSo(); VIPHAM inf = new VIPHAM(); THAMSO songaykhoathe; THAMSO solantrehen = new THAMSO(); inf.madocgia = madocgia; inf = dataViPham.timViPham(inf); solantrehen = new THAMSO(); solantrehen.tenthamso = "solantrehen"; solantrehen = dataThamSo.timThamSo(solantrehen); inf.vipham1++; if (solantrehen.tinhtrang == true) { if (inf.vipham1 % Convert.ToInt32(solantrehen.giatri) == 0) { khoaThe(madocgia); songaykhoathe = new THAMSO(); songaykhoathe.tenthamso = "songaykhoathe"; songaykhoathe = dataThamSo.timThamSo(songaykhoathe); inf.ngayhethan = DateTime.Now.Date.AddDays(Convert.ToInt32(songaykhoathe.giatri)); } } dataViPham.suaViPham(inf); //updateDocGia(); dgvdocgia.DataSource = dataDocGia.loadDocGia(); dgvhocsinh.DataSource = dataDocGia.loadHocSinh(); dgvnhanvien.DataSource = dataDocGia.loadNhanVien(); dgvvipham.DataSource = dataViPham.loadViPham(); }
//kiểm tra thẻ độc giả hết hạn void ktTheHetHan() { ThamSo dataThamSo = new ThamSo(); DataTable dt = dataDocGia.loadDocGia(); THAMSO handungthe = new THAMSO(); handungthe.tenthamso = "handungthe"; handungthe = dataThamSo.timThamSo(handungthe); DateTime ngaydk; DateTime ngayhethan; DOCGIA dg; for (int i = 0; i < dt.Rows.Count; i++) { ngaydk = new DateTime(); ngaydk = (DateTime)dt.Rows[i]["Ngày lập"]; ngayhethan = new DateTime(); ngayhethan = ngaydk.AddMonths(Convert.ToInt32(handungthe.giatri)); if (ngayhethan.Date < DateTime.Now.Date) //khóa thẻ { //dg = new DOCGIA(); //dg.madocgia = dt.Rows[i]["Mã độc giả"].ToString(); string madocgia = dt.Rows[i]["Mã độc giả"].ToString(); dg = dataDocGia.timDocGia(madocgia); dg.tinhtrang = false; dataDocGia.suaDocGia(dg); } } }
//kiểm tra phục hồi thẻ độc giả đã gia hạn void ktPhucHoiThe() { ViPham dataViPham = new ViPham(); ThamSo dataThamSo = new ThamSo(); DataTable dt = dataDocGia.loadDocGia(); THAMSO handungthe = new THAMSO(); handungthe.tenthamso = "handungthe"; handungthe = dataThamSo.timThamSo(handungthe); DateTime ngaydk; DateTime ngayhethan; DOCGIA dg; DataTable vp; for (int i = 0; i < dt.Rows.Count; i++) { vp = dataViPham.timViPham(dt.Rows[i]["Mã độc giả"].ToString()); ngaydk = new DateTime(); ngaydk = (DateTime)dt.Rows[i]["Ngày lập"]; ngayhethan = new DateTime(); ngayhethan = ngaydk.AddMonths(Convert.ToInt32(handungthe.giatri)); if (ngayhethan.Date >= DateTime.Now.Date && (vp.Rows[0]["ngayhethan"].ToString() == String.Empty || (DateTime)vp.Rows[0]["ngayhethan"] < DateTime.Now)) //mở thẻ { //dg = new DOCGIA(); string madocgia = dt.Rows[i]["Mã độc giả"].ToString(); //dg.madocgia = dt.Rows[i]["Mã độc giả"].ToString(); dg = dataDocGia.timDocGia(madocgia); if (dg.tinhtrang != true) { dg.tinhtrang = true; dataDocGia.suaDocGia(dg); } } } }
public THAMSO timThamSo(THAMSO inf) { return data.THAMSOes.Find(inf.tenthamso); }