public static bool AjaxSendCode(string code, string enrollment, string course)
{
try
{
long courseId = Convert.ToInt64(cWebCrypto.Decrypt(course));
long enrollmentId = Convert.ToInt64(cWebCrypto.Decrypt(enrollment));
long userId = GetLogged().userId;
_context = cDataContextFactory.GetDataContext();
Guid guidCode = new Guid(code);
ACAD_CODIGOS cod = _context.ACAD_CODIGOS.Where(x => x.CD_CURSO == courseId &&
x.CD_CODIGO == guidCode &&
x.FL_ATIVO == true && x.DT_DATA == null).FirstOrDefault();
if (cod != null)
{
cod.DT_DATA = DateTime.Now;
_context.Entry(cod).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
ACAD_MATRICULAS enroll = _context.ACAD_MATRICULAS.Where(x => x.CD_CURSO == courseId &&
x.CD_USUARIO == userId &&
x.CD_MATRICULA == enrollmentId)
.FirstOrDefault();
if (enroll != null)
{
enroll.TX_CODIGO = code;
_context.Entry(enroll).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
}
catch { }
return(false);
}
public static bool AjaxSetEnrollment()
{
try
{
long userId = GetLogged().userId;
long courseId = Convert.ToInt64(cWebCrypto.Decrypt(HttpContext.Current.Request.QueryString["c"]));
_context = cDataContextFactory.GetDataContext();
ACAD_MATRICULAS enrollment = _context.ACAD_MATRICULAS.Where(x => x.CD_CURSO == courseId &&
x.CD_USUARIO == userId).FirstOrDefault();
if (enrollment == null)
{
ACAD_MATRICULAS enroll = new ACAD_MATRICULAS()
{
CD_USUARIO = userId,
CD_CURSO = courseId,
DT_DATA = DateTime.Now
};
_context.Entry(enroll).State = System.Data.Entity.EntityState.Added;
_context.SaveChanges();
List <ACAD_BLOCOS> blocks = _context.ACAD_BLOCOS.Where(x => x.ACAD_MODULOS.CD_CURSO == courseId).ToList();
foreach (ACAD_BLOCOS block in blocks)
{
ACAD_USUARIOS_BLOCOS userBlocks = new ACAD_USUARIOS_BLOCOS()
{
CD_BLOCO = block.CD_BLOCO,
CD_USUARIO = userId
};
_context.Entry(userBlocks).State = System.Data.Entity.EntityState.Added;
List <ACAD_EXERCICIOS> exercises = _context.ACAD_EXERCICIOS.Where(x => x.CD_BLOCO == block.CD_BLOCO).ToList();
foreach (ACAD_EXERCICIOS item in exercises)
{
ACAD_USUARIOS_EXERCICIOS userExercise = new ACAD_USUARIOS_EXERCICIOS()
{
CD_EXERCICIO = item.CD_EXERCICIO,
CD_USUARIO = userId,
CD_MATRICULA = enroll.CD_MATRICULA,
TX_PERGUNTA = item.TX_PERGUNTA,
TX_OBS_CORRECAO = item.TX_GABARITO,
DT_EXERCICIO = DateTime.Now
};
_context.Entry(userExercise).State = System.Data.Entity.EntityState.Added;
}
_context.SaveChanges();
}
return(true);
}
}
catch { }
return(false);
}
