public List <string> Preview(string key, string url)
{
List <string> results = new List <string>();
string rkLowerFilter = TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.Equal, LinkRow.CreateMD5(url));
string pkUpperFilter = TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, key);
// Note CombineFilters has the effect of “([Expression1]) Operator (Expression2]), as such passing in a complex expression will result in a logical grouping.
string combinedFilter = TableQuery.CombineFilters(rkLowerFilter, TableOperators.And, pkUpperFilter);
try
{
TableQuery <LinkRow> rangeQuery = new TableQuery <LinkRow>()
.Where(combinedFilter);
var result = DBConnect.GetLinkTable().ExecuteQuery(rangeQuery).Take(1).ToList();
LinkRow res = result[0];
results.Add(res.Title);
results.Add(res.URL);
results.Add(res.Img);
results.Add(res.Body);
}
catch { results.Add("No Preview Found"); }
return(results);
}
public List <string> GetTitle(string q)
{
List <string> titledate = new List <string>();
try
{
TableQuery <LinkRow> rangeQuery = new TableQuery <LinkRow>()
.Where(
TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.Equal, LinkRow.CreateMD5(q))
);
var results = DBConnect.GetLinkTable().ExecuteQuery(rangeQuery);
foreach (var row in results.Take(1))
{
titledate.Add(row.Title);
titledate.Add("Published: " + row.DatePublished.ToString());
}
return(titledate);
}
catch
{
titledate.Add("No Page Found");
titledate.Add("Try a different URL");
return(titledate);
}
}
