public static int InserNewFilter(EnvComparisonFilter envComparisonFilter) { int returnedId = -1; SqlCeConnection conn = BackEndUtils.GetSqlConnection(); try { conn.Open(); SqlCeCommand command = new SqlCeCommand(Env_Comparison_Filters_SQL.commandInsertNewComparisonFilter, conn); command.Parameters.Add("@name", envComparisonFilter.Name); command.Parameters.Add("@description", envComparisonFilter.Description); command.Parameters.Add("@filter", envComparisonFilter.FilterPattern); command.Parameters.Add("@userid", envComparisonFilter.AddedByUserId); command.Parameters.Add("@filterType", envComparisonFilter.FilterType); command.Parameters.Add("@dateAdded", DateTime.Now); if(envComparisonFilter.FilterType == 2) { command.Parameters.Add("@isFolderDeletion", envComparisonFilter.IsFolderDeletion); command.Parameters.Add("@filterScript", envComparisonFilter.FilterScript); command.Parameters.Add("@exclusionList", envComparisonFilter.ExclusionList); } int numberAffectedRows = Convert.ToInt32(command.ExecuteNonQuery()); returnedId = BackEndUtils.GetMaxId("Env_Comparison_Filters", conn); } finally { conn.Close(); } return returnedId; }
public static void UpdatedFilterById(EnvComparisonFilter filter) { SqlCeConnection conn = BackEndUtils.GetSqlConnection(); try { conn.Open(); SqlCeCommand command = new SqlCeCommand(Env_Comparison_Filters_SQL.commandUpdateComparisonFilterById, conn); command.Parameters.Add("@name", filter.Name); command.Parameters.Add("@description", filter.Description); command.Parameters.Add("@filter", filter.FilterPattern); command.Parameters.Add("@filterType", filter.FilterType); command.Parameters.Add("@id", filter.filterId); command.Parameters.Add("@modifiedByUserId",CommonUtils.LoggedInUserId); command.Parameters.Add("@dateModified",DateTime.Now); if(filter.FilterType == 2) { command.Parameters.Add("@isFolderDeletion", filter.IsFolderDeletion); command.Parameters.Add("@filterScript", filter.FilterScript); command.Parameters.Add("@exclusionList", filter.ExclusionList); } command.ExecuteNonQuery(); } finally { conn.Close(); } }
private void FillUiFromSelectedFilter(EnvComparisonFilter selectedFilter) { txtFilterName.Text = selectedFilter.Name; txtFilterDescription.Text = selectedFilter.Description; txtFilterPattern.Text = selectedFilter.FilterPattern; btnAddFilter.Enabled = false; btnSaveFilter.Enabled = true; cboFilterType.SelectedIndex = selectedFilter.FilterType; if (selectedFilter.FilterType == (int)EnvComparisonFilter.ComparisonFilterType.Deletion) { cboRemoveFileOrFolder.SelectedIndex = selectedFilter.IsFolderDeletion ? 1 : 0; txtGeneratedScript.Text = string.IsNullOrEmpty(selectedFilter.FilterScript) ? GetGeneratedScript(selectedFilter.FilterPattern,selectedFilter.IsFolderDeletion) : selectedFilter.FilterScript; txtExclusionList.Text = selectedFilter.ExclusionList; } }
private void btnSaveFilter_Click(object sender, EventArgs e) { try { if (lvAvailableFilters.SelectedItems.Count > 0) { EnvComparisonFilter envComparisonFilter = (lvAvailableFilters.SelectedItems[0].Tag as EnvComparisonFilter); if (envComparisonFilter !=null) { int filterId = envComparisonFilter.filterId; string name = txtFilterName.Text.Trim(); string description = txtFilterDescription.Text.Trim(); string pattern = txtFilterPattern.Text.Trim(); if (IsValidToSaveFilter(filterId, name, description, pattern)) { EnvComparisonFilter filter = new EnvComparisonFilter(filterId, name, description, pattern, (int)cboFilterType.SelectedItem, CommonUtils.LoggedInUserId); if (cboFilterType.SelectedIndex == (int)EnvComparisonFilter.ComparisonFilterType.Deletion) { filter.IsFolderDeletion = cboRemoveFileOrFolder.SelectedIndex == 1; filter.FilterScript = txtGeneratedScript.Text; filter.ExclusionList = txtExclusionList.Text; } Env_Comparison_Filters.UpdatedFilterById(filter); ReloadAllFiltersFromDatabase(); CommonUtils.ShowInformation("Filter ["+filter.Name+"] is saved.",false); } } } } catch (Exception ex) { CommonUtils.ShowError(ex.Message, ex); } }
private void btnApplyCustomFilter_Click(object sender, EventArgs e) { try { SAVED_SEARCH_RESULTS = CopyDataGridToDataTable(dgvResults); List<EnvComparisonFilter> filters = new List<EnvComparisonFilter>(); EnvComparisonFilter filter = new EnvComparisonFilter(0, "customFilter", "oneUsage", WildcardToRegex(cboCustomFilter.Text.Trim()), 0, 0); filters.Add(filter); ApplySelectedFiltersToSearchResults(filters); //ApplyCustomSearchFilter(txtCustomFilter.Text.Trim()); cboCustomFilter.Items.Add(cboCustomFilter.Text); } catch (Exception ex) { CommonUtils.ShowError(ex.Message, ex); } }
private void btnAddFilter_Click(object sender, EventArgs e) { try { string name = txtFilterName.Text.Trim(); string description = txtFilterDescription.Text.Trim(); string pattern = txtFilterPattern.Text.Trim(); if (IsValidToAddFilter(name, description, pattern)) { if (cboFilterType.SelectedIndex == (int)EnvComparisonFilter.ComparisonFilterType.Deletion) { //deletionMode //cboRemoveFileOrFolder.SelectedIndex=0 ==> file //cboRemoveFileOrFolder.SelectedIndex=1 ==> folder EnvComparisonFilter filter = new EnvComparisonFilter(-1, name, description, pattern, cboFilterType.SelectedIndex, CommonUtils.LoggedInUserId, cboRemoveFileOrFolder.SelectedIndex==1, txtGeneratedScript.Text,txtExclusionList.Text); int filterId = Env_Comparison_Filters.InserNewFilter(filter); CommonUtils.ShowInformation("Deletion Filter ["+txtFilterName.Text+"] has beed added.",false); ResetForm(); ReloadAllFiltersFromDatabase(); } else { //all other modes EnvComparisonFilter filter = new EnvComparisonFilter(-1, name, description, pattern, cboFilterType.SelectedIndex, CommonUtils.LoggedInUserId); int filterId = Env_Comparison_Filters.InserNewFilter(filter); CommonUtils.ShowInformation("Filter ["+txtFilterName.Text+"] has been added.",false); ResetForm(); ReloadAllFiltersFromDatabase(); } } } catch (Exception ex) { CommonUtils.ShowError(ex.Message, ex); } }
private void RemoveDiffFilesFromResults(string filter) { List<EnvComparisonFilter> filters = new List<EnvComparisonFilter>(); EnvComparisonFilter filterObject = new EnvComparisonFilter(0, "customFilter", "oneUsage", filter, 0, 0); filters.Add(filterObject); ApplySelectedFiltersToSearchResults(filters); }
private void ReloadAllFiltersFromDatabase() { lvAvailableFilters.Items.Clear(); DataSet dataSet = Env_Comparison_Filters.GetAllAvailableFiltersAsDataset(); foreach (DataRow row in dataSet.Tables[0].Rows) { EnvComparisonFilter filter = new EnvComparisonFilter(Convert.ToInt32(row["id"]), row["name"].ToString(), row["description"].ToString(), row["filter"].ToString(), Convert.ToInt32(row["filterType"]), Convert.ToInt32(row["userid"]), string.Equals(row["userid"].ToString(),1), row["filterScript"].ToString(), row["exclusionList"].ToString()); switch (Convert.ToInt32(row["filterType"])) { case (int)EnvComparisonFilter.ComparisonFilterType.Regular: System.Windows.Forms.ListViewItem item = lvAvailableFilters.Items.Add(filter.Name,filter.Name); item.Group = lvAvailableFilters.Groups["lvgRegularGroup"]; item.Tag = filter; break; case (int)EnvComparisonFilter.ComparisonFilterType.PreFilter: item = lvAvailableFilters.Items.Add(filter.Name,filter.Name); item.Group = lvAvailableFilters.Groups["lvgPrefilter"]; item.Tag = filter; break; case (int)EnvComparisonFilter.ComparisonFilterType.Deletion: item = lvAvailableFilters.Items.Add(filter.Name,filter.Name); item.Group = lvAvailableFilters.Groups["lvgDeletionFilter"]; item.Tag = filter; break; default: break; } } }
private void PopulateCleanupFilters() { clbAvailableCleanupFilters.Items.Clear(); DataSet dataSet = Env_Comparison_Filters.GetAllAvailableFiltersAsDataset(); foreach (DataRow row in dataSet.Tables[0].Rows) { EnvComparisonFilter filter = new EnvComparisonFilter(Convert.ToInt32(row["id"]), row["name"].ToString(), row["description"].ToString(), row["filter"].ToString(), Convert.ToInt32(row["filterType"]), Convert.ToInt32(row["userid"]), string.Equals(row["userid"].ToString(),1), row["filterScript"].ToString(), row["exclusionList"].ToString()); if (Convert.ToInt32(row["filterType"]) == (int)EnvComparisonFilter.ComparisonFilterType.Deletion) { clbAvailableCleanupFilters.Items.Add(filter,true); } } }
private void LoadAllAvailableFiltersToCheckListBox() { clbAvailableFilters.Items.Clear(); DataSet AllFilters = Env_Comparison_Filters.GetAllAvailableFiltersAsDataset(); foreach (DataRow row in AllFilters.Tables[0].Rows) { EnvComparisonFilter filter = new EnvComparisonFilter(Convert.ToInt32(row["id"]), row["name"].ToString(), row["description"].ToString(), row["filter"].ToString(), Convert.ToInt32(row["filterType"]), Convert.ToInt32(row["userid"])); clbAvailableFilters.Items.Add(filter); } }