public async Task <string> GetRespondentsConfirmationRequest()
{
string userName = Request.Params["user"];
string password = Request.Params["password"];
var user = await db.Users.Where(u => (u.UserName == userName) && (u.Password == password)).Include("Groups.Respondents").FirstOrDefaultAsync();
string[] data = Request.Params["respondents"].Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < data.Length; i++)
{
string[] respondentData = data[i].Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
int serverId = int.Parse(respondentData[1]);
int clientId = int.Parse(respondentData[0]);
Respondent respondent = db.Respondents.First(r => r.Id == serverId);
if (respondent.IsModified)
{
respondent.ClientId = clientId;
respondent.IsModified = false;
db.Entry(respondent).State = EntityState.Modified;
}
}
//var ans = db.Groups.Include("Quizs");
await db.SaveChangesAsync();
return("Ok");
}
public async Task <ActionResult> Edit([Bind(Include = "Id,RespondentNumber,FirstName,LastName,IsModified,IsDeleted")] Respondent respondent)
{
if (ModelState.IsValid)
{
respondent.IsModified = true;
db.Entry(respondent).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index", "Groups"));
}
return(View(respondent));
}
public IHttpActionResult PutGroup(int id, Group group)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != group.Id)
{
return(BadRequest());
}
db.Entry(group).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!GroupExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <ActionResult> Create([Bind(Include = "Id,GroupName,IsModified,IsDeleted")] Group group)
{
if (ModelState.IsValid)
{
User user = await db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefaultAsync();
group.IsModified = true;
user.Groups.Add(group);
db.Entry(user).State = EntityState.Modified;
db.Groups.Add(group);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(group));
}
public static string GetRespondentNumber(User user)
{
QuizzyContext db = new QuizzyContext();
string nextNumber = GetNextRespondentNumber(user.LastRespondentNumber);
user.LastRespondentNumber = nextNumber;
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return($"A{nextNumber[0]}B{nextNumber[1]}C{nextNumber[2]}D{nextNumber[3]}");
}
private async Task <ActionResult> AddQuiz(Quiz quiz)
{
if (ModelState.IsValid)
{
db.Entry(quiz).State = EntityState.Added;
quiz.AnswerText = Quiz.SerializeAnswers(quiz.Questions.ToList());
foreach (var q in quiz.Questions)
{
db.Entry(q).State = EntityState.Added;
foreach (var a in q.Answers)
{
db.Entry(a).State = EntityState.Added;
}
}
User user = await db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefaultAsync();
user.Quizs.Add(quiz);
db.Entry(user).State = EntityState.Modified;
db.Quizes.Add(quiz);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(quiz));
}