public ActionResult Edit(int id, Alquiler alquiler) { //var miPropietario = repositorio.ObtenerPorId(id); if (id != alquiler.AlquilerId) { return(NotFound()); } if (ModelState.IsValid) { try { repositorio.Modificacion(alquiler); } catch (Exception ex) { ViewBag.Error = ex.Message; ViewBag.StackTrate = ex.StackTrace; return(View()); } return(RedirectToAction(nameof(Index))); } return(View()); }
public ActionResult Create(Alquiler alquiler) { try { return(View()); } catch (Exception ex) { ViewBag.Error = ex.Message; ViewBag.StackTrate = ex.StackTrace; return(View()); } }
public int Alta(Alquiler entidad) { int res = -1; using (SqlConnection connection = new SqlConnection(connectionString)) { string sql = $"INSERT INTO Alquileres ( Descripcion,FechaAlta , FechaBaja , Monto , InmuebleId , InquilinoId) " + $"VALUES ('{entidad.Descripcion}','{entidad.FechaAlta}', '{entidad.FechaBaja}','{entidad.Monto}','{entidad.InmuebleId}','{entidad.InquilinoId}')"; using (SqlCommand command = new SqlCommand(sql, connection)) { command.CommandType = CommandType.Text; connection.Open(); res = command.ExecuteNonQuery(); command.CommandText = "SELECT SCOPE_IDENTITY()"; var id = command.ExecuteScalar(); entidad.AlquilerId = Convert.ToInt32(id); connection.Close(); } } return(res); }