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