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