public HttpResponseMessage CreateStudent([FromBody] StudentDTO newStudent) { using (var context = new CEISSContext()) { try { context.Students.Add(new Student { BirthDate = newStudent.BirthDate, Email = newStudent.Email, CreationDate = DateTime.UtcNow, CareerID = newStudent.CareerID, Cellphone = newStudent.Cellphone, FirstName = newStudent.FirstName, SecondName = newStudent.SecondName, FirstLastName = newStudent.FirstLastName, SecondLastName = newStudent.SecondLastName, Phone = newStudent.Phone, }); context.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } } }
public HttpResponseMessage getStudentsByFirstName(string name) { using (var context = new CEISSContext()) { var Students = context.Students .Where(student => student.FirstName == name) .ToList(); /* * * Other ways to query the database: * * var Students_ = (from s in context.Students * where s.FirstName == name * select s).ToList(); * * var Students_ = (from s in context.Students * where s.FirstName == name * select s).ToList(); * * var _STUDENTS = context.Database.SqlQuery<Student>("SELECT * FROM USERS").ToList(); * */ return(Request.CreateResponse(HttpStatusCode.OK, Students)); } }
public HttpResponseMessage DeleteStudent([FromUri] int studentID) { using (var context = new CEISSContext()) { try { var StudentInDb = context.Students.Where(U => U.StudentID == studentID).FirstOrDefault(); if (StudentInDb != null) { context.Students.Remove(StudentInDb); context.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (Exception) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } } }
public HttpResponseMessage UpdateStudent([FromUri] int studentID, [FromBody] StudentDTO StudentChanges) { using (var context = new CEISSContext()) { try { var StudentInDb = context.Students.Where(U => U.StudentID == studentID).FirstOrDefault(); if (StudentInDb != null) { StudentInDb.BirthDate = StudentChanges.BirthDate; context.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (Exception) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } } }
public object GetCarreers() { using (var context = new CEISSContext()) { var results = context.Careers.Select(d => new { carreerID = d.CareerId, code = d.CareerCode, name = d.CareerName }).ToList(); if (results != null) { return(Request.CreateResponse(HttpStatusCode.OK, results)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } }
public object GetArticles(int page) { using (var context = new CEISSContext(false)) { int postPerPage = 6; page = page - 1; var Articles = context.Articles .OrderByDescending(o => o.PublishDate) .Skip(postPerPage * page) .Take(postPerPage) .Select(d => new { d.Title, d.Preview, d.PrimaryImage, author = new { name = d.Author.FirstName, lastname = d.Author.FirstLastName, } }).FirstOrDefault(); return(Articles); } }