//UPDATED STUDENT PER COURSE static public List <Course> CourseById() { using (SchoolProject2Context db = new SchoolProject2Context()) { return(db.Courses.ToList()); } }
// READ static public List <Student> GetAllStudents() { using (SchoolProject2Context db = new SchoolProject2Context()) { return(db.Students.ToList()); } }
static public List <Trainer> GetAllTrainers() { using (SchoolProject2Context db = new SchoolProject2Context()) { return(db.Trainers.ToList()); } }
static public List <Assignment> GetAllAssignments() { using (SchoolProject2Context db = new SchoolProject2Context()) { return(db.Assignments.ToList()); } }
static public void AssingmnetPerCourse(int id) { using (SchoolProject2Context db = new SchoolProject2Context()) { Assignment assignment = db.Assignments.Find(id); List <Course> course = assignment.Courses.ToList(); } }
public static Student FindPassword(string Username) { using (SchoolProject2Context db = new SchoolProject2Context()) { var query = db.Students.Where(x => x.Username == Username).FirstOrDefault <Student>(); return(query); } }
//STUDENT PER COURSE UPDATED static public void StudentPerCourse(int id) { using (SchoolProject2Context db = new SchoolProject2Context()) { Student student = db.Students.Find(id); List <Course> course = student.Courses.ToList(); } }
static public void TrainerPerCourse(int id) { using (SchoolProject2Context db = new SchoolProject2Context()) { Trainer trainer = db.Trainers.Find(id); List <Course> course = trainer.Courses.ToList(); } }
static public void UpdateTrainer(int id, string firstname, string lastname, string subject) { using (SchoolProject2Context db = new SchoolProject2Context()) { Trainer TrainerToUpdate = db.Trainers.Find(id); TrainerToUpdate.FirstName = firstname; TrainerToUpdate.LastName = lastname; TrainerToUpdate.Subject = subject; db.SaveChanges(); } }
static public void UpdateAssignment(int id, string title, string description, DateTime submission, int oralmark, int totalmark) { using (SchoolProject2Context db = new SchoolProject2Context()) { Assignment AssignmentToUpdate = db.Assignments.Find(id); AssignmentToUpdate.Title = title; AssignmentToUpdate.Description = description; AssignmentToUpdate.OralMark = oralmark; AssignmentToUpdate.TotalMark = totalmark; db.SaveChanges(); } }
//UPDATE static public void UpdateStudent(int id, string firstname, string lastname, DateTime date_of_birth, decimal tuition_fees) { using (SchoolProject2Context db = new SchoolProject2Context()) { Student StudentToUpdate = db.Students.Find(id); StudentToUpdate.FirstName = firstname; StudentToUpdate.LastName = lastname; StudentToUpdate.DateOfBirth = date_of_birth; StudentToUpdate.TuitionFees = tuition_fees; db.SaveChanges(); } }
//DELETE static public void DeleteAssignment(int id) { using (SchoolProject2Context db = new SchoolProject2Context()) { Assignment AssignmentToDelete = db.Assignments.Find(id); if (AssignmentToDelete == null) { return; } db.Assignments.Remove(AssignmentToDelete); db.SaveChanges(); } }
static public void UpdateCourse(int id, string title, string stream, string type, DateTime startdate, DateTime enddate) { using (SchoolProject2Context db = new SchoolProject2Context()) { Course CourseToUpdate = db.Courses.Find(id); CourseToUpdate.Title = title; CourseToUpdate.Stream = stream; CourseToUpdate.Type = type; CourseToUpdate.StartDate = startdate; CourseToUpdate.EndDate = enddate; db.SaveChanges(); } }
//DELETE static public void DeleteCourse(int id) { using (SchoolProject2Context db = new SchoolProject2Context()) { Course CourseToDelete = db.Courses.Find(id); if (CourseToDelete == null) { return; } db.Courses.Remove(CourseToDelete); db.SaveChanges(); } }
//DELETE static public void DeleteTrainer(int id) { using (SchoolProject2Context db = new SchoolProject2Context()) { Trainer TrainerToDelete = db.Trainers.Find(id); if (TrainerToDelete == null) { return; } db.Trainers.Remove(TrainerToDelete); db.SaveChanges(); } }
public static void CreateAccount(int Id, string Username, string Password) { using (SchoolProject2Context db = new SchoolProject2Context()) { Student student = db.Students.Find(Id); if (student == null) { Console.WriteLine("Nothing."); return; } student.Username = Username; student.Password = Password; db.SaveChanges(); } }
static public int CreateTrainer(string firstname, string lastname, string subject) { Trainer trainer = new Trainer() { FirstName = firstname, LastName = lastname, Subject = subject, }; using (SchoolProject2Context db = new SchoolProject2Context()) { db.Trainers.Add(trainer); db.SaveChanges(); } return(trainer.Id); }
//CREATE static public int CreateStudent(string firstname, string lastname, DateTime date_of_birth, decimal tuition_fees) { Student student = new Student() { FirstName = firstname, LastName = lastname, DateOfBirth = date_of_birth, TuitionFees = tuition_fees }; using (SchoolProject2Context db = new SchoolProject2Context()) { db.Students.Add(student); db.SaveChanges(); } return(student.Id); }
static public int CreateAssignment(string title, string description, DateTime submission, int oralmark, int totalmark) { Assignment assignment = new Assignment() { Title = title, Description = description, SubmissionDateAndTime = submission, OralMark = oralmark, TotalMark = totalmark, }; using (SchoolProject2Context db = new SchoolProject2Context()) { db.Assignments.Add(assignment); db.SaveChanges(); } return(assignment.Id); }
static public int CreateCourse(string title, string stream, string type, DateTime startdate, DateTime enddate) { Course course = new Course() { Title = title, Stream = stream, Type = type, StartDate = startdate, EndDate = enddate }; using (SchoolProject2Context db = new SchoolProject2Context()) { db.Courses.Add(course); db.SaveChanges(); } return(course.Id); }