public static void updateLayouts(CheckedListBox.CheckedItemCollection o)
{
//Console.WriteLine(o);
if (o.Contains("Armenian"))
{
armState = true;
}
else
{
armState = false;
}
if (o.Contains("English"))
{
engState = true;
}
else
{
engState = false;
}
}
private void filterMsg(log _log)
{
CheckedListBox.CheckedItemCollection CC = cLB_filter_clients.CheckedItems;
bool showMSG = false;
if (_log.C != null && CC.Contains(_log.C))
{
showMSG = true;
}
else if (_log.F != null && _log.F.client != null && CC.Contains(_log.F.client))
{
showMSG = true;
}
else
{
dbg_counter_no_client++;
}
if (showMSG && !cLB_msgType.GetItemChecked((int)_log.Prio))
{
showMSG = false;
}
if (showMSG)
{
shown_messages++;
ListLogFrontend.Add(_log);
if (AutoScrollonUpdate)
{
dGV_Log.FirstDisplayedScrollingRowIndex = dGV_Log.RowCount - 1;
}
}
else
{
filtered_messages++;
}
label1.Text = "no client: " + dbg_counter_no_client.ToString();
}
public override void FilterPhotos(CheckedListBox.CheckedItemCollection i_CheckedItems)
{
foreach (string year in m_PhotosHolder.m_PhotosByList.Keys)
{
{
if (i_CheckedItems.Contains(year))
{
PhotoFilter.Instance.SetPhotosBy(m_PhotosHolder.m_PhotosByList[year]);
}
}
}
m_PhotosCheckedByUser = PhotoFilter.Instance.GetFilteredPhotos();
}
public override void FilterPhotos(CheckedListBox.CheckedItemCollection i_CheckedItems)
{
m_PhotosCheckedByUser = new List <Photo>();
PhotoFilter.Instance.b_FirstCheck = true;
foreach (string userName in m_PhotosHolder.m_PhotosByList.Keys)
{
if (i_CheckedItems.Contains(userName))
{
PhotoFilter.Instance.SetPhotosBy(m_PhotosHolder.m_PhotosByList[userName]);
}
}
m_PhotosCheckedByUser = PhotoFilter.Instance.GetFilteredPhotos();
}
public static int CorrectColumnRecords(Database dataBase, int sheetIndex, int Column, CheckedListBox.CheckedItemCollection Parameters, bool ReplaceAlsoInSourceFile)
{
int Proceed = 0;
HSSFWorkbook WorkbookXLS = new HSSFWorkbook();
XSSFWorkbook WorkbookXLSX = new XSSFWorkbook();
ISheet currentSheet = null;
FileStream fs = null;
if (!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++)
{
string text = dataBase.listOfTables.Tables[sheetIndex].Rows[row][Column].ToString();
if (Parameters.Contains("Убрать пробелы с концов строки"))
{
text = text.Trim();
}
if (Parameters.Contains("Удалить пробелы из строки"))
{
text = text.Replace(" ", "");
}
if (Parameters.Contains("Сменить регистр записей на верхний"))
{
text = text.ToUpper();
}
if (Parameters.Contains("Сменить регистр записей на нижний"))
{
text = text.ToLower();
}
dataBase.listOfTables.Tables[sheetIndex].Rows[row][Column] = text;
if (ReplaceAlsoInSourceFile)
{
currentSheet.GetRow(row + 1).GetCell(Column).SetCellValue(text);
}
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);
}