public ActionResult Save(Departamento empleado)
{
//bool status = false;
if (ModelState.IsValid)
{
using (Empresa2Entities Obj_Connection = new Empresa2Entities())
{
if (empleado.Num_Empleado > 0)
{
//Edit
var v = Obj_Connection.Departamentoes.Where(a => a.Num_Empleado == empleado.Num_Empleado).FirstOrDefault();
if (v != null)
{
v.Nombre = empleado.Nombre;
}
}
else
{
//Save
empleado.Fecha_Creacion = DateTime.Now;
Obj_Connection.Departamentoes.Add(empleado);
}
Obj_Connection.SaveChanges();
//status = true;
}
}
return(View("Main"));
}
public ActionResult Save(int id)
{
using (Empresa2Entities Obj_Connection = new Empresa2Entities())
{
var v = Obj_Connection.Departamentoes.Where(a => a.Num_Empleado == id).FirstOrDefault();
return(View(v));
}
}
public ActionResult Delete(int id)
{
using (Empresa2Entities Obj_Connection = new Empresa2Entities())
{
var v = Obj_Connection.Departamentoes.Where(a => a.Num_Empleado == id).FirstOrDefault();
if (v != null)
{
return(View(v));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult DeleteEmpleado(int id)
{
bool status = false;
using (Empresa2Entities Obj_Connection = new Empresa2Entities())
{
var v = Obj_Connection.Departamentoes.Where(a => a.Num_Empleado == id).FirstOrDefault();
if (v != null)
{
Obj_Connection.Departamentoes.Remove(v);
Obj_Connection.SaveChanges();
status = true;
}
}
return(RedirectToAction("Main"));
}
public ActionResult GetEmployees()
{
using (Empresa2Entities Obj_Connection = new Empresa2Entities())
{
var empleados = Obj_Connection.Departamentoes.OrderBy(a => a.Num_Empleado).ToList();
List <Empleado> parseables = new List <Empleado>();
for (int i = 0; i < empleados.Count() - 1; i++)
{
parseables.Add(new Empleado());
parseables[i].Num_Empleado = empleados[i].Num_Empleado;
parseables[i].Nombre = empleados[i].Nombre;
parseables[i].Fecha_Creacion = empleados[i].Fecha_Creacion.ToString("yyyy/MM/dd HH:mm");
}
return(Json(new { data = parseables }, JsonRequestBehavior.AllowGet));
}
}
