private void SmartDetect(string filename)
{
var detector = new FileHelpers.Detection.SmartFormatDetector();
var formats = detector.DetectFileFormat(filename);
foreach (var format in formats)
{
Console.WriteLine("Format Detected, confidence:" + format.Confidence + "%");
var delimited = format.ClassBuilderAsDelimited;
Console.WriteLine(" Delimiter:" + delimited.Delimiter);
Console.WriteLine(" Fields:");
EntityStructure entityData = new EntityStructure();
string sheetname;
sheetname = FileName;
entityData.Viewtype = ViewType.File;
entityData.DatabaseType = DataSourceType.Text;
entityData.DataSourceID = FileName;
entityData.DatasourceEntityName = FileName;
entityData.Caption = FileName;
entityData.EntityName = FileName;
List <EntityField> Fields = new List <EntityField>();
int y = 0;
foreach (var field in delimited.Fields)
{
Console.WriteLine(" " + field.FieldName + ": " + field.FieldType);
EntityField f = new EntityField();
// f.tablename = sheetname;
f.fieldname = field.FieldName;
f.fieldtype = field.FieldType.ToString();
f.ValueRetrievedFromParent = false;
f.EntityName = sheetname;
f.FieldIndex = y;
Fields.Add(f);
y += 1;
}
entityData.Fields = new List <EntityField>();
entityData.Fields.AddRange(Fields);
Entities.Clear();
EntitiesNames.Clear();
EntitiesNames.Add(filename);
Entities.Add(entityData);
}
}
public List <string> GetEntitesList()
{
EntitiesNames.Clear();
EntitiesNames.Add(DatasourceName);
return(EntitiesNames);
}
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);
}
}