Esempio n. 1
0
        public IActionResult Update(string id, CustomerPlace customerPlaceIn)
        {
            var customerPlace = _customerPlaceService.Get(int.Parse(id));

            if (customerPlace == null)
            {
                return(NotFound());
            }

            _customerPlaceService.Update(int.Parse(id), customerPlaceIn);

            return(NoContent());
        }
Esempio n. 2
0
        public void Remove(IDBEntity entity)
        {
            CustomerPlace customerPlaceIn = (CustomerPlace)entity;

            using (MySqlConnection connection = StaticService.GetConnection())
            {
                StaticService.adapter.DeleteCommand =
                    new MySqlCommand("DELETE FROM mydb.customersPlaces WHERE (Id = " + customerPlaceIn.Id + ");", connection);
                connection.Open();
                StaticService.adapter.DeleteCommand.ExecuteNonQuery();
            }
            //
            StaticService.customersPlaces.Remove(customerPlaceIn);
        }
Esempio n. 3
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. 4
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. 5
0
        public ActionResult <Place> Create(CustomerPlace customerPlace)
        {
            _customerPlaceService.Create(customerPlace);

            return(CreatedAtRoute("GetPlaceUpdate", new { id = customerPlace.Id.ToString() }, customerPlace));
        }