Ejemplo n.º 1
0
        private void InsertQueueToSQL()
        {
            int song_id = -1;
            int artist_id = -1;
            int performer_id = -1;
            string firstname = "";
            string lastname = "";
            //if (this.is_SongDeleted == 1) CheckSongDeletion();
            try
            {
                for (int i = 0; i < this.songSyncList.Rows.Count; i++)
                {
                    // Get songList.Rows[i] ID, Artist ID, Performer ID for Insert songList.Rows[i]_queue

                    KaraoqDataAccess.KaraoqWebServiceSoapClient objClient = new KaraoqDataAccess.KaraoqWebServiceSoapClient();
                    song_id = objClient.getSongIdInSyncTrack(this.songSyncList.Rows[i]["Title"].ToString(), "0", "", this.songSyncList.Rows[i]["Artist"].ToString());

                    artist_id = objClient.getArtistIdInSyncTrack(this.songSyncList.Rows[i]["Artist"].ToString());

                    string[] performerName = this.songSyncList.Rows[i]["Singer"].ToString().Split(',');
                    for (int j = 0; j < performerName.Length; j++)
                    {
                        if (j == 0 && performerName[0] != null) firstname = performerName[0];
                        if (j == 1 && performerName[1] != null) lastname = performerName[1];
                    }
                    performer_id = objClient.getPerformerIdInSyncTrack(VenueId, firstname, lastname);
                    System.Diagnostics.Debug.WriteLine("\nXXXXXXXXXXXXXXXXX" + this.songSyncList.Rows[i]["Title"].ToString() + " and IDs are : " + song_id + "***" + artist_id + "***" + performer_id + "\n");

                    //System.Diagnostics.Debug.WriteLine(songList.Rows[i]["Singer"].ToString() + "////" + songList.Rows[i]["Position"].ToString() + "////" + songList.Rows[i]["Title"].ToString() + "////" + songList.Rows[i]["Artist"].ToString());
                    //KaraoqDataAccess.KaraoqWebServiceSoapClient objClient3 = new KaraoqDataAccess.KaraoqWebServiceSoapClient();
                    objClient.InsertSongQueue(General.DJId, VenueId, artist_id, performer_id, this.songSyncList.Rows[i]["Singer"].ToString(), song_id, int.Parse(this.songSyncList.Rows[i]["Position"].ToString()), this.songSyncList.Rows[i]["Title"].ToString(), this.songSyncList.Rows[i]["Artist"].ToString(), "", this.songSyncList.Rows[i]["FileName"].ToString());
                    //Thread.Sleep(1000);
                }

            }
            catch (Exception exception1)
            {
                //ProjectData.SetProjectError(exception1);
                // ProjectData.ClearProjectError();
            }
            finally
            {
                this.previousSongSyncList = new DataTable();
                this.previousSongSyncList = this.songSyncList;
                this.songSyncList = new DataTable();
            }
        }
Ejemplo n.º 2
0
        private void combineTwoQueueList()
        {
            tempSongTable = new DataTable();
            for (int i = 0; i < this.previousSongSyncList.Rows.Count; i++)
            {
                int checkSame = 0;
                for (int j = 0; j < this.songSyncList.Rows.Count; j++)
                {

                    if (this.previousSongSyncList.Rows[i]["Singer"] == this.songSyncList.Rows[j]["Singer"] && this.previousSongSyncList.Rows[i]["Artist"] == this.songSyncList.Rows[j]["Artist"] && this.previousSongSyncList.Rows[i]["Title"] == this.songSyncList.Rows[j]["Title"])
                    {
                        checkSame = 1;
                        //this.combinedsongSyncList.Rows.Add(this.songSyncList.Rows[i]);
                    }
                    else if (j == this.songSyncList.Rows.Count - 1 && checkSame != 1)
                    {
                        tempSongTable.Rows.Add(this.songSyncList.Rows[i]);
                    }
                }
            }
            for (int k = 0; k < tempSongTable.Rows.Count; k++)
            {
                int song_id = -1;
                int artist_id = -1;
                int performer_id = -1;
                string firstname = "";
                string lastname = "";
                KaraoqDataAccess.KaraoqWebServiceSoapClient objClient = new KaraoqDataAccess.KaraoqWebServiceSoapClient();
                song_id = objClient.getSongIdInSyncTrack(tempSongTable.Rows[k]["Title"].ToString(), "0", "", tempSongTable.Rows[k]["Artist"].ToString());

                artist_id = objClient.getArtistIdInSyncTrack(tempSongTable.Rows[k]["Artist"].ToString());

                string[] performerName = tempSongTable.Rows[k]["Singer"].ToString().Split(',');
                for (int j = 0; j < performerName.Length; j++)
                {
                    if (j == 0 && performerName[0] != null) firstname = performerName[0];
                    if (j == 1 && performerName[1] != null) lastname = performerName[1];
                }
                performer_id = objClient.getPerformerIdInSyncTrack(VenueId, firstname, lastname);
                objClient.UpdateSongQueueIsDeleted(General.DJId, VenueId, 1, performer_id, song_id, artist_id, "");
                Thread.Sleep(1000);
            }
            InsertQueueToSQL();
        }