public async Task deleteAsync(int ID)
{
try
{
var applicant = await _context.Applicants.FindAsync(ID);
_context.Applicants.Remove(applicant);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
public async Task deleteAsync(int ID)
{
try
{
var forum = await _context.Forums.FindAsync(ID);
_context.Forums.Remove(forum);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <int> insertAsync(StudentForum data)
{
try
{
var forum = new StudentForum
{
StudentID = data.StudentID,
ForumID = data.ForumID
};
await _context.StudentForums.AddAsync(forum);
await _context.SaveChangesAsync();
return(forum.ID);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <int> insertAsync(Facilitator data)
{
try
{
var facilitator = new Facilitator
{
Code = data.Code,
DateCreated = DateTime.Now,
Nickname = data.Nickname
};
await _context.Facilitators.AddAsync(facilitator);
await _context.SaveChangesAsync();
return(facilitator.ID);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <int> insertAsync(Student data)
{
try
{
var student = new Student
{
Code = data.Code,
DateCreated = DateTime.Now,
Nickname = data.Nickname
};
await _context.Students.AddAsync(student);
await _context.SaveChangesAsync();
return(student.ID);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <int> insertAsync(Course data)
{
try
{
var course = new Course
{
DateCreated = DateTime.Now,
Description = data.Description,
Code = data.Code,
Name = data.Name,
FacilitatorIDs = data.FacilitatorIDs
};
await _context.Courses.AddAsync(course);
await _context.SaveChangesAsync();
return(course.ID);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <int> insertAsync(Contact data)
{
try
{
var contact = new Contact
{
Email = data.Email,
Message = data.Message,
Subject = data.Subject
};
await _context.Contacts.AddAsync(contact);
await _context.SaveChangesAsync();
return(contact.ID);
}
catch (Exception ex)
{
throw ex;
}
}