コード例 #1
0
        public string[] UpdateExpression_ExpressionsPage(
            string ID,
            string Parent_ID,
            string ScriptBeginFa,
            string ScriptEndFa,
            string ScriptBeginEn,
            string ScriptEndEn,
            string AddOnParentCreation,
            string CanAddToFinal,
            string CanEditInFinal,
            string Visible,
            string SortOrder,
            string PageState
            )
        {
            this.InitializeCulture();

            UIValidationExceptions uiValidationExceptions = new UIValidationExceptions();

            string[] retMessage = new string[4];

            decimal           iID = 0;
            ConceptExpression ConceptExpressionRecived = new ConceptExpression();

            ConceptExpressionRecived.ID = Convert.ToDecimal(StringBuilder.CreateString(ID));

            PageState = StringBuilder.CreateString(PageState);
            if (PageState != "Delete")
            {
                uiValidationExceptions = BExpression.Validation(ScriptBeginFa);

                if (uiValidationExceptions.ExceptionList.Count > 0)
                {
                    retMessage = this.ExceptionHandler.HandleException(
                        this.Page,
                        ExceptionTypes.UIValidationExceptions,
                        uiValidationExceptions, retMessage);

                    return(retMessage);
                }

                if (!string.IsNullOrEmpty(StringBuilder.CreateString(Parent_ID)))
                {
                    ConceptExpressionRecived.Parent_ID = Convert.ToDecimal(StringBuilder.CreateString(Parent_ID));
                }

                /*
                 * ID, Parent_ID, ScriptBeginFa, ScriptEndFa, ScriptBeginEn,
                 * ScriptEndEn, AddOnParentCreation, CanAddToFinal, CanEditInFinal,
                 * Visible, SortOrder, PageState
                 */

                ConceptExpressionRecived.ScriptBeginFa = StringBuilder.CreateString(ScriptBeginFa);
                ConceptExpressionRecived.ScriptEndFa   = StringBuilder.CreateString(ScriptEndFa);
                ConceptExpressionRecived.ScriptBeginEn = StringBuilder.CreateString(ScriptBeginEn);
                ConceptExpressionRecived.ScriptEndEn   = StringBuilder.CreateString(ScriptEndEn);
                ConceptExpressionRecived.SortOrder     = int.Parse(StringBuilder.CreateString(SortOrder));

                ConceptExpressionRecived.AddOnParentCreation = bool.Parse(StringBuilder.CreateString(AddOnParentCreation));
                ConceptExpressionRecived.CanAddToFinal       = bool.Parse(StringBuilder.CreateString(CanAddToFinal));
                ConceptExpressionRecived.CanEditInFinal      = bool.Parse(StringBuilder.CreateString(CanEditInFinal));
                ConceptExpressionRecived.Visible             = bool.Parse(StringBuilder.CreateString(Visible));
            }

            #region Effect on DB

            try
            {
                #region Set UIActionType Enum
                UIActionType uiActionType = UIActionType.ADD;
                switch (PageState.ToUpper())
                {
                    #region Add
                case "ADD":
                    uiActionType = UIActionType.ADD;
                    iID          = BExpression.InsertConceptExpression(ConceptExpressionRecived);
                    break;

                    #endregion
                    #region Edit
                case "EDIT":
                    uiActionType = UIActionType.EDIT;
                    if (ConceptExpressionRecived.ID == 0)
                    {
                        retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, new Exception(GetLocalResourceObject("NoConceptExpressionSelectedforEdit").ToString()), retMessage);
                        return(retMessage);
                    }

                    var conceptFromDb = BExpression.GetByID(ConceptExpressionRecived.ID);
                    BExpression.Copy(ConceptExpressionRecived, ref conceptFromDb);

                    iID = BExpression.UpdateConceptExpression(conceptFromDb);
                    break;

                    #endregion
                    #region Delete
                case "DELETE":
                    uiActionType = UIActionType.DELETE;
                    if (ConceptExpressionRecived.ID == 0)
                    {
                        retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, new Exception(GetLocalResourceObject("NoConceptExpressionSelectedforDelete").ToString()), retMessage);
                        return(retMessage);
                    }
                    iID = BExpression.DeleteConceptExpression(ConceptExpressionRecived);
                    break;

                    #endregion
                default:
                    break;
                }
                #endregion

                retMessage[0] = GetLocalResourceObject("RetSuccessType").ToString();
                string SuccessMessageBody = string.Empty;
                switch (uiActionType)
                {
                case UIActionType.ADD:
                    SuccessMessageBody = GetLocalResourceObject("AddComplete").ToString();
                    break;

                case UIActionType.EDIT:
                    SuccessMessageBody = GetLocalResourceObject("EditComplete").ToString();
                    break;

                case UIActionType.DELETE:
                    SuccessMessageBody = GetLocalResourceObject("DeleteComplete").ToString();
                    break;

                default:
                    break;
                }
                retMessage[1] = SuccessMessageBody;
                retMessage[2] = "success";
                retMessage[3] = iID.ToString();
                return(retMessage);
            }
            catch (UIValidationExceptions ex)
            {
                retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, ex, retMessage);
                return(retMessage);
            }
            catch (UIBaseException ex)
            {
                retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.UIBaseException, ex, retMessage);
                return(retMessage);
            }
            catch (Exception ex)
            {
                retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, ex, retMessage);
                return(retMessage);
            }
            #endregion
        }
