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