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