public static List <IDatabaseObject> LoadCompetitionFromTable(TableName tableName) { if (string.IsNullOrWhiteSpace(m_databasePath)) { Log.Error("Select or create database must be called before saving is possible"); return(null); } var filename = Path.Combine(m_databasePath, string.Format("{0}.bos", tableName.ToString())); if (!File.Exists(filename)) { return(new List <IDatabaseObject>()); } var result = new List <IDatabaseObject>(); var lines = File.ReadAllLines(filename); foreach (var line in lines) { if (string.IsNullOrWhiteSpace(line)) { continue; } switch (tableName) { case TableName.LeonRegistration: result.Add(LeonPerson.Parse(line)); break; case TableName.OrionResult: result.Add(OrionResult.ParseFromDatabase(line)); break; case TableName.MinneRegistration: result.Add(MinneRegistration.Parse(line)); break; case TableName.FinishedShooter: result.Add(FinishedPerson.Parse(line)); break; } } return(result); }
public static void WriteLeonResults(List <int> finishedShooters, List <OrionResult> orionResults, OrionSetupViewModel orionSetup, List <LeonPerson> leonPersons, List <MinneRegistration> minnePersons) { var tmpBasePath = DatabaseApi.GetActiveCompetition(); var tmpPath = Path.Combine(tmpBasePath, "LeonTmp"); var tmpPathMinne = Path.Combine(tmpBasePath, "MinneLeonTemp"); if (!Directory.Exists(tmpPath)) { Directory.CreateDirectory(tmpPath); } if (!Directory.Exists(tmpPathMinne)) { Directory.CreateDirectory(tmpPathMinne); } var leonResultsFelt = new List <string>(); var leonResultsBane = new List <string>(); MinneRegistration minnePerson = null; LeonPerson leonPerson = null; foreach (var finishedShooter in finishedShooters) { var allResultsForShooter = orionResults.Where(o => o.ShooterId == finishedShooter); leonPerson = leonPersons.SingleOrDefault(l => l.ShooterId == finishedShooter); if (minnePersons != null) { minnePerson = minnePersons.SingleOrDefault(l => l.ShooterId == finishedShooter); } int sumFelt = 0; int sumBane = 0; List <string> allFeltSeries = new List <string>(); List <string> allMinneSeries = new List <string>(); foreach (var orion in orionSetup.OrionViewModels) { foreach (var rangeViewModel in orion.RangeViews) { if (rangeViewModel.RangeType == RangeType.Shooting) { var resultForThisRange = CalculateOrionAndRange.GetResultForThisRange(allResultsForShooter, orion, rangeViewModel); if (resultForThisRange == null) { if (rangeViewModel.ResultType == ResultType.Felt) { allFeltSeries.Add(string.Empty); } } else { if (resultForThisRange.ResultType == ResultType.Felt) { sumFelt += resultForThisRange.GetSum(); allFeltSeries.AddRange(resultForThisRange.Series); } else if (resultForThisRange.ResultType == ResultType.Bane) { sumBane += resultForThisRange.GetSum(); allMinneSeries.AddRange(resultForThisRange.Series); } } } } } ////foreach (var orionResult in allResultsForShooter) ////{ //// if (orionResult.ResultType == ResultType.Felt) //// { //// sumFelt += orionResult.GetSum(); //// allFeltSeries.AddRange(orionResult.Series); //// } //// else if (orionResult.ResultType == ResultType.Bane) //// { //// sumBane += orionResult.GetSum(); //// allMinneSeries.AddRange(orionResult.Series); //// } ////} if (allFeltSeries.Any() && leonPerson != null) { var allShots = string.Join(";", allFeltSeries).ToUpper(); var leonLine = string.Format( "{0};{1};{2};{3};{4};{5};{6};{7};{8}", leonPerson.Range, leonPerson.Team, leonPerson.Target, leonPerson.ShooterId, leonPerson.Name, leonPerson.ClubName, leonPerson.Class, sumFelt, allShots); leonResultsFelt.Add(leonLine); } if (allMinneSeries.Any() && minnePerson != null) { var allShots = string.Join(";", allMinneSeries).ToUpper(); var leonLine = string.Format( "{0};{1};{2};{3};{4};{5};{6};{7};{8}", minnePerson.Range, minnePerson.Team, minnePerson.Target, minnePerson.ShooterId, minnePerson.Name, minnePerson.ClubName, minnePerson.Class, sumBane, allShots); leonResultsBane.Add(leonLine); } var finishedPerson = new FinishedPerson { Name = leonPerson.Name, ShooterId = leonPerson.ShooterId, Target = leonPerson.Target, Team = leonPerson.Team }; DatabaseApi.Save(finishedPerson); } if (leonResultsFelt.Any()) { var filenameTmp = Path.Combine(tmpPath, ToLeonDataTmp); File.AppendAllLines(filenameTmp, leonResultsFelt, Encoding.GetEncoding("ISO-8859-1")); } if (leonResultsBane.Any()) { var filenameTmp = Path.Combine(tmpPathMinne, ToLeonDataTmp); File.AppendAllLines(filenameTmp, leonResultsBane, Encoding.GetEncoding("ISO-8859-1")); } }
public static void WriteLeonResults( List <int> finishedShooters, List <OrionResult> orionResults, OrionSetupViewModel orionSetup, List <LeonPerson> leonPersons, List <MinneRegistration> minnePersons) { var tmpBasePath = DatabaseApi.GetActiveCompetition(); var tmpPath = Path.Combine(tmpBasePath, "LeonTmp"); var tmpPathMinne = Path.Combine(tmpBasePath, "MinneLeonTemp"); if (!Directory.Exists(tmpPath)) { Directory.CreateDirectory(tmpPath); } if (!Directory.Exists(tmpPathMinne)) { Directory.CreateDirectory(tmpPathMinne); } var leonResultsFelt = new List <string>(); var leonResultsBane = new List <string>(); MinneRegistration minnePerson = null; LeonPerson leonPerson = null; foreach (var finishedShooter in finishedShooters) { var allResultsForShooter = orionResults.Where(o => o.ShooterId == finishedShooter); leonPerson = leonPersons.SingleOrDefault(l => l.ShooterId == finishedShooter); if (minnePersons != null) { minnePerson = minnePersons.SingleOrDefault(l => l.ShooterId == finishedShooter); } int sumFelt = 0; int sumBane = 0; List <string> allFeltSeries = new List <string>(); List <string> allMinneSeries = new List <string>(); var allRanges = orionSetup.OrionViewModels.SelectMany(o => o.RangeViews).OrderBy(r => r.RangeId); ////foreach (var orion in orionSetup.OrionViewModels) ////{ foreach (var rangeViewModel in allRanges) { if (rangeViewModel.RangeType == RangeType.Shooting) { var resultForThisRange = CalculateOrionAndRange.GetResultForThisRange( allResultsForShooter, rangeViewModel.Parent, rangeViewModel); if (resultForThisRange == null) { if (rangeViewModel.ResultType == ResultType.Felt) { allFeltSeries.Add(string.Empty); } } else { if (resultForThisRange.ResultType == ResultType.Felt) { sumFelt += resultForThisRange.GetSum(); resultForThisRange.ValidSeries = resultForThisRange.CalculateValidSeriesForRange(rangeViewModel); allFeltSeries.AddRange(resultForThisRange.ValidSeries); } else if (resultForThisRange.ResultType == ResultType.Bane) { sumBane += resultForThisRange.GetSum(); foreach (var rawSerie in resultForThisRange.Series) { int len = rangeViewModel.CountingShoots; if (rawSerie.Length < rangeViewModel.CountingShoots) { len = rawSerie.Length; } string serieSingle = rawSerie.Substring(0, len); int slen = serieSingle.Length; while (slen < rangeViewModel.CountingShoots) { serieSingle = serieSingle + "0"; slen++; } allMinneSeries.Add(serieSingle); } } } } } ////} ////foreach (var orionResult in allResultsForShooter) ////{ //// if (orionResult.ResultType == ResultType.Felt) //// { //// sumFelt += orionResult.GetSum(); //// allFeltSeries.AddRange(orionResult.Series); //// } //// else if (orionResult.ResultType == ResultType.Bane) //// { //// sumBane += orionResult.GetSum(); //// allMinneSeries.AddRange(orionResult.Series); //// } ////} if (allFeltSeries.Any() && leonPerson != null) { var allShots = string.Join(";", allFeltSeries).ToUpper(); var leonLine = string.Format( "{0};{1};{2};{3};{4};{5};{6};{7};{8};", leonPerson.Range, leonPerson.Team, leonPerson.Target, leonPerson.ShooterId, leonPerson.Name, leonPerson.ClubName, leonPerson.Class, sumFelt, allShots); leonResultsFelt.Add(leonLine); } if (allMinneSeries.Any() && minnePerson != null) { var allShots = string.Join(";", allMinneSeries).ToUpper(); var leonLine = string.Format( "{0};{1};{2};{3};{4};{5};{6};{7};{8};", minnePerson.Range, minnePerson.Team, minnePerson.Target, minnePerson.ShooterId, minnePerson.Name, minnePerson.ClubName, minnePerson.Class, sumBane, allShots); leonResultsBane.Add(leonLine); } var finishedPerson = new FinishedPerson { Name = leonPerson.Name, ShooterId = leonPerson.ShooterId, Target = leonPerson.Target, Team = leonPerson.Team }; DatabaseApi.Save(finishedPerson); } lock (syncObject) { if (leonResultsFelt.Any()) { //var writefilenameTmp = Path.Combine(tmpPath, "WRITE"+ToLeonDataTmp); var filenameTmp = Path.Combine(tmpPath, ToLeonDataTmp); File.AppendAllLines(filenameTmp, leonResultsFelt, Encoding.GetEncoding("ISO-8859-1")); //if (File.Exists(filenameTmp)) //{ // Log.Error("File alredy exsist deliting {0}", filenameTmp); // File.Delete(filenameTmp); //} //File.Move(writefilenameTmp, filenameTmp); } if (leonResultsBane.Any()) { //var writefilenameTmp = Path.Combine(tmpPathMinne, "WRITE"+ToLeonDataTmp); var filenameTmp = Path.Combine(tmpPathMinne, ToLeonDataTmp); File.AppendAllLines(filenameTmp, leonResultsBane, Encoding.GetEncoding("ISO-8859-1")); //if (File.Exists(filenameTmp)) //{ // Log.Error("File alredy exsist deliting {0}", filenameTmp); // File.Delete(filenameTmp); //} //File.Move(writefilenameTmp, filenameTmp); } } }