public void DeleteCountry(ManufacturerCountry country, Proxy proxy) { string sqlExpression = string.Format(@"DELETE FROM manufacturercountry WHERE Id = {0} AND CountryName = ""{1}""", country.Id, country.CountryName); using (var connection = Connection.GetInstance().GetConnection()) { connection.Open(); MySqlCommand command = new MySqlCommand(sqlExpression, connection); var number = command.ExecuteNonQuery(); Console.WriteLine($"Deleted {number} rows"); } NotifyAllObservers(); }
public void UpdateCountry(ManufacturerCountry manufacturerCountry, string newName, Proxy proxy) { string sqlexpression = string.Format(@"UPDATE manufacturercountry SET CountryName = ""{0}"" WHERE Id = {1}", newName, manufacturerCountry.Id); using (var connection = Connection.GetInstance().GetConnection()) { connection.Open(); MySqlCommand command = new MySqlCommand(sqlexpression, connection); var number = command.ExecuteNonQuery(); Console.WriteLine($"{number} rows was updated"); } NotifyAllObservers(); }
public ManufacturerCountry CreateCountry(string name, Proxy proxy) { ManufacturerCountry country = null; string sqlexpression = string.Format(@"INSERT INTO manufacturercountry (CountryName) VALUES (""{0}"")", name); using (var connection = Connection.GetInstance().GetConnection()) { connection.Open(); MySqlCommand command = new MySqlCommand(sqlexpression, connection); int number = command.ExecuteNonQuery(); Console.WriteLine($"Added {number} elements"); } country = GetByName(name); NotifyAllObservers(); return(country); }
public ManufacturerCountry GetById(int id) { ManufacturerCountry country = null; string sqlexpression = String.Format("SELECT * FROM manufacturercountry WHERE ID = {0}", id); using (var connection = Connection.GetInstance().GetConnection()) { connection.Open(); MySqlCommand command = new MySqlCommand(sqlexpression, connection); var reader = command.ExecuteReader(); if (reader.HasRows) { Console.WriteLine($"{reader.GetName(0)}\t{reader.GetName(1)}"); while (reader.Read()) { country = new ManufacturerCountry((int)reader.GetValue(0), (string)reader.GetValue(1)); } } reader.Close(); } return(country); }