public static BooksModel getBookModelByID(int _book_model_id) { LibraryDBEntities entity = new LibraryDBEntities(); BooksModel v = entity.BooksModels.Where(x => x.BookModelId == _book_model_id).First(); return(v); }
/// <summary> /// Create a new BooksModel object. /// </summary> /// <param name="bookModelId">Initial value of the BookModelId property.</param> /// <param name="bookTitle">Initial value of the BookTitle property.</param> /// <param name="author">Initial value of the Author property.</param> /// <param name="bookCategory">Initial value of the BookCategory property.</param> public static BooksModel CreateBooksModel(global::System.Int32 bookModelId, global::System.String bookTitle, global::System.String author, global::System.String bookCategory) { BooksModel booksModel = new BooksModel(); booksModel.BookModelId = bookModelId; booksModel.BookTitle = bookTitle; booksModel.Author = author; booksModel.BookCategory = bookCategory; return(booksModel); }
public static int updateBookModelEntity(BooksModel _book_model) { LibraryDBEntities entity = new LibraryDBEntities(); var book_model_row = (from bm in entity.BooksModels where bm.BookModelId == _book_model.BookModelId select bm).FirstOrDefault(); book_model_row = _book_model; return(entity.SaveChanges()); }
public ucDetailsBook(int _book_model_id) { InitializeComponent(); book_model_id = _book_model_id; entity = new LibraryDBEntities(); dt = new DataTable(); dt.Columns.Add("Book ID", typeof(int)); dt.Columns.Add("Status", typeof(string)); dt.Columns.Add("Lend Date", typeof(string)); dt.Columns.Add("Due Date", typeof(string)); bookmodel = EntityBroker.getBookModelByID(_book_model_id); }
public static int updateBookModel(BooksModel bm) { LibraryDBEntities entity = new LibraryDBEntities(); var book_model_row = entity.BooksModels.Where(x => x.BookModelId == bm.BookModelId).SingleOrDefault(); book_model_row.BookTitle = bm.BookTitle; book_model_row.BookDescription = bm.BookDescription; book_model_row.Author = bm.Author; book_model_row.PublisherName = bm.PublisherName; book_model_row.PublishDate = bm.PublishDate; book_model_row.BookCategory = bm.BookCategory; book_model_row.MaxAvailableDayToRent = bm.MaxAvailableDayToRent; book_model_row.RentalPricePerDay = bm.RentalPricePerDay; int i = entity.SaveChanges(); return(i); }
public Window_Popup_ReturnBook(int _book_id) { InitializeComponent(); this.FormBorderStyle = FormBorderStyle.FixedSingle; //make unresizable transaction = EntityBroker.getLastTransationByBookID(_book_id); book = EntityBroker.getBookByBookID(_book_id); member = EntityBroker.getMemberByMemberID(transaction.MemberID); bookmodel = EntityBroker.getBookModelByID(book.BookModelID); calculateCharge(); lblBookTitle.Text = bookmodel.BookTitle; lblBookIDValue.Text = book.BookID.ToString(); lblMemberNameValue.Text = member.MemberName; lblMemberIDValue.Text = member.MemberID.ToString(); lblRentDateValue.Text = transaction.LendDate.ToString("dd MM, yyyy"); lblChargeValue.Text = charge.ToString(); }
public static int createNewBookModel(BooksModel _book_model) { LibraryDBEntities entity = new LibraryDBEntities(); BooksModel book_model = new BooksModel(); book_model.BookTitle = _book_model.BookTitle; book_model.BookDescription = _book_model.BookDescription; book_model.Author = _book_model.Author; book_model.PublisherName = _book_model.PublisherName; book_model.BookCategory = _book_model.BookCategory; book_model.PublishDate = _book_model.PublishDate; book_model.RentalPricePerDay = _book_model.RentalPricePerDay; book_model.MaxAvailableDayToRent = _book_model.MaxAvailableDayToRent; entity.AddToBooksModels(book_model); int i = entity.SaveChanges(); return(i); }
private void btnSave_Click(object sender, EventArgs e) { int i = 0; if (txtBookTitle.Text == "") { MessageBox.Show("Book Title shouldn't be empty."); return; } if (txtRentalPricePerDay.Text == "") { MessageBox.Show("Rental Price shouldn't be empty."); return; } if (maxAvaiableDaysToRent.Text == "") { MessageBox.Show("Max Avaiable Days To Rent shouldn't be empty."); return; } if (book_model_id > 0) { bookmodel.BookTitle = lblBookTitlePageTitle.Text; bookmodel.BookTitle = txtBookTitle.Text; bookmodel.BookDescription = (string)txtBookDescription.Text; bookmodel.Author = txtAuthor.Text; bookmodel.BookCategory = txtBookCategory.Text; bookmodel.PublisherName = txtPublisherName.Text; bookmodel.PublishDate = dtpPublishDate.Value; bookmodel.RentalPricePerDay = (decimal)Convert.ToDouble(txtRentalPricePerDay.Text); bookmodel.MaxAvailableDayToRent = (short)Convert.ToInt32(maxAvaiableDaysToRent.Text); i = EntityBroker.updateBookModel(bookmodel); } else { BooksModel bm = new BooksModel(); bm.BookTitle = (string)txtBookTitle.Text; bm.BookDescription = (string)txtBookDescription.Text; bm.Author = (string)txtAuthor.Text; bm.BookCategory = (string)txtBookCategory.Text; bm.PublisherName = (string)txtPublisherName.Text; bm.PublishDate = dtpPublishDate.Value; bm.RentalPricePerDay = (decimal)Convert.ToDouble(txtRentalPricePerDay.Text); bm.MaxAvailableDayToRent = (short)Convert.ToDouble(maxAvaiableDaysToRent.Text); i = EntityBroker.createNewBookModel(bm); } if (i == 1) { MessageBox.Show("Book Information Saved"); ucListBooks booklist = new ucListBooks(); booklist.setMainWindowRefrence(MainWindowObject); MainWindowObject.RequestContentChange(booklist); ParentWindowObject.Close(); } else { MessageBox.Show("Error in updating. Error code :: {0}", i.ToString()); } }
/// <summary> /// Deprecated Method for adding a new object to the BooksModels EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToBooksModels(BooksModel booksModel) { base.AddObject("BooksModels", booksModel); }