private void btnTimTen_Click(object sender, EventArgs e) { errorTimTen.SetError(txtTimMa, ""); if (txtTimTen.Text == "") { errorTimTen.SetError(txtTimTen, "Vui lòng nhập tên càn tìm"); return; } NguoiMuonSach nms = new NguoiMuonSach(); nms.HoTen = txtTimTen.Text; NguoiMuonSachBLL ngmsachbll = new NguoiMuonSachBLL(); List <NguoiMuonSach> dsngmsach = ngmsachbll.TimTenNguoiMuon(nms); lvNguoiMuonSachDS.Items.Clear(); foreach (NguoiMuonSach nmsbll in dsngmsach) { ListViewItem lvi = new ListViewItem(nmsbll.Id + ""); lvi.SubItems.Add(nmsbll.HoTen); lvi.SubItems.Add(nmsbll.SoDienThoai); //lvi.SubItems.Add(nms.BieuHien); lvi.SubItems.Add(nmsbll.DiaChi); lvi.SubItems.Add(nmsbll.Email); lvi.SubItems.Add(nmsbll.NamSinh + ""); lvNguoiMuonSachDS.Items.Add(lvi); } }
private void DangKyUser() { QuanTriVien qtvien = new QuanTriVien(); qtvien.HoTen = txtTen.Text; qtvien.NamSinh = int.Parse(txtNamSinh.Text); qtvien.TenDangNhap = txtTenDangNhap.Text; qtvien.SoDienThoai = txtSoDienThoai.Text; qtvien.Email = txtEmail.Text; qtvien.DiaChi = txtDiaChi.Text; qtvien.MatKhau = txtMatKhau1.Text; qtvien.KeyRestore = "resetpassword"; qtvien.Quyen = "User"; QuanTriVienBLL qtvbbl = new QuanTriVienBLL(); bool qtvienbll = qtvbbl.DangKy(qtvien); NguoiMuonSach nms = new NguoiMuonSach(); nms.HoTen = txtTen.Text; nms.SoDienThoai = txtSoDienThoai.Text; nms.DiaChi = txtDiaChi.Text; nms.Email = txtEmail.Text; nms.NamSinh = int.Parse(txtNamSinh.Text); NguoiMuonSachBLL nmsbll = new NguoiMuonSachBLL(); bool nmsnew = nmsbll.ThemDocGia(nms); if (qtvienbll && nmsnew) { MessageBox.Show("Đăng Ký Thành Công", "Thông Báo"); this.Close(); } }
private void btnTimMa_Click(object sender, EventArgs e) { errorTimMa.SetError(txtTimMa, ""); if (txtTimMa.Text == "") { errorTimMa.SetError(txtTimMa, "Vui lòng nhập mã càn tìm"); return; } errorIntTimMa.SetError(txtTimMa, ""); if (!txtTimMa.Text.All(char.IsDigit)) { errorTimMa.SetError(txtTimMa, "Mã là số"); return; } NguoiMuonSach nms = new NguoiMuonSach(); nms.Id = int.Parse(txtTimMa.Text); NguoiMuonSachBLL ngmsachbll = new NguoiMuonSachBLL(); List <NguoiMuonSach> dsngmsach = ngmsachbll.TimNguoiMuonTheoMa(nms); lvNguoiMuonSachDS.Items.Clear(); foreach (NguoiMuonSach nmsbll in dsngmsach) { ListViewItem lvi = new ListViewItem(nmsbll.Id + ""); lvi.SubItems.Add(nmsbll.HoTen); lvi.SubItems.Add(nmsbll.SoDienThoai); //lvi.SubItems.Add(nms.BieuHien); lvi.SubItems.Add(nmsbll.DiaChi); lvi.SubItems.Add(nmsbll.Email); lvi.SubItems.Add(nmsbll.NamSinh + ""); lvNguoiMuonSachDS.Items.Add(lvi); } }
private void btnTimTenDocGia_Click(object sender, EventArgs e) { /*errorTimDocGia.SetError(txtTimTenNMS, ""); * if(txtTimTenNMS.Text=="") * { * errorTimDocGia.SetError(txtTimTenNMS, "Nhập Tên Đọc Giả Cần Tìm"); * return; * } */ NguoiMuonSach nms = new NguoiMuonSach(); nms.HoTen = txtTimTenNMS.Text; NguoiMuonSachBLL ngmsachbll = new NguoiMuonSachBLL(); List <NguoiMuonSach> dsngmsach = ngmsachbll.TimTenNguoiMuon(nms); lvPMSTDocGia.Items.Clear(); foreach (NguoiMuonSach nmsbll in dsngmsach) { ListViewItem lvi = new ListViewItem(nmsbll.Id + ""); lvi.SubItems.Add(nmsbll.HoTen); lvPMSTDocGia.Items.Add(lvi); } }
private void ThemMoiDG() { NguoiMuonSach nms = new NguoiMuonSach(); nms.HoTen = txtTen.Text; nms.NamSinh = int.Parse(txtNamSinh.Text); nms.SoDienThoai = txtSoDienThoai.Text; nms.DiaChi = txtDiaChi.Text; nms.Email = txtEmail.Text; NguoiMuonSachBLL nmsbll = new NguoiMuonSachBLL(); bool nmsnew = nmsbll.ThemDocGia(nms); QuanTriVien qtv = new QuanTriVien(); qtv.HoTen = txtTen.Text; qtv.NamSinh = int.Parse(txtNamSinh.Text); qtv.TenDangNhap = txtTenDangNhap.Text; qtv.SoDienThoai = txtSoDienThoai.Text; qtv.Email = txtEmail.Text; qtv.DiaChi = txtDiaChi.Text; qtv.MatKhau = txtPass.Text; qtv.KeyRestore = "123"; qtv.Quyen = "User"; QuanTriVienBLL qtvbll = new QuanTriVienBLL(); bool qtvnew = qtvbll.ThemQuanTriVien(qtv); if (nmsnew && qtvnew) { MessageBox.Show("Nhấn Nút Cập Nhật Nhé.", "Thông Báo"); this.Close(); } }
private void HienThiPhieuUSer() { NguoiMuonSach nms = new NguoiMuonSach(); nms.Id = int.Parse(this.iddg); NguoiMuonSachBLL nmsbll = new NguoiMuonSachBLL(); List <NguoiMuonSach> dsngmsach = nmsbll.TimNguoiMuonTheoMa(nms); foreach (NguoiMuonSach tennms in dsngmsach) { this.ten = tennms.HoTen; } PhieuMuonSachDAO pms = new PhieuMuonSachDAO(); pms.TenNguoiMuonSach = ten; PhieuMuonSachBLL pmsdgbll = new PhieuMuonSachBLL(); List <PhieuMuonSachDAO> dsphieu = pmsdgbll.PhieuCuaDG(pms); lvPhieuMuonUser.Items.Clear(); foreach (PhieuMuonSachDAO ctpms in dsphieu) { ListViewItem lvi = new ListViewItem(ctpms.MaPhieuMuon + ""); lvi.SubItems.Add(ctpms.TenSach); lvi.SubItems.Add(ctpms.TrangThai); lvi.SubItems.Add(ctpms.NgayMuon.ToString()); lvi.SubItems.Add(ctpms.NgayDuKienTra.ToString()); lvi.SubItems.Add(ctpms.NgayTraSach.ToString()); lvPhieuMuonUser.Items.Add(lvi); } }
public List <NguoiMuonSach> LayToanBoNguoiMuonSach() { List <NguoiMuonSach> dsNguoiMuonSach = new List <NguoiMuonSach>(); OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "select * from NguoiMuonSach"; command.Connection = conn; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32(0); string hoten = reader.GetString(1); string sodienthoai = reader.GetString(2); string diachi = reader.GetString(3); string email = reader.GetString(4); int namsinh = reader.GetInt32(5); NguoiMuonSach nms = new NguoiMuonSach(); nms.Id = id; nms.HoTen = hoten; nms.SoDienThoai = sodienthoai; nms.DiaChi = diachi; nms.Email = email; nms.NamSinh = namsinh; dsNguoiMuonSach.Add(nms); } reader.Close(); CloseConnection(); return(dsNguoiMuonSach); }
private void btnCapNhat_Click(object sender, EventArgs e) { NguoiMuonSach nms = new NguoiMuonSach(); nms.Id = int.Parse(txtMa.Text); nms.HoTen = txtTen.Text; nms.NamSinh = int.Parse(txtNamSinh.Text); nms.SoDienThoai = txtSoDienThoai.Text; nms.DiaChi = txtDiaChi.Text; nms.Email = txtEmail.Text; NguoiMuonSachBLL nmsbll = new NguoiMuonSachBLL(); bool capnhatnms = nmsbll.CapNhatDocGia(nms); QuanTriVien qtv = new QuanTriVien(); qtv.DiaChi = txtDiaChi.Text; qtv.Email = txtEmail.Text; qtv.ID = int.Parse(txtMa.Text); qtv.NamSinh = int.Parse(txtNamSinh.Text); qtv.SoDienThoai = txtSoDienThoai.Text; qtv.HoTen = txtTen.Text; QuanTriVienBLL qtvbll = new QuanTriVienBLL(); bool capnhatqtv = qtvbll.ChinhSuaQuanTriVien(qtv); if (capnhatnms && capnhatqtv) { MessageBox.Show("Đã Thay Đổi Thành Công, Nhấn Cập Nhật Nhé ...", "Thông Báo"); this.Close(); } }
public bool ThemDocGia(NguoiMuonSach nms) { OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "insert into NguoiMuonSach(HoTen,SoDienThoai,DiaChi,Email,NamSinh)values" + "(N'" + nms.HoTen + "','" + nms.SoDienThoai + "', N'" + nms.DiaChi + "', '" + nms.Email + "', '" + nms.NamSinh + "')"; command.Connection = conn; int ketqua = command.ExecuteNonQuery(); return(ketqua > 0); }
public bool CapNhatDocGia(NguoiMuonSach nms) { OpenConnection(); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = "Update NguoiMuonSach set HoTen=N'" + nms.HoTen + "', SoDienThoai ='" + nms.SoDienThoai + "'," + " DiaChi =N'" + nms.DiaChi + "', Email='" + nms.Email + "', NamSinh='" + nms.NamSinh + "' where ID='" + nms.Id + "'"; command.Connection = conn; int ketqua = command.ExecuteNonQuery(); return(ketqua > 0); }
// End tab chờ đọc giả nhận sách // Start tab cho đọc giả mượn tại chỗ private void btnCMTCTimTenDG_Click(object sender, EventArgs e) { NguoiMuonSach nms = new NguoiMuonSach(); nms.HoTen = txtCMTCTimTenDG.Text; NguoiMuonSachBLL ngmsachbll = new NguoiMuonSachBLL(); List <NguoiMuonSach> dsngmsach = ngmsachbll.TimTenNguoiMuon(nms); lvCMTCDSDG.Items.Clear(); foreach (NguoiMuonSach nmsbll in dsngmsach) { ListViewItem lvi = new ListViewItem(nmsbll.Id + ""); lvi.SubItems.Add(nmsbll.HoTen); lvCMTCDSDG.Items.Add(lvi); } }
private void ThayDoiThongTin() { QuanTriVien qtv = new QuanTriVien(); qtv.TenDangNhap = txtAccount.Text; qtv.DiaChi = txtDiaChi.Text; qtv.Email = txtEmail.Text; qtv.ID = int.Parse(txtMa.Text); qtv.NamSinh = int.Parse(txtNamSinh.Text); qtv.SoDienThoai = txtSoDienThoai.Text; qtv.HoTen = txtTen.Text; if (txtQuyen.Text == "Thủ Thư") { this.quyen = "Admin"; } else { this.quyen = "User"; } qtv.Quyen = this.quyen; QuanTriVienBLL qtvbll = new QuanTriVienBLL(); bool capnhatqtv = qtvbll.ChinhSuaQuanTriVien(qtv); NguoiMuonSach nms = new NguoiMuonSach(); nms.Id = int.Parse(txtMa.Text); nms.HoTen = txtTen.Text; nms.NamSinh = int.Parse(txtNamSinh.Text); nms.SoDienThoai = txtSoDienThoai.Text; nms.DiaChi = txtDiaChi.Text; nms.Email = txtEmail.Text; NguoiMuonSachBLL nmsbll = new NguoiMuonSachBLL(); bool capnhatnms = nmsbll.CapNhatDocGia(nms); if (capnhatqtv && capnhatnms) { MessageBox.Show("Đã thay đổi thông tin \n Nhấn nút cập nhật nhé.", "Thông Báo"); this.Close(); } }
public List <NguoiMuonSach> TimNguoiMuonTheoMa(NguoiMuonSach timten) { return(nguoimuons.TimNguoiMuonTheoMa(timten)); }
public bool CapNhatDocGia(NguoiMuonSach CapNhatDG) { return(nguoimuons.CapNhatDocGia(CapNhatDG)); }
public List <NguoiMuonSach> TimTenNguoiMuon(NguoiMuonSach timten) { return(nguoimuons.TimTenNguoiMuon(timten)); }
public bool ThemDocGia(NguoiMuonSach ThemDG) { return(nguoimuons.ThemDocGia(ThemDG)); }
private void btnThemMoi_Click(object sender, EventArgs e) { errorHoTen.SetError(txtTen, ""); if (txtTen.Text == "") { errorHoTen.SetError(txtTen, "Xin Nhập Tên:"); return; } errorNamSinh.SetError(txtNamSinh, ""); if (txtNamSinh.Text == "") { errorNamSinh.SetError(txtNamSinh, "Xin Nhập Năm Sinh:"); return; } errorEmail.SetError(txtAccount, ""); if (txtAccount.Text == "") { errorEmail.SetError(txtAccount, "Xin Nhập Tên Đăng Nhập:"); return; } errorSoDienThoai.SetError(txtSoDienThoai, ""); if (txtSoDienThoai.Text == "") { errorSoDienThoai.SetError(txtSoDienThoai, "Xin Nhập Số Điện Thoại:"); return; } errorTenDangNhap.SetError(txtEmail, ""); if (txtEmail.Text == "") { errorTenDangNhap.SetError(txtEmail, "Xin Nhập Email:"); return; } errorDiaChi.SetError(txtDiaChi, ""); if (txtDiaChi.Text == "") { errorDiaChi.SetError(txtDiaChi, "Xin Nhập Địa Chỉ:"); return; } errorMatKhau1.SetError(txtMatKhau1, ""); if (txtMatKhau1.Text == "") { errorMatKhau1.SetError(txtMatKhau1, "Xin Nhập Mật Khẩu:"); return; } /* * errorKey1.SetError(txtKey1, ""); * if (txtKey1.Text == "") * { * errorKey1.SetError(txtKey1, "Xin Nhập Key Restore Mật Khẩu:"); * return; * }*/ errorQuyen.SetError(txtQuyen, ""); if (txtQuyen.Text == "") { errorQuyen.SetError(txtQuyen, "Chọn Quyền Cho Nhân Viên"); return; } errorIntNamSinh.SetError(txtNamSinh, ""); if (!txtNamSinh.Text.All(char.IsDigit)) { errorIntNamSinh.SetError(txtNamSinh, "Năm Sinh Là Số "); return; } QuanTriVien qtv = new QuanTriVien(); qtv.HoTen = txtTen.Text; qtv.NamSinh = int.Parse(txtNamSinh.Text); qtv.TenDangNhap = txtAccount.Text; qtv.SoDienThoai = txtSoDienThoai.Text; qtv.Email = txtEmail.Text; qtv.DiaChi = txtDiaChi.Text; qtv.MatKhau = txtMatKhau1.Text; qtv.KeyRestore = txtKey1.Text; qtv.Quyen = txtQuyen.Text; QuanTriVienBLL qtvbll = new QuanTriVienBLL(); bool qtvnew = qtvbll.ThemQuanTriVien(qtv); NguoiMuonSach nms = new NguoiMuonSach(); nms.HoTen = txtTen.Text; nms.NamSinh = int.Parse(txtNamSinh.Text); nms.SoDienThoai = txtSoDienThoai.Text; nms.DiaChi = txtDiaChi.Text; nms.Email = txtEmail.Text; NguoiMuonSachBLL nmsbll = new NguoiMuonSachBLL(); bool nmsnew = nmsbll.ThemDocGia(nms); if (qtvnew & nmsnew) { MessageBox.Show("Thêm Thành Công", "Thông báo"); this.Close(); } }