public async Task <IActionResult> DeleteFromProjectJury(int id, string VkId)
{
Project Project = await db.Projects.Where(p => p.ProjectId == id).FirstAsync();
User User = await db.Users.Where(u => u.VkId == int.Parse(VkId)).FirstAsync();
ProjectJury PJ = await db.ProjectJury.Where(p => p.ProjectId == id).Where(u => u.User == User).FirstAsync();
db.ProjectJury.Remove(PJ);
List <Mark> Marks = await db.Marks.Where(t => t.Team.ProjectId == id).Where(u => u.User == User).ToListAsync();
foreach (Mark m in Marks)
{
db.Marks.Remove(m);
}
db.SaveChanges();
return(Ok());
}
public async Task <IActionResult> AddInProjectJury(int id, string VkId)
{
Project Project = await db.Projects.Where(p => p.ProjectId == id).FirstAsync();
User User = await db.Users.Where(u => u.VkId == int.Parse(VkId)).FirstAsync();
ProjectJury PJ = new ProjectJury();
PJ.Project = Project;
PJ.ProjectId = Project.ProjectId;
PJ.User = User;
PJ.UserId = User.UserId;
db.ProjectJury.Add(PJ);
List <Team> Teams = await db.Teams.Where(p => p.ProjectId == id).ToListAsync();
List <Mark> Marks = await db.Marks.Where(t => t.Team.ProjectId == id).Where(u => u.User == null).ToListAsync();
foreach (Mark m in Marks)
{
if (m.Name != "Оценки студентов")
{
Mark NewMark = new Mark {
MaxPoints = m.MaxPoints,
Name = m.Name,
Team = m.Team,
Points = m.Points,
User = User,
};
await db.Marks.AddAsync(NewMark);
}
}
db.SaveChanges();
return(Ok());
}
