예제 #1
0
    public override void ChangeDataSetAfterGetData()
    {
        using (SHS.UserBusinessServices.HarborTreatmentPlan objHarborTreatmentPlan = new SHS.UserBusinessServices.HarborTreatmentPlan())
        {
            int    staffId         = BaseCommonFunctions.GetUserIdInCaseOfMultipleDataBase();
            string InitialOrUpdate = "";
            if (BaseCommonFunctions.CheckRowExists(BaseCommonFunctions.ScreenInfo.CurrentDocument.DocumentDataSet, "CustomDocumentDiagnosticAssessments", 0))
            {
                InitialOrUpdate = BaseCommonFunctions.ScreenInfo.CurrentDocument.DocumentDataSet.Tables["CustomDocumentDiagnosticAssessments"].Rows[0]["InitialOrUpdate"].ToString();
            }
            if (InitialOrUpdate != "" && InitialOrUpdate == "U")
            {
                return;
            }

            using (DataSet dataSetObject = BaseCommonFunctions.GetScreenInfoDataSet())
            {
                //int DocumentVersionId = Convert.ToInt32(dataSetObject.Tables["DocumentVersions"].Rows[0]["DocumentVersionId"].ToString());
                DataSet dataSetTreatmentPlan = objHarborTreatmentPlan.GetTreatmentPlanInitial_2(BaseCommonFunctions.ApplicationInfo.Client.ClientId, staffId, "A");

                if (dataSetTreatmentPlan != null)
                {
                    //if (BaseCommonFunctions.CheckRowExists(dataSetTreatmentPlan, "CustomTPNeeds", 0))
                    //{

                    /*
                     * //dataSetObject.Tables["CustomTPGoalNeeds"].Clear();
                     * //dataSetObject.Tables["CustomTPNeeds"].Clear();
                     *
                     * try
                     * {
                     *  dataSetObject.Merge(dataSetTreatmentPlan, true, MissingSchemaAction.Ignore);
                     * }
                     *
                     *
                     * catch
                     * {
                     *  dataSetObject.Merge(dataSetTreatmentPlan, true, MissingSchemaAction.Ignore);
                     * }
                     */

                    if (BaseCommonFunctions.CheckRowExists(dataSetTreatmentPlan, "CustomTPNeeds", 0))
                    {
                        try
                        {
                            if (dataSetTreatmentPlan.Tables["CustomTPNeeds"] != null)
                            {
                                dataSetObject.Tables["CustomTPNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPNeeds"], true, MissingSchemaAction.Ignore);
                            }
                        }
                        catch
                        {
                            if (dataSetTreatmentPlan.Tables["CustomTPNeeds"] != null)
                            {
                                dataSetObject.Tables["CustomTPNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPNeeds"], true, MissingSchemaAction.Ignore);
                            }
                        }

                        //try
                        //{
                        //    if (dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"] != null)
                        //        dataSetObject.Tables["CustomTPGoalNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"], true, MissingSchemaAction.Ignore);
                        //}
                        //catch
                        //{
                        //    if (dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"] != null)
                        //        dataSetObject.Tables["CustomTPGoalNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"], true, MissingSchemaAction.Ignore);
                        //}

                        if (Convert.ToInt32(dataSetObject.Tables["Documents"].Rows[0]["DocumentId"]) == 0)
                        {
                            foreach (DataRow dr in dataSetObject.Tables["CustomTPGoalNeeds"].Rows)
                            {
                                dr.AcceptChanges();
                                dr.SetAdded();
                            }
                        }
                    }
                    //Code commented by jagdeep to remove CustomTPQuick* from unsaved changes
                    //Strat
                    //try
                    //{
                    //    if (dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"] != null)
                    //    {
                    //        dataSetObject.Tables["CustomTPQuickObjectives"].Clear();
                    //        dataSetObject.Tables["CustomTPQuickObjectives"].Merge(dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"], true, MissingSchemaAction.Ignore);
                    //    }
                    //}
                    //catch
                    //{
                    //    if (dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"] != null)
                    //    {
                    //        dataSetObject.Tables["CustomTPQuickObjectives"].Clear();
                    //        dataSetObject.Tables["CustomTPQuickObjectives"].Merge(dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"], true, MissingSchemaAction.Ignore);
                    //    }
                    //}
                    //end

                    //try
                    //{
                    //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"] != null)
                    //    {
                    //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Clear();
                    //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"], true, MissingSchemaAction.Ignore);
                    //    }
                    //}
                    //catch
                    //{
                    //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"] != null)
                    //    {
                    //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Clear();
                    //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"], true, MissingSchemaAction.Ignore);
                    //    }
                    //}

                    //Code commented by jagdeep to remove CustomTPQuick* from unsaved changes
                    //dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].AcceptChanges();
                    //dataSetObject.Tables["CustomTPGlobalQuickGoals"].AcceptChanges();
                    //End

                    //try
                    //{
                    //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"] != null)
                    //    {
                    //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Clear();
                    //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"], true, MissingSchemaAction.Ignore);
                    //    }
                    //}
                    //catch
                    //{
                    //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"] != null)
                    //    {
                    //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Clear();
                    //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"], true, MissingSchemaAction.Ignore);
                    //    }
                    //}
                }
                //}

                foreach (DataRow dr in dataSetObject.Tables["CustomTPNeeds"].Rows)
                {
                    if (Convert.ToInt32(dr[0]) > 0 && dr.RowState == DataRowState.Added)
                    {
                        dr.AcceptChanges();
                        dr.SetModified();
                    }
                }

                //if (dataSetObject.Tables.Contains("CustomTPNeeds"))
                //{
                //    dataSetObject.Tables["CustomTPNeeds"].AcceptChanges();
                //}
            }


            //using (DataSet dataSetObject = BaseCommonFunctions.GetScreenInfoDataSet())
            //    if (dataSetObject.Tables.Contains("CustomTPNeeds"))
            //    {
            //        foreach (DataRow dr in dataSetObject.Tables["CustomTPNeeds"].Rows)
            //        {
            //            if (Convert.ToInt32(dr[0]) > 0)
            //            {
            //                dr.AcceptChanges();
            //            }
            //        }
            //    }
        }
    }
