private void AddInsertSongVerses(Dictionary <string, MigrationSongVerse> mVerses)
{
using (JetTask t = new JetTask())
{
t.Parameters.Add("@AutoNumber", OleDbType.Integer);
t.Parameters.Add("@IsChorus", OleDbType.SmallInt);
t.Parameters.Add("@Verse", OleDbType.VarWChar, 0);
t.Parameters.Add("@OrderNum", OleDbType.Integer);
foreach (MigrationSongVerse msv in mVerses.Values)
{
t.Parameters["@AutoNumber"].Value = msv.autoNumber;
t.Parameters["@IsChorus"].Value = msv.isChorus ? 1 : 0;
t.Parameters["@Verse"].Value = msv.verse;
t.Parameters["@OrderNum"].Value = msv.orderNumber;
if (!msv.foundInNew)
{
t.CommandText = "INSERT INTO [SongVerses] ([AutoNumber], [IsChorus], [Verse], [OrderNum]) " +
"VALUES (@AutoNumber, @IsChorus, @Verse, @OrderNum)";
t.ExecuteNonQuery();
}
else
{
t.CommandText = "UPDATE [SongVerses] " +
"SET [AutoNumber] = @AutoNumber, " +
"[IsChorus] = @IsChorus, " +
"[Verse] = @Verse, " +
"[OrderNum] = @OrderNum " +
"WHERE ([AutoNumber] = @AutoNumber AND [OrderNum] = @OrderNum)";
t.ExecuteNonQuery();
}
}
}
}
private void AddInsertSongs(Dictionary <int, MigrationSong> mSongs)
{
using (JetTask t = new JetTask())
{
t.Parameters.Add("@AutoNumber", OleDbType.Integer);
t.Parameters.Add("@Number", OleDbType.Integer);
t.Parameters.Add("@Title", OleDbType.VarWChar, 0);
t.Parameters.Add("@Chorus", OleDbType.VarWChar, 0);
t.Parameters.Add("@Location", OleDbType.VarWChar, 0);
t.Parameters.Add("@DisplayDefault", OleDbType.SmallInt);
t.Parameters.Add("@ImageId", OleDbType.Integer);
t.Parameters.Add("@Overlay", OleDbType.Integer);
t.Parameters.Add("@FontId", OleDbType.Integer);
t.Parameters.Add("@Settings", OleDbType.VarWChar, 0);
foreach (MigrationSong ms in mSongs.Values)
{
t.Parameters["@AutoNumber"].Value = ms.autoNumber;
t.Parameters["@Number"].Value = ms.number;
t.Parameters["@Title"].Value = ms.title;
t.Parameters["@Chorus"].Value = ms.chorus;
t.Parameters["@Location"].Value = ms.location;
t.Parameters["@DisplayDefault"].Value = ms.displayDefault ? 1 : 0;
t.Parameters["@ImageId"].Value = ms.imageId;
t.Parameters["@Overlay"].Value = ms.overlay;
t.Parameters["@FontId"].Value = ms.fontId;
t.Parameters["@Settings"].Value = ms.settings;
if (!ms.foundInNew)
{
t.CommandText = "INSERT INTO [Songs] " +
"([AutoNumber], [Number], [Title], [Chorus], [Location], [DisplayDefault], [ImageId], [Overlay], [FontId], [Settings]) VALUES " +
"(@AutoNumber, @Number, @Title, @Chorus, @Location, @DisplayDefault, @ImageId, @Overlay, @FontId, @Settings)";
t.ExecuteNonQuery();
}
else
{
t.CommandText = "UPDATE [Songs] SET " +
"[AutoNumber] = @AutoNumber, " +
"[Number] = @Number, " +
"[Title] = @Title, " +
"[Chorus] = @Chorus, " +
"[Location] = @Location, " +
"[DisplayDefault] = @DisplayDefault, " +
"[ImageId] = @ImageId, " +
"[Overlay] = @Overlay, " +
"[FontId] = @FontId, " +
"[Settings] = @Settings WHERE [AutoNumber] = @AutoNumber";
t.ExecuteNonQuery();
}
}
}
}
