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) { }