public Student(StudentDTO studentDto)
{
this.Id = studentDto.Id;
this.Name = studentDto.Name;
this.ClassId = studentDto.ClassId;
this.Class = new Class(studentDto.Class);
this.Mark1 = studentDto.Mark1;
this.Mark2 = studentDto.Mark2;
this.Mark3 = studentDto.Mark3;
}
public void Update(StudentDTO studentDto)
{
_db = new StudentDbEntities();
Student student = _db.Students.First(p => p.Id == studentDto.Id);
studentDto.Name = student.Name;
studentDto.ClassId = 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;
_db.SaveChanges();
}
public void Save(StudentDTO studentDto)
{
_db = new StudentDbEntities();
var student = new Student {Id = GetMaxId()};
student.Name = studentDto.Name;
student.ClassId = studentDto.ClassId;
student.Mark1 = (decimal?) studentDto.Mark1;
student.Mark2 = (decimal?) studentDto.Mark2;
student.Mark3 = (decimal?) studentDto.Mark3;
_db.Students.Add(student);
_db.SaveChanges();
}
public StudentDTO GetById(int studentId)
{
_db = new StudentDbEntities();
var studentDto = new StudentDTO();
Student student = _db.Students.First(p => p.Id == studentId);
studentDto.Id = student.Id;
studentDto.Name = student.Name;
studentDto.ClassId = student.ClassId;
studentDto.Class = new 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;
return studentDto;
}
public ActionResult Create(Student student)
{
if (ModelState.IsValid)
{
var studentDto = new StudentDTO
{
Name = student.Name,
ClassId = student.ClassId,
Mark1 = student.Mark1,
Mark2 = student.Mark2,
Mark3 = student.Mark3
};
_studentBus.Save(studentDto);
return RedirectToAction("Index");
}
return View(student);
}
public List<StudentDTO> GetList()
{
_db = new StudentDbEntities();
var list = _db.Students.ToList();
var listDto = new List<StudentDTO>();
foreach (var student in list)
{
StudentDTO studentDto = new StudentDTO();
studentDto.Id = student.Id;
studentDto.Name = student.Name;
studentDto.ClassId = 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;
studentDto.Class = new ClassDAL().GetById(student.ClassId);
studentDto.ClassId = student.ClassId;
listDto.Add(studentDto);
}
return listDto;
}
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(StudentDTO studentDto)
{
_studentDal = new StudentDAL();
_studentDal.Update(studentDto);
}
public void Save(StudentDTO studentDto)
{
_studentDal = new StudentDAL();
_studentDal.Save(studentDto);
}
