protected void delete(object sender, GridViewDeleteEventArgs e) { CPT_AccountMaster accountdetails = new CPT_AccountMaster(); int id = int.Parse(gvAccount.DataKeys[e.RowIndex].Value.ToString()); accountdetails.AccountMasterID = id; AccountMasterBL deleteAccount = new AccountMasterBL(); deleteAccount.Delete(accountdetails); BindGrid(); }
protected void update(object sender, GridViewUpdateEventArgs e) { try { CPT_AccountMaster accountdetails = new CPT_AccountMaster(); int id = int.Parse(gvAccount.DataKeys[e.RowIndex].Value.ToString()); accountdetails.AccountMasterID = id; string accountName = ((TextBox)gvAccount.Rows[e.RowIndex].Cells[2].Controls[0]).Text; accountdetails.AccountName = accountName; AccountMasterBL updateAccount = new AccountMasterBL(); updateAccount.Update(accountdetails); gvAccount.EditIndex = -1; BindGrid(); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
protected void AccountAddButton_Click(object sender, EventArgs e) { try { //if (AccountNameTextBox.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_AccountMaster accountdetails = new CPT_AccountMaster(); accountdetails.CityID = Convert.ToInt32(CityList.SelectedValue); accountdetails.AccountName = AccountNameTextBox.Text.Trim(); accountdetails.IsActive = true; AccountMasterBL insertAccount = new AccountMasterBL(); insertAccount.Insert(accountdetails); BindGrid(); CleartextBoxes(this); } 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; } }