public ActionResult Create()
{
using (education_systemEntities1 db = new education_systemEntities1())
{
var er = db.business_position.Where(m => m.position.position_name == "Profesor").First();
person p = new person();
p.id_person = 0;
p.first_name = Request.Form["first_name"];
p.middle_name = Request.Form["middle_name"];
p.last_name = Request.Form["last_name"];
p.second_last_name = Request.Form["second_last_name"];
p.fecha_nacimiento = Convert.ToDateTime(Request.Form["fecha_nacimiento"]);
p.cedula = Request.Form["cedula"];
db.person.Add(p);
db.SaveChanges();
var pe = db.person.Where(m => m.cedula == p.cedula).First();
person_business_position per = new person_business_position();
per.person_id = pe.id_person;
per.business_position_id = er.id_business_position;
per.username = Request.Form["login"];
per.pwd = Request.Form["login"];
db.person_business_position.Add(per);
db.SaveChanges();
TempData["Message"] = "Create Sucess!";
return(RedirectToAction("Index"));
}
}
//GET: /Profesor/Edit/
public ActionResult Edit(int id)
{
using (education_systemEntities1 db = new education_systemEntities1())
{
person prof = new person();
var profesor = db.person.Where(m => m.id_person == id).First <person>();
var bp = db.business_position.Where(m => m.position.position_name == "Profesor").First();
prof.id_person = id;
prof.last_name = profesor.last_name;
prof.first_name = profesor.first_name;
prof.middle_name = profesor.middle_name;
prof.second_last_name = profesor.second_last_name;
Debug.WriteLine(profesor.fecha_nacimiento.Date); // 5/8/2020 0:00:00
//DateTime dt = DateTime.ParseExact(profesor.fecha_nacimiento.ToString(), "dd/M/yyyy h:mm:ss", CultureInfo.InvariantCulture);
//string s = dt.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
//prof.fecha_nacimiento = DateTime.ParseExact(s, "dd/MM/yyyy", CultureInfo.InvariantCulture);
prof.fecha_nacimiento = profesor.fecha_nacimiento.Date;
prof.cedula = profesor.cedula;
//var profesor_pbp = from c in db.person_business_position where c.person_id == profesor.id_person select c;
var profesor_pbp = db.person_business_position.Where(m => m.person_id == profesor.id_person && m.business_position_id == bp.id_business_position).ToList(); //
profesor.person_business_position = profesor_pbp;
prof.person_business_position = profesor_pbp;
return(View("Edit", prof));
}
}
public ActionResult CreatePost()
{
using (education_systemEntities1 db = new education_systemEntities1())
{
int profesor_id = Int32.Parse(Request.Form["profesor_id"]);
quota q = new quota();
subject s = new subject();
s.id_subject = 1;
s.nombre_subject = Request.Form["nombre_subject"];
s.codigo_subject = Request.Form["codigo_subject"];
s.max_alumnos = Int32.Parse(Request.Form["max_alumnos"]);
s.descripcion = Request.Form["descripcion"];
s.hora_entrada = TimeSpan.Parse(Request.Form["hora_entrada"]);
s.hora_salida = TimeSpan.Parse(Request.Form["hora_salida"]);
db.subject.Add(s);
db.SaveChanges();
s = db.subject.Where(m => m.codigo_subject == s.codigo_subject).First();
q.profesor_id = profesor_id;
q.subject_id = s.id_subject;
q.periodo = DateTime.Now.Year.ToString();
db.quota.Add(q);
db.SaveChanges();
TempData["Message"] = "Create sucess!";
}
return(RedirectToAction("Index"));
}
public ActionResult EditPost()
{
using (education_systemEntities1 db = new education_systemEntities1())
{
int id_subject = Int32.Parse(Request.Form["id_subject"]);
int id_quota = Int32.Parse(Request.Form["id_quota"]);
subject s = db.subject.Find(id_subject);
//var su = db.subject.Find(id);
int profesor_id = Int32.Parse(Request.Form["profesor_id"]);
quota q = db.quota.Where(m => m.id_quota == id_quota).First();
s.nombre_subject = Request.Form["nombre_subject"];
s.codigo_subject = Request.Form["codigo_subject"];
s.max_alumnos = Int32.Parse(Request.Form["max_alumnos"]);
s.descripcion = Request.Form["descripcion"];
s.hora_entrada = TimeSpan.Parse(Request.Form["hora_entrada"]);
s.hora_salida = TimeSpan.Parse(Request.Form["hora_salida"]);
q.profesor_id = profesor_id;
q.subject_id = s.id_subject;
q.periodo = DateTime.Now.Year.ToString();
db.Entry(s).State = System.Data.EntityState.Modified;
db.Entry(q).State = System.Data.EntityState.Modified;
db.SaveChanges();
TempData["Message"] = "Edit sucess!";
}
return(RedirectToAction("Index"));
}
//GET: /Materia/Details/
public ActionResult Details(int id)
{
using (education_systemEntities1 db = new education_systemEntities1())
{
var s = db.person.Find(id);
return(View("Details", s));
}
}
//
// GET: /Administrador/
public ActionResult Index(int id)
{
using (education_systemEntities1 db = new education_systemEntities1())
{
//Probando linq
var personName = from c in db.person where c.id_person == id select c.first_name;
ViewBag.FirstName = personName.ToList()[0];
return(View("Index"));
}
}
//
// GET: /Materia/
public ActionResult Index()
{
using (education_systemEntities1 db = new education_systemEntities1())
{
var materias = db.subject.ToList();
if (TempData["Message"] != null)
{
ViewBag.Message = TempData["Message"];
TempData.Remove("Message");
}
return(View("Index", materias));
}
}
//
// GET: /Alumno/
public ActionResult Index()
{
using (education_systemEntities1 db = new education_systemEntities1())
{
var q = db.quota.Where(m => m.alumno_id != null).ToList <quota>();
foreach (var r in q)
{
r.subject = db.subject.Find(r.subject_id);
}
// var q = from c in db.quota where c.alumno_id != null select c;
return(View("Index", q));
}
}
// GET: /Profesor/
public ActionResult Index()
{
using (education_systemEntities1 db = new education_systemEntities1())
{
var er = db.business_position.Where(m => m.position.position_name == "Profesor").First();
var profesores = from c in db.person
join d in db.person_business_position on c.id_person equals d.person_id
where d.business_position_id == er.id_business_position
select c;
if (TempData["Message"] != null)
{
ViewBag.Message = TempData["Message"];
TempData.Remove("Message");
}
return(View("Index", profesores.ToList()));
}
}
//GET: /Materia/Edit/
public ActionResult Edit(int id)
{
using (education_systemEntities1 db = new education_systemEntities1())
{
var materia = db.subject.Where(m => m.id_subject == id).First();
var profesores = from c in db.business_position
join d in db.person_business_position on c.id_business_position equals d.business_position_id
join e in db.person on d.person_id equals e.id_person
where c.position.position_name == "Profesor"
select e;
var q = db.quota.Where(m => m.subject_id == id).First();
materia.profesores = profesores.ToList();
materia.quota.ToList()[0].id_quota = q.id_quota;
return(View("Edit", materia));
}
}
//GET: /Materia/Create/
public ActionResult Create()
{
using (education_systemEntities1 db = new education_systemEntities1())
{
subject materia = new subject();
var profesores = from c in db.business_position
join d in db.person_business_position on c.id_business_position equals d.business_position_id
join e in db.person on d.person_id equals e.id_person
where c.position.position_name == "Profesor"
select e;
materia.profesores = profesores.ToList();
return(View("Create", materia));
}
}
public ActionResult CreatePost()
{
using (education_systemEntities1 db = new education_systemEntities1())
{
int id_quota = Int32.Parse(Request.Form["id_quota"]);
quota q = new quota();
var qt = db.quota.Find(id_quota);
qt.subject.max_alumnos = qt.subject.max_alumnos - 1;
q.subject_id = qt.subject_id;
q.alumno_id = Int32.Parse(HttpContext.Session["id_person"].ToString());
q.profesor_id = qt.profesor_id;
db.quota.Add(q);
db.Entry(qt).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult EditPost()
{
using (education_systemEntities1 db = new education_systemEntities1())
{
int id_person = Int32.Parse(Request.Form["id_person"]);
String intEstado = Request.Form["estado"].ToString();
String strEstado = null;
if (intEstado == "1")
{
strEstado = "Activo";
}
else
{
strEstado = "Inactivo";
}
person p = db.person.Find(id_person);
p.first_name = Request.Form["first_name"];
p.middle_name = Request.Form["middle_name"];
p.last_name = Request.Form["last_name"];
p.second_last_name = Request.Form["second_last_name"];
p.fecha_nacimiento = DateTime.ParseExact(Request.Form["fecha_nacimiento"], "yyyy-MM-dd", CultureInfo.InvariantCulture);
p.cedula = Request.Form["cedula"];
var pbp = db.person_business_position.Where(m => m.person_id == p.id_person).First();
pbp.username = Request.Form["login"];
pbp.pwd = Request.Form["pwd"];
pbp.estado = strEstado;
db.Entry(pbp).State = System.Data.EntityState.Modified;
db.Entry(p).State = System.Data.EntityState.Modified;
db.SaveChanges();
TempData["Message"] = "Edit Sucess!";
}
return(RedirectToAction("Index"));
}
public ActionResult loginPost()
{
String username = Request.Form["username"];
String pwd = Request.Form["pwd"];
Debug.WriteLine("Logueando");
using (education_systemEntities1 db = new education_systemEntities1())
{
try
{
var pbp = db.person_business_position.Where(d => d.username == username).Where(d => d.pwd == pwd).First();
HttpContext.Session["id_person"] = pbp.person_id;
int id_position = pbp.business_position.position.id_position;
String nombre_rol = pbp.business_position.position.position_name;
return(RedirectToAction("Bienvenido", new { id_rol = id_position }));
}
catch (InvalidOperationException) //Null NO hay login registrado
{
return(RedirectToAction("Error", new { id = 2 }));
}
}
}
// GET: /Alumno/Create
public ActionResult Create()
{
using (education_systemEntities1 db = new education_systemEntities1())
{
var listaq = db.quota.Where(m => m.alumno_id == null && m.subject.max_alumnos > 0).OrderBy(c => c.subject.codigo_subject).ToList();
List <Cupo> listaCupo = new List <Cupo>();
foreach (quota q in listaq)
{
var profesor = db.person.Find(q.profesor_id);
Cupo c = new Cupo();
c.id_cupo = q.id_quota;
c.MateriaString = q.subject.nombre_subject;
c.ProfesorString = profesor.first_name + " " + profesor.last_name;
c.maxAlumnos = q.subject.max_alumnos;
c.descripcion = q.subject.descripcion;
listaCupo.Add(c);
}
return(View("Create", listaCupo));
}
}
