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