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