public string Execute(IList <string> parameters)
{
if (parameters.Count < 3)
{
throw new ArgumentException("Invalid number of parameters.");
}
string firstName = parameters[0];
string lastName = parameters[1];
string username = parameters[2];
Student newStudent = new Student()
{
FirstName = firstName,
LastName = lastName,
Username = username
};
List <string> courseList = parameters.Skip(3).ToList();
foreach (string course in courseList)
{
var courseId = int.Parse(course);
newStudent.Courses.Add(context.Courses.First(x => x.Id == courseId));
}
context.Students.Add(newStudent);
context.SaveChanges();
int id = context.Students.OrderByDescending(s => s.Id).FirstOrDefault().Id;
return($"Created student with Username {username} and Id {id}.");
}
public string Execute(IList <string> parameters)
{
if (parameters.Count != 2)
{
throw new ArgumentException("Invalid number of parameters.");
}
int examId = 0;
if (!int.TryParse(parameters[0], out examId))
{
throw new ArgumentException("Invalid ExamId.");
}
Exam examToFind = context.Exams.Find(examId);
if (examToFind == null)
{
throw new ArgumentException("No exam with the provided ExamId fround in the DB.");
}
DateTime newDateTime;
var joinedDate = string.Join(" ", parameters.Skip(1));
if (!DateTime.TryParse(joinedDate, out newDateTime))
{
throw new ArgumentException("Invalid DateTime.");
}
examToFind.DateTime = newDateTime;
context.SaveChanges();
return($"Updated exam with Id {examId}'s DateTime to {newDateTime.ToString()}.");
}
private void InitDatabase()
{
JSONReader <Seat> seatsReader = new JSONReader <Seat>();
List <Seat> seats = seatsReader.ReadFile("../../App_Data/JSON_Data/Seats.json");
foreach (Seat seat in seats)
{
context.Seats.Add(seat);
}
JSONReader <Student> studentsReader = new JSONReader <Student>();
List <Student> students = studentsReader.ReadFile("../../App_Data/JSON_Data/Students.json");
foreach (Student student in students)
{
context.Students.Add(student);
}
XMLReader <Course> coursesReader = new XMLReader <Course>();
List <Course> courses = coursesReader.ReadFile("../../App_Data/XML_Data/Courses.xml");
foreach (Course course in courses)
{
context.Courses.Add(course);
foreach (Student student in students)
{
student.Courses.Add(course);
}
}
XMLReader <Exam> examsReader = new XMLReader <Exam>();
List <Exam> exams = examsReader.ReadFile("../../App_Data/XML_Data/Exams.xml");
foreach (Exam exam in exams)
{
context.Exams.Add(exam);
}
JSONReader <Hall> hallsReader = new JSONReader <Hall>();
List <Hall> halls = hallsReader.ReadFile("../../App_Data/JSON_Data/Halls.json");
foreach (Hall hall in halls)
{
context.Halls.Add(hall);
}
context.SaveChanges();
}
public string Execute(IList <string> parameters)
{
if (parameters.Count != 1)
{
throw new ArgumentException("Invalid number of parameters.");
}
int id = 0;
if (!int.TryParse(parameters[0], out id))
{
throw new ArgumentException("Invalid StudentId.");
}
var delSt = context.Students.First(st => st.Id == id);
context.Students.Remove(delSt);
context.SaveChanges();
return($"Deleted student with Username {delSt.Username} and Id {id}.");
}
