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); }
public ActionResult Editar(TeacherViewModelAlta model) { try { if (ModelState.IsValid) { using (CollegeEntities bd = new CollegeEntities()) { var oTeacher = bd.Teacher.Find(model.Id_Teacher); oTeacher.Name = model.Name; oTeacher.Surname = model.Surname; oTeacher.National_Identity_Document = model.National_Identity_Document; oTeacher.Status = model.Status; bd.Entry(oTeacher).State = System.Data.Entity.EntityState.Modified; bd.SaveChanges(); } return(Redirect("~/Teacher/Index")); } return(View(model)); } catch (Exception ex) { throw new Exception(ex.Message); } return(View()); }
public ActionResult Editar(StudentViewModel model) { try { if (ModelState.IsValid) { using (CollegeEntities bd = new CollegeEntities()) { var oStudent = bd.Student.Find(model.Id_Student); oStudent.Name = model.Name; oStudent.Surname = model.Surname; oStudent.National_Identity_Document = model.National_Identity_Document; oStudent.Docket = model.Docket; oStudent.Email = model.Email; oStudent.Password = model.Password; bd.Entry(oStudent).State = System.Data.Entity.EntityState.Modified; bd.SaveChanges(); } return(Redirect("~/Student/Index")); } return(View(model)); } catch (Exception ex) { throw new Exception(ex.Message); } return(View()); }
public ActionResult Editar(CourseViewModelList model) { try { if (ModelState.IsValid) { using (CollegeEntities bd = new CollegeEntities()) { var oCourse = bd.Course.Find(model.Id_Course); oCourse.Id_Course = model.Id_Course; oCourse.Name_Course = model.Name_Course; oCourse.Day = model.Day; oCourse.Time_Course = model.Time_Course; oCourse.Id_Teacher = model.Id_Teacher; oCourse.Maximun_Number_Of_Students = model.Maximun_Number_Of_Students; bd.Entry(oCourse).State = System.Data.Entity.EntityState.Modified; bd.SaveChanges(); } return(Redirect("~/Course/Index")); } return(View(model)); } catch (Exception ex) { throw new Exception(ex.Message); } return(View()); }
public static string SetUser(cUser cUser) { long enterpriseId = Convert.ToInt64(cWebCrypto.Decrypt(HttpContext.Current.Request.QueryString["ac"])); long userId = GetLogged().userId; _context = cDataContextFactory.GetDataContext(); if (_context.ACAD_USUARIOS.Where(x => x.CD_ACADEMIA == enterpriseId && x.TX_EMAIL == cUser.email && (userId == 0 || x.CD_USUARIO != userId)).Count() > 0) { return("-1"); } ACAD_USUARIOS user = new ACAD_USUARIOS(); if (userId > 0) { user = _context.ACAD_USUARIOS.Where(x => x.CD_USUARIO == userId).FirstOrDefault(); } user.CD_ACADEMIA = enterpriseId; user.NM_USUARIO = cUser.name; user.NM_SOBRENOME = cUser.surname; user.TX_EMAIL = cUser.email; user.TX_TELEFONE = cUser.tel; user.TX_CELULAR = cUser.cel; user.TX_CPF = cUser.cpf; if (!string.IsNullOrEmpty(cUser.password)) { user.TX_SENHA = cUser.password; } user.TX_IP = cUser.ip; user.FL_ATIVO = true; if (userId == 0) { user.DT_DATA = DateTime.Now; _context.Entry(user).State = System.Data.Entity.EntityState.Added; } else { _context.Entry(user).State = System.Data.Entity.EntityState.Modified; } _context.SaveChanges(); return(cWebCrypto.Encrypt(user.CD_USUARIO.ToString())); }
public ActionResult Edit([Bind(Include = "Did,DName,HOD")] Dept dept) { if (ModelState.IsValid) { db.Entry(dept).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(dept)); }
public ActionResult Edit([Bind(Include = "Id,Nome")] College college) { if (ModelState.IsValid) { db.Entry(college).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(college)); }
public ActionResult Edit([Bind(Include = "Eid,EName,Salary,Dob,Gender,DeptDid")] Emp emp) { if (ModelState.IsValid) { db.Entry(emp).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DeptDid = new SelectList(db.Depts, "Did", "DName", emp.DeptDid); return(View(emp)); }
public String EditDep(DepMst objMst) { try { db.Entry(objMst).State = EntityState.Modified; db.SaveChanges(); return("0"); } catch (Exception ex) { return("1"); } finally { db.Dispose(); } }
public String EditMapp(TeacherCollegeMapp objMst) { try { db.Entry(objMst).State = EntityState.Modified; db.SaveChanges(); return("0"); } catch (Exception ex) { return("1"); } finally { db.Dispose(); } }
public ActionResult Edit(int id, Student student) { try { using (CollegeEntities dbModel = new CollegeEntities()) { dbModel.Entry(student).State = EntityState.Modified; dbModel.SaveChanges(); } // TODO: Add update logic here return(RedirectToAction("Index")); } catch { return(View()); } }