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