//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);
}
}
