public static void UpdateCanvasData(int?idEntidad, InscriptionReturn newInscription)
{
logger.Info("InscriptionDAL/UpdateCanvasData - Task 'Update inscription data in Canvas' STARTED");
if (newInscription != null)
{
using (var context = new CANVAS_Model_Entities())
{
uniCanvasEnrolamiento newCanvasInscription = context.uniCanvasEnrolamientos.Where(x => x.ID == idEntidad).FirstOrDefault();
if (newInscription.error_message == null)
{
newCanvasInscription.Estado = CanvasWebApi.Common.ConfigEnum.CanvasState.Sincronizado.GetHashCode();
newCanvasInscription.Fecha = DateTime.Now;
newCanvasInscription.IDCanvas = Int32.Parse(newInscription.id);
}
else
{
newCanvasInscription.Estado = CanvasWebApi.Common.ConfigEnum.CanvasState.Error.GetHashCode();
}
newCanvasInscription.Error = newInscription.error_message;
context.SaveChanges();
}
}
logger.Info("InscriptionDAL/UpdateCanvasData - Task 'Update inscription data in Canvas' FINISHED");
}
public static void UpdateCanvasData(int?idEntidad, UserReturn newUser)
{
logger.Info("UserDAL/UpdateCanvasData - Task 'Update user data from Canvas' STARTED");
if (newUser != null)
{
using (var context = new CANVAS_Model_Entities())
{
uniCanvasUsuario newCanvasUser = context.uniCanvasUsuarios.Where(x => x.IDAcademico == idEntidad).FirstOrDefault();
if (newUser.error_message == null)
{
newCanvasUser.Estado = CanvasWebApi.Common.ConfigEnum.CanvasState.Sincronizado.GetHashCode();
newCanvasUser.Fecha = DateTime.Now;
newCanvasUser.IDCanvas = Int32.Parse(newUser.id);
}
else
{
newCanvasUser.Estado = CanvasWebApi.Common.ConfigEnum.CanvasState.Error.GetHashCode();
}
newCanvasUser.Error = newUser.error_message;
context.SaveChanges();
}
logger.Info("UserDAL/UpdateCanvasData - Task 'Update user data from Canvas' FINISHED");
}
logger.Info("UserDAL/UpdateCanvasData - Task 'Update user data from Canvas' FINISHED");
}
public static List <sp_uni_canvas_sincronizacion_Result> SyncToCanvas()
{
using (var context = new CANVAS_Model_Entities())
{
return(context.sp_uni_canvas_sincronizacion().ToList());
}
}
public static void UpdateCanvasData(int?idEntidad, SectionDTO newSection, int?canvasGroupId)
{
logger.Info("SectionDAL/SectionsToSync - Task 'Get a list with the sections to sync' STARTED");
if (newSection != null)
{
using (var context = new CANVAS_Model_Entities())
{
uniCanvasCursosSeccione newCanvasCourseSection = context.uniCanvasCursosSecciones.Where(x => x.IDAcademico == idEntidad).FirstOrDefault();
if (newSection.error_message == null)
{
newCanvasCourseSection.Estado = CanvasWebApi.Common.ConfigEnum.CanvasState.Sincronizado.GetHashCode();
newCanvasCourseSection.Fecha = DateTime.Now;
newCanvasCourseSection.IDCanvas = Int32.Parse(newSection.id);
newCanvasCourseSection.IDCanvasGrupo = canvasGroupId;
}
else
{
newCanvasCourseSection.Estado = CanvasWebApi.Common.ConfigEnum.CanvasState.Error.GetHashCode();
newCanvasCourseSection.Fecha = DateTime.Now;
}
newCanvasCourseSection.Error = newSection.error_message;
context.SaveChanges();
}
}
}
internal static List <sp_get_uniCanvas_ws_cursos_Result> CoursesToSync()
{
using (var context = new CANVAS_Model_Entities())
{
int sentEnum = CanvasWebApi.Common.ConfigEnum.CanvasState.Sincronizado.GetHashCode();
return(context.sp_get_uniCanvas_ws_cursos().ToList());
}
}
//TODO: Obtener los datos desde la SP de cursos a concluir y modificar el circuito desde el controlador hasta la DAL
internal static List <uniCanvasCurso> CoursesToConclude(string termino)
{
using (var context = new CANVAS_Model_Entities())
{
// http://localhost:52519/API/COURSE/ConcludeCourse?termino=3er%20cuat%202017
// espacio en url es %20
int estadoSincronizado = ConfigEnum.CanvasState.Sincronizado.GetHashCode();
return(context.uniCanvasCursos.Where(x => x.Termino == termino && (!x.Concluido.HasValue || !x.Concluido.Value) && x.Estado == estadoSincronizado).ToList());
}
}
internal static string GetSubjectName(string id)
{
using (var context = new CANVAS_Model_Entities())
{
uniMateria subject = context.uniMaterias.Where(x => x.codmat == id).FirstOrDefault();
if (subject != null)
{
return(subject.nombre);
}
return(null);
}
}
public static List <sp_uni_canvas_sincronizacion_Result> SyncToCanvas()
{
logger.Info("SectionDAL/SyncToCanvas - Task 'Sync section' STARTED");
using (var context = new CANVAS_Model_Entities())
{
try
{
List <sp_uni_canvas_sincronizacion_Result> rtn = context.sp_uni_canvas_sincronizacion().ToList();
logger.Info("SectionDAL/SyncToCanvas - Task 'Sync section' FINISHED");
return(rtn);
}
catch (Exception e)
{
logger.Error("SectionDAL/SyncToCanvas - Task 'Sync section' FINISHED WITH ERROR: \n " + " Message: " + e.Message + "\nInner Exception: " + e.InnerException);
return(new List <sp_uni_canvas_sincronizacion_Result>());
}
}
}
public static List <sp_get_uniCanvas_ws_usuarios_Result> SyncToCanvas()
{
logger.Info("UserDAL/SyncToCanvas - Task 'Sync user' STARTED");
using (var context = new CANVAS_Model_Entities())
{
try
{
List <sp_get_uniCanvas_ws_usuarios_Result> rtn = context.sp_get_uniCanvas_ws_usuarios().ToList();
logger.Info("UserDAL/SyncToCanvas - Task 'Sync user' FINISHED");
return(rtn);
}
catch (Exception e)
{
logger.Error("UserDAL/SyncToCanvas - Task 'Sync user' FINISHED WITH ERROR: \n " + " Message: " + e.Message + "\nInner Exception: " + e.InnerException);
return(new List <sp_get_uniCanvas_ws_usuarios_Result>());
}
}
}
internal static List <sp_get_uniCanvas_ws_secciones_Result> SectionsToSync()
{
logger.Info("SectionDAL/SectionsToSync - Task 'Get a list with the sections to sync' STARTED");
using (var context = new CANVAS_Model_Entities())
{
try
{
int sentEnum = CanvasWebApi.Common.ConfigEnum.CanvasState.Sincronizado.GetHashCode();
List <sp_get_uniCanvas_ws_secciones_Result> rtn = context.sp_get_uniCanvas_ws_secciones().ToList();
logger.Info("SectionDAL/SectionsToSync - Task 'Get a list with the sections to sync' FINISHED");
return(rtn);
}
catch (Exception e)
{
logger.Error("SectionDAL/SectionsToSync - Task 'Get a list with the sections to sync' FINISHED WITH ERROR: \n " + " Message: " + e.Message + "\nInner Exception: " + e.InnerException);
return(new List <sp_get_uniCanvas_ws_secciones_Result>());
}
}
}
internal static List <sp_get_uniCanvas_ws_enrolamientos_Result> InscriptionsToSync(string operation)
{
logger.Info("InscriptionDAL/InscriptionsToSync - Task 'Get the list of inscriptions to sync' STARTED");
using (var context = new CANVAS_Model_Entities())
{
try
{
int sentEnum = CanvasWebApi.Common.ConfigEnum.CanvasState.Sincronizado.GetHashCode();
List <sp_get_uniCanvas_ws_enrolamientos_Result> rtn = context.sp_get_uniCanvas_ws_enrolamientos(operation).ToList();
logger.Info("InscriptionDAL/UpdateCanvasData - Task 'Sync inscription' FINISHED");
return(rtn);
}
catch (Exception e)
{
logger.Error("InscriptionDAL/InscriptionsToSync - Task 'Get the list of inscriptions to sync' FINISHED WITH ERROR: \n " + " Message: " + e.Message + "\nInner Exception: " + e.InnerException);
return(new List <sp_get_uniCanvas_ws_enrolamientos_Result>());
}
}
}
internal static List <uniCanvasUsuario> UsersToSync()
{
logger.Info("UserDAL/UsersToSync - Task 'Get the list of users to sync' STARTED");
using (var context = new CANVAS_Model_Entities())
{
try
{
int sentEnum = CanvasWebApi.Common.ConfigEnum.CanvasState.Sincronizado.GetHashCode();
List <uniCanvasUsuario> rtn = context.uniCanvasUsuarios.Where(x => x.Estado != sentEnum).ToList();
logger.Info("UserDAL/SyncToCanvas - Task 'Get the list of users to sync' FINISHED");
return(rtn);
}
catch (Exception e)
{
logger.Error("UserDAL/UsersToSync - Task 'Get the list of users to sync' FINISHED WITH ERROR: \n " + " Message: " + e.Message + "\nInner Exception: " + e.InnerException);
return(new List <uniCanvasUsuario>());
}
}
}
public static void UpdateConcludedCourseCanvasData(uniCanvasCurso aux)
{
// TODO: Enviar solo el ID como parametro
using (var context = new CANVAS_Model_Entities())
{
try
{
uniCanvasCurso courseToConclude = context.uniCanvasCursos.Where(x => x.IDAcademico == aux.IDAcademico).FirstOrDefault();
if (courseToConclude != null)
{
courseToConclude.Concluido = true;
context.SaveChanges();
}
}
catch
{
//TODO: Loguear la falta del curso en la staging
logger.Error("Error al marcar el curso " + aux.IDAcademico + " como concluido.");
}
}
}
public static void UpdateCanvasData(string idEntidad, CourseReturn newCourse)
{
if (newCourse != null)
{
using (var context = new CANVAS_Model_Entities())
{
uniCanvasCurso newCanvasCourse = context.uniCanvasCursos.Where(x => x.IDAcademico == idEntidad).FirstOrDefault();
if (newCourse.error_message == null)
{
newCanvasCourse.Estado = CanvasWebApi.Common.ConfigEnum.CanvasState.Sincronizado.GetHashCode();
newCanvasCourse.Fecha = DateTime.Now;
newCanvasCourse.IDCanvas = Int32.Parse(newCourse.id);
}
else
{
newCanvasCourse.Estado = CanvasWebApi.Common.ConfigEnum.CanvasState.Error.GetHashCode();
}
newCanvasCourse.Error = newCourse.error_message;
context.SaveChanges();
}
}
}
public static void SyncToCanvas()
{
logger.Info("SyncronizationDAL/SyncToCanvas - Task 'Sync user' STARTED");
try
{
using (var context = new CANVAS_Model_Entities())
{
int ciclo = Int32.Parse(WebConfigurationManager.AppSettings["CurrentYear"]);
int cuatri = Int32.Parse(WebConfigurationManager.AppSettings["CurrentQuarter"]);
context.Database.CommandTimeout = 180;
context.sp_ins_uniCanvas_cursos_secciones(false);
logger.Info("SyncronizationDAL/SyncToCanvas - Task 'Sync user' INFO: CURSOS Y SECCIONES SINCRONIZADAS");
context.sp_ins_uniCanvas_usuarios_enrolamientos(ciclo, cuatri);
logger.Info("SyncronizationDAL/SyncToCanvas - Task 'Sync user' INFO: USUARIOS Y ENROLAMIENTOS SINCRONIZADOS");
}
logger.Info("SyncronizationDAL/SyncToCanvas - Task 'Sync user' FINISHED");
}
catch (Exception e)
{
logger.Error("SyncronizationDAL/SyncToCanvas - Task 'Sync user' FINISHED WITH ERROR: \n " + " Message: " + e.Message + "\nInner Exception: " + e.InnerException);
}
}