public object FindForId(int id)
{
var referenciaemp = new ReferenciaEmpViewModels();
string query = "SELECT id, nombre, apellido, telefono, direccion, id_emp FROM referenciaemp WHERE id = " + id;
using (var connection = PostConnection.Connection())
{
using (var command = db.Command(query))
{
try
{
connection.Open();
command.Connection = connection;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
referenciaemp.id = Convert.ToInt16(reader["id"]);
referenciaemp.nombre = reader["nombre"].ToString();
referenciaemp.apellido = reader["apellido"].ToString();
referenciaemp.tel = Convert.ToInt32(reader["telefono"]);
referenciaemp.direccion = reader["direccion"].ToString();
referenciaemp.id_emp = Convert.ToInt16(reader["id_emp"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(referenciaemp);
}
public ActionResult Edit(ReferenciaEmpViewModels datos)
{
DBReferenciaEmp dbReferenciaEmp = new DBReferenciaEmp();
ReferenciaEmp refemp = new ReferenciaEmp(dbReferenciaEmp);
refemp.Update(datos);
return(RedirectToAction("Index", "Empleado"));
}
public ActionResult Create(ReferenciaEmpViewModels datos)
{
ViewBag.Title = "Ingresar Referencia de Empleado";
DBReferenciaEmp dbReferenciaEmp = new DBReferenciaEmp();
ReferenciaEmp refemp = new ReferenciaEmp(dbReferenciaEmp);
datos.id_emp = Convert.ToInt16(TempData["EmpId"]);
refemp.Save(datos);
return(RedirectToAction("Index", "Empleado"));
}
public int Update(ReferenciaEmpViewModels datos)
{
return(persistence.Update(datos));
}
