private void LoadDropdowns()
        {
            optionPeriodLinksBL = new OptionPeriodLinksBL();
            royaltorId          = Convert.ToInt32(txtRoyaltor.Text.Substring(0, txtRoyaltor.Text.IndexOf("-")));
            DataSet optionPeriods = optionPeriodLinksBL.GetOptionPeriods(royaltorId, Convert.ToString(Session["UserRoleId"]), out errorId); //JIRA-898 CHange

            optionPeriodLinksBL = null;
            if (optionPeriods.Tables.Count != 0 && errorId != 2)
            {
                ddlOptionPeriod.DataTextField  = "option_period";
                ddlOptionPeriod.DataValueField = "opd_option";
                ddlOptionPeriod.DataSource     = optionPeriods.Tables[0];
                ddlOptionPeriod.DataBind();
                ddlOptionPeriod.Items.Insert(0, new ListItem("-"));

                if (optionPeriods.Tables[0].Rows.Count == 0)
                {
                    //btnSaveChanges.Enabled = false;
                    msgView.SetMessage("No option period available for the royaltor",
                                       MessageType.Warning, PositionType.Auto);
                }
                else if (optionPeriods.Tables[0].Rows.Count == 1)
                {
                    ddlOptionPeriod.SelectedIndex = 1;
                }
            }
            else if (optionPeriods.Tables.Count == 0 && errorId != 2)
            {
                ddlOptionPeriod.Items.Insert(0, new ListItem("-"));
            }
            else
            {
                ExceptionHandler("Error in loading option period dropdown.", string.Empty);
            }
        }
        private void LoadArtistGridData(string artistName)
        {
            //Populating grid when a artist is searched in artist textbox
            optionPeriodLinksBL = new OptionPeriodLinksBL();
            DataSet linksData = optionPeriodLinksBL.GetArtistLinksData(artistName, out errorId);

            optionPeriodLinksBL = null;
            BindGrids(linksData);
        }
 private void LoadGridData(Int32 royaltorID, Int32 optionPeriodCode)
 {
     //Loading initial grid after selecting a period option from dropdown list
     //Checking whether the grid is empty. If yes then populate the grid.
     if (gvArtistLinks.Rows.Count == 0)
     {
         optionPeriodLinksBL = new OptionPeriodLinksBL();
         DataSet linksData = optionPeriodLinksBL.GetIntialLinksData(royaltorId, optionPeriodCode, out errorId);
         optionPeriodLinksBL = null;
         BindGrids(linksData);
     }
 }
        private void saveChanges()
        {
            optionPeriodLinksBL = new OptionPeriodLinksBL();

            CheckBox cbAddPeriod;
            CheckBox cbRemovePeriod;
            CheckBox cbReplacePeriod;

            string userCode = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString());
            int    artistId;
            int    flag         = 0;
            int    checkedCount = 0;

            List <Int32> addArtistIds     = new List <Int32>();
            List <Int32> removeArtistIds  = new List <Int32>();
            List <Int32> replaceArtistIds = new List <Int32>();

            StringBuilder displayArtistIds = new StringBuilder();

            foreach (GridViewRow gridrow in gvArtistLinks.Rows)
            {
                cbAddPeriod     = (CheckBox)gridrow.FindControl("cbAddLinks");
                cbRemovePeriod  = (CheckBox)gridrow.FindControl("cbRemoveLinks");
                cbReplacePeriod = (CheckBox)gridrow.FindControl("cbReplaceLinks");
                artistId        = Convert.ToInt32(((Label)gridrow.FindControl("lblArtistId")).Text);

                displayArtistIds.Append(artistId + ",");

                if (cbAddPeriod.Checked)
                {
                    addArtistIds.Add(artistId);
                    checkedCount++;
                }
                else if (cbRemovePeriod.Checked & cbReplacePeriod.Checked)
                {
                    flag++;
                    checkedCount++;
                }
                else if (cbRemovePeriod.Checked & cbReplacePeriod.Checked == false)
                {
                    removeArtistIds.Add(artistId);
                    checkedCount++;
                }
                else if (cbReplacePeriod.Checked & cbRemovePeriod.Checked == false)
                {
                    replaceArtistIds.Add(artistId);
                    checkedCount++;
                }
            }

            if (checkedCount > 0)
            {
                if (flag > 0)
                {
                    msgView.SetMessage("Can't check both remove and replace checkboxes in a row",
                                       MessageType.Warning, PositionType.Auto);
                }
                else
                {
                    if (addArtistIds.Count() > 0 || replaceArtistIds.Count() > 0)
                    {
                        if (txtRoyaltor.Text != string.Empty)
                        {
                            if (ddlOptionPeriod.SelectedIndex != 0)
                            {
                                royaltorId       = Convert.ToInt32(txtRoyaltor.Text.Substring(0, txtRoyaltor.Text.IndexOf("-")));
                                optionPeriodCode = Convert.ToInt32(ddlOptionPeriod.SelectedValue);

                                DataSet linksData = optionPeriodLinksBL.OptionPeriodOperations(addArtistIds.ToArray(), removeArtistIds.ToArray(), replaceArtistIds.ToArray(), royaltorId, optionPeriodCode, userCode, displayArtistIds.ToString(), out errorId);
                                optionPeriodLinksBL = null;
                                BindGrids(linksData);

                                hdnChangeNotSaved.Value = "N";
                            }
                            else
                            {
                                msgView.SetMessage("Please select an option period ",
                                                   MessageType.Warning, PositionType.Auto);
                            }
                        }
                        else
                        {
                            msgView.SetMessage("Please select a royaltor and an option period",
                                               MessageType.Warning, PositionType.Auto);
                        }
                    }
                    else
                    {
                        royaltorId       = 0;
                        optionPeriodCode = 0;

                        DataSet linksData = optionPeriodLinksBL.OptionPeriodOperations(addArtistIds.ToArray(), removeArtistIds.ToArray(), replaceArtistIds.ToArray(), royaltorId, optionPeriodCode, userCode, displayArtistIds.ToString(), out errorId);
                        optionPeriodLinksBL = null;
                        BindGrids(linksData);

                        hdnChangeNotSaved.Value = "N";
                    }
                }
            }
            else
            {
                msgView.SetMessage("Please check at least one checkbox",
                                   MessageType.Warning, PositionType.Auto);
            }
            //    }
            //    else
            //    {
            //        msgView.SetMessage("Please select an option period ",
            //                                    MessageType.Warning, PositionType.Auto);
            //    }
            //}
            //else
            //{
            //    msgView.SetMessage("Please select a royaltor",
            //                                    MessageType.Warning, PositionType.Auto);
            //}
        }