protected void delete(object sender, GridViewDeleteEventArgs e)
{
CPT_RegionMaster Regiondetails = new CPT_RegionMaster();
int id = int.Parse(gvRegion.DataKeys[e.RowIndex].Value.ToString());
Regiondetails.RegionMasterID = id;
RegionMasterBL deleteRegion = new RegionMasterBL();
deleteRegion.Delete(Regiondetails);
BindGrid();
}
protected void SaveRegionButton(object sender, EventArgs e)
{
try
{
CPT_RegionMaster Regiondetails = new CPT_RegionMaster();
Regiondetails.RegionName = RegionInput.Text;
Regiondetails.IsActive = true;
RegionMasterBL insertRegion = new RegionMasterBL();
insertRegion.Insert(Regiondetails);
BindGrid();
CleartextBoxes(this);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
protected void update(object sender, GridViewUpdateEventArgs e)
{
try
{
CPT_RegionMaster Regiondetails = new CPT_RegionMaster();
int id = int.Parse(gvRegion.DataKeys[e.RowIndex].Value.ToString());
Regiondetails.RegionMasterID = id;
string RegionName = ((TextBox)gvRegion.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
Regiondetails.RegionName = RegionName;
RegionMasterBL updateRegion = new RegionMasterBL();
updateRegion.Update(Regiondetails);
gvRegion.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;
}
}
