public int Modificacion(Alquiler p) { int res = -1; using (SqlConnection connection = new SqlConnection(connectionString)) { string sql = $"UPDATE Alquiler SET Precio='{p.Precio}', FechaInicio='{p.FechaInicio}', FechaFin='{p.FechaFin}', InquilinoId='{p.InquilinoId}', InmuebleId='{p.InmuebleId}'" + $"WHERE IdAlquiler = {p.IdAlquiler}"; using (SqlCommand command = new SqlCommand(sql, connection)) { command.CommandType = CommandType.Text; connection.Open(); res = command.ExecuteNonQuery(); connection.Close(); } } return(res); }
public int Alta(Alquiler p) { int res = -1; using (SqlConnection connection = new SqlConnection(connectionString)) { string sql = $"INSERT INTO Alquiler (Precio,FechaInicio, FechaFin, InquilinoId, InmuebleId) " + $"VALUES ('{p.Precio}','{p.FechaInicio}', '{p.FechaFin}','{p.InquilinoId}','{p.InmuebleId}')"; 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(); p.IdAlquiler = Convert.ToInt32(id); connection.Close(); } } return(res); }