private NLPExportModel WriteIntentionCSV(List <Intention> intentions, string outputPath)
{
if (intentions == null)
{
return(null);
}
var total = intentions.Sum((intention) => intention.Questions == null ? 0 : intention.Questions.Length);
var model = new NLPExportModel
{
Columns = new string[] { "Intent", "Question" },
Values = new string[total, 2]
};
var i = 0;
foreach (var intent in intentions)
{
if (intent.Questions == null)
{
continue;
}
foreach (var question in intent.Questions)
{
model.Values[i, 0] = intent.Name;
model.Values[i, 1] = question.Text;
i++;
}
}
model.Name = "intentions.csv";
return(model);
}
private NLPExportModel WriteAnswersCSV(List <Intention> intentions, string outputPath)
{
if (intentions == null)
{
return(null);
}
var total = intentions.Sum((intention) => intention.Answers == null ? 0 : intention.Answers.Length);
var model = new NLPExportModel
{
Columns = new string[] { "Intent", "Answer" },
Values = new string[total, 2]
};
var i = 0;
foreach (var intent in intentions)
{
if (intent.Answers == null)
{
continue;
}
foreach (var answers in intent.Answers)
{
model.Values[i, 0] = intent.Name;
model.Values[i, 1] = answers.Value.ToString();
i++;
}
}
model.Name = "answers.csv";
return(model);
}
private NLPExportModel WriteEntitiesCSV(List <Entity> entities, string outputPath)
{
if (entities == null)
{
return(null);
}
var total = entities.Sum((entity) => entity.Values == null ? 0 : entity.Values.Length);
var model = new NLPExportModel
{
Columns = new string[] { "Entity", "Value", "Synonymous" },
Values = new string[total, 3]
};
var i = 0;
foreach (var entity in entities)
{
if (entity.Values == null)
{
continue;
}
foreach (var value in entity.Values)
{
model.Values[i, 0] = entity.Name;
model.Values[i, 1] = value.Name;
model.Values[i, 2] = string.Join('/', value.Synonymous);
i++;
}
}
model.Name = "entities.csv";
return(model);
}
private NLPExportModel WriteIntentionExcel(List <Intention> intentions)
{
int RowCount = 0;
NLPExportModel excelExportModel = new NLPExportModel();
excelExportModel.Name = "Intentions";
excelExportModel.Columns = new string[3];
excelExportModel.Columns[0] = "ID";
excelExportModel.Columns[1] = "Intention Name";
excelExportModel.Columns[2] = "Updated At";
List <Intention> filteredIntentions = intentions.Where(x => x.IsDeleted == false).ToList();
excelExportModel.Values = new string[filteredIntentions.Count, excelExportModel.Columns.Length];
foreach (var intent in filteredIntentions)
{
excelExportModel.Values[RowCount, 0] = intent.Id;
excelExportModel.Values[RowCount, 1] = intent.Name;
excelExportModel.Values[RowCount, 2] = intent.StorageDate.GetValueOrDefault().ToString("dd/MM/yyyy hh:mm:ss");
RowCount++;
}
return(excelExportModel);
}
private NLPExportModel WriteEntitiesExcel(List <Entity> entities)
{
int RowCount = 0;
int TotalEntitiesValue = 0;
NLPExportModel excelExportModel = new NLPExportModel();
excelExportModel.Name = "Entities";
excelExportModel.Columns = new string[4];
excelExportModel.Columns[0] = "ID";
excelExportModel.Columns[1] = "Entity Name";
excelExportModel.Columns[2] = "Value Name";
excelExportModel.Columns[3] = "Synonymous";
List <Entity> filteredEntities = entities.Where(x => x.IsDeleted == false).ToList();
filteredEntities.ForEach(delegate(Entity entity)
{
EntityValues[] questions = entity.Values;
if (questions == null)
{
TotalEntitiesValue = TotalEntitiesValue + 1;
}
else
{
TotalEntitiesValue = TotalEntitiesValue + questions.Length;
}
});
excelExportModel.Values = new string[TotalEntitiesValue, excelExportModel.Columns.Length];
foreach (var entity in filteredEntities)
{
if (entity.Values == null)
{
excelExportModel.Values[RowCount, 0] = entity.Id;
excelExportModel.Values[RowCount, 1] = entity.Name;
excelExportModel.Values[RowCount, 2] = string.Empty;
excelExportModel.Values[RowCount, 3] = string.Empty;
RowCount++;
continue;
}
foreach (var item in entity.Values)
{
excelExportModel.Values[RowCount, 0] = entity.Id;
excelExportModel.Values[RowCount, 1] = entity.Name;
excelExportModel.Values[RowCount, 2] = item.Name;
excelExportModel.Values[RowCount, 3] = string.Join(";", item.Synonymous);
RowCount++;
}
}
return(excelExportModel);
}
private NLPExportModel WriteAnswersExcel(List <Intention> intentions)
{
int RowCount = 0;
int TotalAnswers = 0;
NLPExportModel excelExportModel = new NLPExportModel();
excelExportModel.Name = "Answers";
excelExportModel.Columns = new string[2];
excelExportModel.Columns[0] = "Intention Name";
excelExportModel.Columns[1] = "Answer";
List <Intention> filteredIntentions = intentions.Where(x => x.IsDeleted == false).ToList();
filteredIntentions.ForEach(delegate(Intention intent)
{
Answer[] questions = intent.Answers;
if (questions == null)
{
TotalAnswers = TotalAnswers + 1;
}
else
{
TotalAnswers = TotalAnswers + questions.Length;
}
});
excelExportModel.Values = new string[TotalAnswers, excelExportModel.Columns.Length];
foreach (var intent in filteredIntentions)
{
if (intent.Answers == null)
{
excelExportModel.Values[RowCount, 0] = intent.Name;
excelExportModel.Values[RowCount, 1] = string.Empty;
RowCount++;
continue;
}
foreach (var answer in intent.Answers)
{
excelExportModel.Values[RowCount, 0] = intent.Name;
excelExportModel.Values[RowCount, 1] = answer.Value.ToString();
RowCount++;
}
}
return(excelExportModel);
}
