public void InsertintoDB(FileTaskMessage message) { string sql = "INSERT INTO Files (HostId,FileName) Values(" + message.HostID + ",'" + message.FileName + "')"; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.InsertCommand = new SqlCommand(sql, connection); adapter.InsertCommand.ExecuteNonQuery(); }
public void DeletefromDB(FileTaskMessage message) { string sql = "DELETE FROM Files WHER FileName = '" + message.FileName + "'"; SqlDataAdapter adapter = new SqlDataAdapter(); adapter.InsertCommand = new SqlCommand(sql, connection); adapter.InsertCommand.ExecuteNonQuery(); }
public void FileTaskMessageManager(FileTaskMessage message) { if (message.SetDelete == SET) { InsertintoDB(message); } else { DeletefromDB(message); } SendMessageToAll(new FileListMessage(ServerIP, GetFileSet())); }
public void SendMessage(string filename, bool task) { FileTaskMessage message = new FileTaskMessage(ClientIP, filename, ClientID, task); SendMessage(message); }