public void Delete(int id)
{
_db = new StudentDbEntities();
Student student = _db.Students.First(p => p.Id == id);
_db.Students.Remove(student);
_db.SaveChanges();
}
public void Delete(int id)
{
_db = new StudentDbEntities();
Class c = _db.Classes.First(p => p.Id == id);
_db.Classes.Remove(c);
_db.SaveChanges();
}
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 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 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;
}
private int GetMaxId()
{
try
{
_db = new StudentDbEntities();
return _db.Students.Max(p => p.Id) + 1;
}
catch (Exception)
{
return 1;
}
}
