public SearchFilterPage() { InitializeComponent(); this.Title = AppResources.Label_SearchSettings; Gender.Text = AppResources.Label_SearchByGender; StatusLabel.Text = AppResources.Label_Status; ProfileLabel.Text = AppResources.Label_Profile_Picture; Save.Text = AppResources.Label_Save; Section.Title = AppResources.Label_SearchBoxFilter; SearchBy.Items.Add(AppResources.Label_All); SearchBy.Items.Add(AppResources.Label_Male); SearchBy.Items.Add(AppResources.Label_Female); ProfilePicture.Items.Add(AppResources.Label_All); ProfilePicture.Items.Add(AppResources.Label_Yes); ProfilePicture.Items.Add(AppResources.Label_NO); Status.Items.Add(AppResources.Label_All); Status.Items.Add(AppResources.Label_Online); Status.Items.Add(AppResources.Label_Offline); var FilterResult = SQL_Commander.GetSearchFilterById(Settings.User_id); if (FilterResult == null) { SearchFilterDB NewSettingsFiltter = new SearchFilterDB(); NewSettingsFiltter.UserID = Settings.User_id; NewSettingsFiltter.Gender = 0; NewSettingsFiltter.ProfilePicture = 0; NewSettingsFiltter.Status = 0; SQL_Commander.InsertSearchFilter(NewSettingsFiltter); ProfilePicture.SelectedIndex = 0; SearchBy.SelectedIndex = 0; Status.SelectedIndex = 0; } else { ProfilePicture.SelectedIndex = FilterResult.ProfilePicture; SearchBy.SelectedIndex = FilterResult.Gender; Status.SelectedIndex = FilterResult.Status; } }
public static void DeleteSearchFilter(SearchFilterDB SearchFilterDB) { SQL_Entity.Connection.Delete(SearchFilterDB); }
public static void UpdateSearchFilter(SearchFilterDB SearchFilterDB) { SQL_Entity.Connection.Update(SearchFilterDB); }
public static void InsertSearchFilter(SearchFilterDB SearchFilterDB) { SQL_Entity.Connection.Insert(SearchFilterDB); }