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