public void AdvancedFilter(string searchString, CheckedListBox.CheckedItemCollection checkedItems)
{
// Start from scratch
gridView.Items.Clear();
// Repopulate if empty search
if (checkedItems.Count == 0 || searchString == "")
{
fullList.ForEach(item => gridView.Items.Add(item));
return;
}
// For each video file showing:
fullList.ForEach(item =>
{
// Big Linq Statement Translation:
// - Find tag entries from file that match type of checked items
// - Any entry that contains the search string, add that file to view
var file = (VideoFile)item.Tag;
if (checkedItems.Cast <Tag>().Select(tag =>
file.Tags.Find(entry => entry.TypeId == tag.Id)).
Any(match => match != null && match.Data.ToLower().Contains(searchString.ToLower())))
{
gridView.Items.Add(item);
}
});
}
private void chkListDiasSemana_SelectedIndexChanged(object sender, EventArgs e)
{
CheckedListBox checkedListBox = (sender as CheckedListBox);
CheckedListBox.CheckedItemCollection DiasProgramacion = checkedListBox.CheckedItems;
IEnumerable <string> diasProgramados = DiasProgramacion.Cast <String>().AsEnumerable();
NombreProgramacion();
string resultadoDias = "";
int numeroSemanas = 1;
if (ProgramacionServicioActual.Semana.HasValue)
{
numeroSemanas = Convert.ToInt32(ProgramacionServicioActual.Semana.Value);
}
if (numeroSemanas > 0)
{
//Efrain Hernandez 20/08/2018: Solo se indica una semana debido a que si se establece
//Lunes cada 2 semanas, debería ser el día lunes cada 2 semanas y no el día lunes de cada semana.
resultadoDias = ObtenerDiasTexto(diasProgramados, 1);
if (resultadoDias.Length > 0)
{
resultadoDias = resultadoDias.Substring(0, resultadoDias.Length - 1);
}
ProgramacionServicioActual.Dias = resultadoDias;
}
programacionservicioBindingSource.ResetBindings(false);
}
private void RunQuestionsOnly()
{
CheckedListBox.CheckedItemCollection c = clbQustions.CheckedItems;
var items = c.Cast <IQuestionClass>().ToList();
_wizardPresenter.GenerateQuestionsOnly(items, Settings.Default.BlankFragmentBaseOlly);
}
public static Queue <DownloadableProgram> GetProgramsQueueFromCheckedListControl(CheckedListBox.CheckedItemCollection items)
{
var downloadLinksResult = new Queue <DownloadableProgram>();
var downloadLinks = items.Cast <DownloadableProgram>();
downloadLinks.ForEach(dl => downloadLinksResult.Enqueue(dl));
return(downloadLinksResult);
}
private void NombreProgramacion()
{
CheckedListBox.CheckedItemCollection DiasProgramacion = chkListDiasSemana.CheckedItems;
IEnumerable <string> diasProgramados = DiasProgramacion.Cast <String>().AsEnumerable();
//Bug fixed: Checar si hay algo seleccionado en el checklist de programacion, sino marca excepción
ProgramacionServicioActual.Nombre = chkListTipoProgramacion.SelectedItem != null?chkListTipoProgramacion.SelectedItem.ToString() + " " : "";
foreach (string dia in diasProgramados)
{
ProgramacionServicioActual.Nombre += dia.Substring(0, 3) + "-";
}
ProgramacionServicioActual.Nombre = ProgramacionServicioActual.Nombre.Substring(0, ProgramacionServicioActual.Nombre.Length - 1);
}
private void semanaTextBox_Leave(object sender, EventArgs e)
{
if (Convert.ToInt32(semanaTextBox.Text) > 0)
{
chkListDiasSemana.Enabled = true;
CheckedListBox.CheckedItemCollection DiasProgramacion = chkListDiasSemana.CheckedItems;
IEnumerable <string> diasProgramados = DiasProgramacion.Cast <String>().AsEnumerable();
string resultadoDias = "";
int numeroSemanas = Convert.ToInt32(semanaTextBox.Text);
if (numeroSemanas > 0)
{
resultadoDias = ObtenerDiasTexto(diasProgramados, numeroSemanas);
diasTextBox.Text = resultadoDias.Substring(0, resultadoDias.Length - 1);
}
}
else
{
chkListDiasSemana.Enabled = false;
}
}
public void SetFilter(CheckedListBox.CheckedItemCollection items)
{
this.binding?.SetFilter(items.Cast <string>(), null);
return;
}
private void btnNext_Click(object sender, EventArgs e)
{
if (String.Equals(btnNext.Text, "&Finish", StringComparison.CurrentCultureIgnoreCase))
{
if (Validation.HasValidationErrors(Controls))
{
MessageBox.Show(@"Please ensure all required fields are populated", @"Required fields are missing",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
try
{
Cursor = Cursors.WaitCursor;
if (GenerateNewTemplate)
{
FactFinder template = GenerateTempalteObject();
_selectedQuestions.Clear();
CheckedListBox.CheckedItemCollection c = clbQustions.CheckedItems;
var items = c.Cast <IQuestionClass>().ToList();
_selectedQuestions.AddRange(items);
template.SelectedQuestions = _selectedQuestions;
Cache.Add(Constants.CacheNames.RegenerateTemplate, template, new CacheItemPolicy());
_wizardPresenter.GenerateNewTemplate(Constants.CacheNames.RegenerateTemplate, Settings.Default.TemplatePrerenewalQuestionare);
}
else
{
// //call presenter to populate
FactFinder tempalte = GenerateTempalteObject();
if (!Reload)
{
_wizardPresenter.PopulateClaimMadeWarningFragment(_populateClaimMadeWarning, Settings.Default.FragmentPRQClaimsMadeWarning);
_wizardPresenter.PopulateApprovalFormFragment(_populateApprovalForm, Settings.Default.FragmentPRQApprovalForm);
CheckedListBox.CheckedItemCollection c = clbQustions.CheckedItems;
var items = c.Cast <IQuestionClass>().ToList();
_wizardPresenter.InsertQuestionnaireFragement(items, Settings.Default.InformationForPolicyFragment);
//_presenter.InsertQuestionnaireFragement(_selectedQuestionnaireFragments);
_wizardPresenter.PopulateImportantNotices(SelectedStatutory, Settings.Default.FragmentStatutory,
Settings.Default.FragmentPrivacy, Settings.Default.FragmentFSG,
Settings.Default.FragmentTermsOfEngagement);
}
PopulateDocument(tempalte, lblCoverPageTitle.Text, lblLogoTitle.Text);
if (!Reload)
{
// //thie information panel loads when a document is in sharePoint that has metadata
// //clients don't wish to see this so force the close of the panel once the wizard completes.
_wizardPresenter.CloseInformationPanel();
_wizardPresenter.MoveToStartOfDocument();
}
//tracking
LogUsage(tempalte,
LoadType == Enums.FormLoadType.RegenerateTemplate
? Enums.UsageTrackingType.RegenerateDocument
: Enums.UsageTrackingType.NewDocument);
}
Close();
}
catch (Exception ex)
{
OnError(ex);
}
finally
{
Cursor = Cursors.Default;
// BasePresenter.SwitchScreenUpdating(true);
}
}
else
{
SwitchTab(tbcWizardScreens.SelectedIndex + 1);
}
}
public static int ReplaceInDataTable(Database dataBase, int sheetIndex, int Column, CheckedListBox.CheckedItemCollection InElements, string OutElement, bool ReplaceAlsoInSourceFile)
{
int Proceed = 0;
List <string> elementList = InElements.Cast <string>().ToList <string>();
if (OutElement == "<пустое значение>")
{
OutElement = String.Empty;
}
if (elementList.Contains("<пустое значение>"))
{
elementList[elementList.IndexOf("<пустое значение>")] = String.Empty;
}
HSSFWorkbook WorkbookXLS = new HSSFWorkbook();
XSSFWorkbook WorkbookXLSX = new XSSFWorkbook();
ISheet currentSheet = null;
FileStream fs = null;
if (ReplaceAlsoInSourceFile && !FileIsAvailable(dataBase.pathOfDatabase))
{
if (MessageBox.Show("Файл открыт в другой программе.\nПродолжить процесс замены в загруженном в программу экземпляре?", "Заменить в программе без сохранения в файле?", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.No)
{
return(0);
}
ReplaceAlsoInSourceFile = false;
}
if (ReplaceAlsoInSourceFile)
{
using (fs = new FileStream(dataBase.pathOfDatabase, FileMode.Open, FileAccess.ReadWrite, FileShare.ReadWrite))
switch (dataBase.TypeOfDB)
{
case Database.DBmode.XLS:
WorkbookXLS = new HSSFWorkbook(fs);
currentSheet = WorkbookXLS.GetSheetAt(sheetIndex);
break;
case Database.DBmode.XLSX:
WorkbookXLSX = new XSSFWorkbook(fs);
currentSheet = WorkbookXLSX.GetSheetAt(sheetIndex);
break;
}
}
for (int row = 0; row < dataBase.listOfTables.Tables[sheetIndex].Rows.Count; row++)
{
if (elementList.Contains(dataBase.listOfTables.Tables[sheetIndex].Rows[row][Column].ToString()))
{
dataBase.listOfTables.Tables[sheetIndex].Rows[row][Column] = OutElement;
if (ReplaceAlsoInSourceFile)
{
currentSheet.GetRow(row + 1).GetCell(Column).SetCellValue(OutElement);
}
Proceed++;
}
Application.DoEvents();
}
dataBase.listOfTables.AcceptChanges();
if (ReplaceAlsoInSourceFile)
{
using (fs = new FileStream(dataBase.pathOfDatabase, FileMode.Open, FileAccess.ReadWrite, FileShare.ReadWrite))
switch (dataBase.TypeOfDB)
{
case Database.DBmode.XLS:
WorkbookXLS.Write(fs);
break;
case Database.DBmode.XLSX:
WorkbookXLSX.Write(fs);
break;
}
fs.Close();
WorkbookXLS = null;
WorkbookXLSX = null;
currentSheet = null;
}
return(Proceed);
}