public IHttpActionResult PostEnroll(EnrollDTO enroll) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { bizEnroll.createEnroll(enroll); } catch (DbUpdateException) { if (EnrollExists(enroll.StudentId)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = enroll.StudentId }, enroll)); }
public IHttpActionResult PutEnroll(string query, EnrollDTO enroll) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (query != enroll.StudentId + enroll.ClassId) { return(BadRequest()); } try { bizEnroll.updateEnroll(enroll); } catch (DbUpdateConcurrencyException) { if (!EnrollExists(query)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public void importData(string path) { using (var db = new ProjectDbContext()) { StreamReader streamCsv = new StreamReader(path); string csvDataLine = ""; string[] data = null; var lineHeader = streamCsv.ReadLine(); while ((csvDataLine = streamCsv.ReadLine()) != null) { data = csvDataLine.Split(','); var newEnreoll = new EnrollDTO { StudentId = data[0], ClassId = data[1], Passed = Convert.ToInt32(data[2]), Hw1Grade = Convert.ToDouble(data[3]), Hw2Grade = Convert.ToDouble(data[4]), Hw3Grade = Convert.ToDouble(data[5]), Hw4Grade = Convert.ToDouble(data[6]), Hw5Grade = Convert.ToDouble(data[7]), ExamGrade = data[8] }; var dto = DTOEFMapper.GetEntityFromDTO(newEnreoll); db.Enrolls.Add(dto); db.SaveChanges(); } } }
public void createEnroll(EnrollDTO newEnroll) { using (var db = new ProjectDbContext()) { var enroll = DTOEFMapper.GetEntityFromDTO(newEnroll); db.Enrolls.Add(enroll); db.SaveChanges(); } }
public void updateEnroll(EnrollDTO updateEnroll) { using (var db = new ProjectDbContext()) { var student = db.Enrolls.Where(x => x.StudentId + x.ClassId == updateEnroll.StudentId + updateEnroll.ClassId).FirstOrDefault(); if (student != null) { db.Entry(student).CurrentValues.SetValues(updateEnroll); db.SaveChanges(); } } }
public IHttpActionResult DeleteEnroll(string id) { EnrollDTO enroll = bizEnroll.findById(id); if (enroll == null) { return(NotFound()); } bizEnroll.deleteEnroll(id); return(Ok(enroll)); }