public void UpdateSlackChannelInfo(SlackChannelInfo slackChannelInfo) { using (var session = _documentStore.OpenSession()) { session.Store(slackChannelInfo, slackChannelInfo.SlackChannelName); session.SaveChanges(); } }
public SlackChannelInfo GetSlackChannelInfo(string slackChannelName) { using (var session = _documentStore.OpenSession()) { var channelInfo = session.Query <SlackChannelInfo>().FirstOrDefault(x => x.SlackChannelName == slackChannelName); if (channelInfo != null) { return(channelInfo); } channelInfo = new SlackChannelInfo(slackChannelName, 0, new List <string>()); UpdateSlackChannelInfo(channelInfo); return(channelInfo); } }
public SlackResponse Process(SlackRequest slackRequest) { var bAuthorized = _validator.IsAuthorized(slackRequest); if (!bAuthorized) { return(new SlackResponse { Text = UnauthorizedResponse, ResponseType = ResponseType.Ephemeral }); } _formTextContent = slackRequest.CommandText; _channelInfo = _databaseClient.GetSlackChannelInfo(slackRequest.ChannelName); return(_triggerWordMap[slackRequest.CommandType]()); }
public void UpdateSlackChannelInfo(SlackChannelInfo slackChannelInfo) { using (var connection = new SqlConnection(ConfigurationManager.AppSettings["SqlConnectionString"])) { connection.Open(); using (var command = new SqlCommand("Update_SlackChannel", connection)) { command.CommandType = StoredProcedure; command.Parameters.AddWithValue("@SlackChannelName", slackChannelInfo.SlackChannelName); command.Parameters.AddWithValue("@PivotalProjectId", slackChannelInfo.PivotalProjectId); command.Parameters.AddWithValue("@Descriptions", CreateDataTable(slackChannelInfo.DefaultTaskDescriptions)); command.ExecuteNonQuery(); } } }