private void btnInsert_Click(object sender, EventArgs e)
{
ReadExcel readExcel = new ReadExcel();
readExcel.getExcelData();
if (readExcel.Status == true)
{
lblStatusExcel.Text = "Ati incarcat fisierul " + readExcel.FileName;
btnExcludeExcel.Visible = true;
}
}
private void btnCerere_Click(object sender, EventArgs e)
{
selectedFirstYear = Convert.ToInt32(cbAn1.Text);
selectedSex = cbSex.Text;
selectedcountryCode = countries.Where(x => x.Value == cbCountry.Text).Select(x => x.Key).FirstOrDefault();
RemoveItemsFromLists();
try
{
CreateEntryForPopulationFromFile("population.txt");
populations = populations.OrderBy(x => x.IntAge).ToList();
}
catch (Exception ex)
{
MessageBox.Show("Fisierul populations.txt nu are formatul asteptat sau nu există", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
try
{
CreateEntryForMortalityFromFile("mortality.txt");
mortalitys = mortalitys.OrderBy(x => x.IntAge).ToList();
}
catch (Exception ex)
{
MessageBox.Show("Fisierul mortality.txt nu are formatul asteptat sau nu există", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
try
{
CreateEntryForNewBornsFromFile("newBorns.txt");
}
catch (Exception ex)
{
MessageBox.Show("Fisierul newBoorns.txt nu are formatul asteptat sau nu există", "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
WriteExcel write = new WriteExcel();
write.FileName = GetWrittenSelectedSex() + ", " + countries[selectedcountryCode] + ", " + selectedFirstYear + "-" + (selectedFirstYear + 2).ToString();
try
{
if (populations.Count == 0 && mortalitys.Count == 0 && newBorns.CheckForNoData())
{
throw new Exception();
}
else
{
write.WriteToExcel(populations, mortalitys, newBorns);
DialogResult result = MessageBox.Show(string.Format("Ati creat fesierul {0}!", write.FileName + ".xlsx \r\nDoriti sa il incarcati?"), "Felicitari", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
Form1 master = (Form1)Application.OpenForms["Form1"];
ReadExcel readExcel = new ReadExcel();
readExcel.GetExcelDataAlreadyCreated(write.FileName + ".xlsx");
if (readExcel.Status == true)
{
master.lblStatusExcel.Text = "Ati incarcat fisierul " + readExcel.FileName;
master.btnExcludeExcel.Visible = true;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(string.Format("Fisierul {0} nu s-a putut crea!", write.FileName + ".xlsx"), "Eroare", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
