//[Produces("application/json")]
//[ValidateAntiForgeryToken]
public async Task <IActionResult> CreateFito(IFormFile qqfile)
{
if (qqfile == null)
{
return(Json(new { success = false, error = "error file null" }));
}
string error = null;
if (qqfile.Length > 0)
{
var toskip = new List <string> {
"Centre", "Fitoplanctons", "PSMB"
};
try
{
using (var stream = new StreamReader(qqfile.OpenReadStream(), Encoding.GetEncoding("Windows-1252"), true))
{
var html = stream.ReadToEnd();
using (var temp = new TableToExcel())
{
temp.Process(html, out ExcelPackage xlsx);
//var package = new ExcelPackage(xlsx);
error = await _import.Fito(xlsx, toskip).ConfigureAwait(false);
}
}
}
catch (FileNotFoundException ex)
{
return(Json(new { success = false, error = ex.Message }));
}
}
return(Json(new { success = string.IsNullOrWhiteSpace(error), error }));
}
public void CreateStationTest()
{
ITableToModel exsaver = new TableToExcel();
var forAssert = exsaver.CreateStation("TestStation");
Assert.IsNotNull(forAssert as TableToExcel);
}
public void TableToModelConvTest()
{
ITableToModel exsaver = new TableToExcel();
var table = new DataTable();
table.Columns.Add("TestColumn");
var row = table.NewRow();
row[0] = "testtext";
table.Rows.Add(row);
exsaver.CreateStation("TestStation");
bool asserting = exsaver.TableToModelConv("TestTable", table, null, null, null, KindOfTable.manual);
Assert.IsTrue(asserting);
}
public void SerializeModelTest()
{
ITableToModel exsaver = new TableToExcel();
var table = new DataTable();
const string fileName = "ExcelSaverTest";
if (File.Exists(fileName))
{
File.Delete(fileName);
}
table.Columns.Add("TestColumn");
var row = table.NewRow();
row[0] = "testtext";
table.Rows.Add(row);
exsaver.CreateStation("TestStation");
exsaver.TableToModelConv("TestTable", table, null, null, null, KindOfTable.manual);
exsaver.SerializeModel(fileName);
Assert.IsTrue(File.Exists(fileName + ".xlsx"));
}
