protected void CountryAddButton_Click(object sender, EventArgs e) { try { if (CountryNameTextBox.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_CountryMaster Countrydetails = new CPT_CountryMaster(); Countrydetails.RegionID = Convert.ToInt32(RegionList.SelectedValue); Countrydetails.CountryName = CountryNameTextBox.Text.Trim(); Countrydetails.IsActive = true; CountryMasterBL insertCountry = new CountryMasterBL(); insertCountry.Insert(Countrydetails); BindGrid(); CleartextBoxes(this); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
protected void delete(object sender, GridViewDeleteEventArgs e) { CPT_CountryMaster Countrydetails = new CPT_CountryMaster(); int id = int.Parse(gvCountry.DataKeys[e.RowIndex].Value.ToString()); Countrydetails.CountryMasterID = id; CountryMasterBL deleteCountry = new CountryMasterBL(); deleteCountry.Delete(Countrydetails); BindGrid(); }
protected void update(object sender, GridViewUpdateEventArgs e) { try { CPT_CountryMaster Countrydetails = new CPT_CountryMaster(); int id = int.Parse(gvCountry.DataKeys[e.RowIndex].Value.ToString()); Countrydetails.CountryMasterID = id; string CountryName = ((TextBox)gvCountry.Rows[e.RowIndex].Cells[2].Controls[0]).Text; Countrydetails.CountryName = CountryName; CountryMasterBL updateCountry = new CountryMasterBL(); updateCountry.Update(Countrydetails); gvCountry.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; } }