/// <summary> /// Handle the Login button click event /// Validate user and allow user to access system /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void kbtnLogin_Click(object sender, EventArgs e) { if (General.ValidateControl(pnlMain)) { KaraoqDataAccess.KaraoqWebServiceSoapClient objClient = new KaraoqDataAccess.KaraoqWebServiceSoapClient(); string passwordencrypted = General.MD5Hash(ktxtPassword.Text.Trim()); int djId = objClient.ValidateDJByEmail(ktxtUserName.Text.Trim(), passwordencrypted); if (djId > 0) { General.DJId = (int)djId; DataTable dtVenue = General.GetVenues(); if (General.DJPlaybackToolID == 2) { KaraokiVenue karaokiVenue = new KaraokiVenue(); if (karaokiVenue.VenueList == null) { karaokiVenue.VenueList = new DataTable(); } karaokiVenue.VenueList = dtVenue; karaokiVenue.TopLevel = false; DatabaseSyncMain databaseSyncMain = (DatabaseSyncMain)this.Parent.Parent; databaseSyncMain.Size = new System.Drawing.Size(karaokiVenue.Size.Width + 10, karaokiVenue.Size.Height + 56); databaseSyncMain.AddForms(karaokiVenue); karaokiVenue.TopMost = true; karaokiVenue.Show(); } else { KaraoqVenue karaoqVenue = new KaraoqVenue(); if (karaoqVenue.VenueList == null) { karaoqVenue.VenueList = new DataTable(); } karaoqVenue.VenueList = dtVenue; karaoqVenue.TopLevel = false; DatabaseSyncMain databaseSyncMain = (DatabaseSyncMain)this.Parent.Parent; databaseSyncMain.Size = new System.Drawing.Size(karaoqVenue.Size.Width + 10, karaoqVenue.Size.Height + 56); databaseSyncMain.AddForms(karaoqVenue); karaoqVenue.TopMost = true; karaoqVenue.Show(); } } else if (djId == 0) { KryptonMessageBox.Show("Invalid username or password.", General.SystemMessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); } else { KryptonMessageBox.Show("There was a problem with the connection.", General.SystemMessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void button1_Click(object sender, EventArgs e) { this.clientSocket = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp); IPEndPoint remoteEP = new IPEndPoint(IPAddress.Parse("127.0.0.1"),8000); this.clientSocket.BeginConnect(remoteEP, new AsyncCallback(this.OnConnect), null); String server; String message = "<Msg Terminal=\"karaoq\"/>"; // Create a TcpClient. // Note, for this client to work you need to have a TcpServer // connected to the same address as specified by the server, port // combination. Int32 port = 13000; TcpClient client = new TcpClient("127.0.0.1", port); // Translate the passed message into ASCII and store it as a Byte array. Byte[] data = new Byte[1024]; // Get a client stream for reading and writing. // Stream stream = client.GetStream(); NetworkStream stream = client.GetStream(); // String to store the response ASCII representation. String responseData = String.Empty; Int32 bytes; // Read the first batch of the TcpServer response bytes. while (stream.DataAvailable) { bytes = stream.Read(data, 0, data.Length); responseData += System.Text.Encoding.Unicode.GetString(data, 0, bytes); } Console.WriteLine("Received: {0}", responseData); string[] result; result = responseData.Split(new string[] { "<Msg" }, StringSplitOptions.None); data = new Byte[1024]; if (responseData.Contains("<Msg Command=\"GetTerminalID")) { data = System.Text.Encoding.Unicode.GetBytes(message); // Send the message to the connected TcpServer. stream.Write(data, 0, data.Length); } data = new Byte[1024]; while (stream.DataAvailable) { bytes = stream.Read(data, 0, data.Length); responseData += System.Text.Encoding.Unicode.GetString(data, 0, bytes); } if (responseData.Contains("<Msg Command=\"GetClientVersion")) { message = "<Msg Terminal=\"" + Application.ProductVersion + "\"/>"; data = new Byte[1024]; data = System.Text.Encoding.Unicode.GetBytes(message); // Send the message to the connected TcpServer. stream.Write(data, 0, data.Length); } data = new Byte[1024]; while (stream.DataAvailable) { bytes = stream.Read(data, 0, data.Length); responseData += System.Text.Encoding.Unicode.GetString(data, 0, bytes); } DataTable SongList = new DataTable(); KaraoqDataAccess.KaraoqWebServiceSoapClient objClient = new KaraoqDataAccess.KaraoqWebServiceSoapClient(); SongList = objClient.GetSongListForDJ(General.DJId, 279); for (int i = 0; i < SongList.Rows.Count; i++) { message = "<RequestSong Singer=\"" + SongList.Rows[i]["performer_name"] + "\" Title=\"" + SongList.Rows[i]["song_name"] + "\" Artist=\"" + SongList.Rows[i]["artist_name"] + "\" ID= \"C03268C\" Index=\"432786\" FileName=\"Filename And Path\"/>"; data = new Byte[1024]; data = System.Text.Encoding.Unicode.GetBytes(message); // Send the message to the connected TcpServer. stream.Write(data, 0, data.Length); data = new Byte[1024]; while (stream.DataAvailable) { bytes = stream.Read(data, 0, data.Length); responseData += System.Text.Encoding.Unicode.GetString(data, 0, bytes); } } // Receive the TcpServer.response. // Close everything. stream.Close(); client.Close(); }
/// <summary> /// When Back ground work completed /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bwVenueSync_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { CurrentSteps = "Step 3/3 (Importing Songs Queue)"; klblCurrentImport.Text = CurrentSteps; OleDbConnection connectionString = new OleDbConnection(accessDatabaseConnectionString); connectionString.Open(); try { KaraoqDataAccess.KaraoqWebServiceSoapClient objClient = new KaraoqDataAccess.KaraoqWebServiceSoapClient(); bool IsDeleted = false; try { using (OleDbCommand cmd = new OleDbCommand("DROP TABLE tblQueue", connectionString)) { cmd.ExecuteNonQuery(); IsDeleted = true; } } catch { } bool IsCreated = !IsDeleted; if (IsDeleted) { String createSQL = "CREATE TABLE tblQueue (QueuePos Long,PerformerName Text (100),ArtistName Text (255),TrackName Text (255),SongKey Long, TrackPath Memo)"; using (OleDbCommand cmd = new OleDbCommand(createSQL, connectionString)) { cmd.ExecuteNonQuery(); IsCreated = true; } } if (IsCreated && SongList != null && SongList.Rows.Count > 0) { pbSync.Maximum = SongList.Rows.Count; for (int i = 0; i < SongList.Rows.Count; i++) { try { pbSync.Value = i + 1; string strQuery = "INSERT INTO tblQueue (QueuePos, PerformerName,ArtistName,TrackName,TrackPath) " + "VALUES ('" + Convert.ToInt32(SongList.Rows[i]["queue_position"]) + "', '" + Convert.ToString(SongList.Rows[i]["performer_name"]) + "','" + Convert.ToString(SongList.Rows[i]["artist_name"]) + "', " + " '" + Convert.ToString(SongList.Rows[i]["song_name"]) + "','" + "" + "')"; OleDbCommand com = new OleDbCommand(strQuery, connectionString); //com.UpdatedRowSource.; com.ExecuteNonQuery(); } catch (Exception) { continue; } } } } catch { } finally { if (connectionString != null && connectionString.State == ConnectionState.Open) { connectionString.Close(); } tmSync.Start(); } }
/// <summary> /// Event is invoked when Do work /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bwVenueSync_DoWork(object sender, DoWorkEventArgs e) { CurrentSteps = "Step 1/3 (Importing KaraokeTracks)"; //bwVenueSync.ReportProgress(0); KaraoqDataAccess.KaraoqWebServiceSoapClient objClient = new KaraoqDataAccess.KaraoqWebServiceSoapClient(); int lastTrackId = objClient.GetLastSynqTrackId(General.DJId, VenueId, Convert.ToInt32(Properties.Settings.Default.DJPlaybackTool)); int lastTrackHistoryId = objClient.GetLastSynqHistoryTrackId(General.DJId, VenueId, Convert.ToInt32(Properties.Settings.Default.DJPlaybackTool)); OleDbConnection connectionString = new OleDbConnection(accessDatabaseConnectionString); connectionString.Open(); try { DataTable dtKaraokeTracks = new DataTable(); dtKaraokeTracks.TableName = "KaraokeTracks"; try { OleDbCommand oleDbCommandKaraokeTracks = new OleDbCommand("SELECT * FROM KaraokeTracks order by KaraokeTrackID ASC", connectionString); if (lastTrackId > 0) { oleDbCommandKaraokeTracks = new OleDbCommand("SELECT * FROM KaraokeTracks where KaraokeTrackID > " + lastTrackId + " order by KaraokeTrackID ASC ", connectionString); } OleDbDataAdapter adapterKaraokeTracks = new OleDbDataAdapter(oleDbCommandKaraokeTracks); adapterKaraokeTracks.Fill(dtKaraokeTracks); } catch (Exception ex) { if (ex.Message == "The Microsoft Jet database engine cannot find the input table or query 'KaraokeTracks'. Make sure it exists and that its name is spelled correctly.") { OleDbCommand oleDbCommandKaraokeTracks = new OleDbCommand("SELECT * FROM tblKaraokeTracks order by KaraokeTrackID ASC", connectionString); if (lastTrackId > 0) { oleDbCommandKaraokeTracks = new OleDbCommand("SELECT * FROM tblKaraokeTracks where KaraokeTrackID > " + lastTrackId + " order by KaraokeTrackID ASC ", connectionString); } OleDbDataAdapter adapterKaraokeTracks = new OleDbDataAdapter(oleDbCommandKaraokeTracks); adapterKaraokeTracks.Fill(dtKaraokeTracks); } } CurrentProgressbarTotal = dtKaraokeTracks.Rows.Count; CurrentSteps = "Step 1/3 (Importing Karaoke Tracks)"; if (dtKaraokeTracks.Rows.Count > 0) { for (int i = 0; i < dtKaraokeTracks.Rows.Count; i++) { try { bwVenueSync.ReportProgress(i + 1); int trackNumber = 0; int.TryParse(Convert.ToString(dtKaraokeTracks.Rows[i]["TrackNo"]), out trackNumber); objClient.InsertSynqTracks(VenueId, General.DJId, Convert.ToInt32(Properties.Settings.Default.DJPlaybackTool), Convert.ToInt32(dtKaraokeTracks.Rows[i]["KaraokeTrackID"]), Convert.ToString(dtKaraokeTracks.Rows[i]["ArtistName"]), Convert.ToString(dtKaraokeTracks.Rows[i]["TrackName"]), Convert.ToString(dtKaraokeTracks.Rows[i]["DiscName"]), trackNumber.ToString(), Convert.ToString(dtKaraokeTracks.Rows[i]["Filename"]), Convert.ToString(dtKaraokeTracks.Rows[i]["TrackPath"]), "", "", "" ); } catch { continue; } } } CurrentSteps = "Step 2/3 (Importing Karaoke Tracks History)"; bwVenueSync.ReportProgress(0); DataTable dttblKaraokeTrackHistory = new DataTable(); dttblKaraokeTrackHistory.TableName = "tblKaraokeTrackHistory"; OleDbCommand oleDbCommandtblKaraokeTrackHistory = new OleDbCommand("SELECT * FROM tblKaraokeTrackHistory order by KaraokeTrackHistoryID ASC", connectionString); if (lastTrackHistoryId > 0) { oleDbCommandtblKaraokeTrackHistory = new OleDbCommand("SELECT * FROM tblKaraokeTrackHistory where KaraokeTrackHistoryID > " + lastTrackHistoryId + " order by KaraokeTrackHistoryID ASC", connectionString); } OleDbDataAdapter adaptertblKaraokeTrackHistory = new OleDbDataAdapter(oleDbCommandtblKaraokeTrackHistory); adaptertblKaraokeTrackHistory.Fill(dttblKaraokeTrackHistory); CurrentProgressbarTotal = dttblKaraokeTrackHistory.Rows.Count; if (dttblKaraokeTrackHistory.Rows.Count > 0) { for (int i = 0; i < dttblKaraokeTrackHistory.Rows.Count; i++) { try { bwVenueSync.ReportProgress(i + 1); objClient.InsertSynqTracksHistory(VenueId, General.DJId, Convert.ToInt32(Properties.Settings.Default.DJPlaybackTool), Convert.ToInt32(dttblKaraokeTrackHistory.Rows[i]["KaraokeTrackHistoryID"]), Convert.ToString(dttblKaraokeTrackHistory.Rows[i]["SingerName"]), Convert.ToString(dttblKaraokeTrackHistory.Rows[i]["Artist"]), Convert.ToString(dttblKaraokeTrackHistory.Rows[i]["Title"]), Convert.ToString(dttblKaraokeTrackHistory.Rows[i]["Key"]), Convert.ToString(dttblKaraokeTrackHistory.Rows[i]["TrackPath"]), Convert.ToDateTime(dttblKaraokeTrackHistory.Rows[i]["Date"]) ); } catch { continue; } } } } catch { } finally { if (connectionString != null && connectionString.State == ConnectionState.Open) { connectionString.Close(); } } SongList = new DataTable(); SongList = objClient.GetSongListForDJ(General.DJId, VenueId); }
/// <summary> /// Method is used to Get Venues /// </summary> public static DataTable GetVenues() { DataTable dtVenue = new DataTable(); KaraoqDataAccess.KaraoqWebServiceSoapClient objClient = new KaraoqDataAccess.KaraoqWebServiceSoapClient(); dtVenue = objClient.GetVenueList(General.DJId); DataRow drVenue = dtVenue.NewRow(); drVenue["club_id"] = 0; drVenue["business_name"] = "Please select Venue"; dtVenue.Rows.InsertAt(drVenue, 0); return dtVenue; }