Exemple #1
0
        public static void AddNewBar(string NameShop, Vector3 position)
        {
            const int eCola           = 50;
            const int Sprunk          = 50;
            const int Schokoriegel    = 50;
            const int Wasser          = 50;
            const int Chips           = 50;
            const int Repair_Kit      = 50;
            const int Bottle          = 50;
            const int Flashlight      = 50;
            const int Beer            = 50;
            const int Caffe           = 50;
            const int Benzin_Kanister = 50;
            const int Tabak           = 50;
            const int Gamburger       = 50;
            const int Viske           = 50;

            switch (NameShop)
            {
            case "Bar":
                Dictionary <string, string> parametersBar = new Dictionary <string, string>
                {
                    { "@NameShop", NameShop },
                    { "@Position", JsonConvert.SerializeObject(position) },
                    { "@eCola", eCola.ToString() },
                    { "@Sprunk", Sprunk.ToString() },
                    { "@Schokoriegel", Schokoriegel.ToString() },
                    { "@Wasser", Wasser.ToString() },
                    { "@Chips", Chips.ToString() },
                    { "@Repair_Kit", Repair_Kit.ToString() },
                    { "@Bottle", Bottle.ToString() },
                    { "@Flashlight", Flashlight.ToString() },
                    { "@Beer", Beer.ToString() },
                    { "@Caffe", Caffe.ToString() },
                    { "@Benzin_Kanister", Benzin_Kanister.ToString() },
                    { "@Tabak", Tabak.ToString() },
                    { "@Gamburger", Gamburger.ToString() },
                    { "@Viske", Viske.ToString() }
                };

                DataTable resultBar = Database.ExecutePreparedStatement("INSERT INTO bar_storages (NameShop, Position, eCola, Sprunk, Schokoriegel, Wasser, Chips, Repair_Kit, Bottle, Flashlight, Beer, Caffe, Benzin_Kanister, Tabak, Gamburger, Viske) " +
                                                                        "VALUES (@NameShop, @Position, @eCola, @Sprunk, @Schokoriegel, @Wasser, @Chips, @Repair_Kit, @Bottle, @Flashlight, @Beer, @Caffe, @Benzin_Kanister, @Tabak, @Gamburger, @Viske)", parametersBar);

                break;
            }
        }
 // Update is called once per frame
 private void Awake()
 {
     timer = GetComponentInChildren <Repair_Kit>();
 }