public ActionResult Create([Bind(Include = "id,knowledge1")] Knowledge knowledge) { if (ModelState.IsValid) { db.Knowledges.Add(knowledge); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(knowledge)); }
public ActionResult Create([Bind(Include = "ISBN,author,name,publication_type,tome,compiler,language,translator,place_publication,publishing,year,number,price")] Book book) { if (ModelState.IsValid) { db.Books.Add(book); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(book)); }
public ActionResult Create([Bind(Include = "id,FullName,age")] Authors authors) { if (ModelState.IsValid) { db.Authors.Add(authors); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(authors)); }
public ActionResult Create([Bind(Include = "id,last_name,name,middle_name,age,address,phone")] Reader reader) { if (ModelState.IsValid) { db.Readers.Add(reader); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(reader)); }
public ActionResult Create([Bind(Include = "ISBN,title,idAuthor,photo")] Books books) { if (ModelState.IsValid) { db.Books.Add(books); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idAuthor = new SelectList(db.Authors, "id", "FullName", books.idAuthor); return(View(books)); }
public void Save(Member member) { if (member.MemberId <= 0) { db.Members.Add(member); } else { db.Entry(member).State = EntityState.Modified; } db.SaveChanges(); }
public void Save(Author author) { if (author.AuthorId <= 0) { db.Authors.Add(author); } else { db.Entry(author).State = EntityState.Modified; } db.SaveChanges(); }
public ActionResult Create([Bind(Include = "id,room,rack,shelf,existence,ISBN")] Instance instance) { if (ModelState.IsValid) { db.Instances.Add(instance); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ISBN = new SelectList(db.Books, "ISBN", "name", instance.ISBN); return(View(instance)); }
public ActionResult Create([Bind(Include = "id,instance_id,reader_id,date_extradition,return_date")] Extradition extradition) { if (ModelState.IsValid) { db.Extraditions.Add(extradition); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.instance_id = new SelectList(db.Instances, "id", "ISBN", extradition.instance_id); ViewBag.reader_id = new SelectList(db.Readers, "id", "last_name", extradition.reader_id); return(View(extradition)); }
/// <summary> /// Add a new book to the database. /// </summary> /// <param name="sender">The details of the new book </param> private void AddNewBook(Book sender) { if (sender.Year == 0 || string.IsNullOrWhiteSpace(sender.BookName) || string.IsNullOrWhiteSpace(sender.Authors) || string.IsNullOrWhiteSpace(sender.Category)) { dialogBox = new DialogBox("FIGYELEM!", "Minden mező kitöltése kötelező!"); dialogBox.Show(); return; } dialogBox = new DialogBox(DialogBoxType.WARNING, "VÉGLEGESÍTÉS!", "Könyv hozzáadása?"); dialogBox.ShowDialog(); if (dialogBox.Answer == DialogAnswer.NO) { return; } using (var context = new LibraryDatabaseEntities()) { try { context.Books.Add(sender); context.SaveChanges(); BooksDataContext.StoredBooksList.Add(sender); dialogBox = new DialogBox("Hozzáadás sikeres!"); dialogBox.Show(); } catch { dialogBox = new DialogBox("HIBA!", "Hozzáadás nem sikerült!"); dialogBox.Show(); } } ControlDataContext.SelectedBookDetails = sender; }
public ActionResult CheckOut(CheckoutViewModel cvm) { if (ModelState.IsValid) { var checkoutEvent = new CheckoutEvent { DateTimeCheckedOut = cvm.TimeCheckedOut, BookId = cvm.BookId, PatronId = cvm.PatronId }; var book = db.Books.Single(x => x.BookId == cvm.BookId); book.PatronId = cvm.PatronId; db.CheckoutEvents.Add(checkoutEvent); db.Entry(book).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cvm)); }
/// <summary> /// Borrow the books and add the selected books to the borrowed table. /// </summary> private void BorrowBooks() { //Check empty fields if (BorrowDataContext.BorrowedBooksList == null) { dialogBox = new DialogBox("HIBA!", "Nem adott hozzá könyvet!"); dialogBox.Show(); return; } if (BorrowDataContext.IsExpired || BorrowDataContext.IsExist == false) { dialogBox = new DialogBox("HIBA!", "Hibás vagy lejárt azonosító!"); dialogBox.Show(); return; } if (BorrowDataContext.ExpDate < DateTime.Today) { dialogBox = new DialogBox("HIBA!", "Érvénytelen kölcsönzési idő"); dialogBox.Show(); return; } dialogBox = new DialogBox(DialogBoxType.WARNING, "FIGYELEM!", "Művelet megerősítése?"); dialogBox.ShowDialog(); if (dialogBox.Answer == DialogAnswer.NO) { return; } using (var context = new LibraryDatabaseEntities()) { foreach (var item in BorrowDataContext.BorrowedBooksList) { context.BorrowedBooks.Add(new BorrowedBook { LibID = BorrowDataContext.LibID, ExpDate = BorrowDataContext.ExpDate, CopyID = item.CopyID }); var bookCopies = context.BookCopies.FirstOrDefault(r => r.ID == item.CopyID); bookCopies.IsBorrowed = true; } context.SaveChanges(); dialogBox = new DialogBox("Kölcsönzés sikeres!"); dialogBox.Show(); // Reset the properties and list. BorrowDataContext.BorrowedBooksList = new ObservableCollection <BorrowModel>(); BorrowDataContext.BookID = ""; BorrowDataContext.MemberID = ""; } }
/// <summary> /// Return the borrowed books to the library and remove them from the borrowed table. /// </summary> private void ReturnBooks() { if (ReturnDataContext.ReturnedBooksList.Count == 0) { return; } dialogBox = new DialogBox(DialogBoxType.WARNING, "FIGYELEM!", "Biztos visszaadja a könyveket?"); dialogBox.ShowDialog(); if (dialogBox.Answer == DialogAnswer.NO) { return; } using (var context = new LibraryDatabaseEntities()) { try { foreach (var item in ReturnDataContext.ReturnedBooksList) { var returnBook = (from borrowed in context.BorrowedBooks join copies in context.BookCopies on borrowed.CopyID equals copies.ID where copies.BookCode == item.CopyID select new { BorrowedBook = borrowed }).Single().BorrowedBook; context.BorrowedBooks.Remove(returnBook); } context.SaveChanges(); dialogBox = new DialogBox("Könyvek visszaadása sikeres!"); dialogBox.Show(); ReturnDataContext.ReturnedBooksList = new ObservableCollection <ReturnModel>(); ReturnDataContext.MemberBooksList = new ObservableCollection <ReturnModel>(); } catch { dialogBox = new DialogBox("HIBA!", "Hiba a művelet közben!"); dialogBox.Show(); } } }
public void Save(Publisher publisher) { db.Publishers.Add(publisher); db.SaveChanges(); }
/// <summary> /// Register a new member or expand the membership. /// </summary> private void RegisterMember() { if (IsRegisterClicked && !IsValidFields()) { dialogBox = new DialogBox("HIBA!", "Helytelenül kitöltött Mezők!"); dialogBox.Show(); return; } if (IsEnabled == Visibility.Visible) { dialogBox = new DialogBox(DialogBoxType.WARNING, "FIGYELEM!", "Regisztrálja az új tagot?"); dialogBox.ShowDialog(); if (dialogBox.Answer == DialogAnswer.NO) { return; } // Register a new member. using (var context = new LibraryDatabaseEntities()) { try { var item = DateTime.Today; item = item.AddMonths(int.Parse(MembershipLength)); MemberInfo.ExpData = item; MemberInfo.LibID = MemberInfo.LibID.ToUpper(); context.Members.Add(MemberInfo); context.SaveChanges(); dialogBox = new DialogBox("Sikeres regisztráció!"); dialogBox.Show(); } catch { dialogBox = new DialogBox("HIBA!", "Művelet sikertelen!"); dialogBox.Show(); return; } } } else { dialogBox = new DialogBox(DialogBoxType.WARNING, "FIGYELEM!", "Tagság meghosszabítása?"); dialogBox.ShowDialog(); if (dialogBox.Answer == DialogAnswer.NO) { return; } // Expand the membership of an existing member. using (var context = new LibraryDatabaseEntities()) { var item = context.Members.FirstOrDefault(r => r.LibID.Equals(MemberInfo.LibID)); if (item == null) { dialogBox = new DialogBox("HIBA!", "Nem található ilyen felhasználó!"); dialogBox.Show(); return; } //Expand membership. try { var dateCurrent = item.ExpData; item.ExpData = dateCurrent.AddMonths(int.Parse(MembershipLength)); context.SaveChanges(); dialogBox = new DialogBox("SIKER!", "Tagság sikeresen meghosszabbítva!"); dialogBox.Show(); } catch { dialogBox = new DialogBox("HIBA!", "Művelet sikertelen!"); dialogBox.Show(); } } } }
/// <summary> /// Add the copies to the database. /// </summary> private void AddNewCopies() { if (ControlDataContext.SelectedBookDetails == null) { return; } foreach (var item in ControlDataContext.CopiesList) { if (item.BookCode.Length != 6) { dialogBox = new DialogBox("HIBA!", "Hibásan kitöltött mező!"); dialogBox.Show(); return; } } dialogBox = new DialogBox(DialogBoxType.WARNING, "FIGYELEM!", "Hozzáadja a másolatokat?"); dialogBox.ShowDialog(); if (dialogBox.Answer == DialogAnswer.NO) { return; } using (var context = new LibraryDatabaseEntities()) { foreach (var item in ControlDataContext.CopiesList) { var bookCopy = new BookCopy { BookCode = item.BookCode.ToUpper(), BookID = ControlDataContext.SelectedBookDetails.ID }; context.BookCopies.Add(bookCopy); } try { context.SaveChanges(); } catch { dialogBox = new DialogBox("HIBA!", "Már létezik ilyen azonosító!\nHozzáadás nem lehetséges!"); dialogBox.Show(); return; } // Calculate the new value of the available copies. short count = (short)context.BookCopies.Count(t => t.BookID == ControlDataContext.SelectedBookDetails.ID); var books = context.Books.FirstOrDefault(r => r.ID == ControlDataContext.SelectedBookDetails.ID); books.BookCopies = count; context.SaveChanges(); //Update thhe copies column acording to the new value. BooksDataContext.StoredBooksList .Where(r => r.ID == ControlDataContext.SelectedBookDetails.ID) .Select(n => { n.BookCopies = count; return(n); }).ToList(); } }
public void Delete(Book book) { db.Books.Remove(book); db.SaveChanges(); }