public async Task <IActionResult> Post([FromBody] Time time)
{
if (ModelState.IsValid)
{
_context.Times.Add(time);
await _context.SaveChangesAsync();
var result = _context.Times
.AsNoTracking()
.Select(c => new Time()
{
Id = c.Id,
NMTecnico = c.NMTecnico,
Pais = c.Pais,
Bandeira = c.Bandeira,
Jogadores = c.Jogadores.Select(j => new Jogador()
{
Id = j.Id,
Nome = j.Nome,
}).ToList()
}).Where(c => c.Id == time.Id).FirstOrDefaultAsync();
return(Created($"api/time/{time.Id}", result));
}
else
{
return(BadRequest(ModelState));
}
}
public async Task <IActionResult> Post([FromBody] Time time)
{
if (ModelState.IsValid)
{
_context.Times.Add(time);
await _context.SaveChangesAsync();
return(Created($"api/time/{time.Id}", time));
}
else
{
return(BadRequest(ModelState));
}
}
public static async Task Collect(ExcelWorksheet rawData, TimeContext ctx)
{
for (int row = 2; row <= rawData.Dimension.Rows; row++)
{
ctx.People.Add(new Employee
{
FirstName = rawData.ReadString(row, 2),
LastName = rawData.ReadString(row, 3),
Image = rawData.ReadString(row, 4),
Email = rawData.ReadString(row, 6),
Phone = rawData.ReadString(row, 7),
BirthDay = rawData.ReadDate(row, 8),
BeginDate = rawData.ReadDate(row, 9),
EndDate = rawData.ReadDate(row, 10),
Status = (EmployeeStatus)rawData.ReadInteger(row, 11),
Position = rawData.ReadString(row, 12)
});
ctx.Users.Add(new User
{
Name = rawData.ReadString(row, 2) + " " + rawData.ReadString(row, 3),
Role = rawData.ReadString(row, 14),
Username = rawData.ReadString(row, 4),
Password = "******"
});
}
await ctx.SaveChangesAsync();
}
public async Task <IActionResult> PutJogo([FromRoute] int id, [FromBody] Jogo jogo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (await _context.Jogos.AnyAsync(x => x.Id == id))
{
jogo.Id = id;
_context.Attach(jogo).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(NoContent());
}
return(NotFound());
}
public async Task <IActionResult> Put([FromRoute] int id, [FromBody] Ficha ficha)
{
if (!await _context.Fichas.AnyAsync(x => x.JogadorId == id))
{
return(NotFound());
}
ficha.JogadorId = id;
if (ModelState.IsValid)
{
_context.Fichas.Attach(ficha).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(Ok(ficha));
}
else
{
return(BadRequest(ModelState));
}
}
public static async Task Collect(ExcelWorksheet rawData, TimeContext ctx)
{
for (int row = 2; row <= rawData.Dimension.Rows; row++)
{
ctx.Teams.Add(new Team
{
Name = rawData.ReadString(row, 2),
Description = rawData.ReadString(row, 3)
});
}
await ctx.SaveChangesAsync();
}
public static async Task Collect(ExcelWorksheet rawData, TimeContext ctx)
{
for (int row = 2; row <= rawData.Dimension.Rows; row++)
{
ctx.Roles.Add(new Role
{
Name = rawData.ReadString(row, 2),
HourlyRate = rawData.ReadDecimal(row, 3),
MonthlyRate = rawData.ReadDecimal(row, 4)
});
}
await ctx.SaveChangesAsync();
}
public static async Task Collect(ExcelWorksheet rawData, TimeContext ctx)
{
for (int row = 2; row <= rawData.Dimension.Rows; row++)
{
ctx.Members.Add(new Member
{
Employee = await ctx.People.FindAsync(rawData.ReadInteger(row, 1)),
Team = await ctx.Teams.FindAsync(rawData.ReadInteger(row, 2)),
Role = await ctx.Roles.FindAsync(rawData.ReadInteger(row, 3)),
HoursWeekly = rawData.ReadInteger(row, 4)
});
}
await ctx.SaveChangesAsync();
}
public async Task <IActionResult> Post([FromBody] Gol gol)
{
if (ModelState.IsValid)
{
_context.Gols.Add(gol);
await _context.SaveChangesAsync();
await NotifyNewGoal(gol.Id);
return(Created($"api/gol/{gol.Id}", gol));
}
else
{
return(BadRequest(ModelState));
}
}
private async Task CheckInterval(TimeInterval interval, DateTime now, Func <DateTime, Task> publishAction)
{
if (IntervalHasPassed(_lastCheck[interval], now))
{
ExtendedConsole.Log($"{interval.ToString()} has passed!");
_lastCheck[interval].Last = now;
_context.TimeEvents.Add(new TimeEvent
{
Type = interval,
Created = now
});
await _context.SaveChangesAsync();
await publishAction(now);
}
}
public static async Task Collect(ExcelWorksheet rawData, TimeContext ctx)
{
for (int row = 2; row <= rawData.Dimension.Rows; row++)
{
ctx.Projects.Add(new Project
{
Name = rawData.ReadString(row, 3),
Description = rawData.ReadString(row, 4),
BeginDate = rawData.ReadDate(row, 5),
EndDate = rawData.ReadDate(row, 6),
Status = (ProjectStatus)rawData.ReadInteger(row, 7),
Customer = await ctx.Customers.FindAsync(rawData.ReadInteger(row, 8)),
Team = await ctx.Teams.FindAsync(rawData.ReadInteger(row, 9)),
Pricing = (Pricing)rawData.ReadInteger(row, 10),
Amount = rawData.ReadDecimal(row, 11)
});
}
await ctx.SaveChangesAsync();
}
public static async Task Collect(ExcelWorksheet rawData, TimeContext ctx)
{
for (int row = 2; row <= rawData.Dimension.Rows; row++)
{
Customer c = new Customer
{
Name = rawData.ReadString(row, 2),
Image = rawData.ReadString(row, 3),
Contact = rawData.ReadString(row, 4),
Email = rawData.ReadString(row, 5),
Phone = rawData.ReadString(row, 6),
Status = (CustomerStatus)rawData.ReadInteger(row, 10)
};
c.Address.Road = rawData.ReadString(row, 7);
c.Address.ZipCode = rawData.ReadString(row, 8);
c.Address.City = rawData.ReadString(row, 9);
c.Address.Country = rawData.ReadString(row, 9);
ctx.Customers.Add(c);
}
await ctx.SaveChangesAsync();
}
