private int[] GetColsIdxFor(string StringToBeDetected, FormForImportExcel FromExcel)
{
List<int> Pos = new List<int>();
for (int i = 0; i < FromExcel.dataGridViewForImport.Rows.Count; i++)
{
string CurrentVal = FromExcel.dataGridViewForImport.Rows[i].Cells[2].Value.ToString();
bool IsSelected = (bool)FromExcel.dataGridViewForImport.Rows[i].Cells[1].Value;
if ((CurrentVal == StringToBeDetected) && (IsSelected == true))
Pos.Add(i);
}
return Pos.ToArray();
}
private void LoadingCSVProcedure(FormForImportExcel FromExcel)
{
int Mode = 2;
if (cGlobalInfo.OptionsWindow.radioButtonWellPosModeSingle.Checked) Mode = 1;
CsvFileReader CSVsr = new CsvFileReader(PathNames[0]);
if (!CSVsr.BaseStream.CanRead)
{
MessageBox.Show("Cannot read the file !", "Process finished !", MessageBoxButtons.OK, MessageBoxIcon.Information);
CSVsr.Close();
return;
}
CsvRow Names = new CsvRow();
if (!CSVsr.ReadRow(Names))
{
CSVsr.Close();
return;
}
int ColSelectedForName = GetColIdxFor("Name", FromExcel);
// int ColLocusID = GetColIdxFor("Locus ID", FromExcel);
// int ColConcentration = GetColIdxFor("Concentration", FromExcel);
// int ColInfo = GetColIdxFor("Info", FromExcel);
// int ColClass = GetColIdxFor("Class", FromExcel);
int ColPlateName = GetColIdxFor("Plate name", FromExcel);
int ColCol = GetColIdxFor("Column", FromExcel);
int ColRow = GetColIdxFor("Row", FromExcel);
int ColWellPos = GetColIdxFor("Well position", FromExcel);
int[] ColsForDescriptors = GetColsIdxFor("Descriptor", FromExcel);
while (CSVsr.EndOfStream != true)
{
NEXT: ;
CsvRow CurrentDesc = new CsvRow();
if (CSVsr.ReadRow(CurrentDesc) == false) break;
string PlateName = CurrentDesc[ColPlateName];
//return;
// check if the plate exist already
cPlate CurrentPlate = cGlobalInfo.CurrentScreening.GetPlateIfNameIsContainIn(PlateName);
if (CurrentPlate == null) goto NEXT;
int[] Pos = new int[2];
if (Mode == 1)
{
Pos = ConvertPosition(CurrentDesc[ColWellPos]);
}
else
{
if (!int.TryParse(CurrentDesc[ColCol], out Pos[0]))
{
if (MessageBox.Show("Error in converting the current well position.\nGo to Edit->Options->Import-Export->Well Position Mode to fix this.\nDo you want continue ?", "Loading error !", MessageBoxButtons.YesNo, MessageBoxIcon.Error) == System.Windows.Forms.DialogResult.No)
{
CSVsr.Close();
return;
}
else
goto NEXTLOOP;
}
Pos[1] = Convert.ToInt16(CurrentDesc[ColRow]);
}
cWell CurrentWell = CurrentPlate.GetWell(Pos[0] - 1, Pos[1] - 1, false);
if (CurrentWell == null) goto NEXT;
if (ColSelectedForName != -1)
{
CurrentWell.SetCpdName(CurrentDesc[ColSelectedForName]);
}
else
{
CurrentWell.SetAsNoneSelected();
}
//if (ColLocusID != -1)
//{
// double CurrentValue;
// if (!double.TryParse(CurrentDesc[ColLocusID], out CurrentValue))
// goto NEXTSTEP;
// CurrentWell.LocusID = CurrentValue;
//}
//if (ColConcentration != -1)
//{
// double CurrentValue;
// if (!double.TryParse(CurrentDesc[ColConcentration], out CurrentValue))
// goto NEXTSTEP;
// CurrentWell.Concentration = CurrentValue;
//}
NEXTSTEP: ;
//if (ColInfo != -1)
// CurrentWell.Info = CurrentDesc[ColInfo];
//if (ColClass != -1)
//{
// int CurrentValue;
// if (!int.TryParse(CurrentDesc[ColClass], out CurrentValue))
// goto NEXTLOOP;
// CurrentWell.SetClass(CurrentValue);
//}
NEXTLOOP: ;
}
CSVsr.Close();
cGlobalInfo.CurrentScreening.GetCurrentDisplayPlate().DisplayDistribution(cGlobalInfo.CurrentScreening.ListDescriptors.GetActiveDescriptor(), false);
MessageBox.Show("File loaded", "Process finished !", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
private int GetColIdxFor(string StringToBeDetected, FormForImportExcel FromExcel)
{
int Pos = -1;
for (int i = 0; i < FromExcel.dataGridViewForImport.Rows.Count; i++)
{
string CurrentVal = FromExcel.dataGridViewForImport.Rows[i].Cells[2].Value.ToString();
bool IsSelected = (bool)FromExcel.dataGridViewForImport.Rows[i].Cells[1].Value;
if ((CurrentVal == StringToBeDetected) && (IsSelected == true)) Pos = i;
}
return Pos;
}
private FormForImportExcel CellByCellFromCSV(string FileName, char Delimiter)
{
FormForImportExcel FromExcel = new FormForImportExcel();
FromExcel.IsImportCSV = true;
int Mode = 2;
if (cGlobalInfo.OptionsWindow.radioButtonWellPosModeSingle.Checked) Mode = 1;
CsvFileReader CSVsr = new CsvFileReader(FileName);
CSVsr.Separator = Delimiter;
CsvRow Names = new CsvRow();
if (!CSVsr.ReadRow(Names))
{
CSVsr.Close();
return null;
}
int NumPreview = 4;
List<CsvRow> LCSVRow = new List<CsvRow>();
for (int Idx = 0; Idx < NumPreview; Idx++)
{
CsvRow TNames = new CsvRow();
// if (TNames.Count == 0) break;
if (!CSVsr.ReadRow(TNames))
{
CSVsr.Close();
return null;
}
LCSVRow.Add(TNames);
}
// FromExcel.dataGridViewForImport.RowsDefaultCellStyle.BackColor = Color.Bisque;
FromExcel.dataGridViewForImport.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
DataGridViewColumn ColName = new DataGridViewColumn();
FromExcel.dataGridViewForImport.Columns.Add("Data Name", "Data Name");
DataGridViewCheckBoxColumn columnSelection = new DataGridViewCheckBoxColumn();
columnSelection.Name = "Selection";
FromExcel.dataGridViewForImport.Columns.Add(columnSelection);
DataGridViewComboBoxColumn columnType = new DataGridViewComboBoxColumn();
if (cGlobalInfo.OptionsWindow.radioButtonWellPosModeDouble.Checked)
columnType.DataSource = new string[] { "Plate name", "Column", "Row", "Descriptor", "Phenotype Class" };
else
columnType.DataSource = new string[] { "Plate name", "Well position", "Descriptor", "Phenotype Class" };
columnType.Name = "Type";
FromExcel.dataGridViewForImport.Columns.Add(columnType);
for (int i = 0; i < LCSVRow.Count; i++)
{
DataGridViewColumn NewCol = new DataGridViewColumn();
NewCol.ReadOnly = true;
FromExcel.dataGridViewForImport.Columns.Add("Readout " + i, "Readout " + i);
}
if (LCSVRow[0].Count > Names.Count)
{
CSVsr.Close();
MessageBox.Show("Inconsistent column number. Check your CSV file.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
for (int i = 0; i < Names.Count; i++)
{
int IdxRow = 0;
FromExcel.dataGridViewForImport.Rows.Add();
FromExcel.dataGridViewForImport.Rows[i].Cells[IdxRow++].Value = Names[i];
if (i == 0) FromExcel.dataGridViewForImport.Rows[i].Cells[IdxRow++].Value = true;
else if (i == 1) FromExcel.dataGridViewForImport.Rows[i].Cells[IdxRow++].Value = true;
else if ((i == 2) && (cGlobalInfo.OptionsWindow.radioButtonWellPosModeDouble.Checked)) FromExcel.dataGridViewForImport.Rows[i].Cells[IdxRow++].Value = true;
else FromExcel.dataGridViewForImport.Rows[i].Cells[IdxRow++].Value = false;
if (i == 0)
{
FromExcel.dataGridViewForImport.Rows[i].Cells[IdxRow++].Value = "Plate name";
}
else if (i == 1)
{
if (cGlobalInfo.OptionsWindow.radioButtonWellPosModeDouble.Checked)
{
FromExcel.dataGridViewForImport.Rows[i].Cells[IdxRow++].Value = "Column";
}
else
{
FromExcel.dataGridViewForImport.Rows[i].Cells[IdxRow++].Value = "Well position";
}
}
else if (i == 2)
{
if (cGlobalInfo.OptionsWindow.radioButtonWellPosModeDouble.Checked)
{
FromExcel.dataGridViewForImport.Rows[i].Cells[IdxRow++].Value = "Row";
}
else
FromExcel.dataGridViewForImport.Rows[i].Cells[IdxRow++].Value = "Descriptor";
}
else
{
FromExcel.dataGridViewForImport.Rows[i].Cells[IdxRow++].Value = "Descriptor";
}
for (int j = 0; j < LCSVRow.Count; j++)
{
if (i < LCSVRow[j].Count)
FromExcel.dataGridViewForImport.Rows[i].Cells[IdxRow + j].Value = LCSVRow[j][i].ToString();
else
FromExcel.dataGridViewForImport.Rows[i].Cells[IdxRow + j].Value = "";
}
}
FromExcel.dataGridViewForImport.Update();
// FromExcel.dataGridViewForImport.MouseClick += new System.Windows.Forms.MouseEventHandler(this.dataGridViewForImport_MouseClick);
FromExcel.CurrentScreen = cGlobalInfo.CurrentScreening;
FromExcel.thisHCSAnalyzer = this;
return FromExcel;
}
