BSEtunes

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using MySql.Data.MySqlClient;
using System.Globalization;
using BSE.Platten.BO.Properties;

namespace BSE.Platten.BO
{
    public class CBSEAdminModel : ModelSql
    {
        #region MethodsPublic

        public static CDataSetAlbum GetDataSetAlbumByQueryParams(string strConnection, CAlbum queryParamsAlbum)
        {
            if (queryParamsAlbum == null)
            {
                throw new ArgumentNullException(
                    string.Format(
                    CultureInfo.CurrentUICulture,
                    Resources.IDS_ArgumentException,
                    typeof(CAlbum).Name));
            }
            
            string strSelectAlbumSql = "SELECT t.titelid, i.interpret, t.titel," +
                " t.interpretid, t.erschdatum, t.mediumid, t.genreid, t.mp3tag, t.guid," +
                " t.pictureformat, t.cover,t.thumbnail, t.erstelldatum," +
                " t.erstellernm, t.mutationdatum, t.mutationnm, t.timestamp" +
                " FROM platten.titel t" +
                " JOIN platten.interpreten i ON t.interpretid = i.interpretid" +
                " WHERE i.interpret LIKE ?interpret" +
                " AND t.titel LIKE ?Titel";
            if (queryParamsAlbum.MediumId > 0)
            {
                strSelectAlbumSql += " AND t.mediumid = ?MediumId";
            }
            if (queryParamsAlbum.GenreId > 0)
            {
                strSelectAlbumSql += " AND t.genreid = ?GenreId";
            }
            if (queryParamsAlbum.Year > 0)
            {
                strSelectAlbumSql += " AND t.erschdatum = ?ErschDatum";
            }
            strSelectAlbumSql += " ORDER BY i.interpret,t.titel";

            string strSelectTracksSql = "Select l.liedid,l.titelid,l.track,l.lied," +
                " l.dauer,l.liedpfad,l.guid,l.timestamp FROM platten.lieder l" +
                " JOIN platten.titel t ON l.titelid = t.titelid" +
                " JOIN platten.interpreten i ON t.interpretid = i.interpretid" +
                " WHERE i.interpret LIKE ?Interpret" +
                " AND t.titel LIKE ?Titel";
            if (queryParamsAlbum.MediumId > 0)
            {
                strSelectTracksSql += " AND t.mediumid = ?mediumID";
            }
            if (queryParamsAlbum.GenreId > 0)
            {
                strSelectTracksSql += " AND t.genreid = ?GenreId";
            }
            if (queryParamsAlbum.Year > 0)
            {
                strSelectTracksSql += " AND t.erschdatum = ?ErschDatum";
            }
            strSelectTracksSql += " ORDER BY l.track";

            CDataSetAlbum dataSet = null;

            using (MySqlConnection mySqlConnection = new MySqlConnection(strConnection))
            {
                mySqlConnection.Open();

                dataSet = new CDataSetAlbum();

                using (MySqlDataAdapter mySqlDataAdapterAlbum = new MySqlDataAdapter())
                {
                    mySqlDataAdapterAlbum.SelectCommand = new MySqlCommand(strSelectAlbumSql, mySqlConnection);
                    SelectAlbumParams(mySqlDataAdapterAlbum.SelectCommand, queryParamsAlbum);
                    mySqlDataAdapterAlbum.Fill(dataSet, "Album");
                }

                using (MySqlDataAdapter mySqlDataAdapterTracks = new MySqlDataAdapter())
                {
                    mySqlDataAdapterTracks.SelectCommand = new MySqlCommand(strSelectTracksSql, mySqlConnection);
                    SelectAlbumParams(mySqlDataAdapterTracks.SelectCommand, queryParamsAlbum);
                    mySqlDataAdapterTracks.Fill(dataSet, "Tracks");
                }
            }
            return dataSet;
        }

