public Student ModifyStudent(string id, string name, string surname, DateTime data) { var db = new s19461Context(); var student = db.Student.SingleOrDefault(x => x.IndexNumber == id); if (name != null && student != null) { student.FirstName = name; } if (surname != null && student != null) { student.LastName = surname; } if (data != null && student != null) { student.BirthDate = data; } db.SaveChanges(); return(student); }
public Response EnrollStudent(EnrollStudentRequest request) { var db = new s19461Context(); using (var dbTran = db.Database.BeginTransaction()) { try { var idStudies = db.Studies.SingleOrDefault(x => x.Name == request.Studies); if (idStudies == null) { throw new Exception(); } if (db.Enrollment.Where(x => x.Semester == 1) .SingleOrDefault(x => x.IdStudy == idStudies.IdStudy) == null) { db.Enrollment.Add(new Enrollment { IdEnrollment = db.Enrollment.Max(x => x.IdEnrollment) + 1, Semester = 1, IdStudy = idStudies.IdStudy, StartDate = DateTime.Now }); } db.Student.Add(new Student { IndexNumber = request.IndexNumber, FirstName = request.FirstName, LastName = request.LastName, BirthDate = request.BirthDate, IdEnrollment = db.Enrollment.Where(x => x.Semester == 1) .Where(x => x.IdStudy == idStudies.IdStudy) .Select(x => x.IdEnrollment).First() }); db.SaveChanges(); dbTran.Commit(); return(db.Enrollment.Where(x => x.Semester == 1) .Where(x => x.IdStudy == idStudies.IdStudy).Select(x => new Response { IdEnrollment = x.IdEnrollment, IdStudy = x.IdStudy, Semester = x.Semester, StartDate = x.StartDate }).First()); } catch (Exception) { dbTran.Rollback(); return(null); } } }
public Student DeleteStudent(string id) { var db = new s19461Context(); var student = db.Student.SingleOrDefault(x => x.IndexNumber == id); if (student != null) { db.Remove(student); } db.SaveChanges(); return(student); }
public IEnumerable <Response> PromoteStudent(PromoteStudentsRequests psrequest) { var db = new s19461Context(); var responsesList = new List <Response>(); var study = db.Studies.Where(s => s.Name == psrequest.Studies).FirstOrDefault(); var enrollment = db.Enrollment.Where(e => e.Semester == psrequest.Semester && e.IdStudy == study.IdStudy).First(); var newEnrollment = db.Enrollment.Where(e => e.Semester == psrequest.Semester + 1 && e.IdStudy == study.IdStudy).FirstOrDefault(); var newIdEnrollment = db.Enrollment.Max(e => e.IdEnrollment) + 1; if (newEnrollment == null) { db.Enrollment.Add(new Enrollment { IdEnrollment = newIdEnrollment, Semester = psrequest.Semester + 1, IdStudy = study.IdStudy, StartDate = DateTime.Now }); newEnrollment = db.Enrollment.Where(e => e.Semester == psrequest.Semester + 1 && e.IdStudy == study.IdStudy).FirstOrDefault(); } var studentsList = db.Student.Where(student => student.IdEnrollment == enrollment.IdEnrollment).ToList(); foreach (var student in studentsList) { student.IdEnrollment = newEnrollment.IdEnrollment; } var psresponse = new Response { IdEnrollment = newEnrollment.IdEnrollment, Semester = psrequest.Semester + 1, IdStudy = study.IdStudy, StartDate = DateTime.Now }; responsesList.Add(psresponse); return(responsesList); }
public IEnumerable <Student> GetStudents() { var db = new s19461Context(); return(db.Student.ToList()); }
public Entity_SqlServerDbService(s19461Context context) { _dbContext = context; }