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