public async Task <bool> UpdateNotifications(string id, NotificationDb notifications)
{
var origin = await _context.Settings.FirstOrDefaultAsync(x => x.SettingsId == id);
_context.Notifications.Load();
if (origin != null)
{
origin.Notifications.IsLikeMyTicket = notifications.IsLikeMyTicket;
origin.Notifications.IsWantBuy = notifications.IsWantBuy;
origin.Notifications.IsOtherNotification = notifications.IsOtherNotification;
await _context.SaveChangesAsync();
return(true);
}
return(false);
}
public async Task <ActionResult> NotificationUserID()
{
var notificationContext = new NotificationDb();
var notificationSignaldbSet = new NotificationSignalR()
{
Id = 1,
RecipientOrganizationId = 4536,
RecipientUserId = 2,
Seen = false
};
notificationContext.NotificationSignalRs.Add(notificationSignaldbSet);
await notificationContext.SaveChangesAsync();
return(Content("new row has been created in notificationDBSET"));
}
public async Task <ActionResult> LogEventSubscriptions()
{
var dbContext = new NotificationDb();
var logEventSub = new LogEventSubscriptions
{
Id = Guid.NewGuid(),
ObjectTypeOfEvent = Enum.ObjectTypeOfEvent.MonthlyMeeting,
EventType = Enum.EventType.Delete,
UserWhoSubscribed = "*****@*****.**"
};
dbContext.LogEventSubscriptionses.Add(logEventSub);
await dbContext.SaveChangesAsync();
return(Content("Created new row"));
}
public async Task <ActionResult> LogEvents()
{
var dbContext = new NotificationDb();
var logEvent = new LogEvents()
{
EventType = Enum.EventType.Delete,
Id = Guid.NewGuid(),
UserWhoCreatesEvent = "*****@*****.**",
ObjectTypeOfEvent = Enum.ObjectTypeOfEvent.MonthlyMeeting
};
dbContext.LogEventses.Add(logEvent);
await dbContext.SaveChangesAsync();
var storageAccount = CloudStorageAccount.Parse(ConfigurationManager.ConnectionStrings["AzureWebJobsStorage"].ToString());
CloudQueueClient queueClient = storageAccount.CreateCloudQueueClient();
CloudQueue queue = queueClient.GetQueueReference("logeventslog");
queue.CreateIfNotExists();
var queueMessage = new CloudQueueMessage(JsonConvert.SerializeObject(logEvent));
queue.AddMessage(queueMessage);
//List<string> c = dbContext.LogEventSubscriptionses.Where(r => r.EventType == logEvent.EventType
// && r.ObjectTypeOfEvent == logEvent.ObjectTypeOfEvent).Select(r => r.UserWhoSubscribed).ToList();
//var mandrill = new MandrillApi(ConfigurationManager.AppSettings["MandrillApiKey"]);
//foreach (var row in c)
//{
// var email = new EmailMessage
// {
// Text = "body",
// FromEmail = "*****@*****.**",
// To = new List<EmailAddress> {new EmailAddress {Email = row}},
// Subject = "Sub"
// };
// await mandrill.SendMessage(new SendMessageRequest(email));
//}
return(Content("new row created"));
}
public static void ProcessQueueMessage([QueueTrigger("logeventslog")] LogEvents logEvent, TextWriter log)
{
var storageAccount = CloudStorageAccount.Parse(ConfigurationManager.ConnectionStrings["AzureWebJobsStorage"].ToString());
var blobClient = storageAccount.CreateCloudBlobClient();
var dbContext = new NotificationDb();
List <string> c = dbContext.LogEventSubscriptionses.Where(r => r.EventType == logEvent.EventType &&
r.ObjectTypeOfEvent == logEvent.ObjectTypeOfEvent)
.Select(r => r.UserWhoSubscribed).ToList();
var y = new LogEventSubscriptions()
{
UserWhoSubscribed = "*****@*****.**",
Id = Guid.NewGuid()
};
dbContext.LogEventSubscriptionses.Add(y);
dbContext.SaveChanges();
//var mandrill = new MandrillApi(ConfigurationManager.AppSettings["MandrillApiKey"]);
//foreach (var row in c)
//{
// var email = new EmailMessage
// {
// Text = "body",
// FromEmail = "*****@*****.**",
// To = new List<EmailAddress> { new EmailAddress { Email = row } },
// Subject = "Sub"
// };
// mandrill.SendMessage(new SendMessageRequest(email));
//}
}
