//#################################################################################################
public IActionResult CreateNewView(Models.UploadModel model, int save)
{
if (save == 1)
{
return(SaveView());
}
List <Tuple <int, string[]> > tuples = new List <Tuple <int, string[]> >();
for (int i = 0; i < Program.uploadModel.ArrayList.Count; i++)
{
for (int j = 0; j < model.IntegerList[i].Count; j++)
{
if (model.IntegerList[i][j] != 0)
{
var t = GetCol(Program.uploadModel.ArrayList[i], j);
Program.uploadModel.ArrayList[i][0][j] = Program.uploadModel.FileList[i].content.accession + "_" + Program.uploadModel.ArrayList[i][0][j];
tuples.Add(new Tuple <int, string[]>(model.IntegerList[i][j], GetCol(Program.uploadModel.ArrayList[i], j)));
}
}
Program.uploadModel.Offset[i] = 0;
}
string[][] ret = new string[0][];
int max = 0;
tuples.Sort((t1, t2) => t1.Item1.CompareTo(t2.Item1));
for (int i = 0; i < tuples.Count; i++)
{
if (max < tuples[i].Item2.Length)
{
max = tuples[i].Item2.Length;
}
}
ret = new string[max][];
int[] offsets = new int[max];
for (int i = 0; i < max; i++)
{
string line = "";
for (int j = 0; j < tuples.Count; j++)
{
line += ";" + (tuples[j].Item2.Length > i ? tuples[j].Item2[i] : null);
}
line = line.Remove(0, 1);
ret[i] = line.Split(';');
offsets[i] = 0;
}
Program.uploadModel.Step = 2;
Program.uploadModel.IntegerList.Clear();
Program.uploadModel.FileList.Clear();
Program.uploadModel.FileList.Add(new Classes.File());
Program.uploadModel.ArrayList.Clear();
Program.uploadModel.ArrayList.Add(ret);
Program.uploadModel.Offset.Clear();
Program.uploadModel.Offset.AddRange(offsets);
return(Upload());
}
//#################################################################################################
public IActionResult ChangeViewMode(Models.UploadModel model, string Mode)
{
if (Program.uploadModel.ViewMode == FlatMode() && Mode == Program.uploadModel.ViewMode)
{
Program.uploadModel.ViewMode = RowMode();
}
if (Program.uploadModel.ViewMode == RowMode() && Mode == Program.uploadModel.ViewMode)
{
Program.uploadModel.ViewMode = FlatMode();
}
Program.uploadModel.ExceptionMessage = null;
return(Upload());
}
public static Models.UploadModel LoadSingleData(string sql)
{
using (IDbConnection cnn = new SqlConnection(GetConnectionString()))
{
var Query = cnn.Query <Models.UploadModel>(sql);
if (Query == null || !Query.Any())
{
var obj = new Models.UploadModel();
obj.Id = -1;
return(obj);
}
return(Query.First());
}
}
public static void Main(string[] args)
{
XmlDocument log4netConfig = new XmlDocument();
log4netConfig.Load(File.OpenRead("log4net.config"));
var repo = log4net.LogManager.CreateRepository(Assembly.GetEntryAssembly(),
typeof(log4net.Repository.Hierarchy.Hierarchy));
log4net.Config.XmlConfigurator.Configure(repo, log4netConfig["log4net"]);
indexModel = new Models.IndexModel();
indexModel.Init();
sessionModel = new Models.SessionModel();
uploadModel = new Models.UploadModel();
Guid g = Guid.NewGuid();
GuidString = Convert.ToBase64String(g.ToByteArray());
GuidString = GuidString.Replace("=", "").Replace("+", "").Replace("/", "").Replace("\\", "");
CreateHostBuilder(args).UseConsoleLifetime().Build().Run();
}
//#################################################################################################
public IActionResult UploadFile(Models.UploadModel uploadModel)
{
try
{
Controllers.LogController.Begin();
StartZeit = DateTime.Now;
Program.uploadModel.ExceptionMessage = null;
Program.uploadModel.Step = 1;
Directory.CreateDirectory(tmpPath);
Directory.CreateDirectory(dataPath);
Directory.CreateDirectory(csvPath);
Directory.CreateDirectory(processedPath);
if (uploadModel.file != null)
{
try
{
using (var stream = System.IO.File.Create(Path.Combine(dataPath, uploadModel.file.FileName)))
{
uploadModel.file.CopyTo(stream);
}
}
catch (Exception ex)
{
LogController.LogError(String.Format(HelperController.GetMessage("UploadController.Err.UploadFile1").txt, ex.ToString()));
Program.uploadModel.ExceptionMessage = HelperController.GetMessage("UploadController.Err.UploadFile1").ext;
return(Upload());
}
}
else
{
try
{
if (uploadModel.fileString.IndexOf("data:") >= 0)
{
uploadModel.fileString = Regex.Replace(uploadModel.fileString, "data:([^,]+)", String.Empty);
uploadModel.fileString = uploadModel.fileString.Remove(0, 1);
}
System.IO.File.WriteAllBytesAsync(Path.Combine(dataPath, uploadModel.fileName), Convert.FromBase64String(uploadModel.fileString));
}
catch (Exception ex)
{
LogController.LogError(String.Format(HelperController.GetMessage("UploadController.Err.UploadFile2").txt, ex.ToString()));
Program.uploadModel.ExceptionMessage = HelperController.GetMessage("UploadController.Err.UploadFile2").ext;
return(Upload());
}
}
Program.uploadModel.FileList = new List <Classes.File>();
FileController.MoveAndExtractFiles(dataPath, csvPath);
FileController.MoveAndExtractFiles(csvPath, processedPath);
LogController.End(String.Format("verstrichene Zeit: {0}", DateTime.Now - StartZeit));
return(Preview(processedPath));
}
catch (Exception ex)
{
LogController.LogError(String.Format(HelperController.GetMessage("UploadController.Err.Total").txt, ex.ToString()));
Program.uploadModel.ExceptionMessage = HelperController.GetMessage("UploadController.Err.Total").ext;
FileController.ClearDirectory(@"C:\temp\tmp_upload_" + Program.GuidString);
Program.uploadModel.FileList = null;
return(Upload());
}
}
