public HttpResponseMessage Put(int id, [FromBody] Student student) { try { using (StudentsDBEntities db = new StudentsDBEntities()) { var _student = db.Students.FirstOrDefault(s => s.Id == id); if (_student == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student with Id " + id.ToString() + " not found to edit.")); } else { _student.FirstName = student.FirstName; _student.LastName = student.LastName; _student.Birthday = student.Birthday; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, _student)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage PUT([FromBody] int id, Student student) { try { using (StudentsDBEntities entities = new StudentsDBEntities()) { var entity = entities.Students.FirstOrDefault(e => e.ID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student with Id = " + id.ToString() + " not found to update")); } else { entity.FirstName = student.FirstName; entity.LastName = student.LastName; entity.Gender = student.Gender; entity.YearAdmitted = student.YearAdmitted; entity.Class = student.Class; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Delete(int id) { try { using (StudentsDBEntities db = new StudentsDBEntities()) { var student = db.Students.FirstOrDefault(s => s.Id == id); if (student == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student with Id " + id + " not found to delete.")); } else { db.Students.Remove(student); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult Create([Bind(Exclude = "Id")] Student studentToCreate) { if (!ModelState.IsValid) { return(View()); } _db.Students.Add(studentToCreate); _db.SaveChanges(); return(RedirectToAction("Details/" + studentToCreate.Id)); }
private void EdytujStudentaBtn_Click(object sender, RoutedEventArgs e) { StudentsDBEntities SDE = new StudentsDBEntities(); var ST = SDE.StudentsTable.Where(p => p.Id == row.Id).FirstOrDefault(); ST.StudentName = ImieTb.Text; ST.StudentSurname = NazwiskoTb.Text; ST.DateOfBirt = DataDp.SelectedDate.Value; SDE.SaveChanges(); DialogResult = true; }
public IHttpActionResult Delete(int id) { using (StudentsDBEntities ctx = new StudentsDBEntities()) { var studentToDelete = ctx.Students.FirstOrDefault(s => s.ID == id); var gradesAndCourses = from studentCourses in ctx.StudentCourses where studentCourses.StudentID == id select studentCourses; foreach (StudentCourses element in gradesAndCourses) { ctx.StudentCourses.Remove(element); } ctx.Students.Remove(studentToDelete); return(Ok(ctx.SaveChanges())); } }
public IHttpActionResult Post([FromBody] Students student) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } using (StudentsDBEntities ctx = new StudentsDBEntities()) { var maxId = ctx.Students.ToList().Select(s => s).Max(x => x.ID); student.ID = maxId + 1; ctx.Students.Add(student); return(Ok(ctx.SaveChanges())); } }
public IHttpActionResult Put([FromBody] Courses course, int id) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } using (StudentsDBEntities ctx = new StudentsDBEntities()) { var courseToEdit = ctx.Courses.FirstOrDefault(c => c.ID == id); courseToEdit.Name = course.Name; courseToEdit.DayLength = course.DayLength; return(Ok(ctx.SaveChanges())); } }
private void DodajOceneBtn_Click(object sender, RoutedEventArgs e) { StudentsDBEntities SDE = new StudentsDBEntities(); AssessmentsTable AT = new AssessmentsTable(); var checkedAssessment = OcenySp.Children.OfType <RadioButton>() .FirstOrDefault(r => r.IsChecked.HasValue && r.IsChecked.Value); var checkedSubject = PrzedmiotySp.Children.OfType <RadioButton>() .FirstOrDefault(r => r.IsChecked.HasValue && r.IsChecked.Value); AT.Assessment = Decimal.Parse(checkedAssessment.Content.ToString().Replace(".", ",")); AT.IndeksID = indeksId; AT.Subjects = checkedSubject.Content.ToString(); SDE.AssessmentsTable.Add(AT); SDE.SaveChanges(); DialogResult = true; }
public IHttpActionResult Put([FromBody] Grades grade, int id) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } using (StudentsDBEntities ctx = new StudentsDBEntities()) { var gradeToEdit = ctx.Grades.FirstOrDefault(g => g.ID == id); gradeToEdit.LetterEquivalent = grade.LetterEquivalent; gradeToEdit.NumberEquivalent = grade.NumberEquivalent; return(Ok(ctx.SaveChanges())); } }
public IHttpActionResult Put([FromBody] Students student, int id) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } using (StudentsDBEntities ctx = new StudentsDBEntities()) { var studentToEdit = ctx.Students.FirstOrDefault(s => s.ID == id); studentToEdit.Name = student.Name; studentToEdit.Surname = student.Surname; studentToEdit.City = student.City; studentToEdit.DateOfBirth = student.DateOfBirth; return(Ok(ctx.SaveChanges())); } }
public HttpResponseMessage Post([FromBody] Student student) { try { using (StudentsDBEntities entities = new StudentsDBEntities()) { entities.Students.Add(student); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, student); message.Headers.Location = new Uri(Request.RequestUri + student.ID.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
private void DodajStudentaBtn_Click(object sender, RoutedEventArgs e) { int id = Int32.Parse(IndeksTb.Text); StudentsDBEntities SDE = new StudentsDBEntities(); StudentsTable ST = new StudentsTable(); var czy_istnieje = SDE.StudentsTable.Where(p => p.Id == id).FirstOrDefault(); if (czy_istnieje == null) { ST.Id = Int32.Parse(IndeksTb.Text); ST.StudentName = ImieTb.Text; ST.StudentSurname = NazwiskoTb.Text; ST.DateOfBirt = DataDp.SelectedDate.Value; SDE.StudentsTable.Add(ST); SDE.SaveChanges(); } else { MessageBox.Show("Istnieje już taki student"); } DialogResult = true; }
public HttpResponseMessage Delete(int id) { try { using (StudentsDBEntities entities = new StudentsDBEntities()) { var entity = entities.Students.FirstOrDefault(e => e.ID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Student with Id = " + id.ToString() + " not found to delete")); } else { entities.Students.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }