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