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));
}
}