        public static CDataSetAlbum GetDataSetAlbumByTitelId(string strConnection, int iTitelId)
        {
            string strSelectAlbumSql = "SELECT t.titelid, i.interpret, t.titel," +
                " t.interpretid, t.erschdatum, t.mediumid, t.genreid, t.mp3tag, t.guid," +
                " t.pictureformat, t.cover, t.thumbnail , t.erstelldatum," +
                " t.erstellernm, t.mutationdatum, t.mutationnm, t.timestamp" +
                " FROM platten.titel t" +
                " JOIN platten.interpreten i ON t.interpretid = i.interpretid" +
                " WHERE t.titelid = ?TitelID";

            string strSelectTracksSql = "Select l.liedid,l.titelid,l.track,l.lied," +
                " l.dauer,l.liedpfad,l.guid,l.timestamp FROM platten.lieder l" +
                " JOIN platten.titel t ON l.titelid = t.titelid" +
                " JOIN platten.interpreten i ON t.interpretid = i.interpretid" +
                " WHERE t.titelid = ?TitelID" +
                " ORDER BY l.track";

            CDataSetAlbum dataSet = null;

            using (MySqlConnection mySqlConnection = new MySqlConnection(strConnection))
            {
                mySqlConnection.Open();

                dataSet = new CDataSetAlbum();

                using (MySqlDataAdapter mySqlDataAdapterAlbum = new MySqlDataAdapter())
                {
                    mySqlDataAdapterAlbum.SelectCommand = new MySqlCommand(strSelectAlbumSql, mySqlConnection);
                    MySqlParameter mySqlParameter = mySqlDataAdapterAlbum.SelectCommand.Parameters.Add(new MySqlParameter("TitelID", MySqlDbType.Int32, 0));
                    mySqlParameter.Direction = ParameterDirection.Input;
                    mySqlParameter.SourceColumn = "TitelID";
                    mySqlParameter.Value = iTitelId;
                    mySqlDataAdapterAlbum.Fill(dataSet, "Album");
                }

                using (MySqlDataAdapter mySqlDataAdapterTracks = new MySqlDataAdapter())
                {
                    mySqlDataAdapterTracks.SelectCommand = new MySqlCommand(strSelectTracksSql, mySqlConnection);
                    MySqlParameter mySqlParameter = mySqlDataAdapterTracks.SelectCommand.Parameters.Add(new MySqlParameter("TitelID", MySqlDbType.Int32, 0));
                    mySqlParameter.Direction = ParameterDirection.Input;
                    mySqlParameter.SourceColumn = "TitelID";
                    mySqlParameter.Value = iTitelId;
                    mySqlDataAdapterTracks.Fill(dataSet, "Tracks");
                }
            }
            return dataSet;
        }

        public DataSet Update(string strConnection, DataSet dataSet)
        {
            if (dataSet == null)
            {
                throw new ArgumentNullException(
                    string.Format(
                    CultureInfo.CurrentUICulture,
                    Resources.IDS_ArgumentException,
                    typeof(DataSet).Name));
            }
            
            using (MySqlConnection mySqlConnection = new MySqlConnection(strConnection))
            {
                mySqlConnection.Open();
                try
                {
                    using (MySqlTransaction mySqlTransaction = mySqlConnection.BeginTransaction())
                    {
                        bool bHasError = false;
                        if (dataSet.Tables[0].GetChanges() != null)
                        {
                            UpdateAlbum(dataSet, mySqlConnection);
                            //Workaround
                            //Die MySql MyISAM Engine kann nicht mit Transactions umgehen.
                            //Da bei �nderungen der Tracks das Mutationsdatum in den Titel Datensatz geschrieben wird
                            //kann so die Mutation des Tracks verhindert werden
                            if (dataSet.Tables[0].HasErrors == true)
                            {
                                bHasError = true;
                            }
                        }
                        if (dataSet.Tables[1].GetChanges() != null)
                        {
                            if (bHasError == false)
                            {
                                UpdateTracks(dataSet, mySqlConnection);
                            }
                        }
                        if (dataSet.HasErrors == false)
                        {
                            mySqlTransaction.Commit();
                            dataSet.AcceptChanges();
                        }
                    }
                }
                catch (MySqlException)
                {
                    throw;
                }
            }
            return dataSet;
        }

