private void radioButton1_Form2_Space_CheckedChanged(object sender, EventArgs e)
{
delimiterF2 = ' ';
if (Form1.dataExport)
{
if (Form1.dataLoaded)
{
dataGridView1_Form2.DataSource = DataHandler.dtToListStr(Form1.dtTarget.AsEnumerable().Take(numberOfRows).CopyToDataTable(), delimiterF2, qualifierF2).ConvertAll(x => new { Value = x });
}
else
{
dataGridView1_Form2.DataSource = DataHandler.dtToListStr(Form1.dt.AsEnumerable().Take(numberOfRows).CopyToDataTable(), delimiterF2, qualifierF2).ConvertAll(x => new { Value = x });
}
}
else
{
temp_dt = DataHandler.FlatToDt(fileWithPathF2, delimiterF2, numberOfRows);
dataGridView1_Form2.DataSource = temp_dt;
}
}
private void textBox2_Form2_qualifier_TextChanged(object sender, EventArgs e)
{
qualifierF2 = checkBox1_Form2_qualifier.Checked == true ? textBox2_Form2_qualifier.Text : "";
if (Form1.dataExport)
{
if (Form1.dataLoaded)
{
dataGridView1_Form2.DataSource = DataHandler.dtToListStr(Form1.dtTarget.AsEnumerable().Take(numberOfRows).CopyToDataTable(), delimiterF2, qualifierF2).ConvertAll(x => new { Value = x });
}
else
{
dataGridView1_Form2.DataSource = DataHandler.dtToListStr(Form1.dt.AsEnumerable().Take(numberOfRows).CopyToDataTable(), delimiterF2, qualifierF2).ConvertAll(x => new { Value = x });
}
}
else
{
temp_dt = DataHandler.FlatToDt(fileWithPathF2, delimiterF2, numberOfRows);
dataGridView1_Form2.DataSource = temp_dt;
}
}
private void button1_Form1_import_Click(object sender, EventArgs e)
{
try
{
if (File.Exists(fileWithPath))
{
form2 = new Form2();
form2.ShowDialog();
}
else
{
MessageBox.Show("Please select a file");
}
if (Form2.dataOk)
{
delimiterF1 = Form2.delimiterF2;
dt = DataHandler.FlatToDt(fileWithPath, delimiterF1);
DataTable dtFirst50 = dt.AsEnumerable().Take(50).CopyToDataTable();
//DATA SOURCES TO GRID AND COMBOBOXES
dataGridView1.Columns.Clear();
dataGridView1.DataSource = dtFirst50;
foreach (Control tab in tabControl1.TabPages)
{
TabPage tabPage = (TabPage)tab;
//COMMITED GIVING
if (tabPage.Name == "CG_tabPage1")
{
foreach (Control group in tabPage.Controls)
{
foreach (Control item in group.Controls)
{
if (item.GetType().Name == "ComboBox")
{
ComboBox comboBox = (ComboBox)item;
if (item.Name == "comboBox1_CG_ClientName")
{
comboBox.BindingContext = new BindingContext();
comboBox.DataSource = new BindingSource(DataHandler.CharityNamesPairs(), null);
comboBox.DisplayMember = "Value";
comboBox.ValueMember = "Key";
}
else
{
comboBox.BindingContext = new BindingContext();
comboBox.DataSource = DataHandler.colNamesArray(dtFirst50, true);
}
}
}
}
comboBox1_CG_duplicates.DataSource = DataHandler.colNamesArray(DataTableFactory.DtScheme(tabPage.Name), true);
}
}
//DEFAULT VALUES
textBox3_CG_Primkey.Text = DateTime.Now.ToString("ddMMyyyy");
textBox1_CG_AddedDateTime.Text = DateTime.Now.ToString("dd/MM/yyyy");
textBox1_CG_AddedBy.Text = "Admin";
textBox1_CG_Primkey.Text = "";
label2_CG_RowsImported.Text = dt.Rows.Count.ToString();
radioButton1_CG_RecordTypeWarm.Checked = true;
//GLOBAL VALUES
fileWithPath = null;
textBox1_Form1_filePath.Text = fileWithPath;
Form2.fileWithPathF2 = null;
dataLoaded = false;
Form2.dataOk = false;
label2_CG_RowsImported.Text = dt.Rows.Count.ToString();
label2_CG_RowsLoaded.Text = "0";
label2_CG_RowsDeleted.Text = "0";
}
}
catch (System.InvalidOperationException)
{
MessageBox.Show("The file you try to import does not contain any rows");
}
catch (Exception)
{
MessageBox.Show("There is an issue with your file");
}
}