public object FindForId(int id)
{
var cargo = new CargoEmpViewModels();
string query = "SELECT id, nombrecargo, sueldo FROM cargo 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())
{
cargo.id = Convert.ToInt16(reader["id"]);
cargo.nombrecargo = reader["nombrecargo"].ToString();
cargo.sueldo = Convert.ToDouble(reader["sueldo"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
return(cargo);
}
public ActionResult Edit(CargoEmpViewModels datos)
{
DBCargoEmp dbcargoEmp = new DBCargoEmp();
CargoEmp cargoemp = new CargoEmp(dbcargoEmp);
cargoemp.Update(datos);
return(RedirectToAction("Index", "CargoEmp"));
}
public ActionResult Create(CargoEmpViewModels datos)
{
ViewBag.Title = "Ingresar Cargo";
DBCargoEmp dbcargoEmp = new DBCargoEmp();
CargoEmp cargoemp = new CargoEmp(dbcargoEmp);
cargoemp.Save(datos);
return(RedirectToAction("Index", "CargoEmp"));
}
public int Update(CargoEmpViewModels datos)
{
return(persistence.Update(datos));
}
public int Save(CargoEmpViewModels datos)
{
return(persistence.Save(datos));
}
