public static List <CreateAvion> GetAvion(int id) { string connString = "Server=tabasserver.postgres.database.azure.com; User Id=chanchus@tabasserver; Database=TabasDB; Port=5432; Password=Password1;SSLMode=Prefer"; using (var conn = new NpgsqlConnection(connString)) { Console.Out.WriteLine("Opening connection"); conn.Open(); string query = "SELECT * FROM avion WHERE id='@id'"; query = query.Replace("@id", id.ToString()); using (var command = new NpgsqlCommand(query, conn)) { var reader = command.ExecuteReader(); List <CreateAvion> listavion = new List <CreateAvion>(); while (reader.Read()) { CreateAvion avion = null; avion = new CreateAvion(); avion.tid = reader.GetValue(0).ToString(); avion.tmodelo = reader.GetValue(1).ToString(); avion.tcapacidad = Convert.ToInt32(reader.GetValue(2)); listavion.Add(avion); } return(listavion); } } }
public bool Post(CreateAvion avion) { if (avion != null) { return(CreateAvionRepository.addAvionDB(avion)); } else { return(false); } }
public static bool addAvionDB(CreateAvion avion) { //string connString = "Server={0}; User Id={1}; Database={2}; Port={3}; Password={4};SSLMode=Prefer"; string connString = "Server=tabasserver.postgres.database.azure.com; User Id=chanchus@tabasserver; Database=TabasDB; Port=5432; Password=Password1;SSLMode=Prefer"; using (var conn = new NpgsqlConnection(connString)) { Console.Out.WriteLine("Opening connection"); conn.Open(); using (var command = new NpgsqlCommand("INSERT INTO avion(id, modelo, capacidad) VALUES(@tid, @tmodelo, @tcapacidad)", conn)) { command.Parameters.AddWithValue("@tid", avion.tid); command.Parameters.AddWithValue("@tmodelo", avion.tmodelo); command.Parameters.AddWithValue("@tcapacidad", avion.tcapacidad); int nRows = command.ExecuteNonQuery(); Console.Out.WriteLine(String.Format("Number of rows updated={0}", nRows)); return(true); } } }