public HttpStatusCodeResult Grade(GradingViewModel form) { var teacher = db.Teachers.Find(HttpContext.User.Identity.GetUserId <int>()); var grading = db.Gradings.Add(new Grading { Grade = form.grade, Date = DateTime.Now, Feedback = form.feedback, Teacher_Id = teacher.Id }); db.SaveChanges(); var sub = db.Submissions.Find(form.sub_id); var name = sub.Student.User.FullName; sub.Grading_Id = grading.Id; db.SaveChanges(); var msg = String.Format("Satte betyget ({0}) på '{1}'s inlämning", form.grade, name); return(new HttpStatusCodeResult(200, msg)); }
private GradingViewModel GetGradingById(int headerId) { var responseData = new GradingViewModel(); using (SqlConnection connection = new SqlConnection(ConnectionString)) { var query = $"select Header_ID, Schedule_ID, Header_Name, Exam_ID from EvalForms_Headers where Header_ID = {headerId}"; using (var da = new SqlDataAdapter(query, connection)) { var tblPromotion = new DataTable(); try { connection.Open(); da.Fill(tblPromotion); if (tblPromotion.Rows.Count != 0) { for (var i = 0; i < tblPromotion.Rows.Count; i++) { var data = tblPromotion.Rows[i]; responseData = new GradingViewModel { GradingId = data.Field <int>("Header_ID"), GradingName = data.Field <string>("Header_Name"), ScheduleId = data.Field <int>("Schedule_ID"), ExamId = data.Field <int>("Exam_ID") }; } } } catch (Exception e) { Console.WriteLine(e); throw; } } } return(responseData); }