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