public List <CallOrEmail> GetCallsOrEmailsForId(int id)
{
using (var context = new StudentsContext(_connectionString))
{
return(context.CallsOrEmails.Where(c => c.StudentId == id).ToList());
}
}
public decimal?GetTotalContributions()
{
using (var context = new StudentsContext(_connectionString))
{
return(context.Students.Sum(s => s.ContributionAmount));
}
}
public Student GetStudentById(int id)
{
using (var context = new StudentsContext(_connectionString))
{
return(context.Students.FirstOrDefault(s => s.Id == id));
}
}
public IEnumerable <Student> GetStudents()
{
using (var context = new StudentsContext(_connectionString))
{
return(context.Students.ToList());
}
}
public void AddCallOrEmail(CallOrEmail c)
{
using (var context = new StudentsContext(_connectionString))
{
context.CallsOrEmails.Add(c);
context.SaveChanges();
}
}
public void AddStudent(Student Student)
{
using (var context = new StudentsContext(_connectionString))
{
context.Students.Add(Student);
context.SaveChanges();
}
}
public void AddContributionForStudent(int id, decimal amount)
{
using (var context = new StudentsContext(_connectionString))
{
Student student = context.Students.FirstOrDefault(s => s.Id == id);
student.ContributionAmount = amount;
context.SaveChanges();
}
}
