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