protected void GrdBook_RowCommand(object sender, GridViewCommandEventArgs e) { int row = int.Parse(e.CommandArgument.ToString()); var issueId = int.Parse(GrdBook.Rows[row].Cells[0].Text.Trim()); if (e.CommandName == "Submit") { using (DemoLibraryAppEntities context = new DemoLibraryAppEntities()) { LibraryDB.User currentUser = Session["CurrentUser"] as LibraryDB.User; var issuedEntry = context.Issues.Where(x => x.IssueID == issueId).SingleOrDefault(); if (issuedEntry.ReturnDate == null) { issuedEntry.ReturnDate = DateTime.Now; context.SaveChanges(); BindGrid(); Errorlabel.Text = " Submitted Successfully!"; } else { Errorlabel.Text = "Already Submitted..!"; } } } }
protected void Insert(object sender, EventArgs e) { using (DemoLibraryAppEntities entities = new DemoLibraryAppEntities()) { LibraryDB.User currentUser = Session["CurrentUser"] as LibraryDB.User; Book NewBook = new Book { Title = txtNewTitle.Text, Author = txtAuthor.Text, Category = txtCategory.Text, Year = int.Parse(txtYear.Text), Quantity = int.Parse(txtQuantity.Text), Available = int.Parse(txtQuantity.Text), IsDeleted = 0, CreatedBy = currentUser.Name }; entities.Books.Add(NewBook); entities.SaveChanges(); } this.BindGrid(); txtAuthor.Text = ""; txtCategory.Text = ""; txtYear.Text = ""; txtQuantity.Text = ""; }
protected void Page_Load(object sender, EventArgs e) { if (Session["CurrentUser"] != null) { LibraryDB.User currentUser = Session["CurrentUser"] as LibraryDB.User; SignedInUser.Text = "Signed in as: " + currentUser.Name.ToString(); } }
private void BindGrid() { using (DemoLibraryAppEntities entities = new DemoLibraryAppEntities()) { LibraryDB.User currentUser = Session["CurrentUser"] as LibraryDB.User; GrdBook.DataSource = (from t1 in entities.Issues join t2 in entities.Books on t1.BookID equals t2.BookID select new { t1.IssueID, t1.UserID, currentUser.Name, t1.BookID, t2.Title, t2.Author, t1.IssueDate, t1.ReturnDate }).ToList(); GrdBook.DataBind(); } }
private void BindGrid() { using (DemoLibraryAppEntities entities = new DemoLibraryAppEntities()) { LibraryDB.User currentUser = Session["CurrentUser"] as LibraryDB.User; GrdBook.DataSource = (from t1 in entities.Issues join t2 in entities.Books on t1.BookID equals t2.BookID where t1.UserID == currentUser.UserID orderby t1.IssueDate descending select t2).Take(5).ToList(); GrdBook.DataBind(); } }
protected void Login_Click(object sender, EventArgs e) { try { string uname = Username.Text; string pass = Password.Text; using (DemoLibraryAppEntities context = new DemoLibraryAppEntities()) { var user = context.Users.FirstOrDefault(u => u.Username == uname); if (user != null) { if (user.Password == pass) { Session["CurrentUser"] = user; LibraryDB.User currentUser = Session["CurrentUser"] as LibraryDB.User; if (currentUser.UserRole == "User") { Response.Redirect("HomeUser.aspx"); } else { Response.Redirect("BookDB.aspx"); } } else { Response.Redirect("Register.aspx"); } } else { Response.Redirect("Register.aspx"); } } } catch (Exception ex) { Response.Write(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["CurrentUser"] != null) { LibraryDB.User currentUser = Session["CurrentUser"] as LibraryDB.User; if (currentUser.UserRole == "User") { } else { Response.Redirect("BookDB.aspx"); } } else { Response.Redirect("Login.aspx"); } } }
private bool IssueBook(int bookId) { int resultCount = 0; using (DemoLibraryAppEntities context = new DemoLibraryAppEntities()) { LibraryDB.User currentUser = Session["CurrentUser"] as LibraryDB.User; Book bookToIssue = context.Books.Where(x => x.BookID == bookId).SingleOrDefault(); if (!IsAlreadyIssued(currentUser.UserID, bookId)) { bookToIssue.Issues.Add(new Issue { BookID = bookToIssue.BookID, UserID = currentUser.UserID, IssueDate = DateTime.Now }); --bookToIssue.Available; resultCount = context.SaveChanges(); } } return(resultCount > 0); }