        #endregion

        #region MethodsPrivate

        private void UpdateAlbum(DataSet dataSet, MySqlConnection mySqlConnection)
        {
            string strSelectSql = "SELECT t.titelid, i.interpret, t.titel," +
                " t.interpretid, t.erschdatum, t.mediumid, t.genreid, t.mp3tag, t.guid," +
                " t.pictureformat, t.cover, t.thumbnail, t.erstelldatum," +
                " t.erstellernm, t.mutationdatum, t.mutationnm, t.timestamp" +
                " FROM platten.titel t" +
                " JOIN platten.interpreten i ON t.interpretid = i.interpretid";

            string strInsertSql = "INSERT INTO platten.titel " +
                " (titelid,titel,interpretid,erschdatum,mediumid,genreid,mp3tag,guid," +
                " pictureformat,cover,thumbnail,erstelldatum,erstellernm) " +
                " VALUES(" +
                " 0,?Titel,?InterpretId,?ErschDatum,?MediumID,?GenreId,0,?Guid," +
                " ?PictureFormat,?Cover,?ThumbNail,now(),?ErstellerNm)";

            string strUpdateSql = "Update platten.titel" +
                " Set interpretid =?InterpretId, titel = ?Titel," +
                "erschDatum = ?ErschDatum, mediumid = ?MediumID, genreid = ?GenreId," +
                "mp3tag = ?mp3Tag," +
                "pictureformat = ?PictureFormat,cover = ?Cover,thumbnail = ?ThumbNail,mutationdatum = now(),mutationnm = ?MutationNm " +
                " WHERE titelid = ?TitelId AND guid = ?Guid AND timestamp = ?Timestamp";

            using (MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(strSelectSql, mySqlConnection))
            {
                mySqlDataAdapter.MissingSchemaAction = System.Data.MissingSchemaAction.AddWithKey;
                mySqlDataAdapter.InsertCommand = new MySqlCommand(strInsertSql, mySqlConnection);
                InsertAlbumParams(mySqlDataAdapter.InsertCommand);
                mySqlDataAdapter.UpdateCommand = new MySqlCommand(strUpdateSql, mySqlConnection);
                UpdateAlbumParams(mySqlDataAdapter.UpdateCommand);

                mySqlDataAdapter.RowUpdated += new MySqlRowUpdatedEventHandler(this.Albums_Updated);

                mySqlDataAdapter.Update(dataSet, "Album");
            }
        }

        private void Albums_Updated(object sender, MySqlRowUpdatedEventArgs rue)
        {
            if (rue.Status == UpdateStatus.ErrorsOccurred)
            {
                rue.Status = UpdateStatus.Continue;
                rue.Row.RowError = rue.Errors.Message;
            }
            else
            {
                rue.Row.ClearErrors();
                string strSelectSql = "SELECT * FROM titel t" +
                " WHERE t.guid = ?guid";

                using (MySqlCommand mySqlCommand = new MySqlCommand(strSelectSql, rue.Command.Connection))
                {
                    MySqlParameter mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Guid", MySqlDbType.VarChar, 36));
                    mySqlParameter.Direction = ParameterDirection.Input;
                    mySqlParameter.SourceColumn = "guid";
                    mySqlParameter.Value = rue.Row["guid"];

                    using (MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader())
                    {
                        if (mySqlDataReader.Read())
                        {
                            if (rue.StatementType == StatementType.Insert)
                            {
                                rue.Row["TitelId"] = GetInt32(mySqlDataReader, "TitelId", false, -1);
                                rue.Row["ErstellDatum"] = GetDateTime(mySqlDataReader, "ErstellDatum", true, new DateTime());
                                rue.Row["ErstellerNm"] = GetString(mySqlDataReader, "ErstellerNm", true, System.Environment.UserName);
                            }

                            if (rue.StatementType == StatementType.Update)
                            {
                                rue.Row["MutationDatum"] = GetDateTime(mySqlDataReader, "MutationDatum", true, new DateTime());
                                rue.Row["MutationNm"] = GetString(mySqlDataReader, "MutationNm", true, System.Environment.UserName);
                            }
                            rue.Row["Timestamp"] = GetDateTime(mySqlDataReader, "Timestamp", false, new DateTime());
                        }
                    }
                }
            }
        }

