protected void btnTraSach_Click(object sender, EventArgs e)
{
string ma = (sender as Button).CommandArgument;
int sl = int.Parse(GridView1.SelectedRow.Cells[4].Text);
DateTime ngayMuon, ngayTra;
ngayMuon = DateTime.Parse(GridView1.SelectedRow.Cells[5].Text);
ngayTra = DateTime.Parse(GridView1.SelectedRow.Cells[6].Text);
//lblThongBao.Text = ngayMuon.ToString();
chucnag cn = new chucnag();
bool kq = cn.UpdateTinhTrangMuonSach(txtMaSV.Text, ma, ngayMuon.ToString("yyyy-MM-dd"), ngayTra.ToString("yyyy-MM-dd"));
if (kq)
{
lblThongBao.Text = "Trả sách thành công";
cn.UpdateSoLuongSachTra(ma, sl);
DoDuLieuVaoGridView();
}
else
{
lblThongBao.Text = "Có lỗi";
}
}
protected void btnMuonSach_Click(object sender, EventArgs e)
{
muonsach ms = LayDuLieuTuForm();
chucnag cn = new chucnag();
bool kt = cn.CheckSoLuongSach(ms.MaSach, ms.SoLuong);
if (kt)
{
bool exist = cn.CheckMuonSach(ms);
if (exist)
{
cn.UpdateMuonSach(ms);
lblThongBao.Text = "Mượn thành công";
cn.UpdateSoLuongSach(ms.MaSach, ms.SoLuong);
}
else
{
bool result = cn.InsertMuonSach(ms);
if (result)
{
lblThongBao.Text = "Mượn thành công";
cn.UpdateSoLuongSach(ms.MaSach, ms.SoLuong);
}
else
{
lblThongBao.Text = "Có lỗi";
}
}
}
else
{
lblThongBao.Text = "Số lượng sách thư viện không đủ";
}
}
protected void ddlLoai_SelectedIndexChanged(object sender, EventArgs e)
{
chucnag cn = new chucnag();
if (ddlLoai.SelectedValue.ToString() == "TG")
{
ddlChiTiet.DataSource = cn.GetTacGia();
ddlChiTiet.DataTextField = "TenTacGia";
ddlChiTiet.DataValueField = "MaTacGia";
ddlChiTiet.DataSourceID = null;
ddlChiTiet.DataBind();
}
else if (ddlLoai.SelectedValue.ToString() == "NXB")
{
ddlChiTiet.DataSource = cn.GetNhaXuatBan();
ddlChiTiet.DataTextField = "TenNhaXB";
ddlChiTiet.DataValueField = "MaNhaXB";
ddlChiTiet.DataSourceID = null;
ddlChiTiet.DataBind();
}
else
{
ddlChiTiet.DataSource = cn.GetLoaiSach();
ddlChiTiet.DataTextField = "TenLoaiSach";
ddlChiTiet.DataValueField = "MaLoai";
ddlChiTiet.DataSourceID = null;
ddlChiTiet.DataBind();
}
}
protected void btnTimKiem_Click(object sender, EventArgs e)
{
chucnag cn = new chucnag();
GridView1.DataSource = cn.GetAllSachByTen(txtTimKiem.Text);
GridView1.DataSourceID = null;
GridView1.DataBind();
}
public void DoDuLieuVaoGridView()
{
chucnag cn = new chucnag();
GridView1.DataSource = cn.GetAllSach();
GridView1.DataSourceID = null;
GridView1.DataBind();
}
public void DoDuLieuVaoForm()
{
chucnag cn = new chucnag();
GridView1.DataSource = cn.GetMuonSachBySV(Session["masv"].ToString());
GridView1.DataSourceID = null;
GridView1.DataBind();
}
protected void btnTimKiem_Click(object sender, EventArgs e)
{
chucnag cn = new chucnag();
bool trangThai = Boolean.Parse(ddlTrangThai.SelectedValue.ToString());
GridView1.DataSource = cn.LayLichSuMuonSachByTrangThai(Session["masv"].ToString(), trangThai);
GridView1.DataSourceID = null;
GridView1.DataBind();
}
protected void btnDangNhap_Click(object sender, EventArgs e)
{
chucnag cn = new chucnag();
bool kq = cn.DangNhapAdmin(txtTenDangNhap.Text, txtMatKhau.Text);
if (kq)
{
Response.Redirect("Admin.aspx");
}
else
{
lblThongBao.Text = "Sai tên đăng nhập hoặc mật khẩu";
}
}
protected void Page_Load(object sender, EventArgs e)
{
chucnag cn = new chucnag();
if (!IsPostBack)
{
lblNhan.Text = "Xin chào: " + Session["masv"].ToString();
DoDuLieuVaoGridView();
ddlChiTiet.DataSource = cn.GetTacGia();
ddlChiTiet.DataTextField = "TenTacGia";
ddlChiTiet.DataValueField = "MaTacGia";
ddlChiTiet.DataSourceID = null;
ddlChiTiet.DataBind();
}
}
protected void btnDangnhap_Click(object sender, EventArgs e)
{
chucnag cn = new chucnag();
bool kq = cn.DangNhap(txtDangNhap.Text, txtMatKhau.Text);
if (kq)
{
Session["masv"] = txtDangNhap.Text;
Response.Redirect("TrangChu.aspx");
}
else
{
lblThongBao.Text = "Sai tên đăng nhập hoặc mật khẩu";
}
}
protected void ddlChiTiet_SelectedIndexChanged(object sender, EventArgs e)
{
chucnag cn = new chucnag();
if (ddlLoai.SelectedValue.ToString() == "TG")
{
GridView1.DataSource = cn.GetAllSachByTacGia(ddlChiTiet.SelectedValue.ToString());
GridView1.DataSourceID = null;
GridView1.DataBind();
}
else if (ddlLoai.SelectedValue.ToString() == "NXB")
{
GridView1.DataSource = cn.GetAllSachByNhaXuatBan(ddlChiTiet.SelectedValue.ToString());
GridView1.DataSourceID = null;
GridView1.DataBind();
}
else
{
GridView1.DataSource = cn.GetAllSachByLoaiSach(ddlChiTiet.SelectedValue.ToString());
GridView1.DataSourceID = null;
GridView1.DataBind();
}
}
