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 Register_Click(object sender, EventArgs e) { try { string username = Username.Text; using (DemoLibraryAppEntities context = new DemoLibraryAppEntities()) { var user = context.Users.FirstOrDefault(u => u.Username == username); if (user != null) { ErrorMessage.Text = "Username already exists."; } else { User useradd = new User(); useradd.Name = Name.Text; useradd.Username = Username.Text; useradd.Email = Email.Text; useradd.Address = Address.Text; useradd.Password = Password.Text; useradd.UserRole = UserRoleDrop.Text; context.Users.Add(useradd); context.SaveChanges(); Response.Redirect("Login.aspx"); } } } catch (Exception ex) { Response.Write(ex.Message); } }
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 OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GrdBook.Rows[e.RowIndex]; int bookid = Convert.ToInt32(GrdBook.DataKeys[e.RowIndex].Values[0]); string title = (row.FindControl("txtTitle") as TextBox).Text; string author = (row.FindControl("txtAuthor") as TextBox).Text; string category = (row.FindControl("txtCategory") as TextBox).Text; string year = (row.FindControl("txtYear") as TextBox).Text; string quantity = (row.FindControl("txtQuantity") as TextBox).Text; string available = (row.FindControl("txtQuantity") as TextBox).Text; using (DemoLibraryAppEntities entities = new DemoLibraryAppEntities()) { Book NewBook = (from c in entities.Books where c.BookID == bookid select c).FirstOrDefault(); NewBook.Title = title; NewBook.Author = author; NewBook.Category = category; NewBook.Year = int.Parse(year); NewBook.Quantity = int.Parse(quantity); NewBook.Available = int.Parse(available); entities.SaveChanges(); } GrdBook.EditIndex = -1; this.BindGrid(); }
private void BindGrid() { using (DemoLibraryAppEntities entities = new DemoLibraryAppEntities()) { GrdBook.DataSource = GetData(); GrdBook.DataBind(); } }
private List <Book> GetData() { using (DemoLibraryAppEntities context = new DemoLibraryAppEntities()) { List <Book> books = context.Books.Where(x => x.IsDeleted == 0).ToList(); return(books ?? new List <Book>()); } }
protected void SearchTitle_Click(object sender, EventArgs e) { string title = txtTitle.Text; using (DemoLibraryAppEntities context = new DemoLibraryAppEntities()) { GrdBook.DataSource = (from b in context.Books where b.Title.Contains(title) && b.IsDeleted == 0 select b).ToList(); GrdBook.DataBind(); } }
private void BindGrid() { using (DemoLibraryAppEntities entities = new DemoLibraryAppEntities()) { GrdBook.DataSource = (from book in entities.Books where book.IsDeleted == 0 select book).ToList(); GrdBook.DataBind(); } }
private bool IsAlreadyIssued(int userId, int bookId) { using (DemoLibraryAppEntities context = new DemoLibraryAppEntities()) { var user = context.Users.Where(x => x.UserID == userId).SingleOrDefault(); if (user != null) { return(user.Issues.Any(x => x.BookID == bookId)); } } return(false); }
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 OnRowDeleting(object sender, GridViewDeleteEventArgs e) { int bookid = Convert.ToInt32(GrdBook.DataKeys[e.RowIndex].Values[0]); using (DemoLibraryAppEntities entities = new DemoLibraryAppEntities()) { Book NewBook = (from c in entities.Books where c.BookID == bookid select c).FirstOrDefault(); NewBook.IsDeleted = 1; entities.SaveChanges(); } this.BindGrid(); }
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); } }
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); }
protected void GrdBook_RowCommand(object sender, GridViewCommandEventArgs e) { using (DemoLibraryAppEntities context = new DemoLibraryAppEntities()) { int row = int.Parse(e.CommandArgument.ToString()); var bookid = int.Parse(GrdBook.Rows[row].Cells[0].Text.Trim()); Book bookToIssue = context.Books.Where(x => x.BookID == bookid).SingleOrDefault(); if (bookToIssue.Issues.Where(x => x.ReturnDate != null).Count() < bookToIssue.Quantity) { } if (e.CommandName == "Issue") { var issuedResult = IssueBook(bookid); if (!issuedResult) { Errorlabel.Text = "Already issued"; } else { Errorlabel.Text = "Issued Successfully."; } } } }