Beispiel #1
0
        // Puni model detaljima o zgradi koja se nalazi u gradu sa cityID, u redu row i koloni column

        public void fillBuildingsDetailsModel(int cityID, int row, int column, RS2Entities entities)
        {
            try
            {
                var result = (from BUILDING in entities.buildings
                              join CITY_BUILDINGS in entities.city_buildings on BUILDING.id equals CITY_BUILDINGS.building_id
                              where (CITY_BUILDINGS.city_id == cityID &&
                                     CITY_BUILDINGS.building_positionX == row &&
                                     CITY_BUILDINGS.building_positionY == column)
                              select new
                {
                    resultBuilding = BUILDING,
                    resultCityBuildings = CITY_BUILDINGS
                }
                              ).First();

                BuildingModel      = result.resultBuilding;
                CityBuildingsModel = result.resultCityBuildings;
            }
            catch
            {
                this.BuildingModel      = null;
                this.CityBuildingsModel = null;
            }
        }
Beispiel #2
0
        public ActionResult AddBuilding(int id, int row, int column, int buildingID, long buildDate, int buildTime)
        {
            city_buildings CB = new city_buildings();
            int            nextID;

            try
            {
                nextID = (entities.city_buildings.Max(u => u.id)) + 1;
            }
            catch
            {
                nextID = 0;
            }

            CB.id  = nextID;
            CB.lvl = 1;
            CB.building_positionX = row;
            CB.building_positionY = column;
            CB.building_id        = buildingID;
            CB.city_id            = id;
            CB.isPending          = 1;
            CB.buildStarted       = Constants.convertSecondsToDateTime(buildDate);
            Debug.WriteLine("U bazu idem datum:" + buildDate);
            CB.buildTime = buildTime;

            Debug.Write("ID: " + CB.id + "\n" +
                        "CityID: " + CB.city_id + "\n" +
                        "BuildingID: " + CB.building_id + "\n" +
                        "Lvl: " + CB.lvl + "\n" +
                        "X: " + CB.building_positionX + "\n" +
                        "Y: " + CB.building_positionY + "\n" +
                        "isPending: " + CB.isPending + "\n" +
                        "buildStarted: " + CB.buildStarted + "\n" +
                        "buildTime: " + CB.buildTime + "\n");

            entities.AddTocity_buildings(CB);
            entities.SaveChanges();
            return(RedirectToAction("ShowCity", "Home", new { id = id }));
        }