/// <summary> /// ClientEventForm - for creating new client event record /// </summary> /// <param name="mainForm">main form</param> public ClientEventForm(MainForm mainForm) { _clientEvent = new ClientEventModel(); _clientsEvents_TrackWorkers = new List <ClientEvents_TrackWorkersModel>(); _mainForm = mainForm; InitializeComponent(); btnEnter.Click += btnClientEventAdd_Click; }
public Task GuildAvailable(DiscordClient client, GuildCreateEventArgs e) { var clientEventModel = new ClientEventModel { GuildName = e.Guild.Name, GuildId = e.Guild.Id, }; (string message, object[] args) = clientEventModel.ToEventLogTuple(message: "Guild available."); client.Logger.LogInformation(DockordEventId.BotClientGuildAvailable, message, args); return(Task.CompletedTask); }
public Task ClientErrored(DiscordClient client, ClientErrorEventArgs e) { var clientEventModel = new ClientEventModel { Username = client.CurrentUser.Username, UserDiscriminator = client.CurrentUser?.Discriminator, UserId = client.CurrentUser?.Id, }; (string message, object[] args) = clientEventModel.ToEventLogTuple(message: "Discord client error occurred."); client.Logger.LogError(DockordEventId.BotClientError, e.Exception, message, args); return(Task.CompletedTask); }
public async Task <IActionResult> GetClientEvent(string eventId, string viewId) { EventModel vEvent = await _eventDataManager.GetEvent(eventId, true); ClientEventModel clientEvent = new ClientEventModel() { Id = vEvent.Id, EventName = vEvent.EventName, EventLocations = vEvent.EventLocations, EventSentiments = vEvent.EventSentiments, EventView = vEvent.EventViews?.Find(p => p.ViewId == viewId), IsEventActive = vEvent.IsEventActive, LastNote = vEvent.LastNote }; return(Ok(clientEvent)); }
/// <summary> /// UpdateClientEvent - update record of client event /// </summary> /// <param name="updatedClientEvent">updated client event</param> /// <param name="id">client event id</param> /// <returns>bool true or false</returns> public static bool UpdateClientEvent(ClientEventModel updatedClientEvent, int id) { using (SQLiteConnection cnn = new SQLiteConnection(LoadConnectionString())) { var ReturnVal = 0; cnn.Open(); string sqlStatement = "UPDATE ClientEvents SET [ClientID] = @updatedClientId, [TrackID] = @updatedTrackId, [Date] = @updatedDate, " + "[WorkersRequested] = @updatedWorkersRequested, [IsLunchProvided] = @updatedIsLunchProvided, " + "[IsUsingUpperPaddock] = @updatedisUsingUpperPaddock, [IsUsingMiddlePaddock] = @updatedisUsingMiddlePaddock, " + "[IsUsingLowerPaddock] = @updatedisUsingLowerPaddock, [WorkerCalloutSent] = @updatedWorkerCalloutSent, " + "[RequireSafetyDemo] = @updatedRequireSafetyDemo, [IsDeleted] = @updatedIsDeleted " + "WHERE [ClientEventID] = @id"; var cmd = new SQLiteCommand(sqlStatement, cnn); cmd.Parameters.AddWithValue("@updatedClientId", updatedClientEvent.ClientID); cmd.Parameters.AddWithValue("@updatedTrackId", updatedClientEvent.TrackID); cmd.Parameters.AddWithValue("@updatedDate", updatedClientEvent.Date); cmd.Parameters.AddWithValue("@updatedWorkersRequested", updatedClientEvent.WorkersRequested); cmd.Parameters.AddWithValue("@updatedIsLunchProvided", updatedClientEvent.IsLunchProvided); cmd.Parameters.AddWithValue("@updatedisUsingUpperPaddock", updatedClientEvent.IsUsingUpperPaddock); cmd.Parameters.AddWithValue("@updatedisUsingMiddlePaddock", updatedClientEvent.IsUsingMiddlePaddock); cmd.Parameters.AddWithValue("@updatedisUsingLowerPaddock", updatedClientEvent.IsUsingLowerPaddock); cmd.Parameters.AddWithValue("@updatedWorkerCalloutSent", updatedClientEvent.WorkerCalloutSent); cmd.Parameters.AddWithValue("@updatedRequireSafetyDemo", updatedClientEvent.RequireSafetyDemo); cmd.Parameters.AddWithValue("@updatedIsDeleted", updatedClientEvent.IsDeleted); cmd.Parameters.AddWithValue("@id", id); try { cmd.Prepare(); ReturnVal = cmd.ExecuteNonQuery(); } catch (SQLiteException ex) { throw ex; } finally { cnn.Close(); } return(ReturnVal == 1); } }
/// <summary> /// SaveClientEvent - save a new record of client event /// </summary> /// <param name="clientEvent">new client event</param> public static void SaveClientEvent(ClientEventModel clientEvent, List <ClientEvents_TrackWorkersModel> clientsEvents_TrackWorkersList) { using (SQLiteConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Open(); string sqlStatement = "INSERT INTO ClientEvents(ClientID, TrackID, Date, WorkersRequested, IsLunchProvided, " + "IsUsingUpperPaddock, IsUsingMiddlePaddock, IsUsingLowerPaddock, WorkerCalloutSent, RequireSafetyDemo, " + "IsDeleted) VALUES( @clientId, @trackId, @date, @workerRequested, @isLunchProvided, @isUsingUpperPaddock, " + "@isUsingMiddlePaddock, @isUsingLowerPaddock, @workerCalloutSent, @requireSafetyDemo, @isDeleted )"; var cmd = new SQLiteCommand(sqlStatement, cnn); cmd.Parameters.AddWithValue("@clientId", clientEvent.ClientID); cmd.Parameters.AddWithValue("@trackId", clientEvent.TrackID); cmd.Parameters.AddWithValue("@date", clientEvent.Date); cmd.Parameters.AddWithValue("@workerRequested", clientEvent.WorkersRequested); cmd.Parameters.AddWithValue("@isLunchProvided", clientEvent.IsLunchProvided); cmd.Parameters.AddWithValue("@isUsingUpperPaddock", clientEvent.IsUsingUpperPaddock); cmd.Parameters.AddWithValue("@isUsingMiddlePaddock", clientEvent.IsUsingMiddlePaddock); cmd.Parameters.AddWithValue("@isUsingLowerPaddock", clientEvent.IsUsingLowerPaddock); cmd.Parameters.AddWithValue("@workerCalloutSent", clientEvent.WorkerCalloutSent); cmd.Parameters.AddWithValue("@requireSafetyDemo", clientEvent.RequireSafetyDemo); // HARD CODED FALSE cmd.Parameters.AddWithValue("@isDeleted", false); try { cmd.Prepare(); cmd.ExecuteNonQuery(); } catch (SQLiteException ex) { throw ex; } try { ClientEvents_TrackWorkersDataAccess.SaveClientEventTrackWorker(clientsEvents_TrackWorkersList, cnn); } finally { cnn.Close(); } } }
public ValidDiscordEventModels() { IDiscordEvent validCmdEventModel = new CommandEventModel { CommandName = _commandName, CommandArgs = $"{_channelName} 90", Username = _username, UserDiscriminator = _userDiscriminator, UserId = _userId, ChannelName = _channelName, ChannelId = _channelId, IsDirectMessage = false, GuildName = _guildName, GuildId = _guildId, }; Add(validCmdEventModel); IDiscordEvent directMessageCmdEventModel = new CommandEventModel { CommandName = "help", CommandArgs = _commandName, Username = _username, UserDiscriminator = _userDiscriminator, UserId = _userId, ChannelId = _channelId, IsDirectMessage = true, }; Add(directMessageCmdEventModel); IDiscordEvent noUserData = new CommandEventModel { CommandName = _commandName, CommandArgs = $"{_channelName} 90", ChannelName = _channelName, ChannelId = _channelId, IsDirectMessage = false, GuildName = _guildName, GuildId = _guildId, }; Add(noUserData); IDiscordEvent noCommandName = new CommandEventModel { Username = _username, UserDiscriminator = _userDiscriminator, UserId = _userId, ChannelId = _channelId, IsDirectMessage = true, }; Add(noCommandName); IDiscordEvent nullUsername = new CommandEventModel { CommandName = _commandName, CommandArgs = $"{_channelName} 90", ChannelName = _channelName, ChannelId = _channelId, IsDirectMessage = false, GuildName = _guildName, GuildId = _guildId, Username = null !, }; Add(nullUsername); IDiscordEvent nullCommandName = new CommandEventModel { CommandName = null !, Username = _username, UserDiscriminator = _userDiscriminator, UserId = _userId, ChannelId = _channelId, IsDirectMessage = true, }; Add(nullCommandName); IDiscordEvent whitespaceUsername = new CommandEventModel { CommandName = _commandName, CommandArgs = $"{_channelName} 90", ChannelName = _channelName, ChannelId = _channelId, IsDirectMessage = false, GuildName = _guildName, GuildId = _guildId, Username = "******", }; Add(whitespaceUsername); IDiscordEvent whitespaceCommandName = new CommandEventModel { CommandName = " ", Username = _username, UserDiscriminator = _userDiscriminator, UserId = _userId, ChannelId = _channelId, IsDirectMessage = true, }; Add(whitespaceCommandName); IDiscordEvent validClientEventModel = new ClientEventModel { Username = _username, UserDiscriminator = _userDiscriminator, UserId = _userId, }; Add(validClientEventModel); IDiscordEvent guildClientEventModel = new ClientEventModel { Username = _username, UserDiscriminator = _userDiscriminator, UserId = _userId, GuildName = _guildName, GuildId = _guildId, }; Add(guildClientEventModel); } }
/// <summary> /// SetWebBrowserTable - for creating html mail /// </summary> public void SetWebBrowserTable() { List <ClientEventModel> clientEventModelsList = new List <ClientEventModel>(); allClientEventTrackWorkerIdList = new List <int>(); foreach (int clientEventId in _clientEventIdList) { ClientEventModel clientEvent = ClientEventDataAccess.LoadClientEvent(clientEventId); clientEvent.TrackWorkersId = ClientEvents_TrackWorkersDataAccess.LoadClientEventTrackWorkerIDList(clientEventId); allClientEventTrackWorkerIdList = allClientEventTrackWorkerIdList.Union(clientEvent.TrackWorkersId).ToList(); clientEventModelsList.Add(clientEvent); } stringBodyHTML += "<table style=\"border: 1px solid black;text-align:center;\">"; stringBodyHTML += "<tr>"; stringBodyHTML += "<td></td>"; foreach (ClientEventModel clientEvent in clientEventModelsList) { ClientModel client = ClientDataAccess.LoadClient(clientEvent.ClientID); stringBodyHTML += "<td style=\"border: 1px solid black;\">" + client.Name + "</td>"; } stringBodyHTML += "</tr>"; stringBodyHTML += "<tr>"; stringBodyHTML += "<td></td>"; foreach (ClientEventModel clientEvent in clientEventModelsList) { stringBodyHTML += "<td style=\"border: 1px solid black;\">" + clientEvent.Date + "</td>"; } stringBodyHTML += "</tr>"; stringBodyHTML += "<tr>"; stringBodyHTML += "<td style=\"border: 1px solid black;\"># Workers Needed</td>"; foreach (ClientEventModel clientEvent in clientEventModelsList) { stringBodyHTML += "<td style=\"border: 1px solid black;\">" + clientEvent.WorkersRequested + "</td>"; } stringBodyHTML += "</tr>"; stringBodyHTML += "<tr>"; stringBodyHTML += "<td style=\"border: 1px solid black;\">Track</td>"; foreach (ClientEventModel clientEvent in clientEventModelsList) { TrackModel track = TrackDataAccess.LoadTrack(clientEvent.TrackID); stringBodyHTML += "<td style=\"border: 1px solid black;\">" + track.Name + "</td>"; } stringBodyHTML += "</tr>"; stringBodyHTML += "<tr><td><b>Worker Name</b></td></tr>"; foreach (int trackWorkerId in allClientEventTrackWorkerIdList) { stringBodyHTML += "<tr>"; TrackWorkerModel trackWorker = TrackWorkerDataAccess.LoadTrackWorker(trackWorkerId); stringBodyHTML += "<td style=\"border: 1px solid black;\">" + trackWorker.FullName() + "</td>"; foreach (ClientEventModel clientEvent in clientEventModelsList) { if (clientEvent.TrackWorkersId.Contains(trackWorkerId)) { stringBodyHTML += "<td style=\"border: 1px solid black;\">X</td>"; } else { stringBodyHTML += "<td style=\"border: 1px solid black;\"> </td>"; } } stringBodyHTML += "</tr>"; } stringBodyHTML += "</table>"; //webBrowser.DocumentText += stringTableHTML; }
/// <summary> /// dgvClientEvent_CellClick - client event cell click event for updating /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvClientEvent_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { ClientEventModel clientEventModel = new ClientEventModel(); clientEventModel.ClientEventID = int.Parse(dgvClientEvent.Rows[e.RowIndex].Cells["ClientEventID"].Value.ToString()); clientEventModel.ClientID = int.Parse(dgvClientEvent.Rows[e.RowIndex].Cells["ClientID"].Value.ToString()); clientEventModel.TrackID = int.Parse(dgvClientEvent.Rows[e.RowIndex].Cells["TrackID"].Value.ToString()); clientEventModel.Date = dgvClientEvent.Rows[e.RowIndex].Cells["Date"].Value.ToString(); clientEventModel.WorkersRequested = int.Parse(dgvClientEvent.Rows[e.RowIndex].Cells["WorkersRequested"].Value.ToString()); if (dgvClientEvent.Rows[e.RowIndex].Cells["IsLunchProvided"].Value.ToString() == "True") { clientEventModel.IsLunchProvided = true; } else { clientEventModel.IsLunchProvided = false; } if (dgvClientEvent.Rows[e.RowIndex].Cells["IsUsingUpperPaddock"].Value.ToString() == "True") { clientEventModel.IsUsingUpperPaddock = true; } else { clientEventModel.IsUsingUpperPaddock = false; } if (dgvClientEvent.Rows[e.RowIndex].Cells["IsUsingMiddlePaddock"].Value.ToString() == "True") { clientEventModel.IsUsingMiddlePaddock = true; } else { clientEventModel.IsUsingMiddlePaddock = false; } if (dgvClientEvent.Rows[e.RowIndex].Cells["IsUsingLowerPaddock"].Value.ToString() == "True") { clientEventModel.IsUsingLowerPaddock = true; } else { clientEventModel.IsUsingLowerPaddock = false; } if (dgvClientEvent.Rows[e.RowIndex].Cells["WorkerCalloutSent"].Value.ToString() == "True") { clientEventModel.WorkerCalloutSent = true; } else { clientEventModel.WorkerCalloutSent = false; } if (dgvClientEvent.Rows[e.RowIndex].Cells["RequireSafetyDemo"].Value.ToString() == "True") { clientEventModel.RequireSafetyDemo = true; } else { clientEventModel.RequireSafetyDemo = false; } if (dgvClientEvent.Rows[e.RowIndex].Cells["IsDeleted"].Value.ToString() == "True") { clientEventModel.IsDeleted = true; } else { clientEventModel.IsDeleted = false; } ClientEventForm tracksForm = new ClientEventForm(this, clientEventModel); tracksForm.ShowDialog(); } }
/// <summary> /// ClientEventForm - for updating client event record /// </summary> /// <param name="mainForm">main form</param> /// <param name="clientEventModel">client event record</param> public ClientEventForm(MainForm mainForm, ClientEventModel clientEventModel) { _mainForm = mainForm; InitializeComponent(); btnEnter.Click += btnClientEventUpdate_Click; btnEnter.Text = "&Update"; // load client event data to the form _clientEvent = clientEventModel; ClientModel clientModel = ClientDataAccess.LoadClient(_clientEvent.ClientID); TrackModel trackModel = TrackDataAccess.LoadTrack(_clientEvent.TrackID); _clientsEvents_TrackWorkers = ClientEvents_TrackWorkersDataAccess.LoadClientEventTrackWorker(clientEventModel.ClientEventID); txtClientEventId.Text = clientEventModel.ClientEventID.ToString(); txtClientId.Text = clientModel.Name.ToString(); txtTrackID.Text = trackModel.Name.ToString(); txtClientEventDate.Text = _clientEvent.Date.ToString(); txtWorkerRequested.Text = _clientEvent.WorkersRequested.ToString(); if (_clientEvent.IsLunchProvided) { rdoClientEventIsLunchProvided_True.Checked = true; } else { rdoClientEventIsLunchProvided_False.Checked = true; } if (_clientEvent.IsUsingUpperPaddock) { cbClientEventIsUsingUpperPaddock.Checked = true; } else { cbClientEventIsUsingUpperPaddock.Checked = false; } if (_clientEvent.IsUsingMiddlePaddock) { cbClientEventIsUsingMiddlePaddock.Checked = true; } else { cbClientEventIsUsingMiddlePaddock.Checked = false; } if (_clientEvent.IsUsingLowerPaddock) { cbClientEventIsUsingLowerPaddock.Checked = true; } else { cbClientEventIsUsingLowerPaddock.Checked = false; } if (_clientEvent.WorkerCalloutSent) { rdoClientEventWorkerCalloutSent_True.Checked = true; } else { rdoClientEventWorkerCalloutSent_False.Checked = true; } if (_clientEvent.RequireSafetyDemo) { rdoClientEventRequireSafetyDemo_True.Checked = true; } else { rdoClientEventRequireSafetyDemo_False.Checked = true; } if (_clientEvent.IsDeleted) { rdoClientEventIsDeleted_Disabled.Checked = true; } else { rdoClientEventIsDeleted_Enabled.Checked = true; } }