public static UserSearches GetSearchesFromDB(int userId, UserSearchDatePeriod period, UserSearchType type, int productId)
{
var newEntries = UserSearches.GetAllSearches(userId, "", period, type, productId);
var model = new UserSearches();
foreach (var search in newEntries)
{
var currentSearch = new UserSearch
{
Text = search["txt"].ToString(),
Date = DateTime.Parse(search["search_date"].ToString()),
Id = int.Parse(search["id"].ToString()),
Details = JsonConvert.DeserializeObject <SearchDetails>(search["details"].ToString(), new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Include
})
};
if (currentSearch.Details.Cases != null)
{
currentSearch.Details.Cases.DateFromShort = currentSearch.Details.Cases.DateFrom.ToShortDateString();
currentSearch.Details.Cases.DateToShort = currentSearch.Details.Cases.DateTo.ToShortDateString();
currentSearch.Details.Cases.DateDefaultByCultureShort = new DateTime(1, 1, 1).ToShortDateString();
}
if (currentSearch.Details.Law != null)
{
currentSearch.Details.Law.DateFromShort = currentSearch.Details.Law.DateFrom.ToShortDateString();
currentSearch.Details.Law.DateToShort = currentSearch.Details.Law.DateTo.ToShortDateString();
currentSearch.Details.Law.DateDefaultByCultureShort = new DateTime(1, 1, 1).ToShortDateString();
}
if (currentSearch.Details.Finances != null)
{
currentSearch.Details.Finances.DateFromShort = currentSearch.Details.Finances.DateFrom.ToShortDateString();
currentSearch.Details.Finances.DateToShort = currentSearch.Details.Finances.DateTo.ToShortDateString();
currentSearch.Details.Finances.DateDefaultByCultureShort = new DateTime(1, 1, 1).ToShortDateString();
}
model.Items.Add(currentSearch);
}
return(model);
}
public static IEnumerable <IDataRecord> GetAllSearches(int userId, string like, UserSearchDatePeriod period, UserSearchType type, int productId)
{
return(DB.GetUserSearches(userId, like, (int)period, (int)type, productId).Take(int.Parse(ConfigurationManager.AppSettings["UserSearchCount"])));
}
