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 Create([Bind(Include = "Id,Nome")] College college) { if (ModelState.IsValid) { db.College.Add(college); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(college)); }
public ActionResult Create([Bind(Include = "Did,DName,HOD")] Dept dept) { if (ModelState.IsValid) { db.Depts.Add(dept); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(dept)); }
public ActionResult Create([Bind(Include = "Eid,EName,Salary,Dob,Gender,DeptDid")] Emp emp) { if (ModelState.IsValid) { db.Emps.Add(emp); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DeptDid = new SelectList(db.Depts, "Did", "DName", emp.DeptDid); return(View(emp)); }
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 Nuevo(TeacherViewModelAlta model) { try { if (ModelState.IsValid) { using (CollegeEntities bd = new CollegeEntities()) { var oTeacher = new Teacher(); oTeacher.Name = model.Name; oTeacher.Surname = model.Surname; oTeacher.National_Identity_Document = model.National_Identity_Document; oTeacher.Status = model.Status; bd.Teacher.Add(oTeacher); bd.SaveChanges(); } return(Redirect("~/Teacher/Index")); } return(View(model)); } catch (Exception ex) { throw new Exception(ex.Message); } return(View()); }
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 Nuevo(CourseViewModelList model) { try { if (ModelState.IsValid) { using (CollegeEntities bd = new CollegeEntities()) { var oCourse = new Course(); oCourse.Name_Course = model.Name_Course; oCourse.Time_Course = model.Time_Course; oCourse.Day = model.Day; oCourse.Id_Teacher = model.Id_Teacher; oCourse.Maximun_Number_Of_Students = model.Maximun_Number_Of_Students; oCourse.Detail = model.Details; bd.Course.Add(oCourse); bd.SaveChanges(); } return(Redirect("~/Course/Index")); } return(View(model)); } catch (Exception ex) { throw new Exception(ex.Message); } return(View()); }
public ActionResult Inscripcion(int Id) { oUsuario = (Student)HttpContext.Session["Usuario"]; InscripcionViewModel model = new InscripcionViewModel(); using (CollegeEntities bd = new CollegeEntities()) { var materia = bd.Course.Find(Id); Course curso = materia; var CountInscriptos = (from m in bd.Course_Student where m.Id_Course == curso.Id_Course select m.Id_Course).ToList(); int Inscriptos = CountInscriptos.Count(); if (Inscriptos < materia.Maximun_Number_Of_Students) { var OInscripcion = new Course_Student(); OInscripcion.Id_Course = materia.Id_Course; OInscripcion.Id_Student = oUsuario.Id_Student; bd.Course_Student.Add(OInscripcion); bd.SaveChanges(); return(RedirectToAction("Index", new { message = "se inscribio correctamente" })); } else { return(RedirectToAction("Index", new { message = "cupo completo" })); } } }
public ActionResult Nuevo(StudentViewModel model) { try { if (ModelState.IsValid) { using (CollegeEntities bd = new CollegeEntities()) { var oStudent = new 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; oStudent.IdFamilia = 1; bd.Student.Add(oStudent); 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 void deleterecord(int Id) { var alldata = GetStudents(); var data = alldata.Where(x => x.stuid == Id).FirstOrDefault(); context.students.Remove(data); context.SaveChanges(); }
public String CreateTeacher(TeacherMst TeacherMst) { try { db.TeacherMsts.Add(TeacherMst); db.SaveChanges(); return("0"); } catch (Exception ex) { return("1"); } finally { db.Dispose(); } }
public String CreateDep(DepMst objMst) { try { db.DepMsts.Add(objMst); db.SaveChanges(); return("0"); } catch (Exception ex) { return("1"); } finally { db.Dispose(); } }
public String CreateEnroll(Enrollment objMst) { try { db.Enrollments.Add(objMst); db.SaveChanges(); return("0"); } catch (Exception ex) { return("1"); } finally { db.Dispose(); } }
public String CreateMapp(TeacherCollegeMapp objMst) { try { db.TeacherCollegeMapps.Add(objMst); db.SaveChanges(); return("0"); } catch (Exception ex) { return("1"); } finally { db.Dispose(); } }
public ActionResult Eliminar(int Id) { using (CollegeEntities bd = new CollegeEntities()) { var oStudent = bd.Student.Find(Id); bd.Student.Remove(oStudent); bd.SaveChanges(); } return(Redirect("~/Student/Index")); }
public ActionResult Eliminar(int Id) { using (CollegeEntities bd = new CollegeEntities()) { var oTeacher = bd.Teacher.Find(Id); bd.Teacher.Remove(oTeacher); bd.SaveChanges(); } return(Redirect("~/Teacher/Index")); }
public ActionResult create() { CollegeEntities db = new CollegeEntities(); User a = new User() { Username = "******", Password = "******", GroupName = "viewer" }; db.Users.Add(a); db.SaveChanges(); return(Content("success")); }
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(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()); } }
public ActionResult Create(Student student) { try { using (CollegeEntities dbModel = new CollegeEntities()) { dbModel.Students.Add(student); dbModel.SaveChanges(); } // TODO: Add insert logic here return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Delete(int id, FormCollection collection) { try { using (CollegeEntities dbModel = new CollegeEntities()) { Student student = dbModel.Students.Where(x => x.Id == id).FirstOrDefault(); dbModel.Students.Remove(student); dbModel.SaveChanges(); } // TODO: Add delete logic here return(RedirectToAction("Index")); } catch { return(View()); } }
protected void SaveChanges() { context.SaveChanges(); }