public static List <SavedSearch> GetSavedSearch(string searchId, int userId) { if (string.IsNullOrEmpty(searchId) || userId <= 0) { log.Warn("This method must be used for a specific control and user"); return(null); } List <SavedSearch> theList = new List <SavedSearch>(); SavedSearchDSTableAdapters.GetSavedSearchTableAdapter adapter = new SavedSearchDSTableAdapters.GetSavedSearchTableAdapter(); try { SavedSearchDS.GetSavedSearchDataTable table = adapter.GetSavedSearch(searchId, userId); if (table != null && table.Rows.Count > 0) { foreach (SavedSearchDS.GetSavedSearchRow row in table.Rows) { SavedSearch obj = FillRecord(row); theList.Add(obj); } } } catch (Exception x) { log.Error("An error was ocurred while getting the saved searches", x); return(null); } return(theList); }
public static bool Delete(SavedSearch obj) { if (string.IsNullOrEmpty(obj.SearchId) || obj.UserId <= 0 || string.IsNullOrEmpty(obj.Name)) { log.Error("One of the arguments was either null, empty or less than 0: " + obj.SearchId + "," + obj.UserId.ToString() + "," + obj.Name); return(false); } SavedSearchDSTableAdapters.GetSavedSearchTableAdapter adapter = new SavedSearchDSTableAdapters.GetSavedSearchTableAdapter(); try { adapter.Delete(obj.SearchId, obj.UserId, obj.Name); return(true); } catch (Exception x) { log.Error("An error was ocurred while deleting the saved search", x); return(false); } }
public static bool Insert(SavedSearch newSavedSearch) { if (newSavedSearch == null) { log.Error("New object cannot be null"); return(false); } if (string.IsNullOrEmpty(newSavedSearch.SearchId) || newSavedSearch.UserId <= 0 || string.IsNullOrEmpty(newSavedSearch.Name)) { log.Error("New object's arguments were either null, empty or less than 0: " + newSavedSearch.SearchId + "," + newSavedSearch.UserId.ToString() + "," + newSavedSearch.Name); return(false); } SavedSearchDSTableAdapters.GetSavedSearchTableAdapter adapter = new SavedSearchDSTableAdapters.GetSavedSearchTableAdapter(); try { adapter.Insert(newSavedSearch.SearchId, newSavedSearch.UserId, newSavedSearch.Name, newSavedSearch.SearchExpression); return(true); } catch (Exception x) { log.Error("An error was ocurred while inserting the saved search", x); return(false); } }
public static List <SavedSearch> GetSavedSearch(string searchId, int userId, string name) { List <SavedSearch> theList = new List <SavedSearch>(); SavedSearchDSTableAdapters.GetSavedSearchTableAdapter adapter = new SavedSearchDSTableAdapters.GetSavedSearchTableAdapter(); try { SavedSearchDS.GetSavedSearchDataTable table = adapter.GetSavedSearchBySearchName(searchId, userId, name); if (table != null && table.Rows.Count == 1) { SavedSearch obj = FillRecord(table[0]); theList.Add(obj); } else { log.Error("No record found with arguments: " + searchId + "," + userId.ToString() + "," + name); } } catch (Exception x) { log.Error("An error was ocurred while getting the saved searches", x); return(null); } return(theList); }