protected void CityAddButton_Click(object sender, EventArgs e)
{
try
{
if (CityNameTextBox.Text.Trim().Length == 0)
{
System.Windows.Forms.MessageBox.Show(new System.Windows.Forms.Form {
TopMost = true
}, "Don't accept Space char in your name");
Focus();
}
CPT_CityMaster Citydetails = new CPT_CityMaster();
Citydetails.RegionID = Convert.ToInt32(RegionList.SelectedValue);
Citydetails.CountryID = Convert.ToInt32(CountryList.SelectedValue);
Citydetails.CityName = CityNameTextBox.Text.Trim();
Citydetails.IsActive = true;
CityMasterBL insertCity = new CityMasterBL();
insertCity.Insert(Citydetails);
BindGrid();
CleartextBoxes(this);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
protected void delete(object sender, GridViewDeleteEventArgs e)
{
CPT_CityMaster Citydetails = new CPT_CityMaster();
int id = int.Parse(gvCity.DataKeys[e.RowIndex].Value.ToString());
Citydetails.CityID = id;
CityMasterBL deleteCity = new CityMasterBL();
deleteCity.Delete(Citydetails);
BindGrid();
}
protected void update(object sender, GridViewUpdateEventArgs e)
{
try
{
CPT_CityMaster Citydetails = new CPT_CityMaster();
int id = int.Parse(gvCity.DataKeys[e.RowIndex].Value.ToString());
Citydetails.CityID = id;
string CityName = ((TextBox)gvCity.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
Citydetails.CityName = CityName;
CityMasterBL updateCity = new CityMasterBL();
updateCity.Update(Citydetails);
gvCity.EditIndex = -1;
BindGrid();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void processData(DataTable dt)
{
try
{
List <string> lstAccountName = new List <string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
lstAccountName.Add(dt.Rows[i]["Client"].ToString());
}
lstAccountName = lstAccountName.Distinct().ToList();
List <string> lstRegion = new List <string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
lstRegion.Add(dt.Rows[i]["Region"].ToString());
}
lstRegion = lstRegion.Distinct().ToList();
List <string> lstCountry = new List <string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
lstCountry.Add(dt.Rows[i]["Country"].ToString());
}
lstCountry = lstCountry.Distinct().ToList();
List <string> lstCity = new List <string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
lstCity.Add(dt.Rows[i]["City"].ToString());
}
lstCity = lstCity.Distinct().ToList();
ImportExcelBL account = new ImportExcelBL();
var lstAccount = account.AccountName();
List <string> lstInsertAccount = new List <string>();
lstInsertAccount = lstAccountName.Except(lstAccount).ToList();
var lstRegionName = account.RegionName();
List <string> lstInsertRegion = lstRegion.Except(lstRegionName).ToList();
var lstCountryName = account.CountryName();
List <string> lstInsertCountryName = lstCountry.Except(lstCountryName).ToList();
List <string> lstRegionNAmes = new List <string>();
foreach (var item in lstInsertCountryName)
{
var dt1 = dt.Select("Country = '" + item + "'").CopyToDataTable().DefaultView.ToTable(true, "Region");
lstRegionNAmes.Add(dt1.Rows[0][0].ToString());
}
var lstCityName = account.CityName();
List <string> lstInsertCity = lstCity.Except(lstCityName).ToList();
List <string> lstRegionNameForCity = new List <string>();
List <string> lstCountryNameForCity = new List <string>();
foreach (var item in lstInsertCity)
{
var dt1 = dt.Select("City = '" + item + "'").CopyToDataTable().DefaultView.ToTable(true, "Region");
lstRegionNameForCity.Add(dt1.Rows[0][0].ToString());
var dt2 = dt.Select("City = '" + item + "'").CopyToDataTable().DefaultView.ToTable(true, "Country");
lstCountryNameForCity.Add(dt2.Rows[0][0].ToString());
}
List <string> lstCityNameForAcc = new List <string>();
foreach (var item in lstInsertAccount)
{
var dt1 = dt.Select("Client = '" + item + "'").CopyToDataTable().DefaultView.ToTable(true, "City");
lstCityNameForAcc.Add(dt1.Rows[0][0].ToString());
}
CPT_RegionMaster details = new CPT_RegionMaster();
if (lstInsertRegion.Count > 0)
{
foreach (var item in lstInsertRegion)
{
details.RegionName = item;
details.IsActive = true;
ImportExcelBL.InsertRegion(details);
}
}
CPT_CountryMaster country = new CPT_CountryMaster();
if (lstInsertCountryName.Count > 0)
{
for (int item = 0; item < lstInsertCountryName.Count; item++)
{
country.CountryName = lstInsertCountryName[item];
country.RegionID = ImportExcelBL.getRegionID(lstRegionNAmes)[item];
country.IsActive = true;
ImportExcelBL.InsertCountry(country);
}
}
CPT_CityMaster city = new CPT_CityMaster();
if (lstInsertCity.Count > 0)
{
for (int i = 0; i < lstInsertCity.Count; i++)
{
city.CityName = lstInsertCity[i];
city.RegionID = ImportExcelBL.getRegionID(lstRegionNameForCity)[i];
city.CountryID = ImportExcelBL.getCountryID(lstCountryNameForCity)[i];
city.IsActive = true;
ImportExcelBL.InsertCity(city);
}
}
CPT_AccountMaster accountDetails = new CPT_AccountMaster();
if (lstInsertAccount.Count > 0)
{
for (int i = 0; i < lstInsertAccount.Count; i++)
{
accountDetails.AccountName = lstInsertAccount[i];
accountDetails.CityID = ImportExcelBL.getCityID(lstCityNameForAcc)[i];
accountDetails.IsActive = true;
ImportExcelBL.InsertAccount(accountDetails);
}
}
}
catch (Exception ex)
{
lblShow.ForeColor = Color.Red;
lblShow.Text = ex.Message;
}
}