コード例 #2
0
        public string[] UpdateConcept_ConceptsPage(
            string ID,
            string IdentifierCode,
            string Name,
            //string Description,
            string Color,
            string KeyColumnName,
            string CSharpCode,
            string Script,
            string UserDefined,
            string PeriodicType,
            string Type,
            string CalcSituationType,
            string PersistSituationType,
            string CustomeCategoryCode,
            string JsonObject,
            string PageState
            )
        {
            this.InitializeCulture();

            UIValidationExceptions uiValidationExceptions = new UIValidationExceptions();

            string[] retMessage = new string[4];

            decimal          iID            = 0;
            SecondaryConcept ConceptRecived = new SecondaryConcept();

            ConceptRecived.ID = Convert.ToDecimal(StringBuilder.CreateString(ID));

            PageState = StringBuilder.CreateString(PageState);
            if (PageState != "Delete")
            {
                uiValidationExceptions = BSecondaryConceptUserDefined.SecondaryConceptEnumJsonObjectsValidation(
                    StringBuilder.CreateString(PeriodicType),
                    StringBuilder.CreateString(Type),
                    StringBuilder.CreateString(CalcSituationType),
                    StringBuilder.CreateString(PersistSituationType)
                    );

                if (uiValidationExceptions.ExceptionList.Count > 0)
                {
                    retMessage = this.ExceptionHandler.HandleException(
                        this.Page,
                        ExceptionTypes.UIValidationExceptions,
                        uiValidationExceptions, retMessage);

                    return(retMessage);
                }

                ConceptRecived.IdentifierCode       = Convert.ToDecimal(StringBuilder.CreateString(IdentifierCode));
                ConceptRecived.Name                 = StringBuilder.CreateString(Name);
                ConceptRecived.Color                = StringBuilder.CreateString(Color);
                ConceptRecived.KeyColumnName        = StringBuilder.CreateString(KeyColumnName);
                ConceptRecived.CSharpCode           = StringBuilder.CreateString(CSharpCode);
                ConceptRecived.Script               = StringBuilder.CreateString(Script);
                ConceptRecived.UserDefined          = bool.Parse(StringBuilder.CreateString(UserDefined));
                ConceptRecived.PeriodicType         = (ScndCnpPeriodicType)Enum.Parse(typeof(ScndCnpPeriodicType), StringBuilder.CreateString(PeriodicType));
                ConceptRecived.Type                 = (ScndCnpPairableType)Enum.Parse(typeof(ScndCnpPairableType), StringBuilder.CreateString(Type));
                ConceptRecived.CalcSituationType    = (ScndCnpCalcSituationType)Enum.Parse(typeof(ScndCnpCalcSituationType), StringBuilder.CreateString(CalcSituationType));
                ConceptRecived.PersistSituationType = (ScndCnpPersistSituationType)Enum.Parse(typeof(ScndCnpPersistSituationType), StringBuilder.CreateString(PersistSituationType));
                ConceptRecived.CustomCategoryCode   = ((ScndCnpCustomeCategoryCode)Enum.Parse(typeof(ScndCnpCustomeCategoryCode), StringBuilder.CreateString(CustomeCategoryCode))).ToString("D");
                ConceptRecived.JsonObject           = StringBuilder.CreateString(JsonObject);
            }

            #region Effect on DB

            try
            {
                #region Set UIActionType Enum
                UIActionType uiActionType = UIActionType.ADD;
                switch (PageState.ToUpper())
                {
                    #region Add
                case "ADD":
                    uiActionType = UIActionType.ADD;
                    iID          = BSecondaryConceptUserDefined.InsertConcept(ConceptRecived);
                    break;

                    #endregion
                    #region Edit
                case "EDIT":
                    uiActionType = UIActionType.EDIT;
                    if (ConceptRecived.ID == 0)
                    {
                        retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, new Exception(GetLocalResourceObject("NoConceptSelectedforEdit").ToString()), retMessage);
                        return(retMessage);
                    }

                    var concept = BSecondaryConceptUserDefined.GetByID(ConceptRecived.ID);
                    BSecondaryConceptUserDefined.Copy(ConceptRecived, ref concept);

                    iID = BSecondaryConceptUserDefined.UpdateConcept(concept);
                    break;

                    #endregion
                    #region Delete
                case "DELETE":
                    uiActionType = UIActionType.DELETE;
                    if (ConceptRecived.ID == 0)
                    {
                        retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, new Exception(GetLocalResourceObject("NoConceptSelectedforDelete").ToString()), retMessage);
                        return(retMessage);
                    }
                    iID = BSecondaryConceptUserDefined.DeleteConcept(ConceptRecived);
                    break;
                    #endregion
                }
                #endregion

                retMessage[0] = GetLocalResourceObject("RetSuccessType").ToString();
                string SuccessMessageBody = string.Empty;
                switch (uiActionType)
                {
                case UIActionType.ADD:
                    SuccessMessageBody = GetLocalResourceObject("AddComplete").ToString();
                    break;

                case UIActionType.EDIT:
                    SuccessMessageBody = GetLocalResourceObject("EditComplete").ToString();
                    break;

                case UIActionType.DELETE:
                    SuccessMessageBody = GetLocalResourceObject("DeleteComplete").ToString();
                    break;
                }
                retMessage[1] = SuccessMessageBody;
                retMessage[2] = "success";
                retMessage[3] = iID.ToString(CultureInfo.InvariantCulture);
                return(retMessage);
            }
            catch (UIValidationExceptions ex)
            {
                retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, ex, retMessage);
                return(retMessage);
            }
            catch (UIBaseException ex)
            {
                retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.UIBaseException, ex, retMessage);
                return(retMessage);
            }
            catch (Exception ex)
            {
                retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, ex, retMessage);
                return(retMessage);
            }
            #endregion
        }
