protected void BindInclusionsExclusions()
        {
            Activity_Flavour_Id = new Guid(Request.QueryString["Activity_Flavour_Id"]);
            MDMSVC.DC_Activity_Inclusions_RQ _obj = new MDMSVC.DC_Activity_Inclusions_RQ();
            _obj.Activity_Flavour_Id = Activity_Flavour_Id;
            var result = ActSVC.GetActivityInclusions(_obj);

            if (result != null)
            {
                var resInc = result.Where(w => w.IsInclusion == true).Select(s => s).ToList();
                gvActInclusionSearch.DataSource = resInc;
                gvActInclusionSearch.DataBind();
                lblTotalRecordsInclusions.Text = Convert.ToString(resInc.Count());

                var resExe = result.Where(w => w.IsInclusion == false).Select(s => s).ToList();
                gvActExclusionSearch.DataSource = resExe;
                gvActExclusionSearch.DataBind();
                lblTotalRecordsExclusions.Text = Convert.ToString(resExe.Count());
            }
            else
            {
                gvActInclusionSearch.DataSource = null;
                gvActInclusionSearch.DataBind();
                gvActExclusionSearch.DataSource = null;
                gvActExclusionSearch.DataBind();
            }
        }
        protected void gvActExclusionSearch_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            ResetControls();

            Guid myRow_Id = Guid.Parse(e.CommandArgument.ToString());

            if (e.CommandName.ToString() == "Editing")
            {
                Activity_Flavour_Id = new Guid(Request.QueryString["Activity_Flavour_Id"]);
                MDMSVC.DC_Activity_Inclusions_RQ _obj = new MDMSVC.DC_Activity_Inclusions_RQ();
                _obj.Activity_Flavour_Id    = Activity_Flavour_Id;
                _obj.Activity_Inclusions_Id = myRow_Id;
                var result = ActSVC.GetActivityInclusions(_obj);
                if (result != null)
                {
                    hdnId.Value         = result[0].Activity_Inclusions_Id.ToString();
                    txtDescription.Text = result[0].InclusionDescription;
                    txtName.Text        = result[0].InclusionName;

                    if (result[0].InclusionFrom != null)
                    {
                        txtFrom.Text = (result[0].InclusionFrom ?? DateTime.Now).ToString("dd/MM/yyyy");
                    }

                    if (result[0].InclusionTo != null)
                    {
                        txtTo.Text = (result[0].InclusionTo ?? DateTime.Now).ToString("dd/MM/yyyy");
                    }

                    ddlInclusionFor.ClearSelection();
                    if (ddlInclusionFor.Items.FindByText(result[0].InclusionFor) != null)
                    {
                        ddlInclusionFor.Items.FindByText(result[0].InclusionFor).Selected = true;
                    }

                    ddlInclusionType.ClearSelection();
                    if (ddlInclusionType.Items.FindByText(result[0].InclusionType) != null)
                    {
                        ddlInclusionType.Items.FindByText(result[0].InclusionType).Selected = true;
                    }

                    chkIsInclusion.Checked = result[0].IsInclusion ?? false;

                    btnAdd.Text = "Update";
                }
            }
            else if (e.CommandName.ToString() == "SoftDelete")
            {
                TLGX_Consumer.MDMSVC.DC_Activity_Inclusions newObj = new MDMSVC.DC_Activity_Inclusions
                {
                    Activity_Inclusions_Id = myRow_Id,
                    IsActive  = false,
                    Edit_Date = DateTime.Now,
                    Edit_User = System.Web.HttpContext.Current.User.Identity.Name
                };
                var result = ActSVC.AddUpdateActivityInclusions(newObj);
                BootstrapAlert.BootstrapAlertMessage(dvMsg, result.StatusMessage, (BootstrapAlertType)result.StatusCode);
                BindInclusionsExclusions();
            }

            else if (e.CommandName.ToString() == "UnDelete")
            {
                TLGX_Consumer.MDMSVC.DC_Activity_Inclusions newObj = new MDMSVC.DC_Activity_Inclusions
                {
                    Activity_Inclusions_Id = myRow_Id,
                    IsActive  = true,
                    Edit_Date = DateTime.Now,
                    Edit_User = System.Web.HttpContext.Current.User.Identity.Name
                };
                var result = ActSVC.AddUpdateActivityInclusions(newObj);
                BootstrapAlert.BootstrapAlertMessage(dvMsg, result.StatusMessage, (BootstrapAlertType)result.StatusCode);
                BindInclusionsExclusions();
            }
        }