protected void btn_login_Click(object sender, EventArgs e)
{
LoginModel model = new LoginModel();
model.LoginId = txt_loginid.Text;
model.Password = txt_Password.Text;
model.LoginType = ddl_logintype.Text;
Session["type"] = model.LoginType;
if (model.LoginType == "Student")
{
LibraryDAL dal = new LibraryDAL();
bool status = dal.Login(model);
if (status == true)
{
Session["loginid"] = txt_loginid.Text;
Response.Redirect("~/Home.aspx");
}
else
{
lbl_msg.Text = "Invalid User";
}
}
else if (model.LoginId == "Admin" && model.Password == "Admin@123" && model.LoginType == "Admin")
{
Session["loginid"] = txt_loginid.Text;
Response.Redirect("~/AdminHome.aspx");
}
else
{
lbl_msg.Text = "Invalid User";
}
}
protected void btn_search_Click(object sender, EventArgs e)
{
string key = txt_search.Text;
LibraryDAL dal = new LibraryDAL();
gv_books.DataSource = dal.ShowAllIssuedBook(key);
gv_books.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
int sid = Convert.ToInt32(Session["loginid"]);
LibraryDAL dal = new LibraryDAL();
gv_books.DataSource = dal.Show(sid);
gv_books.DataBind();
}
protected void btn_search_Click(object sender, EventArgs e)
{
LibraryDAL dal = new LibraryDAL();
List <BookModel> list = dal.Search(txt_search.Text);
gv_books.DataSource = list;
gv_books.DataBind();
}
protected void gv_books_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gv_books.PageIndex = e.NewPageIndex;
int sid = Convert.ToInt32(Session["loginid"]);
LibraryDAL dal = new LibraryDAL();
gv_books.DataSource = dal.MyBookCart(sid);
gv_books.DataBind();
}
protected void gv_books_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gv_books.PageIndex = e.NewPageIndex;
LibraryDAL dal = new LibraryDAL();
List <BookModel> list = dal.Search(txt_search.Text);
gv_books.DataSource = list;
gv_books.DataBind();
}
protected void gv_books_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
gv_books.EditIndex = -1;
LibraryDAL dal = new LibraryDAL();
List <BookModel> list = dal.Search(txt_search.Text);
gv_books.DataSource = list;
gv_books.DataBind();
}
protected void btn_newAdmin_Click(object sender, EventArgs e)
{
LibraryDAL dal = new LibraryDAL();
NewAdminModel model = new NewAdminModel();
model.AdminName = txt_Adminname.Text;
model.AdminEmailId = txt_Adminemailid.Text;
model.AdminPassword = txt_Adminpassword.Text;
model.AdminMobileNo = txt_AdminMobileNo.Text;
}
protected void btn_IssueBook_Click(object sender, EventArgs e)
{
if (Session["type"] == "Student")
{
int bid = Convert.ToInt32(txt_Bookid.Text);
int sid = Convert.ToInt32(Session["loginid"]);
LibraryDAL dal = new LibraryDAL();
int issueid = dal.IssueBook(bid, sid);
Response.Redirect("~/IssuedDone.aspx?issueid=" + issueid);
}
else
{
lbl_msg.Text = "Admin Cannot Issue Book";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request.QueryString["bid"];
int bid = Convert.ToInt32(id);
LibraryDAL dal = new LibraryDAL();
BookModel model = dal.FindBook(id);
txt_Bookid.Text = model.BookID.ToString();
txt_Bookname.Text = model.BookName;
txt_BookAuthor.Text = model.BookAuthor;
txt_BookTitle.Text = model.BookTitle;
txt_BookPrice.Text = model.BookPrice.ToString();
img.ImageUrl = model.BookImage;
txt_BookAddDate.Text = model.BookAddDate.ToString();
txt_NoOfPages.Text = model.NoOfPages.ToString();
}
protected void btn_newBook_Click(object sender, EventArgs e)
{
LibraryDAL dal = new LibraryDAL();
BookModel model = new BookModel();
model.BookName = txt_Bookname.Text;
model.BookAuthor = txt_BookAuthor.Text;
model.BookTitle = txt_BookTitle.Text;
model.BookPrice = Convert.ToInt32(txt_BookPrice.Text);
model.NoOfPages = Convert.ToInt32(txt_NoOfPages.Text);
model.BookImage = "~/Images/" + Guid.NewGuid() + ".jpg";
file_BookImage.SaveAs(Server.MapPath(model.BookImage));
int id = dal.AddBooks(model);
lbl_msg.Text = "Book Added :" + id;
}
protected void btn_newstudent_Click(object sender, EventArgs e)
{
LibraryDAL dal = new LibraryDAL();
NewStudentModel model = new NewStudentModel();
model.StudentName = txt_studentname.Text;
model.StudentEmailId = txt_studentemailid.Text;
model.StudentPassword = txt_studentpassword.Text;
model.StudentCity = txt_studentcity.Text;
model.StudentAddress = txt_studentaddress.Text;
model.StudentDOB = Convert.ToDateTime(txt_studentdob.Text);
model.StudentMobileNo = txt_studentMobileNo.Text;
model.StudentImage = "~/Images/" + Guid.NewGuid() + ".jpg";
file_StudentImage.SaveAs(Server.MapPath(model.StudentImage));
int id = dal.AddStudent(model);
lbl_msg.Text = "Student Added : " + id;
}
protected void btn_MyCart_Click(object sender, EventArgs e)
{
if (Session["type"].ToString() == "Student")
{
int bid = Convert.ToInt32(txt_Bookid.Text);
int sid = Convert.ToInt32(Session["loginid"]);
LibraryDAL dal = new LibraryDAL();
int CartID = dal.AddCart(bid, sid);
if (CartID == 0)
{
lbl_msg.Text = "Book is already in cart";
}
else
{
lbl_msg.Text = "Book added in Cart :" + CartID;
}
}
else
{
lbl_msg.Text = "Admin Cannot Add to Cart";
}
}
protected void btn_RemoveFromCart_Click(object sender, EventArgs e)
{
if (Session["type"].ToString() == "Student")
{
int bid = Convert.ToInt32(txt_Bookid.Text);
int sid = Convert.ToInt32(Session["loginid"]);
LibraryDAL dal = new LibraryDAL();
bool status = dal.RemoveFromCart(bid, sid);
if (status == true)
{
lbl_msg.Text = "not removed from cart";
}
else
{
lbl_msg.Text = "removed from cart";
}
}
else
{
lbl_msg.Text = "Admin Cannot Add to Cart";
}
}
protected void gv_books_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string bid = (gv_books.Rows[e.RowIndex].FindControl("lbl_bid") as Label).Text;
string bname = (gv_books.Rows[e.RowIndex].FindControl("txt_bname") as TextBox).Text;
string bauthor = (gv_books.Rows[e.RowIndex].FindControl("txt_bAuthor") as TextBox).Text;
string btitle = (gv_books.Rows[e.RowIndex].FindControl("txt_bTitle") as TextBox).Text;
string bprice = (gv_books.Rows[e.RowIndex].FindControl("txt_bPrice") as TextBox).Text;
string bpages = (gv_books.Rows[e.RowIndex].FindControl("txt_bNoofPages") as TextBox).Text;
FileUpload bimage = (gv_books.Rows[e.RowIndex].FindControl("txt_bimg") as FileUpload);
string address = "~/Images/" + Guid.NewGuid() + ".jpg";
bimage.SaveAs(Server.MapPath(address));
LibraryDAL dal = new LibraryDAL();
dal.Update(Convert.ToInt32(bid), bname, bauthor, btitle, Convert.ToInt32(bprice), Convert.ToInt32(bpages), address);
gv_books.EditIndex = -1;
List <BookModel> list = dal.Search(txt_search.Text);
gv_books.DataSource = list;
gv_books.DataBind();
lbl_msg.Text = "Updated Successfully...";
}