コード例 #3
0
        public string[] UpdateRule_RulesPage(
            string ID,
            string IdentifierCode,
            string Name,
            string CustomCategoryCode,
            string TypeId,
            string UserDefined,
            string Script,
            string CSharpCode,
            string JsonObject,
            string PageState)
        {
            this.InitializeCulture();

            UIValidationExceptions uiValidationExceptions = new UIValidationExceptions();

            string[] retMessage = new string[4];

            decimal      iID         = 0;
            RuleTemplate RuleRecived = new RuleTemplate();

            RuleRecived.ID = Convert.ToDecimal(StringBuilder.CreateString(ID));

            PageState = StringBuilder.CreateString(PageState);
            if (PageState != "Delete")
            {
                RuleRecived.IdentifierCode     = Convert.ToDecimal(StringBuilder.CreateString(IdentifierCode));
                RuleRecived.Name               = StringBuilder.CreateString(Name);
                RuleRecived.CustomCategoryCode = StringBuilder.CreateString(CustomCategoryCode);
                RuleRecived.TypeId             = Convert.ToDecimal(StringBuilder.CreateString(TypeId));
                RuleRecived.UserDefined        = bool.Parse(StringBuilder.CreateString(UserDefined));
                RuleRecived.Script             = StringBuilder.CreateString(Script);
                RuleRecived.CSharpCode         = StringBuilder.CreateString(CSharpCode);
                if (!string.IsNullOrEmpty(JsonObject))
                {
                    RuleRecived.JsonObject = JsonObject.Substring(1, JsonObject.Length - 2);
                }
            }

            #region Effect on DB

            try
            {
                #region Set UIActionType Enum
                UIActionType uiActionType = UIActionType.ADD;
                switch (PageState.ToUpper())
                {
                    #region Add
                case "ADD":
                    uiActionType = UIActionType.ADD;
                    iID          = RuleBusiness.InsertRule(RuleRecived);
                    break;

                    #endregion
                    #region Edit
                case "EDIT":
                    uiActionType = UIActionType.EDIT;
                    if (RuleRecived.ID == 0)
                    {
                        retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, new Exception(GetLocalResourceObject("NoRuleSelectedforEdit").ToString()), retMessage);
                        return(retMessage);
                    }

                    var concept = RuleBusiness.GetByID(RuleRecived.ID);
                    RuleBusiness.Copy(RuleRecived, ref concept);

                    iID = RuleBusiness.UpdateRule(concept);
                    break;

                    #endregion
                    #region Delete
                case "DELETE":
                    uiActionType = UIActionType.DELETE;
                    if (RuleRecived.ID == 0)
                    {
                        retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, new Exception(GetLocalResourceObject("NoRuleSelectedforDelete").ToString()), retMessage);
                        return(retMessage);
                    }
                    iID = RuleBusiness.DeleteRule(RuleRecived);
                    break;

                    #endregion
                default:
                    break;
                }
                #endregion

                retMessage[0] = GetLocalResourceObject("RetSuccessType").ToString();
                string SuccessMessageBody = string.Empty;
                switch (uiActionType)
                {
                case UIActionType.ADD:
                    SuccessMessageBody = GetLocalResourceObject("AddComplete").ToString();
                    break;

                case UIActionType.EDIT:
                    SuccessMessageBody = GetLocalResourceObject("EditComplete").ToString();
                    break;

                case UIActionType.DELETE:
                    SuccessMessageBody = GetLocalResourceObject("DeleteComplete").ToString();
                    break;

                default:
                    break;
                }
                retMessage[1] = SuccessMessageBody;
                retMessage[2] = "success";
                retMessage[3] = iID.ToString();
                return(retMessage);
            }
            catch (UIValidationExceptions ex)
            {
                retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, ex, retMessage);
                return(retMessage);
            }
            catch (UIBaseException ex)
            {
                retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.UIBaseException, ex, retMessage);
                return(retMessage);
            }
            catch (Exception ex)
            {
                retMessage = this.ExceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, ex, retMessage);
                return(retMessage);
            }
            #endregion
        }