public void Update(ClassDTO classDto)
{
_db = new StudentDbEntities();
Class c = _db.Classes.First(p => p.Id == classDto.Id);
c.Name = classDto.Name;
c.Code = classDto.Code;
_db.SaveChanges();
}
public void Save(ClassDTO classDto)
{
_db = new StudentDbEntities();
Class c = new Class();
c.Id = GetMaxId();
c.Name = classDto.Name;
c.Code = classDto.Code;
_db.Classes.Add(c);
_db.SaveChanges();
}
public ClassDTO GetById(int classId)
{
_db = new StudentDbEntities();
var classDto = new ClassDTO();
Class c = _db.Classes.First(p => p.Id == classId);
classDto.Id = c.Id;
classDto.Name = c.Name;
classDto.Code = c.Code;
return classDto;
}
public ActionResult Create(Class c)
{
if (ModelState.IsValid)
{
var classDto = new ClassDTO {Name = c.Name, Code = c.Code};
_classBus.Save(classDto);
return RedirectToAction("Index");
}
return View(c);
}
public List<ClassDTO> GetList()
{
_db = new StudentDbEntities();
var list = _db.Classes.ToList();
var listDto = new List<ClassDTO>();
foreach (var @class in list)
{
var classDto = new ClassDTO {Id = @class.Id, Name = @class.Name, Code = @class.Code};
var listStudentDto = new List<StudentDTO>();
foreach (var student in @class.Students)
{
var studentDto = new StudentDTO {Id = student.Id, Name = student.Name};
var classDal = new ClassDAL();
studentDto.Class = classDal.GetById(student.ClassId);
if (student.Mark1 != null) studentDto.Mark1 = (double) student.Mark1;
if (student.Mark2 != null) studentDto.Mark2 = (double) student.Mark2;
if (student.Mark3 != null) studentDto.Mark3 = (double) student.Mark3;
listStudentDto.Add(studentDto);
}
classDto.Students = listStudentDto;
listDto.Add(classDto);
}
return listDto;
}
public void Update(ClassDTO classDto)
{
_classDal = new ClassDAL();
_classDal.Update(classDto);
}
public Class(ClassDTO classDto)
{
this.Id = classDto.Id;
this.Name = classDto.Name;
this.Code = classDto.Code;
}
public ActionResult Edit(Class c)
{
if (ModelState.IsValid)
{
var classDto = new ClassDTO {Id = c.Id, Name = c.Name, Code = c.Code};
_classBus.Update(classDto);
return RedirectToAction("Index");
}
return View(c);
}