/// <summary>
/// Get all football players
/// </summary>
/// <param name="dbContext"></param>
/// <returns></returns>
public async Task<List<Event>> GetAsync(DbContext dbContext)
{
var collection = dbContext.database.GetCollection<Event>(typeof(Event).Name);
var filter = Builders<Event>.Filter.Empty;
var events = await collection.FindAsync(filter).ConfigureAwait(false);
return await events.ToListAsync();
}
/// <summary>
/// Updates a property of an event
/// </summary>
/// <param name="context"></param>
public async Task UpdateAsync(DbContext dbContext, string id, string property, object newValue)
{
var teamEvent = dbContext.database.GetCollection<Event>("Event");
var filter = Builders<Event>.Filter.Eq("_id", ObjectId.Parse(id));
var update = Builders<Event>.Update.Set(property, newValue);
await teamEvent.UpdateOneAsync(filter, update).ConfigureAwait(false);
}
/// <summary>
/// Get event by id
/// </summary>
/// <param name="dbContext"></param>
/// <param name="id"></param>
/// <returns></returns>
public async Task<Event> GetAsync(DbContext dbContext, string id)
{
var collection = dbContext.database.GetCollection<Event>(typeof(Event).Name);
var filter = Builders<Event>.Filter.Eq("_id", ObjectId.Parse(id));
var player = await collection.FindAsync(filter).ConfigureAwait(false);
return await player.FirstOrDefaultAsync();
}
public async Task<IEnumerable<FootballPlayer>> GetAsync()
{
try
{
var dbContext = new DbContext();
var playersRepository = new FootballPlayersRepository();
return await playersRepository.GetAsync(dbContext);
}
catch (Exception ex)
{
_logger.LogError("Error occured: {0}", ex);
return null;
}
}
/// <summary>
/// Removes an event from db
/// </summary>
/// <param name="dbContext"></param>
/// <param name="id"></param>
/// <returns></returns>
public async Task<bool> RemoveAsync(DbContext dbContext, string id)
{
var filter = Builders<Event>.Filter.Eq("_id", ObjectId.Parse(id));
var collection = dbContext.database.GetCollection<Event>(typeof(Event).Name);
var myevent = await collection.DeleteOneAsync(filter).ConfigureAwait(false);
if (myevent.DeletedCount == 1)
{
return true;
}
else
{
return false;
}
}
public async Task<IEnumerable<Event>> GetAsync()
{
try
{
var dbContext = new DbContext();
var eventsRepository = new EventsRepository();
return await eventsRepository.GetAsync(dbContext);
}
catch (Exception ex)
{
_logger.LogError("Error occured: {0}", ex);
return null;
}
}
public async Task<Dictionary<string, int>> GetFootballplayersAssignment()
{
try
{
var dbContext = new DbContext();
var playersService = new FootballPlayersService();
var result = await playersService.PositionAssignmentAsync(dbContext);
return result;
}
catch (Exception ex)
{
_logger.LogError("Error occured: {0}", ex);
return null;
}
}
public async Task PostAsync([FromBody]dynamic data)
{
try
{
var newEvent = new Event();
newEvent.Name = data["Name"].ToString();
newEvent.StartTime = data["StartTime"];
newEvent.Type = data["Type"];
var dbContext = new DbContext();
await newEvent.InsertAsync(dbContext);
}
catch (Exception ex)
{
_logger.LogError("Error occured: {0}", ex);
}
}
public async Task Put(string id, [FromBody]dynamic data)
{
try
{
var dbContext = new DbContext();
var eventsRepository = new EventsRepository();
var myEvent = await eventsRepository.GetAsync(dbContext, id);
JValue newName = (JValue)data["Name"];
if (!string.IsNullOrEmpty(newName?.ToString()))
{
await eventsRepository.UpdateAsync(dbContext, id, "Name", newName.ToString());
}
JValue newType = (JValue)data["Type"];
int typeResult = 0;
if (int.TryParse(newType?.ToString(), out typeResult))
{
await eventsRepository.UpdateAsync(dbContext, id, "Type", typeResult.ToString());
}
JValue newStartTime = (JValue)data["startsAt"];
DateTime newTime;
if (DateTime.TryParse(newStartTime?.ToString("yyyy'-'MM'-'dd'T'HH':'mm':'ss'.'fff'Z'"), out newTime))
{
await eventsRepository.UpdateAsync(dbContext, id, "StartTime", newTime);
}
}
catch (Exception ex)
{
_logger.LogError("Error occured: {0}", ex);
}
}
public async Task<int> GetCountPlayersAsync([FromQuery] bool active)
{
try
{
var dbContext = new DbContext();
var playersRepository = new FootballPlayersRepository();
if (active)
{
return await playersRepository.GetCountActiveAsync(dbContext);
}
else
{
return await playersRepository.GetCountAsync(dbContext);
}
}
catch (Exception ex)
{
_logger.LogError("Error occured: {0}", ex);
return 0;
}
}
public async Task PostAsync([FromBody]dynamic data)
{
try
{
JValue firstname = (JValue)data["Firstname"];
JValue lastname = (JValue)data["Lastname"];
var newPlayer = new FootballPlayer();
newPlayer.Firstname = firstname.ToString();
newPlayer.Lastname = lastname.ToString();
var dbContext = new DbContext();
await newPlayer.SaveAsync(dbContext);
}
catch (Exception ex)
{
_logger.LogError("Error occured: {0}", ex);
}
}
public async Task<IActionResult> UpdatePeriodsAsync(string id, [FromBody]dynamic data)
{
try
{
var dbContext = new DbContext();
var playersRepository = new FootballPlayersRepository();
var player = await playersRepository.GetAsync(dbContext, id);
if (player == null)
{
return HttpNotFound();
}
else
{
var array = ((JObject)data)["periods"];
List<PositionTimeperiod> list = new List<PositionTimeperiod>();
foreach (var item in array)
{
var positionPeriod = item.ToObject<PositionTimeperiod>();
list.Add(positionPeriod);
}
var updateResult = await playersRepository.Update(dbContext, id, list);
if (updateResult.IsModifiedCountAvailable && updateResult.ModifiedCount == 1)
{
return Ok();
}
return HttpBadRequest();
}
}
catch (Exception ex)
{
_logger.LogError("Error occured: {0}", ex);
return HttpBadRequest();
}
}
public async Task<IActionResult> UpdateAsync(string id)
{
try
{
string Column = Request.Headers["Column"];
string NewValue = Request.Headers["NewValue"];
if (Column == string.Empty || NewValue == string.Empty)
{
return HttpBadRequest();
}
var dbContext = new DbContext();
var playersRepository = new FootballPlayersRepository();
var updateResult = await playersRepository.Update(dbContext, id, Column, NewValue);
if (updateResult.IsModifiedCountAvailable && updateResult.ModifiedCount == 1)
{
return Ok();
}
else
{
return HttpNotFound();
}
}
catch (Exception ex)
{
_logger.LogError("Error occured: {0}", ex);
return HttpBadRequest();
}
}
/// <summary>
/// Speichert eine Zeitreihe in die Datenbank
/// </summary>
/// <param name="context"></param>
public async Task SaveAsync(DbContext dbContext)
{
var player = dbContext.database.GetCollection<FootballPlayer>("FootballPlayer");
await player.InsertOneAsync(this).ConfigureAwait(false);
}
public async Task<bool> DeleteAsync(string id)
{
try
{
var dbContext = new DbContext();
var eventsRepository = new EventsRepository();
return await eventsRepository.RemoveAsync(dbContext, id);
}
catch (Exception ex)
{
_logger.LogError("Error occured: {0}", ex);
return false;
}
}
/// <summary>
/// Speichert eine Zeitreihe in die Datenbank
/// </summary>
/// <param name="context"></param>
public async Task InsertAsync(DbContext dbContext)
{
var teamEvent = dbContext.database.GetCollection<Event>("Event");
await teamEvent.InsertOneAsync(this).ConfigureAwait(false);
}