private void LoadConfigTypeList()
        {
            configurationSearchBL = new ConfigurationSearchBL();
            DataSet configTypeData = configurationSearchBL.GetInitialData(out errorId);

            configurationSearchBL = null;

            if (configTypeData.Tables.Count != 0 && errorId != 2)
            {
                ddlConfigType.DataSource     = configTypeData.Tables[1];
                ddlConfigType.DataTextField  = "config_type_desc";
                ddlConfigType.DataValueField = "config_type";
                ddlConfigType.DataBind();
                ddlConfigType.Items.Insert(0, new ListItem("-"));

                ddlGridConfigType.DataSource     = configTypeData.Tables[1];
                ddlGridConfigType.DataTextField  = "config_type_desc";
                ddlGridConfigType.DataValueField = "config_type";
                ddlGridConfigType.DataBind();
                ddlGridConfigType.Items.Insert(0, new ListItem("-"));
            }
            else if (configTypeData.Tables.Count == 0 && errorId != 2)
            {
                Session["FuzzySearchConfigGroupListTypeC"] = null;
            }
            else
            {
                ExceptionHandler("Error in loading Configuration Type", string.Empty);
            }
        }
        private void LoadGridData(string configurationCode)
        {
            configurationSearchBL = new ConfigurationSearchBL();
            DataSet configurationList = configurationSearchBL.GetConfigurationData(configurationCode, out errorId);

            configurationSearchBL = null;

            BindGrids(configurationList);
        }
        protected void BtnAddConfigType_Click(object sender, EventArgs e)
        {
            try
            {
                Page.Validate("valAddConfigTypeGroup");
                if (!Page.IsValid)
                {
                    mpeAddConfigTypeCode.Show();
                }
                else
                {
                    string userCode = Convert.ToString(Session["UserCode"]);

                    configurationSearchBL = new ConfigurationSearchBL();
                    DataSet dtConfigTypeList = configurationSearchBL.SaveConfigGroup("I", txtConfigTypeCode.Text.ToUpper(), txtConfigTypeName.Text.ToUpper(), ddlConfigType.SelectedValue, userCode, out errorId);
                    configurationSearchBL = null;

                    if (dtConfigTypeList.Tables.Count > 0 && errorId == 0)
                    {
                        Session["FuzzySearchConfigGroupListTypeC"] = dtConfigTypeList.Tables[0];
                        msgView.SetMessage("Configuration added successfully.", MessageType.Warning, PositionType.Auto);
                        mpeAddConfigTypeCode.Hide();
                        txtConfigTypeCode.Text = "";
                        txtConfigTypeName.Text = "";
                        ddlConfigType.Text     = "-";
                    }
                    else if (errorId == 1)
                    {
                        msgView.SetMessage("Configuration already exists.", MessageType.Warning, PositionType.Auto);
                        mpeAddConfigTypeCode.Show();
                    }
                    else
                    {
                        ExceptionHandler("Error in adding the new Configuration.", "");
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler("Error in adding the new Configuration.", ex.Message);
            }
        }
        protected void imgBtnConfigUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                string userCode = Convert.ToString(Session["UserCode"]);

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

                configurationSearchBL = new ConfigurationSearchBL();
                DataSet dtConfigTypeList = configurationSearchBL.SaveConfigGroup("U", lblConfigTypeCode.Text.ToUpper(), txtGridConfigTypeName.Text.ToUpper(), ddlGridConfigType.SelectedValue, userCode, out errorId);
                configurationSearchBL = null;

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

                    DataTable dtConfigDtls = dtConfigTypeList.Tables[1];
                    lblConfigTypeCode.Text      = dtConfigDtls.Rows[0]["config_code"].ToString();
                    hdnGridConfigTypeName.Value = txtGridConfigTypeName.Text = dtConfigDtls.Rows[0]["config_name"].ToString();
                    hdnGridConfigType.Value     = ddlGridConfigType.SelectedValue = dtConfigDtls.Rows[0]["config_type"].ToString();

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