public ActionResult <string> createEvaluation(int CourseCrn)
{
try
{
var evaluation = _context.Evaluations
.Where(c => c.CourseCrn == CourseCrn).FirstOrDefault();
if (evaluation == null)
{
Evaluation newEvaluation;
var sList = _context.CourseStudents
.Where(c => c.CourseCrn == CourseCrn)
.Select(c => c.StudentId);
Console.WriteLine("List:" + sList);
foreach (string student in sList)
{
var st = _context.Students
.Where(c => c.UserName == student)
.Select(c => new { c.FirstName, c.LastName, c.UserName })
.ToList();
newEvaluation = new Evaluation();
newEvaluation.StudentGroupName = _context.StudentGroup
.Where(c => c.StudentId == student && c.CourseCrn == CourseCrn)
.Select(c => c.GroupName)
.FirstOrDefault();
newEvaluation.StudentId = student;
newEvaluation.CourseCrn = CourseCrn;
newEvaluation.Grades = "";
newEvaluation.Comments = "";
newEvaluation.CourseName = _context.Courses
.Where(c => c.CourseCrn == CourseCrn)
.Select(c => c.CourseName)
.FirstOrDefault();
newEvaluation.Completed = false;
_context.Evaluations.Add(newEvaluation);
}
//Evaluation newEvaluation = new Evaluation();
_context.SaveChanges();
return(JsonConvert.SerializeObject("Created New Evaluations"));
}
return(JsonConvert.SerializeObject("You already created forms for this course."));
}
catch (Exception e)
{
}
return(JsonConvert.SerializeObject("Error"));
}
public ActionResult <string> createCourseStudent([FromBody] CourseStudent model)
{
try
{
CourseStudent newCourseStudent = new CourseStudent();
newCourseStudent.StudentId = model.StudentId;
newCourseStudent.CourseCrn = model.CourseCrn;
_context.CourseStudents.Add(newCourseStudent);
_context.SaveChanges();
return(JsonConvert.SerializeObject("Created New CourseStudent"));
}
catch (Exception e)
{
return(JsonConvert.SerializeObject(e.Message));
}
}
public ActionResult <string> createCourse([FromBody] CreateCourseViewModel model)
{
try
{
Course newCourse = new Course();
newCourse.CourseName = model.CourseName;
newCourse.CourseTerm = model.CourseTerm;
newCourse.CourseYear = model.CourseYear;
newCourse.InstructorId = model.InstructorId;
_context.Courses.Add(newCourse);
_context.SaveChanges();
return(JsonConvert.SerializeObject("Created New Course"));
}
catch (Exception e)
{
}
return(JsonConvert.SerializeObject("Error"));
}
public ActionResult <string> createEvaluation([FromBody] StudentGroup model)
{
try
{
StudentGroup newStudentGroup = new StudentGroup();
newStudentGroup.GroupName = model.GroupName;
newStudentGroup.StudentId = model.StudentId;
newStudentGroup.CourseCrn = model.CourseCrn;
newStudentGroup.Grade = model.Grade;
_context.StudentGroup.Add(newStudentGroup);
_context.SaveChanges();
return(JsonConvert.SerializeObject("Created New StudentGroup"));
}
catch (Exception e)
{
}
return(JsonConvert.SerializeObject("Error"));
}
public ActionResult <string> createEvaluation([FromBody] Grade model)
{
try
{
Grade newGrade = new Grade();
newGrade.GradeId = model.GradeId;
newGrade.Percentage = model.Percentage;
newGrade.StudentId = model.StudentId;
_context.Grades.Add(newGrade);
_context.SaveChanges();
return(JsonConvert.SerializeObject("Created New Grade"));
}
catch (Exception e)
{
}
return(JsonConvert.SerializeObject("Error"));
}
public ActionResult <string> createEvaluation([FromBody] Evaluation model)
{
try
{
Evaluation newEvaluation = new Evaluation();
newEvaluation.CourseCrn = model.CourseCrn;
newEvaluation.CourseTerm = model.CourseTerm;
newEvaluation.CourseYear = model.CourseYear;
newEvaluation.EvaluationId = model.EvaluationId;
newEvaluation.StudentGroupId = model.StudentGroupId;
_context.Evaluations.Add(newEvaluation);
_context.SaveChanges();
return(JsonConvert.SerializeObject("Created New Evaluation"));
}
catch (Exception e)
{
}
return(JsonConvert.SerializeObject("Error"));
}
