public async Task <IActionResult> PutGroup(long id, Group @group)
{
if (id != @group.Id)
{
return(BadRequest());
}
_context.Entry(@group).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!GroupExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public int deleteQuestion(int id)
{
QuestionModel tmp = db.SetQuestions.FirstOrDefault(u => u.Id == id);
using (GroupContext db2 = new GroupContext())
{
GroupModel item_tmp = db2.SetGroupModels.FirstOrDefault(u => u.QuestionID == tmp.Id);
DeleteQuota((int)item_tmp.ProjectID, (int)item_tmp.QuestionID);
if (tmp.TypeQuestion == Models.Question.Type.Table)
{
List <TableRow> table_row_list = db.SetTableRows.Where(u => u.TableID == tmp.Id).ToList();
db.SetTableRows.RemoveRange(table_row_list);
db.SaveChanges();
}
List <AnswerAll> answerAll_tmp = db.SetAnswerAll.Where(u => u.QuestionID == tmp.Id).ToList();
db.SetAnswerAll.RemoveRange(answerAll_tmp);
db.SetQuestions.Remove(tmp);
db.SaveChanges();
List <GroupModel> list_tmp = db2.SetGroupModels.Where(u => u.ProjectID == tmp.ProjectID && u.GroupID == item_tmp.GroupID && u.IndexQuestion > item_tmp.IndexQuestion).ToList();
if (list_tmp != null)
{
int index = 0;
foreach (var item in list_tmp)
{
item.IndexQuestion = item_tmp.IndexQuestion + index;
db2.Entry(item).State = EntityState.Modified;
db2.SaveChanges();
index++;
}
}
}
return(200);
}
public ActionResult Edit([Bind(Include = "Id,Group")] GroupModel groupModel)
{
if (ModelState.IsValid)
{
db.Entry(groupModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(groupModel));
}
public void RemoveStudentFromDB(Student student)
{
if (GroupContext.Students.Count(s => s.StudentId == student.StudentId) == 0)
{
throw new ArgumentException("Таких студентов нет!");
}
GroupContext = new GroupContext();
GroupContext.Entry(student).State = EntityState.Deleted;
GroupContext.SaveChanges();
}
public void RenameGroup(int id, string name)
{
System.Diagnostics.Debug.WriteLine("ID group --- " + id);
System.Diagnostics.Debug.WriteLine("Name group --- " + name);
GroupModel tmp = db.SetGroupModels.FirstOrDefault(u => u.Id == id);
if (tmp != null)
{
tmp.GroupName = name;
db.Entry(tmp).State = EntityState.Modified;
db.SaveChanges();
}
}
