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