public static void NewMessage(int id, string href, string userId)
{
using (var db = new ApplicationDbContext())
{
var ft = db.tForumMessages.Find(id);
var t = new tNotification
{
tNotificationType = db.tNotificationType.Find(3),
tNotification_date = System.DateTime.Now,
tNotification_IsRead = false,
tNotification_message =
"Новое сообщение на форуме " + ft.tForumThemes.tForumList.tForumList_name + " в разделе " + "\"" +
ft.tForumThemes.tForumThemes_name + "\"",
tNotification_href = href
};
//Отсылаем модераторам
foreach (var item2 in db.Roles.Where(a => a.Name == "moderator").SelectMany(item => item.Users.Where(a => a.UserId != userId)))
{
t.tUsers = db.Users.Find(item2.UserId);
db.tNotification.Add(t);
db.SaveChanges();
}
foreach (var item in ft.tForumThemes.tForumMessages.Select(a => a.tUsers).Distinct().Where(a => a.Id != userId).Where(item => !db.tNotification.Where(a => a.tUsers.Id == item.Id)
.Any(a => a.tNotification_href == t.tNotification_href)))
{
t.tUsers = db.Users.Find(item.Id);
db.tNotification.Add(t);
db.SaveChanges();
}
//а теперь отошлем email
var emList = new List<string>();
var emailList = ft.tForumThemes.tForumMessages;
var roleId = db.Roles.First(a => a.Name == "user").Id;
foreach (var item in emailList.Where(a => a.tUsers.Id != userId).Where(a => a.tUsers.Roles.Any(b=> b.RoleId == roleId)))
{
emList.AddIfNotExists(item.tUsers.Email);
}
if (emList.Count() != 0)
{
var mm = new MailMessage
{
IsBodyHtml = true,
Body =
"<h4>Форум Талисман-SQL</h4>" + "Появилось новоое сообщение на форуме " +
ft.tForumThemes.tForumList.tForumList_name + " в разделе " +
ft.tForumThemes.tForumThemes_name + "<p>" + href + "</p>",
Subject = "Новое сообщение на форуме Talisman-SQL"
};
foreach (var item in emList)
{
mm.To.Add(item);
}
Code.Mail.SendEmail(mm);
}
db.Dispose();
}
}
public static void NewThemes(int id, string href, string userId)
{
using(var db = new ApplicationDbContext())
{
var ft = db.tForumThemes.Find(id);
var t = new tNotification
{
tNotificationType = db.tNotificationType.Find(2),
tNotification_date = System.DateTime.Now,
tNotification_IsRead = false,
tNotification_message =
"Новая тема на форуме " + ft.tForumList.tForumList_name + "\n" + "\"" + ft.tForumThemes_name +
"\"",
tNotification_href = href
};
//Отсылаем модераторам
foreach (var item2 in db.Roles.Where(a => a.Name == "moderator").SelectMany(item => item.Users.Where(a => a.UserId != userId)))
{
t.tUsers = db.Users.Find(item2.UserId);
db.tNotification.Add(t);
db.SaveChanges();
}
db.Dispose();
}
}
public static void NewUser(string id)
{
using (var db = new ApplicationDbContext())
{
var t = new tNotification
{
tNotificationType = db.tNotificationType.Find(1),
tNotification_date = System.DateTime.Now,
tNotification_IsRead = false,
tNotification_message = "В системе появился новый пользователь - " + db.Users.Find(id).NickName
};
foreach (var item2 in db.Roles.Where(a=> a.Name == "admin").SelectMany(item => item.Users))
{
t.tUsers = db.Users.Find(item2.UserId);
db.tNotification.Add(t);
db.SaveChanges();
}
db.Dispose();
}
}