//private List<xFerParamater> _props = new List<xFerParamater>(); //public List<xFerParamater> Props //{ // get { return _props; } // set { _props = value; } //} #endregion #region method: init private void initMe(string path) { //EMPTY PREVIOUS _xFerPackages.Clear(); _initPath = path; string[] files = xFerFiles.openAllFiles(path); foreach (string file in files) { if (file.StartsWith(path + "package_")) { string sLoad = xFerFiles.getFile(file); if (sLoad.Length > 0) { try { xFerPackage _x = new xFerPackage(); _x = LitJson.JsonMapper.ToObject<xFerPackage>(sLoad); if (_x != null) { _xFerPackages.Add(_x); Console.WriteLine("Loaded Package: " + _x.PackageName); foreach (xFer xf in _x.XFers) { Console.WriteLine("--" + xf.XFerName); } } } catch (Exception ex) { Console.WriteLine("failed to load file " + file); } } } } //GET Saved DBs string[] dbFiles = xFerFiles.openAllFiles(path + "\\db"); foreach (string db in dbFiles) { try { string dbJSON = xFerFiles.getFile(db); if (dbJSON.Length > 0) { xFerDb _d = new xFerDb(); _d = LitJson.JsonMapper.ToObject<xFerDb>(dbJSON); if (_d != null) { _dbs.Add(_d); Console.WriteLine("Loaded DB: " + _d.DbName); } } } catch { } } }
public void createQuery(List<xFerParamater> _vars) { string packageName = _vars[0].Value.ToString().Trim(); string queryName = _vars[1].Value.ToString().Trim(); string queryType = _vars[2].Value.ToString().Trim(); string queryText = _vars[3].Value.ToString().Trim(); List<xFerParamater> _params = new List<xFerParamater>(); if (_vars.Count > 4) { string paramtext = _vars[4].Value.ToString().Trim(); try { _params = getParametersPassed(paramtext); } catch (Exception ex) { Console.WriteLine("query parameters failed."); } } //SEARCH QUERY FOR EXISTING QUERIES bool packageExists = false; foreach (xFerPackage _x in _xFerPackages) { if (_x.PackageName == packageName) { packageExists = true; bool exists = false; foreach (xFerQuery _q in _x.Queries) { if (_q.QueryName == queryName) { exists = true; if (queryType == "SP") { _q.QueryType = xFerQueryType.StoredProcedure; } else if (queryType == "T") { _q.QueryType = xFerQueryType.Text; } _q.QueryText = queryText; // newQuery.MongoQuery = ""; //newQuery.Paramaters if (_params.Count > 0) { _q.Paramaters = _params; } savePackage(_x.PackageName); } } if (!exists) { xFerQuery newQuery = new xFerQuery(); newQuery.QueryName = queryName; if (queryType == "SP") { newQuery.QueryType = xFerQueryType.StoredProcedure; } else if (queryType == "T") { newQuery.QueryType = xFerQueryType.Text; } newQuery.QueryText = queryText; // newQuery.MongoQuery = ""; //newQuery.Paramaters if (_params.Count > 0) { newQuery.Paramaters = _params; } _x.Queries.Add(newQuery); savePackage(_x.PackageName); } } } if (!packageExists) { //CREATE PACKAGE xFerPackage xPack = new xFerPackage(); xPack.PackageName = packageName; xFerQuery newQuery = new xFerQuery(); newQuery.QueryName = queryName; if (queryType == "SP") { newQuery.QueryType = xFerQueryType.StoredProcedure; } else if (queryType == "T") { newQuery.QueryType = xFerQueryType.Text; } newQuery.QueryText = queryText; //newQuery.Paramaters if (_params.Count > 0) { newQuery.Paramaters = _params; } xPack.Queries.Add(newQuery); _xFerPackages.Add(xPack); savePackage(xPack.PackageName); } }
public void createPackage(List<xFerParamater> _vars) { bool packageExists = false; //SEE IF PACKAGE ALREADY EXISTS foreach (xFerPackage p in _xFerPackages) { if (p.PackageName == _vars[0].Value.ToString().Trim()) { packageExists = true; } } if (!packageExists) { xFerPackage xPack = new xFerPackage(); xPack.PackageName = _vars[0].Value.ToString().Trim(); _xFerPackages.Add(xPack); savePackage(xPack.PackageName); //xFerFiles.createFile(LitJson.JsonMapper.ToJson(xPack), _initPath + "\\package_" + xPack.PackageName + ".txt"); } else { if (_vars.Count > 1) { foreach (xFerPackage p in _xFerPackages) { if (p.PackageName == _vars[0].Value.ToString().Trim()) { //ADD STUFF } } } } }