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"]; }