// Step NA: Returns the LOCData, based on iterating the results from the ResultsTables
private LOCData GetV1(string search)
{
// Step: Return data form using the ResultsTables property
var resultsTable = ExperienceITDB.ResultsTables.AsEnumerable();
// Step: Filter based on the title containing the search value
var dbresults = resultsTable.Where(x => x.Title.Contains(search));
var data = new LOCData();
var results = new List <Result>();
foreach (var dbItem in dbresults)
{
var item = new Result();
item.title = dbItem.Title;
item.createdOn = dbItem.CreateDate;
item.image = new Image()
{
full = "https://dummyimage.com/275x275/aaaaaa/000000.jpg&text=" + item.title,
square = "https://dummyimage.com/75x75/cccccc/000000.jpg&text=" + item.title
};
item.links = new Links()
{
item = "https://dummyimage.com/75x75/aaaaaa/000000.jpg&text=link:" + item.title,
resource = "https://dummyimage.com/275x275/aaaaaa/000000.jpg&text=link:" + item.title
};
results.Add(item);
}
data.results = results;
return(data);
}
public LOCData GetFromQueryString([FromUri] LOCRequest location)
{
var data = new LOCData();
data.results = Reader(location.query);
return(data);
}
// Step 8.60 Returns the LOCData, based on using LINQ
private LOCData Get(string search)
{
// This will create a variable db that contains the entity information.
using (var db = new ExperienceITDatabaseEntities())
{
// Step 8.61: Iterate the ResultsTables.
var resultList = db.ResultsTables
// Step 8.62: Filter based on the title containing the search value
//Student: Update Code Here.
.Where(x => true)
// Step 8.63: transform the data from ResultsTable to Result
.Select <ResultsTable, Result>
(t => new Result
{
//Student: Insert Code Here.
})
.ToList(); // Converts to a list
// This will return the resultList, and place it in an LOCData object.
var data = new LOCData()
{
results = resultList
};
throw new NotImplementedException();
return(null);
}
}
public LOCData GetFromQueryString([FromUri] LOCRequest location)
{
var search = location.query;
// Step 6.60: Return the LOCData object, with sample data
var data = new LOCData();
data.results = new List <Result>
{
// Step 6.70: Return the Result object, with sample data
/* use the following value for the Image:
* full ="//www.loc.gov/pictures/cdn/service/pnp/cph/3c30000/3c34000/3c34900/3c34960_150px.jpg",
* square = "//cdn.loc.gov/service/pnp/cph/3c30000/3c34000/3c34900/3c34960_75x75px.jpg",
* use the following value for the Links:
* item = "//www.loc.gov/pictures/item/2004675446/",
* resource ="//www.loc.gov/pictures/item/2004675446/resource/"
*/
new Result()
{
title = "SAMPLE: Michigan, Detroit, Campus Martius",
createdOn = "[between 1920 and 1940]",
// Step 6.80: Return the Image object, with sample data
image = new Image()
{
full = "//www.loc.gov/pictures/cdn/service/pnp/cph/3c20000/3c23000/3c23000/3c23096_150px.jpg",
square = "https://dummyimage.com/75x75/cccccc/000000.jpg&text=gsdfgdfsdf+dsaf+"
},
// Step 6.90: Return the Links object, with sample data
links = new Links()
{
item = "//www.loc.gov/pictures/item/99403554/",
resource = "//www.loc.gov/pictures/item/99403554/resource/"
}
},
// Step 6.100: Create a second Result object.
new Result()
{
title = "SAMPLE: [Shubert's Detroit Opera House, Campus Martins, Detroit, Michigan]",
createdOn = "1929.",
image = new Image()
{
full = "//www.loc.gov/pictures/cdn/service/pnp/cph/3c30000/3c34000/3c34900/3c34960_150px.jpg",
square = "//cdn.loc.gov/service/pnp/cph/3c30000/3c34000/3c34900/3c34960_75x75px.jpg",
},
links = new Links()
{
item = "//www.loc.gov/pictures/item/2004675446/",
resource = "//www.loc.gov/pictures/item/2004675446/resource/"
}
}
};
return(data);
}
// Step 9.60: Returns the LOCData, based on iterating the results from the Products object */
private LOCData Get(string search)
{
// This will allow to get the base url.
var request = HttpContext.Current.Request;
var urlBase = "http://" + request.Url.Authority + "/WebPages";
// Step 9.61: Create a products variable that gets data from the Products entity. Convert it to a List
//Student: Update your code here
//var products = null;
// Step 9.62: Create a filtered variable, using LINQ that filters if either search == null or the name contains search.
//Student: Update your code here
//var filtered = products.Where(x => true);
// Step 9.63: Create a filteredFilled that filters out data with no images. This can be determined by:
// making sure the ProductProductPhotoes.ElementAt(0).ProductPhotoID value is not 1
//Student: Update your code here
//var filteredFilled = filtered.Where(x => true);
var data = new LOCData();
var results = new List <Result>();
// Step 9.64: Interate through all the filteredFilled items using the dbItems name.
// foreach ...
{
// Step 9.65: For each item, create a Result object, call it item.
//Student: Update your code here
//var item = null;
// Step 9.66: Populate the title with the dbItems' Name
//Student: Update your code here
//item.title = null;
// Step 9.67: Populate the createdOn with the dbItems' ModifiedDate (need to convert it to a string)
//Student: Update your code here
//item.createdOn = null;
// Step 9.68: The photo object can be gotten using dbItem.ProductProductPhotoes.First(), which grabs the first photo.
//var productPhoto = null;
// Step 9.69: Uncomment below. This will initialise the image, and links object with image urls.
// item.image = new Image()
// {
// full = urlBase + "/ProductImage.ashx?ProductID=" + productPhoto.ProductPhotoID + "&size=large",
// square = urlBase + "/ProductImage.ashx?ProductID=" + productPhoto.ProductPhotoID + "&size=small"
// };
// item.links = new Links()
// {
// item = urlBase + "/ProductImage.ashx?ProductID=" + productPhoto.ProductPhotoID + "&size=small",
// resource = urlBase + "/ProductImage.ashx?ProductID=" + productPhoto.ProductPhotoID + "&size=large"
// };
//results.Add(item);
}
// data.results = results;
return(data);
}
// Returns the LOCData, based on iterating the results from the Products object */
// Step 9.60: Create a Get method, that given a search string, returns the LOCData object */
private LOCData Get(string search)
{
// This will allow to get the base url.
var request = HttpContext.Current.Request;
var urlBase = "http://" + request.Url.Authority + "/WebPages";
// Step 9.61: Create a products variable that gets data from the Products entity. Convert it to a List
var products = AdventureWorksDB.Products.AsEnumerable().ToList();
// Step 9.62: Create a filtered variable, using LINQ that filters if either search == null or the name contains search.
var filtered = products.Where(x => (search == null) || x.Name.Contains(search));
// Step 9.63: Create a filteredFilled that filters out data with no images. This can be determined by:
// making sure the ProductProductPhotoes.ElementAt(0).ProductPhotoID value is not 1
var filteredFilled = filtered.Where(x => x.ProductProductPhotoes.ElementAt(0).ProductPhotoID != 1);
var data = new LOCData();
var results = new List <Result>();
// Step 9.64: Interate through all the filteredFilled items using the dbItems name.
foreach (var dbItem in filteredFilled)
{
// Step 9.65: For each item, create a Result object, call it item.
var item = new Result();
// Step 9.66: Populate the title with the dbItems' Name
item.title = dbItem.Name;
// Step 9.67: Populate the createdOn with the dbItems' ModifiedDate (need to convert it to a string)
item.createdOn = dbItem.ModifiedDate.ToString();
// Step 9.68: The photo object can be gotten using dbItem.ProductProductPhotoes.First(), which grabs the first photo.
var productPhoto = dbItem.ProductProductPhotoes.First();
// Step 9.69: Uncomment below. This will initialise the image, and links object with image urls.
item.image = new Image()
{
full = urlBase + "/ProductImage.ashx?ProductID=" + productPhoto.ProductPhotoID + "&size=large",
square = urlBase + "/ProductImage.ashx?ProductID=" + productPhoto.ProductPhotoID + "&size=small"
};
item.links = new Links()
{
item = urlBase + "/ProductImage.ashx?ProductID=" + productPhoto.ProductPhotoID + "&size=small",
resource = urlBase + "/ProductImage.ashx?ProductID=" + productPhoto.ProductPhotoID + "&size=large"
};
results.Add(item);
}
data.results = results;
return(data);
}
public LOCData GetFromQueryString([FromUri] LOCRequest location)
{
var search = location.query;
// Step 6.60: Return the LOCData object, with sample data
var data = new LOCData();
data.results = new List <Result>
{
// Step 6.70: Return the Result object, with sample data
// use the following value for the Image:
// full ="//www.loc.gov/pictures/cdn/service/pnp/cph/3c30000/3c34000/3c34900/3c34960_150px.jpg",
// square = "//cdn.loc.gov/service/pnp/cph/3c30000/3c34000/3c34900/3c34960_75x75px.jpg",
// use the following value for the Links:
// item = "//www.loc.gov/pictures/item/2004675446/",
// resource ="//www.loc.gov/pictures/item/2004675446/resource/"
new Result()
{
//Student: Insert your code here
// Step 6.80: Return the Image object, with sample data
image = new Image()
{
//Student: Insert your code here
},
// Step 6.90: Return the Links object, with sample data
links = new Links()
{
//Student: Insert your code here
}
},
// Step 6.100: Create a second Result object.
new Result()
{
//Student: Insert your code here
}
};
return(data);
}
// Step 8.60: Returns the LOCData, based on using LINQ
private LOCData Get(string search)
{
// This will create a variable db that contains the entity information.
using (var db = new ExperienceITDatabaseEntities())
{
// Step 8.61: Iterate the ResultsTables.
var resultList = db.ResultsTables
// Step 8.62: Filter based on the title containing the search value
.Where(x => x.Title.Contains(search))
// Step 8.63: transform the data from ResultsTable to Result
.Select <ResultsTable, Result>
(t => new Result
{
title = t.Title,
createdOn = t.CreateDate,
image = new Image()
{
full = "https://dummyimage.com/275x275/aaaaaa/000000.jpg&text=" + t.Title,
square = "https://dummyimage.com/75x75/cccccc/000000.jpg&text=" + t.Title
},
links = new Links()
{
item = "https://dummyimage.com/75x75/aaaaaa/000000.jpg&text=link:" + t.Title,
resource = "https://dummyimage.com/275x275/aaaaaa/000000.jpg&text=link:" + t.Title
}
})
.ToList(); // Converts to a list
// This will return the resultList, and place it in an LOCData object.
var data = new LOCData()
{
results = resultList
};
return(data);
}
}
