public ActionResult Create(Submission formToInsert)
{
try
{
submission dalSubmission = new submission
{
submission_date = DateTime.Now,
work_id = formToInsert.work_id,
submission_content = formToInsert.submission_content,
editor_id = formToInsert.editor_id,
approved = false
};
// TODO: get userID
var currentUserIDbyEmail = (from u in dbContext.users
where u.email.Contains(formToInsert.submission_email)
select u.email).FirstOrDefault();
dalSubmission.submission_email = currentUserIDbyEmail; // user id
dbContext.submissions.InsertOnSubmit(dalSubmission);
dbContext.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult DeleteConfirmed(int id)
{
submission submission = db.submissions1.Find(id);
db.submissions1.Remove(submission);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,code")] submission submission)
{
if (ModelState.IsValid)
{
db.Entry(submission).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(submission));
}
public ActionResult SubmitCode([Bind(Include = "code")] submission submission)
{
if (ModelState.IsValid)
{
db.submissions1.Add(submission);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(submission));
}
public ActionResult getBid([FromBody] submission subbid)
{
/* string id = "Hello";*/
if (subbid.username == null)
{
submission stam = new submission {
username = "******", a_id = 1, time = DateTime.UtcNow
};
return(Json(stam, JsonRequestBehavior.AllowGet));
}
enterBid2DB(subbid);
return(Json("Success", JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
submission submission = db.submissions1.Find(id);
if (submission == null)
{
return(HttpNotFound());
}
return(View(submission));
}
public int SubmitCode(int problemId, int usrId, string userName, string code, int languageId)
{
int?assignmentId = (from probs in db.problems
where probs.problemId == problemId
select probs.assignmentId).FirstOrDefault();
int?teamId = (from team in db.teams
where team.assignmentId == assignmentId && team.userId == usrId
select team.teamId).FirstOrDefault();
// Check if user is in team
if (teamId == 0)
{
// Create a team
team newTeam = new team {
name = userName
};
db.team.Add(newTeam);
db.SaveChanges();
teamId = db.team.Max(x => x.id);
teams teamsEntry = new teams {
assignmentId = Convert.ToInt32(assignmentId), userId = usrId, teamId = Convert.ToInt32(teamId)
};
db.teams.Add(teamsEntry);
db.SaveChanges();
}
submission newSubmission = new submission {
code = code, problemId = problemId, languageId = languageId
};
db.submission.Add(newSubmission);
db.SaveChanges();
int submissionId = db.submission.Max(x => x.id);
submissions submissionEntry = new submissions {
submissionId = submissionId, teamId = Convert.ToInt32(teamId)
};
db.submissions.Add(submissionEntry);
db.SaveChanges();
return(submissionId);
}
public ActionResult Edit(Submission submissionToInsert)
{
try
{
submission dalSubmission = (from s in dbContext.submissions
where s.submission_id == submissionToInsert.submission_id
select s).FirstOrDefault();
dalSubmission.submission_date = DateTime.Now;
dalSubmission.submission_email = submissionToInsert.submission_email;
dalSubmission.work_id = submissionToInsert.work_id;
dalSubmission.submission_content = submissionToInsert.submission_content;
dalSubmission.editor_id = submissionToInsert.editor_id; // need to write methods to get all kinds of ids
dalSubmission.approved = false; // submit changes for approval
dbContext.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
var(submission, round) = e;
private void enterBid2DB(submission subb)
{
}
