public LibrarianRepositoryTest()
{
repositoryFactory = new T();
libraryDepartmentRepository = repositoryFactory.CreateLibraryDepartmentRepository();
librarianRepository = repositoryFactory.CreateLibrarianRepository(libraryDepartmentRepository);
countItems = librarianRepository.GetItems().Count();
}
static Unit()
{
Context = new MyAppDbContext(
new DbContextOptionsBuilder <MyAppDbContext>()
.UseSqlServer(new SqlConnectionStringBuilder
{
DataSource = "127.0.0.1",
InitialCatalog = "Univercity",
IntegratedSecurity = true
}.ConnectionString)
.Options);
Context.Database.EnsureDeleted();
Context.Database.EnsureCreated();
AuthorRepository = new AuthorRepository(Context);
BookRepository = new BookRepository(Context);
CategoryRepository = new CategoryRepository(Context);
DepartmentRepository = new DepartmentRepository(Context);
ECardRepository = new ECardsRepository(Context);
EmployeeRepository = new EmploeeRepository(Context);
FacultyRepository = new FacultyRepository(Context);
GroupRepository = new GroupRepository(Context);
LibrarianRepository = new LibrarianRepository(Context);
PressRepository = new PressRepository(Context);
SCardRepository = new SCardsRepository(Context);
StudentRepository = new StudentRepository(Context);
ThemeRepository = new ThemeRepository(Context);
}
public void addButton_Click(object sender, EventArgs e)
{
var addReaderForm = new AddLibrarianForm();
DialogResult dialogResult = addReaderForm.ShowDialog(this);
if (dialogResult == DialogResult.Cancel)
{
return;
}
string name = addReaderForm.nameTextBox.Text;
string surname = addReaderForm.surnameTextBox.Text;
string patronymic = addReaderForm.patronymicTextBox.Text;
DateTime DoB = addReaderForm.dateTimePicker.Value;
string telNumber = addReaderForm.telNumberTextBox.Text;
var reader = new Librarian
{
Name = name,
Surname = surname,
Patronymic = patronymic,
DateOfBirth = DoB,
TelephoneNumber = telNumber
};
var readerRepository = new LibrarianRepository();
readerRepository.Create(reader);
_db.SaveChanges();
SetDataGridView();
}
private void findByIdButton_Click(object sender, EventArgs e)
{
var librarianRepository = new LibrarianRepository();
if (string.IsNullOrEmpty(idNumericUpDown.Value.ToString()))
{
SetDataGridView();
return;
}
List <Librarian> librarians = new List <Librarian>();
Librarian librarian = librarianRepository.FindById((int)idNumericUpDown.Value);
librarians.Add(librarian);
if (librarian == null)
{
dataGridView1.DataSource = "No readers found";
return;
}
dataGridView1.DataSource = librarians.Select(r => new
{
r.Id,
r.Name,
r.Surname,
r.Patronymic,
r.DateOfBirth,
r.TelephoneNumber
}).ToList();
}
private void findBySurnameButton_Click(object sender, EventArgs e)
{
var librarianRepository = new LibrarianRepository();
if (string.IsNullOrEmpty(surnameTextBox.Text))
{
SetDataGridView();
return;
}
List <Librarian> librarians = librarianRepository.FindBySurname(surnameTextBox.Text);
if (librarians == null)
{
dataGridView1.DataSource = "No readers found";
return;
}
dataGridView1.DataSource = librarians.OrderBy(b => b.Id)
.Select(b => new
{
b.Id,
b.Name,
b.Surname,
b.Patronymic,
b.DateOfBirth,
b.TelephoneNumber
}).ToList();;
}
private void patronymicLinkLabel_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
var librarianRepository = new LibrarianRepository();
LinkLabel thisLinkLabel = (sender as LinkLabel);
var readers = librarianRepository.Get().Select(r => new {
r.Id,
r.Name,
r.Surname,
r.Patronymic,
r.DateOfBirth,
r.TelephoneNumber
});
if (thisLinkLabel.Text.Contains("˄"))
{
dataGridView1.DataSource = readers.OrderBy(r => r.Patronymic).ToList();
thisLinkLabel.Text = thisLinkLabel.Text.Split('˄')[0] + "˅";
}
else
{
dataGridView1.DataSource = readers.OrderByDescending(r => r.Patronymic).ToList();
thisLinkLabel.Text = thisLinkLabel.Text.Split('˅')[0] + "˄";
}
}
bool ConfirmLibrarian()
{
ConfirmForm conForm = new ConfirmForm();
DialogResult conResult = conForm.ShowDialog(this);
if (conResult == DialogResult.Cancel)
{
return(false);
}
if (conForm.idTextBox.Text.ToUpper().Equals("ADMIN") && conForm.surnameTextBox.Text.ToUpper().Equals("PASSWORD"))
{
var adminForm = new AdminForm();
DialogResult dialogResult = adminForm.ShowDialog(this);
return(true);
}
int id = int.Parse(conForm.idTextBox.Text);
string surname = conForm.surnameTextBox.Text;
LibrarianRepository librRep = new LibrarianRepository();
var librarian = librRep.FindById(id);
if (librarian == null || librarian.Surname.ToUpper() != surname.ToUpper())
{
return(false);
}
_librarianId = id;
return(true);
}
public OrderObjectRepository(ReaderRepository readerRepository, BookRepository bookRepository,
LibraryDepartmentRepository libraryDepartmentRepository, LibrarianRepository librarianRepository)
{
this.readerRepository = readerRepository;
this.bookRepository = bookRepository;
this.libraryDepartmentRepository = libraryDepartmentRepository;
this.librarianRepository = librarianRepository;
orders = new List<Order>();
}
public LibrarianRepositoryTest()
{
repositoryFactory = new T();
libraryDepartmentRepository = repositoryFactory.CreateLibraryDepartmentRepository();
librarianRepository = repositoryFactory.CreateLibrarianRepository(libraryDepartmentRepository);
countItems = librarianRepository.GetItems().Count();
department = new LibraryDepartment("Абонемент", true);
librarian1 = new Librarian("John Doe", department);
librarian2 = new Librarian("Alex Pupkin", department);
}
public OrderMSSQLRepository(ReaderRepository readerRepository, BookRepository bookRepository,
LibraryDepartmentRepository libraryDepartmentRepository, LibrarianRepository librarianRepository,
LibraryDataContext context)
{
this.readerRepository = readerRepository;
this.bookRepository = bookRepository;
this.libraryDepartmentRepository = libraryDepartmentRepository;
this.librarianRepository = librarianRepository;
this.context = context;
}
public OrderTextRepository(ReaderRepository readerRepository, BookRepository bookRepository,
LibraryDepartmentRepository libraryDepartmentRepository, LibrarianRepository librarianRepository)
{
this.readerRepository = readerRepository;
this.bookRepository = bookRepository;
this.libraryDepartmentRepository = libraryDepartmentRepository;
this.librarianRepository = librarianRepository;
if (!Directory.GetParent(FileName).Exists) Directory.GetParent(FileName).Create();
if (!File.Exists(FileName)) File.Create(FileName).Close();
}
public OrderRepositoryTest()
{
repositoryFactory = new T();
readerRepository = repositoryFactory.CreateReaderRepository();
libraryDepartmentRepository = repositoryFactory.CreateLibraryDepartmentRepository();
bookRepository = repositoryFactory.CreateBookRepository(libraryDepartmentRepository);
librarianRepository = repositoryFactory.CreateLibrarianRepository(libraryDepartmentRepository);
orderRepository = repositoryFactory.CreateOrderRepository(readerRepository, bookRepository, libraryDepartmentRepository, librarianRepository);
countItems = orderRepository.GetItems().Count();
}
public void changeButton_Click(object sender, EventArgs e)
{
if (!(dataGridView1.SelectedRows.Count > 0))
{
return;
}
var addLibrarianForm = new AddLibrarianForm();
var librarianRepository = new LibrarianRepository();
int index = dataGridView1.SelectedRows[0].Index;
int id = 0;
bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id);
if (converted == false)
{
return;
}
Librarian librarian = librarianRepository.FindById(id);
addLibrarianForm.nameTextBox.Text = librarian.Name;
addLibrarianForm.surnameTextBox.Text = librarian.Surname;
addLibrarianForm.patronymicTextBox.Text = librarian.Patronymic;
addLibrarianForm.dateTimePicker.Value = librarian.DateOfBirth;
addLibrarianForm.telNumberTextBox.Text = librarian.TelephoneNumber;
DialogResult dialogResult = addLibrarianForm.ShowDialog(this);
if (dialogResult == DialogResult.Cancel)
{
return;
}
string name = addLibrarianForm.nameTextBox.Text;
string surname = addLibrarianForm.surnameTextBox.Text;
string patronymic = addLibrarianForm.patronymicTextBox.Text;
DateTime DoB = addLibrarianForm.dateTimePicker.Value;
string telNumber = addLibrarianForm.telNumberTextBox.Text;
librarian.Name = name;
librarian.Surname = surname;
librarian.Patronymic = patronymic;
librarian.DateOfBirth = DoB;
librarian.TelephoneNumber = telNumber;
librarianRepository.Update(librarian);
_db.SaveChanges();
SetDataGridView();
}
public Home()
{
InitializeComponent();
_bookRepository = new BookRepository();
_librarianRepository = new LibrarianRepository();
_authorRepository = new AuthorRepository();
_cardholderRepository = new CardholderRepository();
_checkoutLogRepository = new CheckoutLogRepository();
_librarianHelper = new LibrarianHelper();
_bookHelper = new BookHelper();
_viewHelper = new ViewHelper();
SetUp();
}
public void SetDataGridView()
{
var librarianRepository = new LibrarianRepository();
var readers = from reader in librarianRepository.Get()
select new
{
reader.Id,
reader.Name,
reader.Surname,
reader.Patronymic,
reader.DateOfBirth,
reader.TelephoneNumber
};
this.dataGridView1.DataSource = readers.ToList();
}
static void Main()
{
var connectionString = "Data Source = LUNA\\SQLEXPRESS; Initial Catalog = Library; Integrated Security = True";
IBookRepository bookRepository = new BookRepository(new BookContext(connectionString));
ILibrarianRepository librarianRepository = new LibrarianRepository(new LibrarianContext(connectionString));
ISubscriberRepository subscriberRepository = new SubscriberRepository(new SubscriberContext(connectionString));
IBorrowedBookRepository borrowedBookRepository = new BorrowedBookRepository(new BorrowedBookContext(connectionString));
IReservedBookRepository reservedBookRepository = new ReservedBookRepository(new ReservedBookContext(connectionString));
IReturnedBookRepository returnedBookRepository = new ReturnedBookRepository(new ReturnedBookContext(connectionString));
IService service = new Service.Service(bookRepository, librarianRepository, subscriberRepository, borrowedBookRepository, reservedBookRepository, returnedBookRepository);
Application.SetHighDpiMode(HighDpiMode.SystemAware);
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new LogInForm(service));
}
static LibraryUnit()
{
_context = new ApplicationDbContext("Library");
AuthorRepository = new AuthorRepository(_context);
BookRepository = new BookRepository(_context);
CategoryRepository = new CategoryRepository(_context);
PressRepository = new PressRepository(_context);
ThemeRepository = new ThemeRepository(_context);
DepartmentRepository = new DepartmentRepository(_context);
TeacherRepository = new TeacherRepository(_context);
FacultyRepository = new FacultyRepository(_context);
GroupRepository = new GroupRepository(_context);
StudentRepository = new StudentRepository(_context);
SCardRepository = new SCardRepository(_context);
TCardRepository = new TCardRepository(_context);
LibrarianRepository = new LibrarianRepository(_context);
}
public OrderXMLRepository(ReaderRepository readerRepository, BookRepository BookRepository,
LibraryDepartmentRepository libraryDepartmentRepository, LibrarianRepository librarianRepository)
{
this.readerRepository = readerRepository;
this.bookRepository = BookRepository;
this.libraryDepartmentRepository = libraryDepartmentRepository;
this.librarianRepository = librarianRepository;
if (!Directory.GetParent(FileName).Exists) Directory.GetParent(FileName).Create();
if (File.Exists(FileName))
{
document = XDocument.Load(FileName);
}
else
{
document = new XDocument(
new XDeclaration("1.0", "utf-8", "yes"),
new XElement("Orders", null));
document.Save(FileName);
}
}
public OrderRepositoryTest()
{
repositoryFactory = new T();
readerRepository = repositoryFactory.CreateReaderRepository();
libraryDepartmentRepository = repositoryFactory.CreateLibraryDepartmentRepository();
bookRepository = repositoryFactory.CreateBookRepository(libraryDepartmentRepository);
librarianRepository = repositoryFactory.CreateLibrarianRepository(libraryDepartmentRepository);
orderRepository = repositoryFactory.CreateOrderRepository(readerRepository, bookRepository, libraryDepartmentRepository, librarianRepository);
countItems = orderRepository.GetItems().Count();
department = new LibraryDepartment("Абонемент", true);
reader = new Reader("Reader Name", "Reader Address");
book = new Book("Author", "Title", 2000, department);
librarian = new Librarian("Name", department);
order1 = new Order(reader, book);
order2 = new Order(reader, book)
{
TimeGetBook = DateTime.Now, LibrarianOpenOrder = librarian
};
}
public void deleteButton_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
int index = dataGridView1.SelectedRows[0].Index;
int id = 0;
bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id);
if (converted == false)
{
return;
}
var librarianRepository = new LibrarianRepository();
var dealRepository = new DealRepository();
var bookCopyInDealRepository = new BookCopyInDealRepository();
List <Deal> deals = dealRepository.GetDealsByReaderId(id);
List <BookCopyInDeal> bookCopyInDeals = bookCopyInDealRepository.GetBookCopiesInDealByReaderId(id);
for (int i = 0; i < bookCopyInDeals.Count; i++)
{
bookCopyInDealRepository.Remove(bookCopyInDeals[i].Id);
}
for (int i = 0; i < deals.Count; i++)
{
dealRepository.Remove(deals[i].Id);
}
librarianRepository.Remove(id);
_db.SaveChanges();
SetDataGridView();
MessageBox.Show("Объект удален");
}
}
/// <summary>
/// Initializes a new instance of the <see cref="LibrarianService"/> class.
/// </summary>
/// <param name="extensionRepository">The extension repository.</param>
public LibrarianService(LibrarianRepository extensionRepository) :
base(extensionRepository)
{
}
static void Main(string[] args)
{
var serviceProvider = new ServiceCollection()
.AddSingleton <ILibrarianHelper, LibrarianHelper>()
.AddSingleton <IBookHelper, BookHelper>()
.AddTransient <IGenericSqlRepository <Librarian>, LibrarianRepository>()
.AddTransient <IGenericSqlRepository <CheckOutLog>, CheckoutLogRepository>()
.BuildServiceProvider();
Database.SetInitializer <LibraryContext>(new LibraryInitializer());
LibrarianRepository librarianRepository = new LibrarianRepository();
var t = librarianRepository.GetAll();
#region Check UserName and Password is true
var librarianHelper = serviceProvider.GetService <ILibrarianHelper>();
var isUserLogin = librarianHelper.IsUserLogin("hoyoung", "holim1");
#endregion
#region Search Book
// initialize BookHelper
var bookHelper = serviceProvider.GetService <IBookHelper>();
// find books search
var z = bookHelper.FindBooksSearch("Andrew;Programming");
var d = bookHelper.FindBooksSearch("Science Fiction");
#endregion
#region Check out book
BookRepository bookRepository = new BookRepository();
var book = bookRepository.Find(5);
var canUserCheckout = librarianHelper.CanCheckOut(book, 16);
CheckOutLog checkOutLog = new CheckOutLog
{
BookID = 5,
CardholderID = 10,
CheckOutDate = DateTime.Now
};
CheckoutLogRepository checkoutlogRepository = new CheckoutLogRepository();
if (canUserCheckout)
{
var checkedOut = checkoutlogRepository.Add(checkOutLog);
}
var found = checkoutlogRepository.GetAll().Where(x => x.BookID == checkOutLog.BookID &&
x.CardholderID == checkOutLog.CardholderID)
.Select(x => x).ToList();
#endregion
#region Update Check Out Log
checkOutLog.BookID = 7;
var checkOut = checkoutlogRepository.Update(checkOutLog);
#endregion
#region Delete Checkoutlog
var foundCol = checkoutlogRepository.Find(8);
checkoutlogRepository.Delete(8);
foundCol = checkoutlogRepository.Find(8);
#endregion
}
public OrderRepository CreateOrderRepository(ReaderRepository readerRepository, BookRepository bookRepository,
LibraryDepartmentRepository libraryDepartmentRepository, LibrarianRepository librarianRepository)
{
return new OrderTextRepository(readerRepository, bookRepository, libraryDepartmentRepository, librarianRepository);
}
