//JIRA-908 Changes by Ravi in 13/02/2019 -- Start protected void btnYes_Click(object sender, EventArgs e) { try { string breakdownGroupCode = Convert.ToString(hdnDeleteBreakDownGrpCode.Value); breakdownGroupMaintenanceBL = new BreakdownGroupMaintenanceBL(); DataSet updatedData = breakdownGroupMaintenanceBL.DeleteBreakdownGroupData(breakdownGroupCode, out errorId); breakdownGroupMaintenanceBL = null; if (updatedData.Tables.Count != 0 && errorId == 0) { Session["BreakdownGroupData"] = updatedData.Tables[0]; txtBreakdownGroupSearch.Text = string.Empty; hdnSearchText.Value = null; PopulateGrid(); hdnChangeNotSaved.Value = "N"; hdnGridRowSelectedPrvious.Value = null; msgView.SetMessage("Breakdown group deleted successfully.", MessageType.Success, PositionType.Auto); hdnDeleteBreakDownGrpCode.Value = ""; } else { msgView.SetMessage("Failed to delete breakdown group.", MessageType.Warning, PositionType.Auto); } } catch (Exception ex) { ExceptionHandler("Failed to delete breakdown group.", ex.Message); } }
private void InsertBreakdownGroup() { Page.Validate("valInsertBreakdownGroup"); if (!Page.IsValid) { msgView.SetMessage("Breakdown group details not saved – invalid or missing data!", MessageType.Warning, PositionType.Auto); return; } string userCode = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString()); breakdownGroupMaintenanceBL = new BreakdownGroupMaintenanceBL(); DataSet updatedData = breakdownGroupMaintenanceBL.InsertBreakdownGroupData(txtBreakdownGroupCodeInsert.Text.Trim(), txtBreakdownGroupDescInsert.Text.Trim(), ddlTerritoryInsert.SelectedValue, ddlConfigurationInsert.SelectedValue, ddlSalesTypeInsert.SelectedValue, txtGFSPLAccountInsert.Text.Trim(), txtGFSBLAccountInsert.Text.Trim(), userCode, out errorId); breakdownGroupMaintenanceBL = null; if (errorId == 1) { msgView.SetMessage("Breakdown group exists with this group code.", MessageType.Success, PositionType.Auto); } else if (updatedData.Tables.Count != 0 && errorId != 2) { Session["BreakdownGroupData"] = updatedData.Tables[0]; txtBreakdownGroupSearch.Text = string.Empty; hdnSearchText.Value = null; PopulateGrid(); txtBreakdownGroupCodeInsert.Text = string.Empty; txtBreakdownGroupDescInsert.Text = string.Empty; ddlTerritoryInsert.SelectedIndex = 0; ddlConfigurationInsert.SelectedIndex = 0; ddlSalesTypeInsert.SelectedIndex = 0; txtGFSPLAccountInsert.Text = string.Empty; txtGFSBLAccountInsert.Text = string.Empty; hdnChangeNotSaved.Value = "N"; hdnInsertDataNotSaved.Value = "N"; hdnGridRowSelectedPrvious.Value = null; msgView.SetMessage("Breakdown group created successfully.", MessageType.Success, PositionType.Auto); } else { msgView.SetMessage("Failed to create breakdown group.", MessageType.Warning, PositionType.Auto); } }
private void UpdateBreakdownGroup() { string userCode = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString()); if (!string.IsNullOrEmpty(hdnGridRowSelectedPrvious.Value)) { int rowIndex = Convert.ToInt32(hdnGridRowSelectedPrvious.Value); Page.Validate("GroupUpdate_" + rowIndex + ""); if (!Page.IsValid) { msgView.SetMessage("Breakdown group details not saved – invalid or missing data!", MessageType.Warning, PositionType.Auto); return; } //int rowIndex = ((GridViewRow)((ImageButton)(e.CommandSource)).NamingContainer).RowIndex; string breakdownGroupCode = ((Label)gvBreakdownGroupDetails.Rows[rowIndex].FindControl("lblBreakdownGroupCode")).Text; string breakdownGroupDesc = ((TextBox)gvBreakdownGroupDetails.Rows[rowIndex].FindControl("txtBreakdownGroupDesc")).Text; string territory = ((DropDownList)gvBreakdownGroupDetails.Rows[rowIndex].FindControl("ddlTerritory")).SelectedValue; string configuration = ((DropDownList)gvBreakdownGroupDetails.Rows[rowIndex].FindControl("ddlConfiguration")).SelectedValue; string salesType = ((DropDownList)gvBreakdownGroupDetails.Rows[rowIndex].FindControl("ddlSalesType")).SelectedValue; string GFSPLAccount = ((TextBox)gvBreakdownGroupDetails.Rows[rowIndex].FindControl("txtGFSPLAccount")).Text; string GFSBLAccount = ((TextBox)gvBreakdownGroupDetails.Rows[rowIndex].FindControl("txtGFSBLAccount")).Text; breakdownGroupMaintenanceBL = new BreakdownGroupMaintenanceBL(); DataSet updatedData = breakdownGroupMaintenanceBL.UpdateBreakdownGroupData(breakdownGroupCode, breakdownGroupDesc, territory, configuration, salesType, GFSPLAccount, GFSBLAccount, userCode, out errorId); breakdownGroupMaintenanceBL = null; if (updatedData.Tables.Count != 0 && errorId != 2) { Session["BreakdownGroupData"] = updatedData.Tables[0]; PopulateGrid(); hdnChangeNotSaved.Value = "N"; hdnGridRowSelectedPrvious.Value = null; msgView.SetMessage("Breakdown group details saved successfully.", MessageType.Success, PositionType.Auto); } else { msgView.SetMessage("Failed to save breakdown group details.", MessageType.Warning, PositionType.Auto); } } }
private void LoadData() { breakdownGroupMaintenanceBL = new BreakdownGroupMaintenanceBL(); DataSet initialData = breakdownGroupMaintenanceBL.GetInitialData(out errorId); breakdownGroupMaintenanceBL = null; if (initialData.Tables.Count != 0 && errorId != 2) { Session["BreakdownGroupData"] = initialData.Tables[0]; Session["BGTerritoryList"] = initialData.Tables[1]; Session["BGConfigurationList"] = initialData.Tables[2]; Session["BGSalesTypeList"] = initialData.Tables[3]; BindGrid(initialData.Tables[0]); ddlTerritoryInsert.DataSource = initialData.Tables[1]; ddlTerritoryInsert.DataTextField = "seller_name"; ddlTerritoryInsert.DataValueField = "seller_group_code"; ddlTerritoryInsert.DataBind(); ddlTerritoryInsert.Items.Insert(0, new ListItem("-")); ddlConfigurationInsert.DataSource = initialData.Tables[2]; ddlConfigurationInsert.DataTextField = "config_name"; ddlConfigurationInsert.DataValueField = "config_group_code"; ddlConfigurationInsert.DataBind(); ddlConfigurationInsert.Items.Insert(0, new ListItem("-")); ddlSalesTypeInsert.DataSource = initialData.Tables[3]; ddlSalesTypeInsert.DataTextField = "price_name"; ddlSalesTypeInsert.DataValueField = "price_group_code"; ddlSalesTypeInsert.DataBind(); ddlSalesTypeInsert.Items.Insert(0, new ListItem("-")); } else { ExceptionHandler("Error in fetching data", string.Empty); } }