Esempio n. 1
0
 public void Remove(int id)
 {
     using (MySqlConnection connection = StaticService.GetConnection())
     {
         StaticService.adapter.DeleteCommand =
             new MySqlCommand("DELETE FROM mydb.cities WHERE (Id = " + id.ToString() + ");", connection);
         connection.Open();
         StaticService.adapter.DeleteCommand.ExecuteNonQuery();
     }
     StaticService.cities.Remove(StaticService.cities.Find(x => x.Id == id));
 }
Esempio n. 2
0
        public void Remove(IDBEntity entity)
        {
            City cityIn = (City)entity;

            using (MySqlConnection connection = StaticService.GetConnection())
            {
                StaticService.adapter.DeleteCommand =
                    new MySqlCommand("DELETE FROM mydb.cities WHERE (Id = " + cityIn.Id + ");", connection);
                connection.Open();
                StaticService.adapter.DeleteCommand.ExecuteNonQuery();
            }
            //
            StaticService.cities.Remove(cityIn);
        }
Esempio n. 3
0
        public void Remove(IDBEntity entity)
        {
            Customer customerIn = (Customer)entity;

            using (MySqlConnection connection = StaticService.GetConnection())
            {
                StaticService.adapter.DeleteCommand =
                    new MySqlCommand("DELETE FROM mydb.customers WHERE (Name = '" + customerIn.Name + "') AND (FirstName = '"
                                     + customerIn.FirstName + "');", connection);
                connection.Open();
                StaticService.adapter.DeleteCommand.ExecuteNonQuery();
            }
            //
            StaticService.customers.Remove(customerIn);
        }
Esempio n. 4
0
        public IDBEntity Create(IDBEntity entity)
        {
            City city = (City)entity;

            using (MySqlConnection connection = StaticService.GetConnection())
            {
                StaticService.adapter.InsertCommand = new MySqlCommand(
                    "INSERT INTO mydb.cities " +
                    "VALUES(@Id,@City);",
                    connection);
                StaticService.adapter.InsertCommand.Parameters.Add("@Id", MySqlDbType.Int32).Value     = city.Id;
                StaticService.adapter.InsertCommand.Parameters.Add("@City", MySqlDbType.VarChar).Value = city.Name;


                connection.Open();
                StaticService.adapter.InsertCommand.ExecuteNonQuery();
            }
            StaticService.cities.Add(city);
            return(city);
        }
Esempio n. 5
0
        public void Update(int id, IDBEntity entity)
        {
            City cityIn = (City)entity;

            using (MySqlConnection connection = StaticService.GetConnection())
            {
                string query =
                    @"UPDATE cities SET Id =" + cityIn.Id + " ,City = '" + cityIn.Name +
                    @" WHERE (" +
                    @"Id = " + cityIn.Id + @")";

                MySqlDataAdapter localAadapter = new MySqlDataAdapter();

                localAadapter.UpdateCommand = new MySqlCommand(query, connection);
                connection.Open();
                localAadapter.UpdateCommand.ExecuteNonQuery();
            }
            //
            StaticService.cities.Remove(StaticService.cities.Find(city => city.Id == id));
            StaticService.cities.Add(cityIn);
        }
Esempio n. 6
0
        public IDBEntity Create(IDBEntity entity)
        {
            CustomerPlace customerPlace = (CustomerPlace)entity;

            using (MySqlConnection connection = StaticService.GetConnection())
            {
                StaticService.adapter.InsertCommand = new MySqlCommand(
                    "INSERT INTO mydb.customersPlaces " +
                    "VALUES(@Id,@UpdateTime,@CustomerId,@PlaceId);",
                    connection);
                StaticService.adapter.InsertCommand.Parameters.Add("@Id", MySqlDbType.Int32).Value             = customerPlace.Id;
                StaticService.adapter.InsertCommand.Parameters.Add("@UpdateTime", MySqlDbType.Timestamp).Value = customerPlace.UpdateTime; // no ToString("FormatString")
                StaticService.adapter.InsertCommand.Parameters.Add("@CustomerId", MySqlDbType.Int32).Value     = customerPlace.CustomerId;
                StaticService.adapter.InsertCommand.Parameters.Add("@PlaceId", MySqlDbType.Int32).Value        = customerPlace.PlaceId;

                connection.Open();
                StaticService.adapter.InsertCommand.ExecuteNonQuery();
            }
            StaticService.customersPlaces.Add(customerPlace);
            return(customerPlace);
        }
