public string ModStudent(Models2.Student s) { string odp = ""; try { var student = _context.Student.Where(stu => stu.IndexNumber == s.IndexNumber).ToList(); if (student.Count == 0) { //eskaUnik = 0; return("bad req"); } var stu = student[0]; _context.Entry(stu).CurrentValues.SetValues(s);//połowocznie działa ale popraw _context.Entry(stu).State = EntityState.Modified; _context.SaveChanges(); odp = "zmodyfikowano studenta o idndeksie =" + s.IndexNumber; } catch (Exception exc) { odp = "Wystapil blad transakcji"; } return(odp); }
public IActionResult updateStudent(Models2.Student student) { var db = new Models2.s19278Context(); var st = db.Student.Where(e => e.IndexNumber == student.IndexNumber); if (!st.Any()) { return(NotFound()); } if (student.LastName != null) { st.FirstOrDefault().LastName = student.LastName; } if (student.FirstName != null) { st.FirstOrDefault().FirstName = student.FirstName; } if (student.BirthDate != null) { st.FirstOrDefault().BirthDate = student.BirthDate; } if (student.IdEnrollment != 0) { st.FirstOrDefault().IdEnrollment = student.IdEnrollment; } db.SaveChanges(); return(Ok()); }
public string EnrollStudent(Models.Student s) { if (!(_context.Studies.Any(st => st.Name == s.Studies))) { return("Nie ma takich studiow"); } if ((_context.Student.Any(st => st.IndexNumber == s.IndexNumber))) { // JEST TAKI INDEX return("Nie jest to unikalny index"); } var s2 = new Models2.Student() { IndexNumber = s.IndexNumber, FirstName = s.FirstName, LastName = s.LastName, BirthDate = DateTime.Parse(s.BirthDate) }; //var result = _context.Studies.Where(stu => stu.Name == s.Studies).; var study = _context.Studies.Where(stu => stu.Name == s.Studies).FirstOrDefault(); int idStudy = study.IdStudy; if (!(_context.Enrollment.Any(en => en.IdStudy == idStudy && en.Semester == 1 && en.StartDate.Date == DateTime.Now.Date))) { var setStudent = new HashSet <Student> { s2 }; var enroll = new Models2.Enrollment() { IdEnrollment = _context.Enrollment.Select(en => en.IdEnrollment).Max() + 1, Semester = 1, StartDate = DateTime.Now.Date, Student = setStudent, }; study.Enrollment.Add(enroll); _context.Add(enroll); _context.Attach(study); _context.Entry(study).State = EntityState.Modified; _context.SaveChanges(); return("Utworzono enrollment i student"); } else { var enroll = _context.Enrollment.Where(en => en.IdStudy == idStudy && en.Semester == 1 && en.StartDate.Date == DateTime.Now.Date).FirstOrDefault(); enroll.Student.Add(s2); _context.Attach(enroll); _context.Entry(enroll).State = EntityState.Modified; _context.SaveChanges(); return("Utworzono student"); } }
public bool ModifyStudents(Models2.Student s) { try { _context.Attach(s); _context.Entry(s).State = EntityState.Modified; _context.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public IActionResult ModStudent(Models2.Student s) { Student stu = s; var operacja = _context.ModStudent(stu); if (operacja == "bad req") { return(BadRequest("nie ma takiej eski")); } else if (operacja == "Wystapil blad transakcji") { return(BadRequest(operacja)); } return(Ok(operacja)); }
public bool DeleteStudents(Models2.Student d) { try { /*var d = new Student * { * IndexNumber = index * };*/ _context.Attach(d); _context.Remove(d); _context.SaveChanges(); return(true); }catch (Exception e) { return(false); } }
public IActionResult updateStudent(Models2.Student student) { return(Ok(_dbService.updateStudent(student))); }
public string EnrollStudent(Models.Student s) { int eskaUnik = 1; var student = new Student(); var studia = _context.Studies.Where(stu => stu.Name == s.Studies).ToList(); if (studia.Count == 0) { return("nie ma takiego kierunku"); } var unikId = _context.Student.Where(stu => stu.IndexNumber == s.IndexNumber).ToList(); if (unikId.Count != 0) { eskaUnik = 0; student = unikId[0]; } var stud = new Models2.Student() { IndexNumber = s.IndexNumber, FirstName = s.FirstName, LastName = s.LastName, BirthDate = DateTime.Parse(s.BirthDate) }; var study = _context.Studies.Where(stu => stu.Name == s.Studies).FirstOrDefault(); int idStudy = study.IdStudy; if ((!(_context.Enrollment.Any(enrl => enrl.IdStudy == idStudy && enrl.Semester == 1 && enrl.StartDate.Date == DateTime.Now.Date)))) { if (eskaUnik == 1) { var setStudent = new HashSet <Student> { stud }; var enroll = new Models2.Enrollment() { IdEnrollment = _context.Enrollment.Select(en => en.IdEnrollment).Max() + 1, Semester = 1, StartDate = DateTime.Now.Date, Student = setStudent, }; study.Enrollment.Add(enroll); _context.Add(enroll); _context.Attach(study); _context.Entry(study).State = EntityState.Modified; _context.SaveChanges(); return("dodano nowego studenta i nowy enroll"); } else { var setStudent = new HashSet <Student> { student }; var enroll = new Models2.Enrollment() { IdEnrollment = _context.Enrollment.Select(en => en.IdEnrollment).Max() + 1, Semester = 1, StartDate = DateTime.Now.Date, Student = setStudent, }; study.Enrollment.Add(enroll); _context.Add(enroll); _context.Attach(study); _context.Entry(study).State = EntityState.Modified; _context.SaveChanges(); return("zapisano studenta na nowy enroll"); } } else { if (eskaUnik == 1) { var enroll = _context.Enrollment.Where(en => en.IdStudy == idStudy && en.Semester == 1 && en.StartDate.Date == DateTime.Now.Date).FirstOrDefault(); enroll.Student.Add(stud); _context.Attach(study); _context.Entry(study).State = EntityState.Modified; _context.SaveChanges(); return("dodano nowego studenta na instniejacy enroll"); } else { var enroll = _context.Enrollment.Where(en => en.IdStudy == idStudy && en.Semester == 1 && en.StartDate.Date == DateTime.Now.Date).FirstOrDefault(); enroll.Student.Add(student); _context.Attach(study); _context.Entry(study).State = EntityState.Modified; _context.SaveChanges(); return("dodano studenta na instniejacy enroll"); } } }
public IActionResult updateStudent(Models2.Student student) { throw new NotImplementedException(); }