private void importAllButton_Click(object sender, EventArgs e) { try { if (login.permission) { var dataToimport = excelData; SqlManipulator sql = new SqlManipulator(); Utility util = new Utility(); foreach (var data in dataToimport) { var convertedData = util.convertYekeQuery(data.ToList()); var query = convertedData.AsQueryable(); ComboboxItem itm = (ComboboxItem)cityComboBox.SelectedItem; long id = itm.Value; sql.excelToSqlCopy(query, id); } } else { var dataToimport = excelData; SqlManipulator sql = new SqlManipulator(); Utility util = new Utility(); foreach (var data in dataToimport) { var convertedData = util.convertYekeQuery(data.ToList()); var query = convertedData.AsQueryable(); sql.excelToSqlCopy(query, login.cityID); } } this.mainForm.refreshDGV(); } catch (Exception ex) { MessageBox.Show(ex.Data.ToString()); } this.Hide(); }
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(); }