        private void UpdateTracks(DataSet dataSet, MySqlConnection mySqlConnection)
        {
            string strSelectSql = "SELECT * FROM platten.lieder WHERE liedid = ?LiedID";

            string strInsertSql = "INSERT INTO platten.lieder (liedid,titelid,track,lied,dauer,liedpfad,guid)" +
                " VALUES (0,?TitelId,?Track,?Lied,?Dauer,?Liedpfad,?guid)";

            string strUpdateSql = "UPDATE platten.lieder SET track = ?Track,lied = ?Lied,dauer = ?Dauer," +
                "liedpfad = ?Liedpfad" +
                " WHERE liedid = ?LiedID AND timestamp =?TimeStamp";

            string strDeleteSql = "DELETE FROM platten.lieder WHERE liedid = ?LiedID";

            using (MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter())
            {
                mySqlDataAdapter.SelectCommand = new MySqlCommand(strSelectSql, mySqlConnection);
                SelectTracksParams(mySqlDataAdapter.SelectCommand);
                mySqlDataAdapter.InsertCommand = new MySqlCommand(strInsertSql, mySqlConnection);
                InsertTracksParams(mySqlDataAdapter.InsertCommand);
                mySqlDataAdapter.UpdateCommand = new MySqlCommand(strUpdateSql, mySqlConnection);
                UpdateTracksParams(mySqlDataAdapter.UpdateCommand);
                mySqlDataAdapter.DeleteCommand = new MySqlCommand(strDeleteSql, mySqlConnection);
                DeleteTracksParams(mySqlDataAdapter.DeleteCommand);

                mySqlDataAdapter.RowUpdated += new MySqlRowUpdatedEventHandler(this.Tracks_Updated);
                mySqlDataAdapter.Update(dataSet, "Tracks");
            }
        }

        private void Tracks_Updated(object sender, MySqlRowUpdatedEventArgs rue)
        {
            if (rue.Status == UpdateStatus.ErrorsOccurred)
            {
                rue.Status = UpdateStatus.Continue;
                rue.Row.RowError = rue.Errors.Message;
            }
            else
            {
                rue.Row.ClearErrors();
                if (rue.StatementType == StatementType.Delete)
                {
                    return;
                }
                string strSelectSql = "SELECT * FROM lieder l" +
                " WHERE l.guid = ?guid";


                using (MySqlCommand mySqlCommand = new MySqlCommand(strSelectSql, rue.Command.Connection))
                {
                    MySqlParameter mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Guid", MySqlDbType.VarChar, 36));
                    mySqlParameter.Direction = ParameterDirection.Input;
                    mySqlParameter.SourceColumn = "guid";
                    mySqlParameter.Value = rue.Row["guid"];

                    using (MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader())
                    {
                        if (mySqlDataReader.Read())
                        {
                            if (rue.StatementType == StatementType.Insert)
                            {
                                rue.Row["LiedID"] = GetInt32(mySqlDataReader, "LiedID", false, -1);
                            }
                            rue.Row["Timestamp"] = GetDateTime(mySqlDataReader, "Timestamp", false, new DateTime());
                        }
                    }
                }
            }
        }