예제 #2
0
        public override void ChangeInitializedDataSet(ref DataSet dataSetObject)
        {
            ////base.ChangeInitializedDataSet(ref dataSetObject);


            int DocumentVersionId = Convert.ToInt32(dataSetObject.Tables["DocumentVersions"].Rows[0]["DocumentVersionId"].ToString());

            using (SHS.UserBusinessServices.HarborTreatmentPlan objHarborTreatmentPlan = new SHS.UserBusinessServices.HarborTreatmentPlan())
            {
                int     staffId = BaseCommonFunctions.GetUserIdInCaseOfMultipleDataBase();
                DataSet dataSetTreatmentPlan = objHarborTreatmentPlan.GetTreatmentPlanInitial_2(BaseCommonFunctions.ApplicationInfo.Client.ClientId, staffId, "T");

                if (dataSetTreatmentPlan != null)
                {
                    if (BaseCommonFunctions.CheckRowExists(dataSetTreatmentPlan, "CustomTPNeeds", 0))
                    {
                        //dataSetObject.Tables["CustomTPGoalNeeds"].Clear();
                        //dataSetObject.Tables["CustomTPNeeds"].Clear();
                        //try
                        //{
                        //    if (dataSetTreatmentPlan.Tables["CustomTPNeeds"] != null)
                        //        dataSetObject.Tables["CustomTPNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPNeeds"], true, MissingSchemaAction.Ignore);
                        //}
                        //catch
                        //{
                        //    if (dataSetTreatmentPlan.Tables["CustomTPNeeds"] != null)
                        //        dataSetObject.Tables["CustomTPNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPNeeds"], true, MissingSchemaAction.Ignore);
                        //}

                        //try
                        //{
                        //    if (dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"] != null)
                        //        dataSetObject.Tables["CustomTPGoalNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"], true, MissingSchemaAction.Ignore);
                        //}
                        //catch
                        //{
                        //    if (dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"] != null)
                        //        dataSetObject.Tables["CustomTPGoalNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"], true, MissingSchemaAction.Ignore);
                        //}


                        //foreach (DataRow dr in dataSetObject.Tables["CustomTPGoalNeeds"].Rows)
                        //{
                        //    //if(Convert.ToInt32(dr[0])<0)
                        //    dr.SetAdded();

                        //}
                    }
                    try
                    {
                        if (dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"] != null)
                        {
                            dataSetObject.Tables["CustomTPQuickObjectives"].Clear();
                            dataSetObject.Tables["CustomTPQuickObjectives"].Merge(dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"], true, MissingSchemaAction.Ignore);
                        }
                    }
                    catch
                    {
                        if (dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"] != null)
                        {
                            dataSetObject.Tables["CustomTPQuickObjectives"].Clear();
                            dataSetObject.Tables["CustomTPQuickObjectives"].Merge(dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"], true, MissingSchemaAction.Ignore);
                        }
                    }

                    //try
                    //{
                    //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"] != null)
                    //    {
                    //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Clear();
                    //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"], true, MissingSchemaAction.Ignore);
                    //    }
                    //}
                    //catch
                    //{
                    //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"] != null)
                    //    {
                    //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Clear();
                    //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"], true, MissingSchemaAction.Ignore);
                    //    }
                    //}
                    dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].AcceptChanges();
                    dataSetObject.Tables["CustomTPGlobalQuickGoals"].AcceptChanges();
                    //try
                    //{
                    //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"] != null)
                    //    {
                    //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Clear();
                    //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"], true, MissingSchemaAction.Ignore);
                    //    }
                    //}
                    //catch
                    //{
                    //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"] != null)
                    //    {
                    //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Clear();
                    //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"], true, MissingSchemaAction.Ignore);
                    //    }
                    //}
                }

                //if (dataSetObject.Tables.Contains("CustomTPNeeds"))
                //{
                //    dataSetObject.Tables["CustomTPNeeds"].AcceptChanges();
                //}

                if (!BaseCommonFunctions.CheckRowExists(dataSetObject, "CustomTPGoals", 0))
                {
                    DataRow drCustomNeed = dataSetObject.Tables["CustomTPGoals"].NewRow();
                    drCustomNeed["TPGoalId"]          = -1;
                    drCustomNeed["DocumentVersionId"] = dataSetObject.Tables["DocumentVersions"].Rows[0]["DocumentVersionId"];
                    drCustomNeed["GoalNumber"]        = 1;
                    drCustomNeed["TargeDate"]         = DateTime.Now.AddYears(1);
                    BaseCommonFunctions.InitRowCredentials(drCustomNeed);

                    dataSetObject.Tables["CustomTPGoals"].Rows.Add(drCustomNeed);
                }
            }
        }
예제 #3
0
    public override void ChangeInitializedDataSet(ref DataSet dataSetObject)
    {
        //base.ChangeInitializedDataSet(ref dataSetObject);


        int DocumentVersionId = Convert.ToInt32(dataSetObject.Tables["DocumentVersions"].Rows[0]["DocumentVersionId"].ToString());

        if (GetRequestParameterValue("AssessmentScreenType").ToString() == "U" || GetRequestParameterValue("AssessmentScreenType").Trim() == "")
        {
            return;
        }
        using (SHS.UserBusinessServices.HarborTreatmentPlan objHarborTreatmentPlan = new SHS.UserBusinessServices.HarborTreatmentPlan())
        {
            int staffId = BaseCommonFunctions.GetUserIdInCaseOfMultipleDataBase();

            //DataSet dataSetTreatmentPlan = objHarborTreatmentPlan.GetTreatmentPlanInitial_2(BaseCommonFunctions.ApplicationInfo.Client.ClientId, staffId, "A");

            //if (dataSetTreatmentPlan != null)
            //{

            //    if (BaseCommonFunctions.CheckRowExists(dataSetTreatmentPlan, "CustomTPNeeds", 0))
            //    {

            //        //dataSetObject.Tables["CustomTPGoalNeeds"].Clear();
            //        dataSetObject.Tables["CustomTPNeeds"].Clear();
            //        try
            //        {
            //            if (dataSetTreatmentPlan.Tables["CustomTPNeeds"] != null)
            //                dataSetObject.Tables["CustomTPNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPNeeds"], true, MissingSchemaAction.Ignore);
            //        }
            //        catch
            //        {
            //            if (dataSetTreatmentPlan.Tables["CustomTPNeeds"] != null)
            //                dataSetObject.Tables["CustomTPNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPNeeds"], true, MissingSchemaAction.Ignore);
            //        }

            //        //try
            //        //{
            //        //    if (dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"] != null)
            //        //        dataSetObject.Tables["CustomTPGoalNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"], true, MissingSchemaAction.Ignore);
            //        //}
            //        //catch
            //        //{
            //        //    if (dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"] != null)
            //        //        dataSetObject.Tables["CustomTPGoalNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"], true, MissingSchemaAction.Ignore);
            //        //}


            //        //foreach (DataRow dr in dataSetObject.Tables["CustomTPGoalNeeds"].Rows)
            //        //{
            //        //    //if(Convert.ToInt32(dr[0])<0)
            //        //    dr.SetAdded();

            //        //}

            //    }
            //    //Code commented by jagdeep to remove CustomTPQuickObjectives from unsaved changes
            //    //Start
            //    //try
            //    //{
            //    //    if (dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"] != null)
            //    //    {
            //    //        dataSetObject.Tables["CustomTPQuickObjectives"].Clear();
            //    //        dataSetObject.Tables["CustomTPQuickObjectives"].Merge(dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"], true, MissingSchemaAction.Ignore);
            //    //    }
            //    //}
            //    //catch
            //    //{
            //    //    if (dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"] != null)
            //    //    {
            //    //        dataSetObject.Tables["CustomTPQuickObjectives"].Clear();
            //    //        dataSetObject.Tables["CustomTPQuickObjectives"].Merge(dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"], true, MissingSchemaAction.Ignore);
            //    //    }
            //    //}
            //    //End


            //    //try
            //    //{
            //    //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"] != null)
            //    //    {
            //    //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Clear();
            //    //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"], true, MissingSchemaAction.Ignore);
            //    //    }
            //    //}
            //    //catch
            //    //{
            //    //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"] != null)
            //    //    {
            //    //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Clear();
            //    //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"], true, MissingSchemaAction.Ignore);
            //    //    }
            //    //}

            //    //Code commented by jagdeep to remove CustomTPQuick* from unsaved changes
            //    //dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].AcceptChanges();
            //    //dataSetObject.Tables["CustomTPGlobalQuickGoals"].AcceptChanges();
            //    //end

            //    //try
            //    //{
            //    //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"] != null)
            //    //    {
            //    //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Clear();
            //    //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"], true, MissingSchemaAction.Ignore);
            //    //    }
            //    //}
            //    //catch
            //    //{
            //    //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"] != null)
            //    //    {
            //    //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Clear();
            //    //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"], true, MissingSchemaAction.Ignore);
            //    //    }
            //    //}

            //}

            //if (dataSetObject.Tables.Contains("CustomTPNeeds"))
            //{
            //    dataSetObject.Tables["CustomTPNeeds"].AcceptChanges();
            //}

            if (!BaseCommonFunctions.CheckRowExists(dataSetObject, "CustomTPGoals", 0))
            {
                DataRow drCustomNeed = dataSetObject.Tables["CustomTPGoals"].NewRow();
                drCustomNeed["TPGoalId"]          = -1;
                drCustomNeed["DocumentVersionId"] = dataSetObject.Tables["DocumentVersions"].Rows[0]["DocumentVersionId"];
                drCustomNeed["GoalNumber"]        = 1;
                drCustomNeed["TargeDate"]         = DateTime.Now.AddYears(1);
                BaseCommonFunctions.InitRowCredentials(drCustomNeed);

                dataSetObject.Tables["CustomTPGoals"].Rows.Add(drCustomNeed);
            }
        }
    }
예제 #4
0
        public override void ChangeDataSetAfterGetData()
        {
            base.ChangeDataSetAfterGetData();


            using (SHS.UserBusinessServices.HarborTreatmentPlan objHarborTreatmentPlan = new SHS.UserBusinessServices.HarborTreatmentPlan())
            {
                int staffId = BaseCommonFunctions.GetUserIdInCaseOfMultipleDataBase();

                using (DataSet dataSetObject = BaseCommonFunctions.GetScreenInfoDataSet())
                {
                    int DocumentVersionId = Convert.ToInt32(dataSetObject.Tables["DocumentVersions"].Rows[0]["DocumentVersionId"].ToString());

                    DataSet dataSetTreatmentPlan = objHarborTreatmentPlan.GetTreatmentPlanInitial_2(BaseCommonFunctions.ApplicationInfo.Client.ClientId, staffId, "T");

                    if (dataSetTreatmentPlan != null)
                    {
                        //if (BaseCommonFunctions.CheckRowExists(dataSetTreatmentPlan, "CustomTPNeeds", 0))
                        //{

                        /*
                         * //dataSetObject.Tables["CustomTPGoalNeeds"].Clear();
                         * //dataSetObject.Tables["CustomTPNeeds"].Clear();
                         *
                         * try
                         * {
                         *  dataSetObject.Merge(dataSetTreatmentPlan, true, MissingSchemaAction.Ignore);
                         * }
                         *
                         *
                         * catch
                         * {
                         *  dataSetObject.Merge(dataSetTreatmentPlan, true, MissingSchemaAction.Ignore);
                         * }
                         */

                        if (BaseCommonFunctions.CheckRowExists(dataSetTreatmentPlan, "CustomTPNeeds", 0))
                        {
                            try
                            {
                                if (dataSetTreatmentPlan.Tables["CustomTPNeeds"] != null)
                                {
                                    dataSetObject.Tables["CustomTPNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPNeeds"], true, MissingSchemaAction.Ignore);
                                }
                            }
                            catch
                            {
                                if (dataSetTreatmentPlan.Tables["CustomTPNeeds"] != null)
                                {
                                    dataSetObject.Tables["CustomTPNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPNeeds"], true, MissingSchemaAction.Ignore);
                                }
                            }

                            //try
                            //{
                            //    if (dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"] != null)
                            //        dataSetObject.Tables["CustomTPGoalNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"], true, MissingSchemaAction.Ignore);
                            //}
                            //catch
                            //{
                            //    if (dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"] != null)
                            //        dataSetObject.Tables["CustomTPGoalNeeds"].Merge(dataSetTreatmentPlan.Tables["CustomTPGoalNeeds"], true, MissingSchemaAction.Ignore);
                            //}

                            if (Convert.ToInt32(dataSetObject.Tables["Documents"].Rows[0]["DocumentId"]) == 0)
                            {
                                foreach (DataRow dr in dataSetObject.Tables["CustomTPGoalNeeds"].Rows)
                                {
                                    dr.AcceptChanges();
                                    dr.SetAdded();
                                }
                            }
                        }
                        try
                        {
                            if (dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"] != null)
                            {
                                dataSetObject.Tables["CustomTPQuickObjectives"].Clear();
                                dataSetObject.Tables["CustomTPQuickObjectives"].Merge(dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"], true, MissingSchemaAction.Ignore);
                            }
                        }
                        catch
                        {
                            if (dataSetTreatmentPlan.Tables["CustomTPQuickObjectives"] != null)
                            {
                                dataSetObject.Tables["CustomTPQuickObjectives"].Clear();
                                dataSetObject.Tables["CustomTPQuickObjectives"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"], true, MissingSchemaAction.Ignore);
                            }
                        }
                        //try
                        //{
                        //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"] != null)
                        //    {
                        //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Clear();
                        //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"], true, MissingSchemaAction.Ignore);
                        //    }
                        //}
                        //catch
                        //{
                        //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"] != null)
                        //    {
                        //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Clear();
                        //        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickTransitionPlans"], true, MissingSchemaAction.Ignore);
                        //    }
                        //}
                        dataSetObject.Tables["CustomTPGlobalQuickTransitionPlans"].AcceptChanges();
                        dataSetObject.Tables["CustomTPGlobalQuickGoals"].AcceptChanges();
                        //try
                        //{
                        //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"] != null)
                        //    {
                        //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Clear();
                        //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"], true, MissingSchemaAction.Ignore);
                        //    }
                        //}
                        //catch
                        //{
                        //    if (dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"] != null)
                        //    {
                        //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Clear();
                        //        dataSetObject.Tables["CustomTPGlobalQuickGoals"].Merge(dataSetTreatmentPlan.Tables["CustomTPGlobalQuickGoals"], true, MissingSchemaAction.Ignore);
                        //    }
                        //}
                    }
                    //}

                    foreach (DataRow dr in dataSetObject.Tables["CustomTPNeeds"].Rows)
                    {
                        if (Convert.ToInt32(dr[0]) > 0 && dr.RowState == DataRowState.Added)
                        {
                            dr.AcceptChanges();
                            dr.SetModified();
                        }
                    }

                    //if (dataSetObject.Tables.Contains("CustomTPNeeds"))
                    //{
                    //    dataSetObject.Tables["CustomTPNeeds"].AcceptChanges();
                    //}
                }


                //using (DataSet dataSetObject = BaseCommonFunctions.GetScreenInfoDataSet())
                //    if (dataSetObject.Tables.Contains("CustomTPNeeds"))
                //    {
                //        foreach (DataRow dr in dataSetObject.Tables["CustomTPNeeds"].Rows)
                //        {
                //            if (Convert.ToInt32(dr[0]) > 0)
                //            {
                //                dr.AcceptChanges();
                //            }
                //        }
                //    }
            }
        }