private void LoadData(string royaltorId)
        {
            royContractRoyGroupingBL = new RoyContractRoyGroupingBL();
            DataSet initialData = royContractRoyGroupingBL.GetInitialData(Convert.ToInt32(royaltorId), out errorId);

            royContractRoyGroupingBL = null;

            if (errorId == 2)
            {
                ExceptionHandler("Error in loading data", string.Empty);
                return;
            }

            if (initialData.Tables.Count == 0)
            {
                ExceptionHandler("Error in loading data", string.Empty);
            }
            else
            {
                //Popupate dropdown
                ddlGFSCompany.DataSource     = initialData.Tables[1];
                ddlGFSCompany.DataTextField  = "dropdown_text";
                ddlGFSCompany.DataValueField = "dropdown_value";
                ddlGFSCompany.DataBind();
                ddlGFSCompany.Items.Insert(0, new ListItem("-"));

                //Populate textfields
                PopulateRoyGroupingDetails(initialData.Tables[0]);
            }
        }
        protected void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (hdnIsValidRoyaltorGFS.Value == "N")
                {
                    msgView.SetMessage("Royaltor grouping deatils not saved – nota valid royaltor for 'GFS Grouping Royaltor'!", MessageType.Warning, PositionType.Auto);
                    return;
                }

                if (hdnIsValidRoyaltorSummary.Value == "N")
                {
                    msgView.SetMessage("Royaltor grouping deatils not saved – nota valid royaltor for 'Summary Statements'!", MessageType.Warning, PositionType.Auto);
                    return;
                }

                if (hdnIsValidRoyaltorTXT.Value == "N")
                {
                    msgView.SetMessage("Royaltor grouping deatils not saved – nota valid royaltor for 'TXT Detail Statements'!", MessageType.Warning, PositionType.Auto);
                    return;
                }

                if (txtDSPAnalytics.Text != string.Empty && hdnIsValidRoyaltorDSP.Value == "N")
                {
                    msgView.SetMessage("Royaltor grouping deatils not saved – nota valid royaltor for 'DSP Analytics'!", MessageType.Warning, PositionType.Auto);
                    return;
                }

                loggedUserID = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString());

                string gfsComapny;
                if (ddlGFSCompany.SelectedIndex > 0)
                {
                    gfsComapny = ddlGFSCompany.SelectedValue;
                }
                else
                {
                    gfsComapny = string.Empty;
                }

                if (hdnDataChanged.Value != "Y")
                {
                    if (isNewRoyaltor == "Y")
                    {
                        //WUIN-450
                        //set screen button enabled = Y
                        contractNavigationButtons.SetNewRoyButtonStatus(ContractScreens.ContractGroupings.ToString());

                        ScriptManager.RegisterStartupScript(this, typeof(Page), "NewRoySave", "RedirectOnNewRoyaltorSave(" + royaltorId + ");", true);
                    }
                    else
                    {
                        msgView.SetMessage("No changes made to save!", MessageType.Warning, PositionType.Auto);
                    }

                    return;
                }

                royContractRoyGroupingBL = new RoyContractRoyGroupingBL();
                DataSet updatedData = royContractRoyGroupingBL.UpdateRoyaltorGrouping(Convert.ToInt32(royaltorId), txtSummaryStatements.Text.Split('-')[0], txtTXTDetailStatements.Text.Split('-')[0], txtGFSGroupingRoyaltor.Text.Split('-')[0], txtDSPAnalytics.Text.Split('-')[0], txtGFSLabel.Text, gfsComapny, txtPrintGrp.Text, loggedUserID, out errorId);
                royContractRoyGroupingBL = null;

                if (updatedData.Tables.Count == 0 || errorId == 2)
                {
                    ExceptionHandler("Error in saving data", string.Empty);
                }
                else
                {
                    PopulateRoyGroupingDetails(updatedData.Tables[0]);
                    hdnDataChanged.Value = "N";

                    if (isNewRoyaltor == "Y")
                    {
                        //WUIN-450
                        //set screen button enabled = Y
                        contractNavigationButtons.SetNewRoyButtonStatus(ContractScreens.ContractGroupings.ToString());

                        ScriptManager.RegisterStartupScript(this, typeof(Page), "NewRoySave", "RedirectOnNewRoyaltorSave(" + royaltorId + ");", true);
                    }
                    else
                    {
                        msgView.SetMessage("Royaltor grouping details saved successfully", MessageType.Warning, PositionType.Auto);
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionHandler("Error in saving data.", ex.Message);
            }
        }