private void openButton1_Click(object sender, EventArgs e) { excelMonthscomboBox.Enabled = false; excelDataGridView.Enabled = true; OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.Filter = "Excel Files|*.xlsx"; openFileDialog1.Title = "فایل اکسل را انتخاب نمائید"; if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { ExcelValidationClass valid = new ExcelValidationClass(); var file = openFileDialog1.FileName; path = file; try { // StartProgress(); ExcelManipulatorcs excel = new ExcelManipulatorcs(); try { excelData = excel.getDataFromFile(path); valid = excel.check(excelData, file); } catch (Exception ex) { MessageBox.Show(ex.Message); }; var monthComboBox = excel.getSheetsName(path); if (!setComboBoxData(monthComboBox)) { MessageBox.Show("sheet's name are not correct!"); } excelMonthscomboBox.Enabled = true; importButton1.Enabled = true; excelMonthscomboBox.SelectedIndex = 0; if (valid.isValid) { excelData = excel.ignoreBlanksRow(excelData); makeTable(excelData[0]); excelMonthscomboBox.SelectedIndex = 0; changeColumnName(); // CloseProgress(); } else { Reporter rpt = new Reporter(valid.report, (int)errorImages.info); rpt.Show(); importButton1.Enabled = false; } } catch (Exception a) { MessageBox.Show("خطا در باز کردن فایل. فایل مورد نظر خارج از قالب است! " + a.Message + " "); // CloseProgress(); } } }
private void check(object f) { try { string[] files = (string[])f; if (files == null || files.Length == 0) { MessageBox.Show("هشدار", "فایل را انتخاب کنید", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } ExcelManipulatorcs excel = new ExcelManipulatorcs(); List <string> list = new List <string>(); List <List <string> > t = new List <List <string> >(); foreach (String file in files) { string filenameWithoutPath = Path.GetFileName(file); var validation = excel.check(excel.getDataFromFile(file), filenameWithoutPath); if (!validation.isValid) { t.Add(validation.report); } else { string msg = " فایل سالم است : \n" + filenameWithoutPath; list.Add(msg); } } ; t.Add(list); if (InvokeRequired) { this.Invoke(new Action(() => CreateAndShowForm(t))); return; } } catch (Exception) { MessageBox.Show("جدول خارج از قالب است"); } }
private void importButton1_Click(object sender, EventArgs e) { try { if (refundRadioButton.Checked == false && depositRadioButton.Checked == false) { MessageBox.Show(" لطفا نوع فایل را انتخاب نمایید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } // StartProgress(); if (login.permission) { var dataToimport = excelData[excelMonthscomboBox.SelectedIndex]; SqlManipulator sql = new SqlManipulator(); ExcelManipulatorcs excel = new ExcelManipulatorcs(); var query = excel.dataCorrection(dataToimport); var itm = (ComboboxItem)cityComboBox.SelectedItem; long id = itm.Value; if (this.refundRadioButton.Checked) { var report = sql.refundFromFile(query, id); Reporter rpt = new Reporter(report, Convert.ToInt32(errorImages.info)); rpt.Show(); } if (this.depositRadioButton.Checked) { sql.excelToSqlCopy(query, id); } this.mainForm.refreshDGV(); } else { Utility util = new Utility(); var dataToimport = excelData[excelMonthscomboBox.SelectedIndex]; SqlManipulator sql = new SqlManipulator(); var convertedData = util.convertYekeQuery(dataToimport.ToList()); convertedData = util.convertToRealDate(convertedData); var query = convertedData.AsQueryable(); if (this.refundRadioButton.Checked) { var report = sql.refundFromFile(query, login.cityID); Reporter rpt = new Reporter(report, Convert.ToInt32(errorImages.info)); rpt.Show(); } if (this.depositRadioButton.Checked) { sql.excelToSqlCopy(query, login.cityID); } this.mainForm.refreshDGV(); } excelData.Clear(); this.Hide(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } // CloseProgress(); }