private void btnRun_Click(object sender, EventArgs e) { try { TotalColumnList obj = new TotalColumnList(); obj.SheetName = lblSheetName.Text; if (cbxAddress_Line1.SelectedIndex != 0) { obj.Addressline1col = cbxAddress_Line1.SelectedValue.ToString(); } else { obj.Addressline1col = ""; } if (cbxAddressLine_2.SelectedIndex != 0) { obj.AddressLine2col = cbxAddressLine_2.SelectedValue.ToString(); } else { obj.AddressLine2col = ""; } if (cbxzip.SelectedIndex != 0) { obj.Zipcol = cbxzip.SelectedValue.ToString(); } else { obj.Zipcol = ""; } if (cbxState.SelectedIndex != 0) { obj.Statecol = cbxState.SelectedValue.ToString(); } else { obj.Statecol = ""; } if (cbxCity.SelectedIndex != 0) { obj.Citycol = cbxCity.SelectedValue.ToString(); } else { obj.Citycol = ""; } if (cbxHouseNo.SelectedIndex != 0) { obj.Housenocol = cbxHouseNo.SelectedValue.ToString(); } else { obj.Housenocol = ""; } //if (obj.Addressline1col == "") //{ // lblAddress1.Visible = true; // lblAddress1.Text = "Address Required"; // lblAddress1.ForeColor = Color.Red; //} //else if (obj.Zipcol == "") //{ // lblZipCode.Visible = true; // lblZipCode.Text = "Zip Code Required"; // lblZipCode.ForeColor = Color.Red; //} //else //{ FullColumnList.Add(obj); var fileupload = new UploadFile(); fileupload.Show(); this.Hide(); //} } catch (Exception ex) { Logger.Log(ex, null); MessageBox.Show(ex.Message); } }
private void btnNextSheet_Click(object sender, EventArgs e) { try { var SheetNamesList = USPSCleanUp.UploadFile.dtsheetName; if (SheetNamesList.Count <= sheetCount + 1) { TotalColumnList obj = new TotalColumnList(); obj.SheetName = lblSheetName.Text; var first = SheetNamesList[sheetCount].ToString(); lblSheetName.Text = first; if (cbxAddress_Line1.SelectedIndex != 0) { obj.Addressline1col = cbxAddress_Line1.SelectedValue.ToString(); } else { obj.Addressline1col = ""; } if (cbxAddressLine_2.SelectedIndex != 0) { obj.AddressLine2col = cbxAddressLine_2.SelectedValue.ToString(); } else { obj.AddressLine2col = ""; } if (cbxzip.SelectedIndex != 0) { obj.Zipcol = cbxzip.SelectedValue.ToString(); } else { obj.Zipcol = ""; } if (cbxState.SelectedIndex != 0) { obj.Statecol = cbxState.SelectedValue.ToString(); } else { obj.Statecol = ""; } if (cbxCity.SelectedIndex != 0) { obj.Citycol = cbxCity.SelectedValue.ToString(); } else { obj.Citycol = ""; } if (cbxHouseNo.SelectedIndex != 0) { obj.Housenocol = cbxHouseNo.SelectedValue.ToString(); } else { obj.Housenocol = ""; } if (obj.Addressline1col == "") { lblAddress1.Visible = true; lblAddress1.Text = "Address Required"; lblAddress1.ForeColor = Color.Red; } else if (obj.Zipcol == "") { lblZipCode.Visible = true; lblZipCode.Text = "Zip Code Required"; lblZipCode.ForeColor = Color.Red; } USPSCleanUp.UploadFile.ColumnList.Clear(); foreach (DataColumn dc in USPSCleanUp.UploadFile.dt.Tables[first].Columns) { string collist = dc.ToString(); USPSCleanUp.UploadFile.ColumnList.Add(collist); } //var filename = USPSCleanUp.UploadFile.onlyFileName; var ColumnList = USPSCleanUp.UploadFile.ColumnList; ColumnList.Insert(0, "--Select--"); cbxAddress_Line1.DataSource = new BindingSource(ColumnList, null); cbxAddressLine_2.DataSource = new BindingSource(ColumnList, null); cbxzip.DataSource = new BindingSource(ColumnList, null); cbxState.DataSource = new BindingSource(ColumnList, null); cbxCity.DataSource = new BindingSource(ColumnList, null); cbxHouseNo.DataSource = new BindingSource(ColumnList, null); sheetCount += 1; if (sheetCount == SheetNamesList.Count) { if (sheetCount == 2) { btnSkip.Visible = true; } btnRun.Visible = true; btnNextSheet.Visible = false; } else { if (sheetCount == 2) { btnSkip.Visible = true; } btnRun.Visible = false; btnNextSheet.Visible = true; } FullColumnList.Add(obj); } } catch (Exception ex) { Logger.Log(ex, null); MessageBox.Show(ex.Message); } }