private void barBtnDoiMatKhau_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //Sửa try { txtDienThoai.ReadOnly = false; txtDiaChi.ReadOnly = false; txtEmail.ReadOnly = false; txtGTinh.ReadOnly = false; DocGia_DTO dg = new DocGia_DTO(); dg.MaDocGia = int.Parse(MaDGia); dg.HoTen = txtTen.Text; dg.GioiTinh = 1; if (txtGTinh.Text == "Nam") { dg.GioiTinh = 0; } dg.NgaySinh = dtNgaySinh.Value; dg.Email = txtEmail.Text; dg.DienThoai = txtDienThoai.Text; dg.DiaChi = txtDiaChi.Text; DocGia_DAO.Sua(dg); grdDocGia.DataSource = DocGia_DAO.LoadDuLieu(); } catch (Exception ex) { MessageBox.Show("Chưa chọn độc giả cần chỉnh sửa", "THÔNG BÁO", MessageBoxButtons.OK); } }
private void FrmDocGia_Load(object sender, EventArgs e) { grdDocGia.DataSource = DocGia_DAO.LoadDuLieu(); txtTen.ReadOnly = true; txtDienThoai.ReadOnly = true; txtDiaChi.ReadOnly = true; txtEmail.ReadOnly = true; txtGTinh.ReadOnly = true; }
private void FrmSuaPhieuMuon_Load(object sender, EventArgs e) { DataTable dt = PhieuMuon_DAO.LoadDuLieuTheoMa(MaPM.ToString()); MaNV = int.Parse(dt.Rows[0][3].ToString()); MaDG = int.Parse(dt.Rows[0][1].ToString()); NgayMuon = DateTime.Parse(dt.Rows[0][2].ToString()); cboNhanVien.DataSource = NhanVien_DAO.LoadDuLieu(); cboNhanVien.DisplayMember = "HoTen"; cboNhanVien.ValueMember = "MaNV"; //Khach Hang cboDocGia.DataSource = DocGia_DAO.LoadDuLieu(); cboDocGia.DisplayMember = "HoTen"; cboDocGia.ValueMember = "MaDocGia"; LoadDL(); }
private void button1_Click(object sender, EventArgs e) { //Load Ten Doc Gia string IDDG = ""; IDDG = txtMaDG.Text; try { DataTable dt = DocGia_DAO.LayDuLieu(IDDG); txtTenDG.Text = dt.Rows[0][1].ToString(); ThemPhieuMuon(int.Parse(IDDG)); } catch (Exception ex) { MessageBox.Show("Mã Độc Giả không tồn tại", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void barButtonItem12_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { DocGia_DTO dg = new DocGia_DTO(); // dg.MaDocGia = int.Parse(MaDGia); dg.HoTen = txtTen.Text; dg.GioiTinh = 1; if (txtGTinh.Text == "Nam") { dg.GioiTinh = 0; } dg.NgaySinh = dtNgaySinh.Value; dg.Email = txtEmail.Text; dg.DienThoai = txtDienThoai.Text; dg.DiaChi = txtDiaChi.Text; DocGia_DAO.Them(dg); grdDocGia.DataSource = DocGia_DAO.LoadDuLieu(); }
public bool XoaDocGia(int maCanXoa) { var docgia_dao = new DocGia_DAO(); return(docgia_dao.XoaDocGia(maCanXoa)); }
public DataSet LoadComBoBoxLoaiDocGia(string tenbang) { return(DocGia_DAO.LoadComBoBoxLoaiDocGia(tenbang)); }
public int MaMax() { var docgia_dao = new DocGia_DAO(); return(docgia_dao.MaMax()); }
public static DataTable LoadBangDocGia() { return(DocGia_DAO.LoadBangDocGia()); }
public static string layTenLoaiDocGia(string maDocGia) { return(DocGia_DAO.layTenLoaiDocGia(maDocGia)); }
public static void themDG(string maDG, string tenDG, string gioiTinh, DateTime ngaySinh, string diaChi, string sdt, DateTime nct, DateTime nht, string donVi) { DocGia_DAO.themDG(maDG, tenDG, gioiTinh, ngaySinh, diaChi, sdt, nct, nht, donVi); // DataTable dtb = SqlHelper.ExecuteDataset(cnn, "sp_themSV").Tables[0]; }
public static string TenDG(string s) { return(DocGia_DAO.TenDG(s)); }
public static int?LaySachMuonToiDa(int maDocGia) { return(DocGia_DAO.LaySachMuonToiDa(maDocGia)); }
public static DataTable checkDG(string s) { return(DocGia_DAO.checkDG(s)); }
public static DataTable dsMaDG() { return(DocGia_DAO.dsMaDG()); }
public static void xoaDG(string ma) { DocGia_DAO.xoaDG(ma); }
public static void suaDG_nhh(string ma, DateTime s) { DocGia_DAO.suaDG_nhh(ma, s); }
public static void suaDG_sdt(string ma, string s) { DocGia_DAO.suaDG_sdt(ma, s); }
public static bool Kt_SachMuon(int maDocGia, int maDauSach) { return(DocGia_DAO.KT_SachMuon(maDocGia, maDauSach)); }
public static DataTable DanhSachDG() { return(DocGia_DAO.DanhSachDG()); }
public static bool KiemTraDocGia(int maDocGia) { return(DocGia_DAO.KiemTraDocGia(maDocGia)); }
public bool ThemDocGia(DocGia dg) { var docgia_dao = new DocGia_DAO(); return(docgia_dao.ThemDocGia(dg)); }
public static DocGia_DTO layTTDocGia(string maDocGia) { return(DocGia_DAO.layTTDocGia(maDocGia)); }
public string TraVeGiaTriMaLoaiDG(string a) { var docgia_dao = new DocGia_DAO(); return(docgia_dao.TraVeGiaTriMaLoaiDG(a)); }
public bool ThemNguoiDung(NguoiDung ng) { var docgia_dao = new DocGia_DAO(); return(docgia_dao.themNguoiDung(ng)); }
public static string LastMaDG() { return(DocGia_DAO.LastMaDG()); }