/// <summary> /// Gets all map projects in the database /// </summary> /// <returns>All map projects in the database</returns> public static MapProjects GetAllMapProjects() { MapProjects toReturn = new MapProjects(); MapProject temp = null; DataTable dt = null; string query = "SELECT * FROM MapProject"; dt = DatabaseHelper.ExecuteTextCommandQuery(GetConnectionString(), query); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { temp = new MapProject(); temp.Name = DatabaseHelper.GetValidValueFromObject(dr["Name"], string.Empty); temp.TileMaps = new TileEngine.Collections.TileMaps(); temp.Tileset = GetObjectDirectory(DatabaseHelper.GetValidValueFromObject(dr["Tileset"], (long)0)); } } return toReturn; }
/// <summary> /// Inserts or Updates the given map project to the database /// </summary> /// <param name="o">The Map Project to insert or update</param> public static void InsertUpdateMapProject(MapProject o) { string query = string.Empty; SqlCommand cmd = null; if (o != null) { cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; //Update if (o.ID > 0) { query = "UPDATE [MapProject] SET Name = @Name, Tileset = @Tileset WHERE ID = @ID"; cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = o.ID; } //Insert else { query = "INSERT INTO [MapProject] (Name, Tileset) VALUES (@Name, @Tileset)"; } cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = o.Name; cmd.Parameters.Add("@Tileset", SqlDbType.BigInt).Value = o.Tileset.ID; cmd.CommandText = query; DatabaseHelper.ExecuteCommand(GetConnectionString(), cmd); } }