private void btnSave_Click(object sender, EventArgs e) { tsProgress.Value += 5; foreach (BookLendByMemberSP_Result returnBook in list) { if(returnBook.Status=="Available") { tsProgress.Value += 5; IssueDetail issueDetail = context.IssueDetails.First(x => x.BookCopyID == returnBook.BookCopyID && x.ReturnDate == null); issueDetail.ReturnDate = DateTime.Now.Date; BookCopy bookCopy = new BookCopy(); bookCopy = context.BookCopies.First(x => x.BookCopyID == returnBook.BookCopyID); bookCopy.Status = "Available"; context.SaveChanges(); tsProgress.Value += 5; } } tslStatus.Text = "Successfully Save !"; tsProgress.Value = 100; resetForm(); }
public void AddNewBookDetail() { foreach (BookCopy b in copies) { int count=0; foreach (BookCopy ob in originalcopies) { if (ob.BookCopyID != b.BookCopyID) { count++; } } if (count == originalcopies.Count) // No exist in database (New) { BookCopy bookCopy = new BookCopy(); bookCopy.BookID = b.BookID; bookCopy.BookShelfNo = b.BookShelfNo; bookCopy.Status = b.Status; context.BookCopies.AddObject(bookCopy); } } }
/// <summary> /// Create a new BookCopy object. /// </summary> /// <param name="bookCopyID">Initial value of the BookCopyID property.</param> /// <param name="bookID">Initial value of the BookID property.</param> /// <param name="bookShelfNo">Initial value of the BookShelfNo property.</param> /// <param name="status">Initial value of the Status property.</param> public static BookCopy CreateBookCopy(global::System.Int32 bookCopyID, global::System.Int32 bookID, global::System.String bookShelfNo, global::System.String status) { BookCopy bookCopy = new BookCopy(); bookCopy.BookCopyID = bookCopyID; bookCopy.BookID = bookID; bookCopy.BookShelfNo = bookShelfNo; bookCopy.Status = status; return bookCopy; }
/// <summary> /// Deprecated Method for adding a new object to the BookCopies EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToBookCopies(BookCopy bookCopy) { base.AddObject("BookCopies", bookCopy); }
private void AddNewBook() { var book = new Book(); book.Author = txtAuthor.Text; book.CategoryID = Convert.ToInt32(cboCatagoyName.SelectedValue.ToString()); book.Edition = Convert.ToInt32(txtEdition.Text); book.ISBN = txtISBN.Text; book.Publisher = txtPublisher.Text; book.Title = txtTitle.Text; book.YearOfPublishion = dtPickerYearofPublish.Value; foreach(BookCopy c in copies) { BookCopy newCopy = new BookCopy(); newCopy.BookID = c.BookID; newCopy.BookCopyID = c.BookCopyID; newCopy.Status = c.Status; newCopy.BookShelfNo = c.BookShelfNo; book.BookCopies.Add(newCopy); } context.Books.AddObject(book); context.SaveChanges(); // update latest no in Number var lastBookCopy = (from x in context.Books select x).OrderByDescending(x => x.BookID).Take(1); foreach(Book b in lastBookCopy) { bookid = b.BookID; } newform = false; }
private void btnEditcopy_Click(object sender, EventArgs e) { BookCopy bc; int bookCopyId = Convert.ToInt32(txtBookCopyID.Text); if (update == false) { bc = new BookCopy(); bc.BookCopyID = Convert.ToInt32(txtBookCopyID.Text); bc.BookID = Convert.ToInt32(txtBookID.Text); } else bc = SearchID(bookCopyId); bc.BookShelfNo = txtShelfNo.Text; bc.Status = txtStatus.Text; if(update==false) copies.Add(bc); //if (update == false) //{ // context.BookCopies.AddObject(bc); //} dgvcopy.DataSource = copies.ToList(); dgvcopy.Refresh(); update = true; //context.SaveChanges(); }