public SearchResult(IDictionary <string, string> dict)
{
Id = dict["id"];
Name = dict["name"];
Database = dict["database"];
Schema = dict["schema"];
Server = dict["server"];
Score = (long)Math.Round(Convert.ToDecimal(dict["score"]), 0);
Rank = float.Parse(dict["rank"]);
Equality = dict["equality"];
Included = dict["included"];
Inequality = dict["inequality"];
LastNeededDate = Dates.ConvertDocDate(dict["lastneeded"]);
LastNeededDateFormatted = Dates.FormatDate(LastNeededDate);
SqlQuery = CreateExpressionToSearchForPossibleCauses();
SqlIndexQuery = CreateExpressionToSearchForOtherIndexes();
CreateIndexSql = CreateMissingIndexSql();
}
public SearchResult(IDictionary <string, string> dict, Controller controller)
{
Name = dict["name"];
Database = dict["database"];
Id = dict["id"];
Schema = dict["schema"];
Server = dict["server"];
Type = dict["type"];
Url = controller.Url.Content(string.Format("~/Sql/Download?id={0}", HttpUtility.UrlEncode(dict["id"])));
CreateDate = Dates.ConvertDocDate(dict["created"]);
CreateDateFormatted = Dates.FormatDate(Dates.ConvertDocDate(dict["created"]));
ModifyDate = Dates.ConvertDocDate(dict["modified"]);
ModifyDateFormatted = Dates.FormatDate(Dates.ConvertDocDate(dict["modified"]));
Rank = float.Parse(dict["rank"]);
Dropped = Convert.ToBoolean(dict["dropped"]);
Use = Convert.ToInt64(dict["use"]);
LastUsedDate = Dates.ConvertDocDate(dict["lastused"]);
LastUsedDateFormatted = Dates.FormatDate(Dates.ConvertDocDate(dict["lastused"]));
SqlScript = dict["sqlscript"];
}
