private void LoadSalesTypeList()
        {
            salesTypeSearchBL = new SalesTypeSearchBL();
            DataSet salesTypeData = salesTypeSearchBL.GetInitialData(out errorId);

            salesTypeSearchBL = null;

            if (salesTypeData.Tables.Count != 0 && errorId != 2)
            {
                ddlSalesTypeType.DataSource     = salesTypeData.Tables[1];
                ddlSalesTypeType.DataTextField  = "price_description";
                ddlSalesTypeType.DataValueField = "price_type";
                ddlSalesTypeType.DataBind();
                ddlSalesTypeType.Items.Insert(0, new ListItem("-"));

                ddlGridSalesTypeType.DataSource     = salesTypeData.Tables[1];
                ddlGridSalesTypeType.DataTextField  = "price_description";
                ddlGridSalesTypeType.DataValueField = "price_type";
                ddlGridSalesTypeType.DataBind();
                ddlGridSalesTypeType.Items.Insert(0, new ListItem("-"));
            }
            else if (salesTypeData.Tables.Count == 0 && errorId != 2)
            {
                Session["FuzzySearchPriceGroupListTypeC"] = null;
            }
            else
            {
                ExceptionHandler("Error in loading Sales Type", string.Empty);
            }
        }
        private void SalesTypeSelected()
        {
            salesTypeSearchBL = new SalesTypeSearchBL();
            DataSet salesTypeData = salesTypeSearchBL.GetSalesTypeData(txtSalestypeSearch.Text.Split('-')[0].ToString().Trim(), out errorId);

            salesTypeSearchBL = null;

            BindGrids(salesTypeData);

            tdGrid.Visible = true;
        }
        protected void BtnAddSalesType_Click(object sender, EventArgs e)
        {
            try
            {
                Page.Validate("valAddSalesTypeGroup");
                if (!Page.IsValid)
                {
                    mpeAddSalesTypeCode.Show();
                }
                else
                {
                    string userCode          = Convert.ToString(Session["UserCode"]);
                    string escalationProrata = txtEscalationProrata.Text == string.Empty ? "1" : txtEscalationProrata.Text;

                    salesTypeSearchBL = new SalesTypeSearchBL();
                    DataSet dtSalesTypeList = salesTypeSearchBL.SaveSalesTypeGroup("I", txtSalesTypeCode.Text.ToUpper(), txtSalesTypeName.Text.ToUpper(), ddlSalesTypeType.SelectedValue, escalationProrata, userCode, out errorId);
                    salesTypeSearchBL = null;

                    if (dtSalesTypeList.Tables.Count > 0 && errorId == 0)
                    {
                        Session["FuzzySearchPriceGroupListTypeC"] = dtSalesTypeList.Tables[0];
                        msgView.SetMessage("Sales type added successfully.", MessageType.Warning, PositionType.Auto);
                        mpeAddSalesTypeCode.Hide();
                        txtSalesTypeCode.Text     = "";
                        txtSalesTypeName.Text     = "";
                        ddlSalesTypeType.Text     = "-";
                        txtEscalationProrata.Text = "";
                    }
                    else if (errorId == 1)
                    {
                        msgView.SetMessage("Sales type already exists.", MessageType.Warning, PositionType.Auto);
                        mpeAddSalesTypeCode.Show();
                    }
                    else
                    {
                        ExceptionHandler("Error in adding the new Sales type.", "");
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler("Error in adding the new sales type code.", ex.Message);
            }
        }
        protected void imgBtnSalesTypeUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                string userCode = Convert.ToString(Session["UserCode"]);

                Page.Validate("valUpdateSalesTypeGroup");
                if (!Page.IsValid)
                {
                    return;
                }

                salesTypeSearchBL = new SalesTypeSearchBL();
                DataSet dtSalesTypeList = salesTypeSearchBL.SaveSalesTypeGroup("U", lblSalesTypeCode.Text.ToUpper(), txtGridSalesTypeName.Text.ToUpper(), ddlGridSalesTypeType.SelectedValue, txtGridEscalationProrata.Text, userCode, out errorId);
                salesTypeSearchBL = null;

                if (dtSalesTypeList.Tables.Count != 0 && errorId != 2)
                {
                    Session["FuzzySearchPriceGroupListTypeC"] = dtSalesTypeList.Tables[0];

                    DataTable dtSalesTypeDtls = dtSalesTypeList.Tables[1];
                    lblSalesTypeCode.Text          = dtSalesTypeDtls.Rows[0]["price_group_code"].ToString();
                    hdnGridSalesTypeName.Value     = txtGridSalesTypeName.Text = dtSalesTypeDtls.Rows[0]["price_name"].ToString();
                    hdnGridSalesTypeType.Value     = ddlGridSalesTypeType.SelectedValue = dtSalesTypeDtls.Rows[0]["price_type"].ToString();
                    hdnGridEscalationProrata.Value = txtGridEscalationProrata.Text = dtSalesTypeDtls.Rows[0]["escalation_prorata"].ToString();

                    msgView.SetMessage("Sales type updated successfully.", MessageType.Warning, PositionType.Auto);
                }
                else
                {
                    msgView.SetMessage("Failed to update Sales type.", MessageType.Warning, PositionType.Auto);
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler("Error in updating Sales type.", ex.Message);
            }
        }