// 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; } }
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 })); }