public List <string> GetEntitesList() { try { //---------------Get Categories---------------- - if (Entities.Count == 0) { DatasourceEntities f = DMEEditor.ConfigEditor.LoadDataSourceEntitiesValues(DatasourceName); if (f != null) { Entities = f.Entities; } } if (Entities == null || Entities.Count() == 0) { string retval = GetCategoriesDataAsync("GetCategories", @"/category/?api_key=@apikey&category_id=371").Result; var data = JObject.Parse(retval); var categorytk = data.SelectToken("category"); // Category categorys = JsonConvert.DeserializeObject<Category>(categorytk.ToString()); int i = 1; //foreach (var item in categorys.childcategories) //{ // EntityStructure x = new EntityStructure(); // x.ParentId = 0; // x.Id = i; // i += 1; // x.EntityName = item.name; // x.Viewtype = ViewType.Url; // x.Category = "WEBAPI"; // x.DataSourceID = DatasourceName; // x.CustomBuildQuery = $"/category/?api_key=7535ABF7E83252CB08E4300380DFA02D&category_id={item.category_id}"; // Entities.Add(x); // // retval = GetCategoriesDataAsync("GetCategories", x.CustomBuildQuery).Result; // var ou = GetCategoriesDataAsync("GetCategories", x.CustomBuildQuery); // ou.Wait(); // data = JObject.Parse(ou.Result); // categorytk = data.SelectToken("category"); //Category ct = JsonConvert.DeserializeObject<Category>(categorytk.ToString()); //foreach (Childcategory cc in ct.childcategories) //{ // createentities(cc, x); //} //} } EntitiesNames.Clear(); foreach (EntityStructure item in Entities) { item.CustomBuildQuery = item.CustomBuildQuery.Replace("api_key=7535ABF7E83252CB08E4300380DFA02D", "api_key=@apikey"); EntitiesNames.Add(item.EntityName); } DMEEditor.ConfigEditor.SaveDataSourceEntitiesValues(new DatasourceEntities { datasourcename = DatasourceName, Entities = Entities }); return(EntitiesNames); } catch (Exception ex) { DMEEditor.ConfigEditor.SaveDataSourceEntitiesValues(new DatasourceEntities { datasourcename = DatasourceName, Entities = Entities }); return(null); } }
public List <string> GetEntitesList() { try { if (!string.IsNullOrEmpty(Dataconnection.ConnectionProp.ApiKey)) { if (Entities.Count == 0) { DatasourceEntities f = DMEEditor.ConfigEditor.LoadDataSourceEntitiesValues(DatasourceName); if (f != null) { Entities = f.Entities; } } DMEEditor.AddLogMessage("Log Time", $"started International Energy Data {DateTime.Now}", DateTime.Now, 2134384, "International Energy Data", Errors.Ok); if (!Entities.Where(o => o.EntityName.Equals("International Energy Data", StringComparison.OrdinalIgnoreCase)).Any()) { CreateCategories(2134384, "International Energy Data", 0); } DMEEditor.AddLogMessage("Log Time", $"started Petroleum {DateTime.Now}", DateTime.Now, 2134384, "Petroleum", Errors.Ok); DMEEditor.ConfigEditor.SaveDataSourceEntitiesValues(new DatasourceEntities { datasourcename = DatasourceName, Entities = Entities }); if (!Entities.Where(o => o.EntityName.Equals("Petroleum", StringComparison.OrdinalIgnoreCase)).Any()) { CreateCategories(714755, "Petroleum", 0); } DMEEditor.AddLogMessage("Log Time", $"started Crude Oil Imports {DateTime.Now}", DateTime.Now, 2134384, "Crude Oil Imports", Errors.Ok); DMEEditor.ConfigEditor.SaveDataSourceEntitiesValues(new DatasourceEntities { datasourcename = DatasourceName, Entities = Entities }); if (!Entities.Where(o => o.EntityName.Equals("Crude Oil Imports", StringComparison.OrdinalIgnoreCase)).Any()) { CreateCategories(1292190, "Crude Oil Imports", 0); } DMEEditor.ConfigEditor.SaveDataSourceEntitiesValues(new DatasourceEntities { datasourcename = DatasourceName, Entities = Entities }); //string retval = GetCategoriesDataAsync("GetCategories", $"/category/?api_key={Dataconnection.ConnectionProp.ApiKey}&category_id=371").Result; // var data = JObject.Parse(retval); // var categorytk = data.SelectToken("category"); // Category categorys = JsonConvert.DeserializeObject<Category>(categorytk.ToString()); // int i = 1; // foreach (Childcategory item in categorys.childcategories) // { // if (!Entities.Where(o => o.EntityName.Equals(item.name, StringComparison.OrdinalIgnoreCase)).Any()) // { // EntityStructure x = new EntityStructure(); // x.ParentId = 0; // x.Id = i; // i += 1; // x.EntityName = item.name; // x.Viewtype = ViewType.Url; // x.DataSourceID = DatasourceName; // x.Category = "Category"; // x.CustomBuildQuery = $"/category/?api_key={Dataconnection.ConnectionProp.ApiKey}&category_id={item.category_id}"; // Entities.Add(x); // var ou = GetCategoriesDataAsync("GetCategories", x.CustomBuildQuery); // ou.Wait(); // data = JObject.Parse(ou.Result); // categorytk = data.SelectToken("category"); // Category ct = JsonConvert.DeserializeObject<Category>(categorytk.ToString()); // foreach (Childcategory cc in ct.childcategories) // { // CreateChildCategories(cc, x); // } // DMEEditor.ConfigEditor.SaveDataSourceEntitiesValues(new DatasourceEntities { datasourcename = DatasourceName, Entities = Entities }); // } // } //} EntitiesNames.Clear(); EntitiesNames = Entities.Select(p => p.EntityName).ToList(); DMEEditor.ConfigEditor.SaveDataSourceEntitiesValues(new DatasourceEntities { datasourcename = DatasourceName, Entities = Entities }); } //---------------Get Categories---------------- - if (!string.IsNullOrEmpty(Dataconnection.ConnectionProp.ApiKey)) { } return(EntitiesNames); } catch (Exception) { DMEEditor.ConfigEditor.SaveDataSourceEntitiesValues(new DatasourceEntities { datasourcename = DatasourceName, Entities = Entities }); return(null); } }