public static List <CreateBagcart> GetBagcart(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 bagcart WHERE id='@id'"; query = query.Replace("@id", id.ToString()); using (var command = new NpgsqlCommand(query, conn)) { var reader = command.ExecuteReader(); List <CreateBagcart> listabagcart = new List <CreateBagcart>(); while (reader.Read()) { CreateBagcart bagcart = null; bagcart = new CreateBagcart(); bagcart.tid = reader.GetValue(0).ToString(); bagcart.tmarca = reader.GetValue(1).ToString(); bagcart.tmodelo = Convert.ToInt32(reader.GetValue(2)); listabagcart.Add(bagcart); } return(listabagcart); } } }
public bool Post(CreateBagcart bagcart) { if (bagcart != null) { return(CreateBagcartRepository.addBagcartToDB(bagcart)); } else { return(false); } }
public static bool addBagcartToDB(CreateBagcart bagcart) { //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("SELECT CreateBagcart(@ID, @TMarca, @TModelo)", conn)) { command.Parameters.AddWithValue("@ID", bagcart.tid); command.Parameters.AddWithValue("@TMarca", bagcart.tmarca); command.Parameters.AddWithValue("@TModelo", bagcart.tmodelo); int nRows = command.ExecuteNonQuery(); Console.Out.WriteLine(String.Format("Number of rows updated={0}", nRows)); return(true); } } }