BAGCST.api.FoodMenu.Database.onlinePlaceDB.saveNewPlace C# (CSharp) Method

        public PlaceItem saveNewPlace(PlaceItem place)
        {

            sqlConnection = null;
            sqlConnection = TimeTableDatabase.getConnection();
            try
            {
                using (sqlConnection)
                {
                    string SQL = "INSERT INTO [foodplace] ([name]) " +
                        "VALUES('" + place.PlaceName + "');" +
                        "SELECT SCOPE_IDENTITY();";
                    sqlConnection.Open();
                    SqlCommand myCommand = new SqlCommand(SQL, sqlConnection);
                    int LastID = Convert.ToInt32(myCommand.ExecuteScalar());
                    sqlConnection.Close();
                    sqlConnection = null;
                    return getPlaceItem(LastID);
                }
            }
            catch (System.Exception ex)
            {

                return null;
            }
        }
    }