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); } }