private List <SearchDisplay> ConvertCardholderToSearchDisplay(List <Cardholder> cardholders)
{
List <SearchDisplay> searchDisplays = new List <SearchDisplay>();
foreach (var ch in cardholders)
{
var checkoutlog = _checkoutLogRepository.GetAll().Where(x => x.CardholderID == ch.ID).Select(x => x)
.FirstOrDefault();
var searchDisplay = new SearchDisplay();
var hasOverDue = "No";
searchDisplay.Display = ch.ToString();
searchDisplay.Person = ch.Person;
if (checkoutlog != null)
{
//TODO: Check if this is returning false
if (_librarianHelper.CanCheckOut(checkoutlog.Book, ch.ID))
{
hasOverDue = "Yes";
}
searchDisplay.Display += $"Book ID: {checkoutlog.BookID}, " +
$"ISBN: {checkoutlog.Book.ISBN}, " +
$"Title: {checkoutlog.Book.Title}, " +
$"Check Out Date: {checkoutlog.CheckOutDate.ToString("MM/dd/yyyy")}," +
$"Has Over Due: {hasOverDue}";
searchDisplay.Book = checkoutlog.Book;
}
searchDisplays.Add(searchDisplay);
}
return(searchDisplays.OrderBy(x => x.Person.LastName).OrderBy(x => x.Person.FirstName).ToList());
}
private List <SearchDisplay> ConvertBooktoSearchDisplay(List <Book> books)
{
List <SearchDisplay> searchDisplays = new List <SearchDisplay>();
foreach (var book in books)
{
var checkoutlog = _checkoutLogRepository.GetAll().Where(x => x.BookID == book.BookID).FirstOrDefault();
var searchDisplay = new SearchDisplay();
searchDisplay.Book = book;
searchDisplay.CheckOutLogDate = checkoutlog.CheckOutDate;
searchDisplay.Display = $"Id:{book.BookID}, " +
$"ISBN: {book.ISBN}, " +
$"Title: {book.Title}, " +
$"Check Out Date: {checkoutlog.CheckOutDate.ToString("MM/dd/yyyy")}, " +
$"Cardholder Id: {checkoutlog.Cardholder.ID}, " +
$"Cardholder Full Name: {checkoutlog.Cardholder.Person.FirstName} {checkoutlog.Cardholder.Person.LastName}, " +
$"Library Card Id: {checkoutlog.Cardholder.LibraryCardID}, " +
$"Phone: {checkoutlog.Cardholder.Phone}";
searchDisplays.Add(searchDisplay);
}
return(searchDisplays.OrderBy(x => x.CheckOutLogDate)
.OrderBy(x => x.Book.Title)
.ToList());
}
private void Btn_submit_Click(object sender, RoutedEventArgs e)
{
var text = txt_search.Text;
List <Book> books = new List <Book>();
if (string.IsNullOrEmpty(text))
{
books = _bookRepository.GetAll();
}
else
{
books = _bookHelper.FindBooksSearch(text);
}
List <SearchDisplay> displayList = new List <SearchDisplay>();
books.ForEach(x =>
{
SearchDisplay display = new SearchDisplay();
display.Book = x;
display.Available = _bookHelper.CanCheckOutBook(x);
display.Display = $"Id: {x.BookID}, Title: {x.Title}, Author: {x.Author.Person.FirstName} {x.Author.Person.LastName}, Publisher: {x.Publisher}, Year Published: {x.YearPublished}";
displayList.Add(display);
});
lstview_books.ItemsSource = displayList;
lbl_notFound.Visibility = lstview_books.Items.Count > 0 ? Visibility.Hidden : Visibility.Visible;
_viewHelper.ClearTextBox(containerCanvas);
txt_search.Text = text;
}
private List <SearchDisplay> ConvertLibrarianToSearchDisplay(List <LibraryOrganizerDB.Entities.Librarian> librarians)
{
List <SearchDisplay> searchDisplays = new List <SearchDisplay>();
foreach (var librarian in librarians)
{
var searchDisplay = new SearchDisplay();
searchDisplay.Display = librarian.ToString();
searchDisplay.Person = librarian.Person;
searchDisplays.Add(searchDisplay);
}
return(searchDisplays.OrderBy(x => x.Person.LastName).OrderBy(x => x.Person.FirstName).ToList());
}
public IEnumerable <SearchDisplay> UsedVehicles()
{
List <SearchDisplay> vehicles = new List <SearchDisplay>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("SearchedVehiclesUsed", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
SearchDisplay row = new SearchDisplay();
row.VehicleID = (int)dr["VehicleID"];
row.VIN = dr["VIN"].ToString();
row.ModelID = (int)dr["ModelID"];
row.ModelName = dr["ModelName"].ToString();
row.MakeName = dr["MakeName"].ToString();
row.ConditionID = (int)dr["ConditionID"];
row.ConditionName = dr["ConditionName"].ToString();
row.VehicleTypeID = (int)dr["VehicleTypeID"];
row.VehicleTypeName = dr["VehicleTypeName"].ToString();
row.Year = dr["Year"].ToString();
row.TransmissionTypeID = (int)dr["TransmissionTypeID"];
row.TransmissionTypeName = dr["TransmissionTypeName"].ToString();
row.CarColor = (int)dr["CarColor"];
row.CarColorName = dr["Color"].ToString();
row.Interior = (int)dr["Interior"];
row.InteriorColorName = dr["Interior"].ToString();
row.Mileage = dr["Mileage"].ToString();
row.MSRP = (decimal)dr["MSRP"];
row.SalesPrice = (decimal)dr["SalesPrice"];
//row.Description = dr["Description"].ToString();
row.Picture = dr["Picture"].ToString();
//row.Featured = (bool)dr["Featured"];
vehicles.Add(row);
}
}
}
return(vehicles);
}
private List <SearchDisplay> ConvertAuthorToSearchDisplay(List <Author> authors)
{
List <SearchDisplay> searchDisplays = new List <SearchDisplay>();
foreach (var author in authors)
{
var book = _bookRepository.GetAll().Where(x => x.AuthorID == author.ID).FirstOrDefault();
var searchDisplay = new SearchDisplay();
if (book != null)
{
searchDisplay.Display = author.ToString() +
$", Book Id: {book.BookID}, ISBN: {book.ISBN}, Title: {book.Title}, Publisher: {book.Publisher}";
searchDisplay.Book = book;
searchDisplay.Person = author.Person;
searchDisplays.Add(searchDisplay);
}
}
return(searchDisplays.OrderBy(x => x.Person.LastName)
.OrderBy(x => x.Person.FirstName)
.OrderBy(x => x.Book.Title).ToList());
}
public IEnumerable <SearchDisplay> Search(VehicleSearchParams parameters)
{
List <SearchDisplay> vehicles = new List <SearchDisplay>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
string query = "SELECT VehicleID, VIN, Vehicle.ModelID, Model.MakeID, Make.MakeName, Model.ModelName, " +
"Vehicle.ConditionID, ConditionName, Year, Vehicle.VehicleTypeID, VehicleType.VehicleTypeName, " +
"Vehicle.TransmissionTypeID, TransmissionTypeName, Vehicle.CarColor, Color.ColorName AS CarColorName, " +
"Vehicle.Interior, (SELECT ColorName FROM Color WHERE Vehicle.Interior = Color.ColorID) AS InteriorColorName, " +
"Mileage, MSRP, SalesPrice, Picture, Featured " +
"FROM Vehicle " +
"INNER JOIN Model ON Vehicle.ModelID = Model.ModelID " +
"INNER JOIN Make ON Model.MakeID = Make.MakeID " +
"INNER JOIN Condition ON Vehicle.ConditionID = Condition.ConditionID " +
"INNER JOIN VehicleType ON Vehicle.VehicleTypeID = VehicleType.VehicleTypeID " +
"INNER JOIN TransmissionType ON Vehicle.TransmissionTypeID = TransmissionType.TransmissionTypeID " +
"INNER JOIN Color ON Vehicle.CarColor = Color.ColorID " +
"WHERE 1 = 1 ";
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
if (parameters.MinPrice.HasValue)
{
query += "AND SalesPrice >= @MinPrice ";
cmd.Parameters.AddWithValue("@MinPrice", parameters.MinPrice.Value);
}
if (parameters.MaxPrice.HasValue)
{
query += "AND SalesPrice <= @MaxPrice ";
cmd.Parameters.AddWithValue("@MaxPrice", parameters.MaxPrice.Value);
}
if (parameters.MinYear.HasValue)
{
query += "AND Year >= @MinYear ";
cmd.Parameters.AddWithValue("@MinYear", parameters.MinYear.Value);
}
if (parameters.MaxYear.HasValue)
{
query += "AND Year <= @MaxYear ";
cmd.Parameters.AddWithValue("@MaxYear", parameters.MaxYear.Value);
}
if (!string.IsNullOrEmpty(parameters.ModelName))
{
query += "AND ModelName LIKE @ModelName ";
cmd.Parameters.AddWithValue("@ModelName", '%' + parameters.ModelName + '%');
}
if (!string.IsNullOrEmpty(parameters.MakeName))
{
query += "AND MakeName LIKE @MakeName ";
cmd.Parameters.AddWithValue("@MakeName", '%' + parameters.MakeName + '%');
}
if (!string.IsNullOrEmpty(parameters.Year))
{
query += "AND Year LIKE @Year ";
cmd.Parameters.AddWithValue("@Year", '%' + parameters.Year + '%');
}
cmd.CommandText = query;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
SearchDisplay row = new SearchDisplay();
row.VehicleID = (int)dr["VehicleID"];
row.VIN = dr["VIN"].ToString();
row.ModelID = (int)dr["ModelID"];
row.ModelName = dr["ModelName"].ToString();
row.MakeName = dr["MakeName"].ToString();
row.ConditionID = (int)dr["ConditionID"];
row.ConditionName = dr["ConditionName"].ToString();
row.VehicleTypeID = (int)dr["VehicleTypeID"];
row.VehicleTypeName = dr["VehicleTypeName"].ToString();
row.Year = dr["Year"].ToString();
row.TransmissionTypeID = (int)dr["TransmissionTypeID"];
row.TransmissionTypeName = dr["TransmissionTypeName"].ToString();
row.CarColor = (int)dr["CarColor"];
row.CarColorName = dr["CarColorName"].ToString();
row.Interior = (int)dr["Interior"];
row.InteriorColorName = dr["InteriorColorName"].ToString();
row.Mileage = dr["Mileage"].ToString();
row.MSRP = (decimal)dr["MSRP"];
row.SalesPrice = (decimal)dr["SalesPrice"];
//row.Description = dr["Description"].ToString();
row.Picture = dr["Picture"].ToString();
//row.Featured = (bool)dr["Featured"];
vehicles.Add(row);
}
}
}
return(vehicles);
}
