public void D2TC1() { LibrarianDataManager.ClearAll(); LibrarianDataManager.AddLibrarian(new Librarian("LibrarianName", "LibrarianSurname", "80000000000", "Address"), "librarian_1", "12345"); LibrarianDataManager.AddFaculty(new Faculty("Sergey", "Afonso", "30001", "ViaMargutta, 3", ""), "patron_1", "12345"); LibrarianDataManager.AddStudent(new Student("Nadia", "Teixeira", "30002", "Via Sacra, 13"), "patron_2", "12345"); LibrarianDataManager.AddStudent(new Student("Elvira", "Espindola", "30003", "Via del Corso, 22"), "patron_3", "12345"); LibrarianDataManager.AddBook(new Book("Authors", "Book_1", "Publisher", "Edition", 2018, false, "Keys", "", 100)); LibrarianDataManager.AddCopies(3, new Copy(1, 1, 1)); LibrarianDataManager.AddBook(new Book("Authors", "Book_2", "Publisher", "Edition", 2018, false, "Keys", "", 100)); LibrarianDataManager.AddCopies(2, new Copy(2, 1, 2)); LibrarianDataManager.AddBook(new Book("Authors", "Book_3", "Publisher", "Edition", 2018, false, "Keys", "", 100)); LibrarianDataManager.AddCopies(1, new Copy(3, 1, 3)); LibrarianDataManager.AddAVMaterial(new AVMaterial("Authors", "AVMaterial_1", "Keys", "", 100)); LibrarianDataManager.AddCopies(1, new Copy(4, 1, 4)); LibrarianDataManager.AddAVMaterial(new AVMaterial("Authors", "AVMaterial_2", "Keys", "", 100)); LibrarianDataManager.AddCopies(1, new Copy(5, 1, 5)); Assert.AreEqual(LibrarianDataManager.GetNumberOfCopies(), 8); Assert.AreEqual(LibrarianDataManager.GetNumberOfUsers(), 4); }
public void D2TC6() { D2TC2(); PatronDataManager.CheckOutDocument(1, 2); PatronDataManager.CheckOutDocument(2, 4); PatronDataManager.CheckOutDocument(2, 2); User faculty = LibrarianDataManager.GetUserById(2); Assert.AreEqual(faculty.FirstName, "Sergey"); Assert.AreEqual(faculty.SecondName, "Afonso"); Assert.AreEqual(faculty.Phone, "30001"); Assert.AreEqual(faculty.Address, "ViaMargutta, 3"); Copy copy = LibrarianDataManager.GetCheckedByUserCopiesList(faculty.CardNumber)[0]; Assert.AreEqual(copy.DocumentId, 1); faculty = LibrarianDataManager.GetUserById(4); Assert.AreEqual(faculty.FirstName, "Elvira"); Assert.AreEqual(faculty.SecondName, "Espindola"); Assert.AreEqual(faculty.Phone, "30003"); Assert.AreEqual(faculty.Address, "Via del Corso, 22"); Copy[] copies = LibrarianDataManager.GetAllCopiesList(); copy = LibrarianDataManager.GetCheckedByUserCopiesList(faculty.CardNumber)[0]; Assert.AreEqual(copy.DocumentId, 2); }
///<summary> ///when users input all data to textBoxes clicked on this button user go to workWindow but before system will checked all data in textBoxes and checked if this user exist ///</summary> private void button_sign_in_Click(object sender, RoutedEventArgs e) { // here you will need to check that a username and password exist in dB it should be done in a separate function which will check it //a function that checks if there is a user with such data entered in the fields // здесь нужно будет проверить что такой логи и пароль существуют в бд это нужно сделать в отдельной фукции которая будет проверять это //функция которая проверяет если есть такой пользователь с такими данными введенными в поля if (InputFieldsManager.CheckPasswordValidity(passwordBox_enter)) { //these functions return a string with the maintained data in their textbooks //данные функции возвращают строку с веденными данными в их текстБоксы string login = InputFieldsManager.ReturnStringFromTextBox(textBox_login), password = InputFieldsManager.ReturnPasswordFromTextBox(passwordBox_enter); //if all is OK, so we go to the Work window long userID = CredentialsManager.Authorize(login, password); if (userID != -1) { using (StreamWriter writer = new StreamWriter("id.txt")) { writer.Write(userID); } GoToWork(LibrarianDataManager.GetUserById(userID)); } else { MessageBox.Show("Error. Can not find user with current login and password"); } } else { MessageBox.Show("Such user doesn't exist"); } }
public void D1TC7() { Initialize(); PatronDataManager.CheckOutDocument(BOOK_TWO_COPY_BESTSELLER_NO_REFERENCE_ID, PATRON_1_ID); PatronDataManager.CheckOutDocument(BOOK_TWO_COPY_BESTSELLER_NO_REFERENCE_ID, PATRON_2_ID); int size = 0; bool first = false, last = false; foreach (var c in LibrarianDataManager.GetAllCopiesList()) { if (c.DocumentId == BOOK_TWO_COPY_BESTSELLER_NO_REFERENCE_ID) { size++; } if (c.PatronId == PATRON_1_ID && c.DocumentId == BOOK_TWO_COPY_BESTSELLER_NO_REFERENCE_ID) { first = true; } if (c.PatronId == PATRON_2_ID && c.DocumentId == BOOK_TWO_COPY_BESTSELLER_NO_REFERENCE_ID) { last = true; } } LibrarianDataManager.ReturnDocument(BOOK_TWO_COPY_BESTSELLER_NO_REFERENCE_ID, PATRON_1_ID); LibrarianDataManager.ReturnDocument(BOOK_TWO_COPY_BESTSELLER_NO_REFERENCE_ID, PATRON_2_ID); Assert.IsTrue(last && first && size == 2); }
private void save_to_db(object sender, RoutedEventArgs e) { av.Title = av_title_text_box.Text; av.Authors = authors_av_text_box.Text; av.KeyWords = av_key_words_text_box.Text; av.Price = Convert.ToInt32(av_price_text_box.Text); av.CoverURL = av_coverUrl_text_box.Text; LibrarianDataManager.EditAVMaterial(av); Copy copy = new Copy(); copy.DocumentId = av.Id; if (av_room_text_box.Text != "" && av_level_text_box.Text != "" && av_copy_text_box.Text != "") { copy.Room = Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(av_room_text_box)); copy.Level = Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(av_level_text_box)); LibrarianDataManager.AddCopies(Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(av_copy_text_box)), copy); } workWindow.UptadeDataGridAV_material(); this.Close(); }
public void D1TC10() { Initialize(); PatronDataManager.CheckOutDocument(BOOK_ONE_COPY_NOT_BESTSELLER_NO_REFERENCE_ID, STUDENT_ID); PatronDataManager.CheckOutDocument(BOOK_REFERENCE_ID, STUDENT_ID); bool flag = false; foreach (var c in LibrarianDataManager.GetAllCopiesList()) { if (c.DocumentId == BOOK_REFERENCE_ID && c.PatronId == STUDENT_ID) { Assert.IsTrue(false); } if (c.DocumentId == BOOK_ONE_COPY_NOT_BESTSELLER_NO_REFERENCE_ID && c.PatronId == STUDENT_ID) { flag = true; } } LibrarianDataManager.ReturnDocument(BOOK_ONE_COPY_NOT_BESTSELLER_NO_REFERENCE_ID, STUDENT_ID); Assert.IsTrue(flag); }
public LibrarianWorkWindow(long userId) { InitializeComponent(); user = LibrarianDataManager.GetUserById(userId); librarian_name_fill.Content = user.FirstName; librarian_status_fill.Content = user.Type; }
private void add_ja_to_db_Click(object sender, RoutedEventArgs e) { if (ja_title_text_box.Text != null && ja_publisher_text_box.Text != null && ja_editors_text_box.Text != null && ja_issue_text_box.Text != null && ja_price_text_box.Text != null && ja_room_text_box.Text != null && ja_level_text_box.Text != null && ja_PD_text_box.Text != null && ja_coverURL_text_box.Text != null && ja_countOf_text_box.Text != null && ja_copies_text_box.Text != null) { Journal journal = new Journal(InputFieldsManager.ReturnStringFromTextBox(ja_editors_text_box), InputFieldsManager.ReturnStringFromTextBox(ja_title_text_box), InputFieldsManager.ReturnStringFromTextBox(ja_publisher_text_box), Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(ja_issue_text_box)), InputFieldsManager.ReturnStringFromTextBox(ja_PD_text_box), InputFieldsManager.ReturnStringFromTextBox(ja_keywords_text_box), InputFieldsManager.ReturnStringFromTextBox(ja_coverURL_text_box), Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(ja_price_text_box))); long journalId = LibrarianDataManager.AddJournal(journal); Copy copy = new Copy(); int n = Convert.ToInt32(ja_copies_text_box.Text); copy.DocumentId = journalId; copy.Room = Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(ja_room_text_box)); copy.Level = Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(ja_level_text_box)); LibrarianDataManager.AddCopies(n, copy); AddJournalArticlesToJournal addJournalArticlesToJournal = new AddJournalArticlesToJournal(journalId, this); addJournalArticlesToJournal.Owner = this; addJournalArticlesToJournal.Show(); } }
public void D1TC3() { Initialize(); PatronDataManager.CheckOutDocument(BOOK_ONE_COPY_NOT_BESTSELLER_NO_REFERENCE_ID, FACULTY_ID); Copy[] copies = LibrarianDataManager.GetAllCopiesList(); bool flag = false; foreach (var c in copies) { if (c.ReturningDate != null) { double days = (DateTime.Parse(c.ReturningDate) - DateTime.Now).TotalDays; if (c.PatronId == FACULTY_ID && c.DocumentId == BOOK_ONE_COPY_NOT_BESTSELLER_NO_REFERENCE_ID && Math.Abs(days - Book.FACULTY_RETURN_TIME) < 1) { flag = true; break; } } } LibrarianDataManager.ReturnDocument(BOOK_ONE_COPY_NOT_BESTSELLER_NO_REFERENCE_ID, FACULTY_ID); Assert.IsTrue(flag); }
private void add_book_to_db_Click(object sender, RoutedEventArgs e) { bool is_best_seller = false; if (best_seller_of_book.IsChecked == true) { is_best_seller = true; } if (title_of_book.Text != null && author_of_book.Text != null && publisher_of_book.Text != null && edition_of_book.Text != null && year_of_book.Text != null && keywords_of_book.Text != null && price_of_book.Text != null && copy_of_book.Text != null && room_of_book.Text != null && level_of_book.Text != null && book_cover_URL_text_box.Text != null) { Book book = new Book(InputFieldsManager.ReturnStringFromTextBox(author_of_book), InputFieldsManager.ReturnStringFromTextBox(title_of_book), InputFieldsManager.ReturnStringFromTextBox(publisher_of_book), InputFieldsManager.ReturnStringFromTextBox(edition_of_book), Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(year_of_book)), is_best_seller, InputFieldsManager.ReturnStringFromTextBox(keywords_of_book), InputFieldsManager.ReturnStringFromTextBox(book_cover_URL_text_box), Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(price_of_book))); long bookId = LibrarianDataManager.AddBook(book); Copy copy = new Copy(); int n = Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(copy_of_book)); copy.DocumentId = bookId; copy.Room = Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(room_of_book)); copy.Level = Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(level_of_book)); LibrarianDataManager.AddCopies(n, copy); this.Close(); } }
private void Enter_Click(object sender, RoutedEventArgs e) { user.FirstName = FirstName.Text; user.SecondName = SecondName.Text; user.Phone = Phone.Text; user.Address = Address.Text; if (librarianCheckBoxType.IsChecked == true) { LibrarianDataManager.EditLibrarian(user as Librarian); } else if (InstructorCheckBoxType.IsChecked == true) { LibrarianDataManager.EditFaculty(user as Faculty); } else if (taCheckBoxType.IsChecked == true) { LibrarianDataManager.EditFaculty(user as Faculty); } else if (professorCheckBoxType.IsChecked == true) { LibrarianDataManager.EditFaculty(user as Faculty); } else if (visitingProfessorCheckBoxType.IsChecked == true) { LibrarianDataManager.EditGuest(user as Guest); } workWindow.UpdateUsersDataGrid(); this.Close(); }
private void saveButton_Click(object sender, RoutedEventArgs e) { journal.Title = titleTextBox.Text; journal.Publisher = publisherTextBox.Text; journal.Issue = Convert.ToInt32(issueTextBox.Text); journal.Authors = editorsTextBox.Text; journal.KeyWords = keyWordsTextBox.Text; journal.CoverURL = coverUrlTextBox.Text; journal.KeyWords = keyWordsTextBox.Text; journal.Price = Convert.ToInt32(priceTextBox.Text); journal.PublicationDate = publicationDateBox.Text; LibrarianDataManager.EditJournal(journal); Copy copy = new Copy(); if (roomTextBox.Text != "" && levelTextBox.Text != "" && copiesOfJournalTextBox.Text != "") { copy.Room = Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(roomTextBox)); copy.Level = Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(levelTextBox)); LibrarianDataManager.AddCopies(Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(copiesOfJournalTextBox)), copy); } window.UpdateDataGridBook(); this.Close(); }
public void D2TC2() { D2TC1(); List <Copy> copies = LibrarianDataManager.GetAllCopiesList().ToList(); Copy copy = copies.Where(c => c.DocumentId == 1 && c.Room == 1 && c.Level == 1).First(); LibrarianDataManager.DeleteCopy(copy.Id); copies.Remove(copy); copy = copies.Where(c => c.DocumentId == 1 && c.Room == 1 && c.Level == 1).First(); LibrarianDataManager.DeleteCopy(copy.Id); copies.Remove(copy); copy = copies.Where(c => c.DocumentId == 3 && c.Room == 1 && c.Level == 3).First(); LibrarianDataManager.DeleteCopy(copy.Id); Student student = new Student("StudentName", "StudentSurname", "80000000000", "Address") { CardNumber = 3 }; LibrarianDataManager.DeleteUser(student.CardNumber); int n = LibrarianDataManager.GetNumberOfCopies(); int s = LibrarianDataManager.GetNumberOfUsers(); Assert.AreEqual(LibrarianDataManager.GetNumberOfCopies(), 5); Assert.AreEqual(LibrarianDataManager.GetNumberOfUsers(), 3); }
private void save_changes_in_db_Click(object sender, RoutedEventArgs e) { book.Title = title_of_book.Text; book.Authors = author_of_book.Text; book.Publisher = publisher_of_book.Text; book.Edition = edition_of_book.Text; book.Year = Convert.ToInt32(year_of_book.Text); book.KeyWords = keywords_of_book.Text; book.Price = Convert.ToInt32(price_of_book.Text); book.IsBestseller = best_seller_of_book.IsEnabled; LibrarianDataManager.EditBook(book); Copy copy = new Copy(); copy.DocumentId = book.Id; if (room_of_book.Text != "" && level_of_book.Text != "" && copy_of_book.Text != "") { copy.Room = Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(room_of_book)); copy.Level = Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(level_of_book)); LibrarianDataManager.AddCopies(Convert.ToInt32(InputFieldsManager.ReturnStringFromTextBox(copy_of_book)), copy); } workWindow.UpdateDataGridBook(); this.Close(); }
public void D2TC9() { D2TC1(); Assert.AreEqual(LibrarianDataManager.GetAllCopiesList().Count(copy => copy.DocumentId == 1), 3); Assert.AreEqual(LibrarianDataManager.GetAllCopiesList().Count(copy => copy.DocumentId == 2), 2); Assert.AreEqual(LibrarianDataManager.GetAllCopiesList().Count(copy => copy.DocumentId == 3), 1); Assert.AreEqual(LibrarianDataManager.GetAllAVMaterialsList().Length, 2); }
public void D2TC7() { D2TC1(); PatronDataManager.CheckOutDocument(1, 2); PatronDataManager.CheckOutDocument(2, 2); PatronDataManager.CheckOutDocument(3, 2); PatronDataManager.CheckOutDocument(4, 2); PatronDataManager.CheckOutDocument(1, 3); PatronDataManager.CheckOutDocument(2, 3); PatronDataManager.CheckOutDocument(5, 3); User faculty = LibrarianDataManager.GetUserById(2); Assert.AreEqual(faculty.FirstName, "Sergey"); Assert.AreEqual(faculty.SecondName, "Afonso"); Assert.AreEqual(faculty.Phone, "30001"); Assert.AreEqual(faculty.Address, "ViaMargutta, 3"); Copy[] copies = LibrarianDataManager.GetCheckedByUserCopiesList(faculty.CardNumber); int c = 0; if (copies.Any(copy => copy.DocumentId == 1)) { c++; } if (copies.Any(copy => copy.DocumentId == 2)) { c++; } if (copies.Any(copy => copy.DocumentId == 4)) { c++; } Assert.AreEqual(c, 3); faculty = LibrarianDataManager.GetUserById(3); Assert.AreEqual(faculty.FirstName, "Nadia"); Assert.AreEqual(faculty.SecondName, "Teixeira"); Assert.AreEqual(faculty.Phone, "30002"); Assert.AreEqual(faculty.Address, "Via Sacra, 13"); copies = LibrarianDataManager.GetCheckedByUserCopiesList(faculty.CardNumber); c = 0; if (copies.Any(copy => copy.DocumentId == 1)) { c++; } if (copies.Any(copy => copy.DocumentId == 2)) { c++; } if (copies.Any(copy => copy.DocumentId == 5)) { c++; } Assert.AreEqual(c, 3); }
/// <summary> /// update table (data grid) Book /// </summary> private void UpdateDataGridBook() { List <Book> result = new List <Book>(); result.Clear(); foreach (Book book in LibrarianDataManager.GetAllBooksList()) { result.Add(book); } DataGridBook.ItemsSource = result; }
/// <summary> /// update data grid journal articles /// </summary> public void UpdateDataGridJournaArticles() { List <Article> result = new List <Article>(); result.Clear(); foreach (Article journalArticle in LibrarianDataManager.GetAllArticlesList()) { result.Add(journalArticle); } DataGridJournalArticles.ItemsSource = result; }
/// <summary> /// update table (data grid) AV material /// </summary> public void UptadeDataGridAV_material() { List <AVMaterial> result = new List <AVMaterial>(); result.Clear(); foreach (AVMaterial av_material in LibrarianDataManager.GetAllAVMaterialsList()) { result.Add(av_material); } DataGridAV_material.ItemsSource = result; }
/// <summary> /// update table (data grid) Journal /// </summary> private void UpdateDataGridJournal() { List <Journal> result = new List <Journal>(); result.Clear(); foreach (Journal journal in LibrarianDataManager.GetAllJournalsList()) { result.Add(journal); } DataGridJournal.ItemsSource = result; }
/// <summary> /// update table (data grid) inner material /// </summary> private void UpdateDataGridInnerMaterials() { List <InnerMaterial> result = new List <InnerMaterial>(); result.Clear(); foreach (InnerMaterial inner in LibrarianDataManager.GetAllInnerMaterialsList()) { result.Add(inner); } DataGridRefernce_book.ItemsSource = result; }
public void D3TC1() { Initialization(); PatronDataManager.CheckOutDocument(1, 1); PatronDataManager.CheckOutDocument(2, 1); LibrarianDataManager.ReturnDocument(2, 1); Copy copy = LibrarianDataManager.GetCheckedByUserCopiesList(1)[0]; Assert.AreEqual(copy.DocumentId, 1); Assert.AreEqual(copy.ReturningDate, DateTime.Today.AddDays(28).ToShortDateString()); }
/// <summary> /// Initilization info about Patron /// </summary> public void InitilizePatron(Patron patron) { int amountChekedOutCopies = LibrarianDataManager.GetCheckedByUserCopiesList(patron.CardNumber).Length; nameLabeloutput.Content = patron.FirstName; lastNameLabeloutput.Content = patron.SecondName; addressLabeloutput.Content = patron.Address; phoneLabeloutput.Content = patron.Phone; typeLabeloutput.Content = patron.Type; amountOfCopiesLabeloutput.Content = amountChekedOutCopies; }
public void UpdateUsersDataGrid() { List <User> result = new List <User>(); result.Clear(); foreach (User user in LibrarianDataManager.GetAllUsersList()) { result.Add(user); } DataGridInfoUser.ItemsSource = result; }
public void UpdateDataGridCopies() { List <Copy> result = new List <Copy>(); result.Clear(); foreach (Copy copy in LibrarianDataManager.GetAllCopiesList()) { result.Add(copy); } DataGridCopies.ItemsSource = result; }
public void UpdateDataGrid() { List <Copy> result = new List <Copy>(); result.Clear(); foreach (Copy doc in LibrarianDataManager.GetCheckedByUserCopiesList(patron.CardNumber)) { result.Add(doc); } check_out_doc.ItemsSource = result; }
public void D2TC5() { D2TC2(); PatronDataManager.CheckOutDocument(1, 3); foreach (var copy in LibrarianDataManager.GetAllCopiesList()) { if (copy.DocumentId == 1 && copy.PatronId == 3) { Assert.Fail(); } } }
public void D2TC4() { D2TC2(); User faculty = LibrarianDataManager.GetUserById(3); Assert.IsNull(faculty); faculty = LibrarianDataManager.GetUserById(4); Assert.AreEqual(faculty.FirstName, "Elvira"); Assert.AreEqual(faculty.SecondName, "Espindola"); Assert.AreEqual(faculty.Phone, "30003"); Assert.AreEqual(faculty.Address, "Via del Corso, 22"); }
public void D2TC8() { D2TC1(); PatronDataManager.CheckOutDocument(1, 2); PatronDataManager.CheckOutDocument(2, 2); PatronDataManager.CheckOutDocument(1, 3); PatronDataManager.CheckOutDocument(4, 3); Copy copy = LibrarianDataManager.GetCheckedByUserCopiesList(2)[0]; Assert.AreEqual(DateTime.Parse(copy.ReturningDate).Subtract(DateTime.Now).Days, 27); copy = LibrarianDataManager.GetCheckedByUserCopiesList(3)[0]; Assert.AreEqual(DateTime.Parse(copy.ReturningDate).Subtract(DateTime.Now).Days, 20); }
private void saveButton_Click(object sender, RoutedEventArgs e) { inner.Title = titleTextBox.Text; inner.Authors = authorTextBox.Text; inner.KeyWords = keyWordsTextBox.Text; inner.Room = Convert.ToInt32(roomTextBox.Text); inner.Level = Convert.ToInt32(levelTextBox.Text); inner.Type = typeTextBox.Text; inner.CoverURL = coverUrlTextBox.Text; LibrarianDataManager.EditInnerMaterial(inner); window.UpdateDataGridInnerMaterials(); this.Close(); }