        private static void SelectAlbumParams(MySqlCommand mySqlCommand, CAlbum queryParamsAlbum)
        {
            MySqlParameter mySqlParameter = null;
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Interpret", MySqlDbType.VarChar, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Interpret";
            mySqlParameter.Value = queryParamsAlbum.Interpret;
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Titel", MySqlDbType.VarChar, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Titel";
            mySqlParameter.Value = queryParamsAlbum.Title;
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("MediumID", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "MediumID";
            mySqlParameter.Value = queryParamsAlbum.MediumId;
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("GenreId", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "genreid";
            mySqlParameter.Value = queryParamsAlbum.GenreId;
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("ErschDatum", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "ErschDatum";
            mySqlParameter.Value = queryParamsAlbum.Year;
        }

        private static void InsertAlbumParams(MySqlCommand mySqlCommand)
        {
            MySqlParameter mySqlParameter = null;
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("InterpretId", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "InterpretId";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Titel", MySqlDbType.VarChar, 60));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Titel";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("ErschDatum", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "ErschDatum";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("MediumId", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "MediumId";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("GenreId", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "GenreId";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Guid", MySqlDbType.VarChar, 36));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceVersion = System.Data.DataRowVersion.Original;
            mySqlParameter.SourceColumn = "Guid";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("PictureFormat", MySqlDbType.VarChar, 5));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "PictureFormat";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Cover", MySqlDbType.Blob, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Cover";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("ThumbNail", MySqlDbType.MediumBlob, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "ThumbNail";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("ErstellerNm", MySqlDbType.VarChar, 50));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "ErstellerNm";
        }

        private static void UpdateAlbumParams(MySqlCommand mySqlCommand)
        {
            MySqlParameter mySqlParameter = null;
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("TitelId", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "TitelId";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("InterpretId", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "InterpretId";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Titel", MySqlDbType.VarChar, 60));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Titel";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("ErschDatum", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "ErschDatum";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("MediumId", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "MediumId";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("GenreId", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "GenreId";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Guid", MySqlDbType.VarChar, 36));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Guid";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("PictureFormat", MySqlDbType.VarChar, 5));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "PictureFormat";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Cover", MySqlDbType.Blob, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Cover";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("ThumbNail", MySqlDbType.MediumBlob, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "ThumbNail";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("MutationNm", MySqlDbType.VarChar, 50));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "MutationNm";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Timestamp", MySqlDbType.Timestamp, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Timestamp";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Mp3Tag", MySqlDbType.Bit, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Mp3Tag";
        }

        private static void SelectTracksParams(MySqlCommand mySqlCommand)
        {
            MySqlParameter mySqlParameter = null;
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("LiedID", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "LiedID";
        }

        private static void InsertTracksParams(MySqlCommand mySqlCommand)
        {
            MySqlParameter mySqlParameter = null;
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("LiedID", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "LiedID";
            mySqlParameter.SourceVersion = DataRowVersion.Original;
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("TitelID", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "TitelID";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Track", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Track";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Lied", MySqlDbType.VarChar, 100));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Lied";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Dauer", MySqlDbType.DateTime, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Dauer";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Liedpfad", MySqlDbType.VarChar, 255));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Liedpfad";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Guid", MySqlDbType.VarChar, 36));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Guid";
        }

        private static void UpdateTracksParams(MySqlCommand mySqlCommand)
        {
            MySqlParameter mySqlParameter = null;
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("LiedID", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "LiedID";
            mySqlParameter.SourceVersion = DataRowVersion.Original;
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Track", MySqlDbType.Int32, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Track";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Lied", MySqlDbType.VarChar, 100));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Lied";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Dauer", MySqlDbType.DateTime, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Dauer";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Liedpfad", MySqlDbType.VarChar, 255));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Liedpfad";
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("Timestamp", MySqlDbType.Timestamp, 0));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "Timestamp";
        }

        private static void DeleteTracksParams(MySqlCommand mySqlCommand)
        {
            MySqlParameter mySqlParameter = null;
            mySqlParameter = mySqlCommand.Parameters.Add(new MySqlParameter("LiedID", MySqlDbType.Int32, 11));
            mySqlParameter.Direction = ParameterDirection.Input;
            mySqlParameter.SourceColumn = "LiedID";
        }

        #endregion
    }
}