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);
}