/// <summary>
/// Retrieve missing information by id or username of the entities and build the
/// Enrollment to be inserted in the database
/// </summary>
/// <param name="enroll"></param>
public void InsertEnrollment(EnrollmentEntity enroll)
{
DbDataProvider ddp = new DbDataProvider();
var resApplicant = ddp.GetResourceByIdOrUsername(-1, enroll.Resource.Username);
if (resApplicant.Count != 1)
{
throw new Exception("Error retrieving applicant resource by username " + enroll.Resource.Username);
}
var resLeader = ddp.GetResourceByIdOrUsername(-1, enroll.ProjectLeader.Username);
if (resLeader.Count != 1)
{
throw new Exception("Error retrieving applicant leader resource by username " + enroll.ProjectLeader.Username);
}
var course = ddp.GetCourseById(enroll.Course.Id);
if (course == null)
{
throw new Exception("Error retrieving course by id " + enroll.Course.Id);
}
enroll.Course = course;
enroll.Resource = resApplicant[0];
enroll.ProjectLeader = resLeader[0];
ddp.InsertEnrollment(enroll);
}
public HttpResponseMessage InsertEnrollment([FromBody] EnrollmentEntity enrollment)
{
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.InternalServerError);
try
{
EnrollmentsManager enrollManager = new EnrollmentsManager();
enrollManager.InsertEnrollment(enrollment);
response = Request.CreateResponse(HttpStatusCode.OK);
}
catch (Exception ex)
{
response.Content = new StringContent($"{GENERIC_ERROR} [{ex.Message}]");
DbLog.LogError("Error in EnrollmentsController", ex);
}
return response;
}
/// <summary>
/// Retrieve missing information by id or username of the entities and build the
/// Enrollment that will be updated
/// </summary>
/// <param name="enroll"></param>
public void EditEnrollment(EnrollmentEntity enroll)
{
DbDataProvider ddp = new DbDataProvider();
//if resource not arriving from controller
if (enroll.Resource.Id == -1)
{
var result = ddp.GetResourceByIdOrUsername(-1, enroll.Resource.Username);
if (result != null && result.Count == 1)
{
enroll.Resource = result[0];
}
else
{
throw new Exception("Cannot retrieve applicant from username " + enroll.Resource.Username);
}
}
//if project leader not arriving from controller
if (enroll.ProjectLeader.Id == -1)
{
var result = ddp.GetResourceByIdOrUsername(-1, enroll.ProjectLeader.Username);
if (result != null && result.Count == 1)
{
enroll.ProjectLeader = result[0];
}
else
{
throw new Exception("Cannot retrieve project leader from username " + enroll.ProjectLeader.Username);
}
}
var course = ddp.GetCourseById(enroll.Course.Id);
if (course != null)
{
enroll.Course = course;
}
else
{
throw new Exception("Cannot retrieve course for id " + enroll.Course.Id);
}
ddp.EditEnrollment(enroll);
}
public void EditEnrollment(EnrollmentEntity enroll)
{
EnrollmentsRepository enrollRepo = new EnrollmentsRepository();
using (var uow = UnitOfWork.CreateUoW())
{
try
{
enrollRepo.Update(EntitiesMapper.ToDbModel(enroll), uow);
uow.ApplyChanges();
}
catch (Exception ex)
{
DbLog.LogError("Error editing enrollment " + enroll, ex);
throw ex;
}
}
}
public void DeleteEnrollment(EnrollmentEntity enroll)
{
EnrollmentsRepository enrollRepo = new EnrollmentsRepository();
using (var uow = UnitOfWork.CreateUoW())
{
try
{
enrollRepo.Delete(enroll.Id, uow);
uow.ApplyChanges();
}
catch (Exception ex)
{
DbLog.LogError("Error deleting enrollment " + enroll.Id, ex);
throw ex;
}
}
}
private EnrollmentEntity Transform(EnrollmentFileRecord fileRecord)
{
var entity = new EnrollmentEntity();
entity.SchoolId = SchoolLookup[fileRecord.Building.Replace(" ", "")];
if (fileRecord.Grade.Trim() == "K")
{
entity.GradeLevel = 0;
}
else
{
entity.GradeLevel = int.Parse(fileRecord.Grade);
}
entity.FiscalYearid = FiscalYearLookup[int.Parse(fileRecord.Year)].FiscalYearId;
entity.Enrollment = fileRecord.Enrollment;
return(entity);
}
public EnrollmentEntity GetEnrollmentById(int id)
{
EnrollmentEntity result = null;
EnrollmentsRepository enrollRepo = new EnrollmentsRepository();
using (var uow = UnitOfWork.CreateUoW())
{
try
{
var res = enrollRepo.GetEnrollmentByID(id, uow);
result = res != null?EntitiesMapper.ToEntity(res) : null;
}
catch (Exception ex)
{
DbLog.LogError("Error retrieving enrollment " + id, ex);
throw ex;
}
}
return(result);
}
public static Enrollment ToDbModel(EnrollmentEntity enrl)
{
return(new Enrollment(enrl.Id, enrl.Resource.Id, enrl.ProjectLeader.Id, enrl.Course.Id, enrl.StartDate, enrl.MaxEndDate, enrl.IsAdmitted, enrl.Notes));
}
public void DeleteEnrollment(EnrollmentEntity enroll)
{
DbDataProvider ddp = new DbDataProvider();
ddp.DeleteEnrollment(enroll);
}
