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); }