Esempio n. 7
0
        public void Update(int id, IDBEntity entity)
        {
            CustomerPlace customerPlaceIn = (CustomerPlace)entity;

            using (MySqlConnection connection = StaticService.GetConnection())
            {
                string query =
                    @"UPDATE customersPlaces SET Id =" + customerPlaceIn.Id + " ,UpdateTime = '" + customerPlaceIn.UpdateTime.ToString("yyyy-MM-dd hh:mm:ss") + "' ,CustomerId = " + customerPlaceIn.CustomerId + " ,PlaceId = " + customerPlaceIn.PlaceId +
                    @" WHERE (" +
                    @"Id = " + customerPlaceIn.Id + @")";

                MySqlDataAdapter localAadapter = new MySqlDataAdapter();

                localAadapter.UpdateCommand = new MySqlCommand(query, connection);
                connection.Open();
                localAadapter.UpdateCommand.ExecuteNonQuery();
            }
            //
            StaticService.customersPlaces.Remove(StaticService.customersPlaces.Find(city => city.Id == id));
            StaticService.customersPlaces.Add(customerPlaceIn);
        }
Esempio n. 8
0
        public IDBEntity Create(IDBEntity entity)
        {
            Place place = (Place)entity;

            using (MySqlConnection connection = StaticService.GetConnection())
            {
                StaticService.adapter.InsertCommand = new MySqlCommand(
                    "INSERT INTO mydb.places " +
                    "VALUES(@Id,@CityId,@Street);",
                    connection);
                StaticService.adapter.InsertCommand.Parameters.Add("@Id", MySqlDbType.Int32).Value       = place.Id;
                StaticService.adapter.InsertCommand.Parameters.Add("@CityId", MySqlDbType.Int32).Value   = place.City.Id;
                StaticService.adapter.InsertCommand.Parameters.Add("@Street", MySqlDbType.VarChar).Value = place.Street;


                connection.Open();
                StaticService.adapter.InsertCommand.ExecuteNonQuery();
            }
            StaticService.places.Add(place);
            return(place);
        }
Esempio n. 9
0
        public void Update(int id, IDBEntity entity)
        {
            Place placeIn = (Place)entity;

            using (MySqlConnection connection = StaticService.GetConnection())
            {
                string query =
                    @"UPDATE places SET Id =" + placeIn.Id + " ,CityId = '" + placeIn.City.Id + "' ,Street = '" + placeIn.Street +
                    @"' WHERE (" +
                    @"Id = " + placeIn.Id + @")";

                MySqlDataAdapter localAadapter = new MySqlDataAdapter();

                localAadapter.UpdateCommand = new MySqlCommand(query, connection);
                connection.Open();
                localAadapter.UpdateCommand.ExecuteNonQuery();
            }
            //
            StaticService.places.Remove(StaticService.places.Find(city => city.Id == id));
            StaticService.places.Add(placeIn);
        }
Esempio n. 10
0
        public void Update(int id, IDBEntity entity)
        {
            Customer customerIn = (Customer)entity;

            using (MySqlConnection connection = StaticService.GetConnection())
            {
                string query =
                    @"UPDATE customers SET Id = " + customerIn.Id + " ,Name = '" + customerIn.Name +
                    @"',FirstName = '" + customerIn.FirstName +
                    @"',DateOfBirth = '" + customerIn.DateOfBirth.ToString("yyyy-MM-dd") +
                    @"' WHERE (" +
                    @"Id = " + id + @")";

                MySqlDataAdapter localAadapter = new MySqlDataAdapter();

                localAadapter.UpdateCommand = new MySqlCommand(query, connection);
                connection.Open();
                localAadapter.UpdateCommand.ExecuteNonQuery();
            }
            //
            StaticService.customers.Remove(StaticService.customers.Find(customer => customer.Id == id));
            StaticService.customers.Add(customerIn);
        }
Esempio n. 11
0
        public IDBEntity Create(IDBEntity entity)
        {
            Customer customer = (Customer)entity;

            using (MySqlConnection connection = StaticService.GetConnection())
            {
                StaticService.adapter.InsertCommand = new MySqlCommand(
                    "INSERT INTO mydb.customers " +
                    "VALUES(@Id,@Name,@FirstName,@DateOfBirth);",
                    connection);
                StaticService.adapter.InsertCommand.Parameters.Add("@Id", MySqlDbType.Int32).Value          = customer.Id;
                StaticService.adapter.InsertCommand.Parameters.Add("@Name", MySqlDbType.VarChar).Value      = customer.Name;
                StaticService.adapter.InsertCommand.Parameters.Add("@FirstName", MySqlDbType.VarChar).Value = customer.Name;
                StaticService.adapter.InsertCommand.Parameters.Add("@DateOfBirth", MySqlDbType.Date).Value  = customer.DateOfBirth.ToString("yyyy-MM-dd");



                connection.Open();
                StaticService.adapter.InsertCommand.ExecuteNonQuery();
            }
            StaticService.customers.Add(customer);
            return(customer);
        }