//delete param public static bool DeleteParam(DataSItem parent, DataParam delParam) { bool res = false; if (IsDocLoaded) { try { XmlNode node = ConfigurationDocument.SelectSingleNode( SettingsHelperManager.QueryOfSelectingParametrOfTheProcedureByPval(parent.Value, delParam.Name)); if (node == null) { return(false); } node.ParentNode.RemoveChild(node); if (Save()) { res = true; ReadAllProcedures(); } } catch { } } return(res); }
//add param public static bool AddParam(DataSItem parent, DataParam newparam) { bool res = false; if (IsDocLoaded) { try { XmlNode procParent = _doc.SelectSingleNode(SettingsHelperManager.QueryOfSelectinProcedureByValue(parent.Value)); if (procParent != null) { procParent.AppendChild(newparam.ToXmlNode()); if (Save()) { res = true; ReadAllProcedures(); } } } catch { return(false); } } return(res); }
//<param name="" type="0" IsOutput="0"/> public static DataParam GetparamFromXmlNode(XmlNode node) { DataParam res = new DataParam(); res.Name = node.Attributes["name"].Value; int type = Convert.ToInt16(node.Attributes["type"].Value); res.Type = (CustomSqlTypes)type; int a = Convert.ToInt32(node.Attributes["direction"].Value); res.Direction = (ParamDirection)a; res.Default = node.Attributes["default"].Value; return(res); }
public DataParam GetParamByName(string name) { DataParam param = null; foreach (DataParam prm in _params.Values) { if (prm.Name.Trim() == name.Trim()) { return(prm); } } return(param); }
public void AddParam(DataParam param) { if (_hasReturnParam && param.Direction == ParamDirection.Return) { throw new ReturnValueUniqueException(); } if (!_hasReturnParam && param.Direction == ParamDirection.Return) { _hasReturnParam = true; } if (param.Direction == ParamDirection.Output) { _outputParams.Add(param.Name, param); } _params.Add(param.Name, param); }
/* * <item name="" schema="" constr=""> * <param name="" type="0" IsOutput="0"/> * </item>*/ public void ReadParamsFromXml(XmlNode xmlItem) { if (xmlItem != null && xmlItem.Name == "item") { _params.Clear(); Name = xmlItem.Attributes["name"].Value; // Value = xmlItem.Attributes["value"].Value; Schema = xmlItem.Attributes["schema"].Value; ConnectionString = xmlItem.Attributes["constr"].Value; if (xmlItem.HasChildNodes) { foreach (XmlNode node in xmlItem.ChildNodes) { DataParam prm = new DataParam(); prm = DataParam.GetparamFromXmlNode(node); prm.SetParent(this); AddParam(prm); } } } }
//update param public static bool UpdateParam(DataSItem parent, string oldParamname, DataParam unewparam) { bool res = false; if (IsDocLoaded) { try { string test = SettingsHelperManager.QueryOfSelectingParametrOfTheProcedureByPval(parent.Value, oldParamname); XmlNode node = ConfigurationDocument.SelectSingleNode(test); if (node == null) { return(false); } //<param name="@action_name" type="4" IsOutput="True" default="asdasd" /> node.Attributes["name"].Value = unewparam.Name; node.Attributes["type"].Value = ((int)unewparam.Type).ToString(); node.Attributes["direction"].Value = ((int)unewparam.Direction).ToString(); node.Attributes["default"].Value = unewparam.Default; if (Save()) { res = true; ReadAllProcedures(); } } catch { return(false); } } return(res); }
//<param name="" type="0" IsOutput="0"/> public static bool UpDateProcedureParametr(string procedureVal, string ParamName, DataParam newparam) { bool res = false; if (IsDocLoaded) { try { XmlNode node = ConfigurationDocument.SelectSingleNode( SettingsHelperManager.QueryOfSelectingParametrOfTheProcedureByPval(procedureVal, ParamName)); if (node == null) { return(false); } node.Attributes["name"].Value = newparam.Name; node.Attributes["type"].Value = ((int)newparam.Type).ToString(); node.Attributes["direction"].Value = newparam.Direction.ToString(); if (Save()) { res = true; ReadAllProcedures(); } } catch { return(false); } } return(res); }