public void AddEventResults(EventResult eventResult) { var query = new List<EventResultDto>(); foreach (var result in eventResult.Results) { if (result.User.DateOfBirth.Equals(DateTime.MinValue)) { var dataObject = Tools.Serialize(result); Console.WriteLine(dataObject); Console.WriteLine(result.Time); Console.WriteLine("*******"); var tempResult = new TempResultDto { Data = dataObject, Registered = DateTime.Now, UserId = result.User.Id, EventId = eventResult.Event.Id }; _resultDataService.AddTempResult(tempResult); } else { var time = CalculateTime(result.Time); var eventResultDto = CreateEventResultDto(eventResult.Event, result, time); query.Add(eventResultDto); } } _resultDataService.AddEventResults(query); }
public void TestAddTempResult() { var tempResult = new TempResultDto { Data = "tttt", UserId = 1, Registered = DateTime.Now }; _dataService.AddTempResult(tempResult); }
public void DeleteTempResult(TempResultDto tempResult) { throw new NotImplementedException(); }
public void DeleteTempResult(TempResultDto tempResultDto) { var sql = "delete from wp_tempresults where id = @id"; var query = new Query { Sql = sql }; query.ParameterValues.Add(new Parameter("@id", tempResultDto.Id)); _sqlDirectService.RunCommand(query); }
public void AddTempResult(TempResultDto tempResultDto) { const string userTemplate = "Northernrunners.ImportLibrary.Resources.CreateTempResult.txt"; Query query; using (var stream = _assembly.GetManifestResourceStream(userTemplate)) { var sql = Tools.StreamToString(stream); query = new Query { Sql = sql }; } query.ParameterValues.Add(new Parameter("@userid", tempResultDto.UserId)); query.ParameterValues.Add(new Parameter("@registered", tempResultDto.Registered)); query.ParameterValues.Add(new Parameter("@data", tempResultDto.Data)); query.ParameterValues.Add(new Parameter("@eventid", tempResultDto.EventId)); _sqlDirectService.RunCommand(query); }
public void DeleteTempResult(TempResultDto tempResult) { _resultDataService.DeleteTempResult(tempResult); }