public void SaveBorrowedItemsState()
{
using (LibAppContext dbConn = new LibAppContext())
{
foreach (ViewBorrowTableItems row in BorrowedBooksView)
{
BorrowedItem singleItem = dbConn.BorrowedItems.First(el => el.Id == row.BorrowedId);
singleItem.Returned = row.Returned;
dbConn.SaveChanges();
}
}
}
public bool VerifyPassword(string password)
{
using (LibAppContext conn = new LibAppContext())
{
var result = conn.Users.Where(user => user.Name == UserName).ToList();
if (result == null || !result.Any())
{
return(false);
}
else
{
return(result.First <User>().ConfirmPassword(password));
}
}
}
private void Startup(object sender, RoutedEventArgs e)
{
using (LibAppContext DbConn = new LibAppContext())
{
string password;
using (MD5 md5Hash = MD5.Create())
{
EncryptionTools obj = new EncryptionTools(md5Hash);
password = obj.GetMd5Hash("avertis");
}
int count = DbConn.Users.Count();
if (count == 0)
{
User Obj = new User(name: "admin", password: password);
DbConn.Users.Add(Obj);
DbConn.SaveChanges();
}
#region BorrowerTypes
int currentTypes = DbConn.BorrowerTypes.Count();
if (currentTypes == 0)
{
//MessageBox.Show(currentTypes.ToString());
List <BorrowerType> defaults = new List <BorrowerType> {
new BorrowerType()
{
TypeName = "Student"
},
new BorrowerType()
{
TypeName = "Teacher"
}
};
DbConn.BorrowerTypes.AddRange(defaults);
DbConn.SaveChanges();
}
#endregion
DbConn.Dispose();
}
}
public void LoadBorrowed()
{
using (LibAppContext conn = new LibAppContext())
{
BorrowedBooksView = (from bitem in conn.BorrowedItems
join user in conn.Borrowers on bitem.BorrowerId equals user.Id
join books in conn.Books on bitem.BookId equals books.Id
select new ViewBorrowTableItems
{
BorrowedId = bitem.Id,
User = user,
BorrowedBookName = books.Title,
BorrowDate = bitem.BorrowDate,
DueDate = bitem.ReturnDate,
Returned = bitem.Returned
}).ToList();
}
}
public void SaveNewBorrow()
{
using (LibAppContext dbConn = new LibAppContext())
{
if (CurrentBook.Available <= 0)
{
MessageBox.Show("No Books are available to lend out");
CurrentPage = new ViewBooks(this);
return;
}
LendBook.BookId = CurrentBook.Id;
dbConn.BorrowedItems.Add(LendBook);
dbConn.SaveChanges();
}
LoadBorrowed();
LoadBooks();
CurrentPage = new ViewBooks(this);
}
public void LoadReport(string ReportName)
{
LibAppContext conn = new LibAppContext();
switch (ReportName)
{
case "Lost_Books":
List <LostItemsReport> res = (from item in conn.LostBooks
join books in conn.Books on item.BookID equals books.Id
select new LostItemsReport
{
Id = item.Id,
Title = books.Title,
Author = books.Author,
//WriteOffDate = item.LossDate,
Narration = item.LossReason
}
).ToList();
ExportListUsingEPPlus <LostItemsReport>(res, namePrefix: "Write off Books");
break;
case "Registered_Borrowers":
List <RegisteredBorrowers> borrowers = (from row in conn.Borrowers
join names in conn.BorrowerTypes on row.TypeName_Id equals names.Id
select new RegisteredBorrowers
{
Id = row.IdentificationNumber,
Name = row.FirstName + " " + row.LastName,
Email = row.EmailAddress,
Type = names.TypeName
}).ToList();
ExportListUsingEPPlus(borrowers, "Registered Borrowers");
break;
case "Borrowed_Books":
ExportListUsingEPPlus(BorrowedBooksView, "BorrowedBooks");
break;
default:
ExportListUsingEPPlus(LibraryBooks, "All Books");
break;
}
conn.Dispose();
}
