public GameMap LoadGameMap(int mapID) { SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RPGMasterDb"].ConnectionString); SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = "LoadGameMap"; command.CommandType = CommandType.StoredProcedure; SqlParameter MapID = new SqlParameter("@MapID", SqlDbType.Int); MapID.Value = mapID; command.Parameters.Add(MapID); connection.Open(); SqlDataReader dr; dr = command.ExecuteReader(); var gameMap = new GameMap(); if (dr.HasRows) { dr.Read(); gameMap.Name = dr.GetString(0); gameMap.TilesData = dr.GetString(1); } connection.Close(); dr.Close(); return gameMap; }
public void SaveGameMap(GameMap gameMap) { SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RPGMasterDb"].ConnectionString); SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = "SaveGameMap"; command.CommandType = CommandType.StoredProcedure; SqlParameter Name = new SqlParameter("@Name", SqlDbType.NVarChar); SqlParameter UserName = new SqlParameter("@UserName", SqlDbType.NVarChar); SqlParameter TilesData = new SqlParameter("@TilesData", SqlDbType.NVarChar); SqlParameter isActive = new SqlParameter("@isActive", SqlDbType.NVarChar); Name.Value = gameMap.Name; UserName.Value = gameMap.UserName; TilesData.Value = gameMap.TilesData; isActive.Value = 1; command.Parameters.Add(Name); command.Parameters.Add(UserName); command.Parameters.Add(TilesData); command.Parameters.Add(isActive); connection.Open(); command.ExecuteNonQuery(); connection.Close(); }
public string SaveMap(GameMap gameMap) { var MapRepo = new MapRepository(); MapRepo.SaveStoredGameMap(gameMap); return "{'Result': '" + gameMap.Name + " Map Saved.'}"; }
public void SaveStoredGameMap(GameMap gameMap) { var sm = new StoredGameMap(); sm.SaveGameMap(gameMap); }