//JIRA-746 CHanges by Ravi on 05/03/2019 -- End #endregion EVENTS #region METHODS private void LoadTerritoryList() { territorySearchBL = new TerritorySearchBL(); DataSet territoriesList = territorySearchBL.GetInitialData(out errorId); territorySearchBL = null; if (territoriesList.Tables.Count != 0 && errorId != 2) { Session["FuzzyTerritorySearchSellerGrpList"] = territoriesList.Tables[0]; Session["TerritoyrSearhCountryList"] = territoriesList.Tables[2]; ddlTerritoryType.DataSource = territoriesList.Tables[1]; ddlTerritoryType.DataTextField = "territory_description"; ddlTerritoryType.DataValueField = "territory_type"; ddlTerritoryType.DataBind(); ddlTerritoryType.Items.Insert(0, new ListItem("-")); ddlGridTerritoryType.DataSource = territoriesList.Tables[1]; ddlGridTerritoryType.DataTextField = "territory_description"; ddlGridTerritoryType.DataValueField = "territory_type"; ddlGridTerritoryType.DataBind(); ddlGridTerritoryType.Items.Insert(0, new ListItem("-")); } else if (territoriesList.Tables.Count == 0 && errorId != 2) { Session["FuzzyTerritorySearchSellerGrpList"] = null; } else { ExceptionHandler("Error in loading territories", string.Empty); } }
protected void btnAdd_Click(object sender, EventArgs e) { try { string territoryCode; //changes maded by Harish - 27-10-16 //if (!string.IsNullOrWhiteSpace(txtNewTerritory.Text) & !string.IsNullOrWhiteSpace(txtNewTerritoryLoc.Text)) if (string.IsNullOrWhiteSpace(txtNewTerritory.Text) & string.IsNullOrWhiteSpace(txtNewTerritoryLoc.Text)) { msgView.SetMessage("Please select a territory to add to the groups", MessageType.Warning, PositionType.Auto); } else { if (!string.IsNullOrWhiteSpace(txtNewTerritory.Text)) { territoryCode = txtNewTerritory.Text.Substring(0, txtNewTerritory.Text.IndexOf("-") - 1); } else { territoryCode = txtNewTerritoryLoc.Text.Substring(0, txtNewTerritoryLoc.Text.IndexOf("-") - 1); } string territoryGroupCode; List <string> territoryGroupCodes = new List <string>(); foreach (GridViewRow gridrow in gvTerritoryGroup.Rows) { territoryGroupCode = (gridrow.FindControl("lblTerritoryGroupCode") as Label).Text; territoryGroupCodes.Add(territoryGroupCode); } if (territoryGroupCodes.Count > 0) { string userCode = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString()); territorySearchBL = new TerritorySearchBL(); territorySearchBL.AddTerritoryToGroups(territoryCode, territoryGroupCodes.ToArray(), userCode, out errorId); territorySearchBL = null; if (errorId == 0) { msgView.SetMessage("New territory has been added to the groups", MessageType.Warning, PositionType.Auto); } else { ExceptionHandler("Error in adding the territory to groups.", ""); } } } mpeInsertGroup.Show(); } catch (Exception ex) { ExceptionHandler("Error in adding the territory to groups.", ex.Message); } }
private void LoadGridData(string territoryCode) { territorySearchBL = new TerritorySearchBL(); DataSet territoryData = territorySearchBL.GetTerritoryData(territoryCode, out errorId); territorySearchBL = null; BindGrids(territoryData); }
protected void btnAddTerritory_Click(object sender, EventArgs e) { try { Page.Validate("valAddTerritoryGroup"); if (!Page.IsValid) { mpeAddTerritoryCode.Show(); } else { string userCode = Convert.ToString(Session["UserCode"]); territorySearchBL = new TerritorySearchBL(); DataSet dtTerritoryList = territorySearchBL.InsertUpdateTerritoryGroup("I", txtTerritoryCode.Text.ToUpper(), txtTerritoryName.Text.ToUpper(), txtTerritoryLocation.Text.ToUpper(), txtCountryCode.Text.ToUpper(), ddlTerritoryType.SelectedValue, userCode, out errorId); territorySearchBL = null; if (dtTerritoryList.Tables.Count > 0 && errorId == 0) { Session["FuzzyTerritorySearchSellerGrpList"] = dtTerritoryList.Tables[0]; msgView.SetMessage("Territory code added successfully.", MessageType.Warning, PositionType.Auto); mpeAddTerritoryCode.Hide(); txtTerritoryCode.Text = ""; txtTerritoryName.Text = ""; txtTerritoryLocation.Text = ""; txtCountryCode.Text = ""; ddlTerritoryType.SelectedIndex = 0; } else if (errorId == 1) { msgView.SetMessage("Territory code already exists.", MessageType.Warning, PositionType.Auto); mpeAddTerritoryCode.Show(); } else { ExceptionHandler("Error in adding the new territory code.", ""); } } } catch (Exception ex) { ExceptionHandler("Error in adding the new territory code.", ex.Message); } }
protected void imgBtnTerritoryUpdate_Click(object sender, EventArgs e) { try { string userCode = Convert.ToString(Session["UserCode"]); Page.Validate("valUpdateTerritoryGroup"); if (!Page.IsValid) { return; } territorySearchBL = new TerritorySearchBL(); DataSet dtTerritoryList = territorySearchBL.InsertUpdateTerritoryGroup("U", lblTerritoryCode.Text.ToUpper(), txtGridTerritoryName.Text.ToUpper(), txtGridTerritoryLocation.Text.ToUpper(), txtGridCountryCode.Text.ToUpper(), ddlGridTerritoryType.SelectedValue, userCode, out errorId); territorySearchBL = null; if (dtTerritoryList.Tables.Count != 0 && errorId != 2) { Session["FuzzyTerritorySearchSellerGrpList"] = dtTerritoryList.Tables[0]; DataTable dtTerritoryDtls = dtTerritoryList.Tables[1]; lblTerritoryCode.Text = dtTerritoryDtls.Rows[0]["seller_code"].ToString(); hdnGridTerritoryName.Value = txtGridTerritoryName.Text = dtTerritoryDtls.Rows[0]["seller_name"].ToString(); hdnGridTerritoryLocation.Value = txtGridTerritoryLocation.Text = dtTerritoryDtls.Rows[0]["seller_location"].ToString(); hdnGridCountryCode.Value = txtGridCountryCode.Text = dtTerritoryDtls.Rows[0]["country_code"].ToString(); hdnGridTerritoryType.Value = ddlGridTerritoryType.SelectedValue = dtTerritoryDtls.Rows[0]["territory_type"].ToString(); msgView.SetMessage("Territory code updated successfully.", MessageType.Warning, PositionType.Auto); } else { msgView.SetMessage("Failed to update territory code.", MessageType.Warning, PositionType.Auto); } } catch (Exception ex) { ExceptionHandler("Error in updating territory code.", ex.Message); } }