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 }
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 }
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 }