public Boolean RemoveTemplate(long templateID) { using (ISession session = NHSessionHelper.GetSession()) { try { session.BeginTransaction(); DatabaseContext dc = new lm.Notification.Core.DataLayer.DatabaseContext(session); TemplateMessage t = session.Get <TemplateMessage>(templateID); if (t != null && t.ID > 0) { session.Delete(t); session.CommitTransaction(); return(true); } return(false); } catch (Exception ex) { session.RollbackTransaction(); return(false); } } }
public List <dtoTemplateMessage> AvailableTemplates(int ModuleID, int ActionID, dtoTemplateType tType) { List <dtoTemplateMessage> templates = null; using (ISession session = NHSessionHelper.GetSession()) { DatabaseContext dc = new lm.Notification.Core.DataLayer.DatabaseContext(session); try { List <TemplateMessage> l = (from TemplateMessage t in dc.Templates where (ActionID == -9999 || t.ActionID == ActionID) && t.ModuleID == ModuleID && (int)t.Type == (int)tType orderby t.LanguageID select t).ToList <TemplateMessage>(); templates = (from TemplateMessage t in l orderby t.LanguageID select new dtoTemplateMessage(t)).ToList <dtoTemplateMessage>(); } catch (Exception ex) { templates = new List <dtoTemplateMessage>(); } return(templates); } }
public List <dtoModule> AvailableModules() { List <dtoModule> modules = null; using (ISession session = NHSessionHelper.GetSession()) { try { List <NotificatedModule> n = (from NotificatedModule m in session.Linq <NotificatedModule>() orderby m.Name select m).ToList <NotificatedModule>(); modules = (from NotificatedModule m in n select new dtoModule(m)).ToList <dtoModule>(); //modules = (from NotificatedModule m in session.Linq<NotificatedModule>() // orderby m.Name // select new dtoModule(m) ).ToList<dtoModule>(); } catch (Exception ex) { modules = new List <dtoModule>(); } return(modules); } }
public List <CommunityNews> GetNotifications(List <Guid> notificationsID, int UserLanguageID, int DefaultLanguageID) { List <CommunityNews> iResponse = new List <CommunityNews>(); using (ISession session = NHSessionHelper.GetSession()) { try { foreach (Guid ID in notificationsID) { NotificationBase notification = (from nb in session.Linq <NotificationBase>() where nb.UniqueNotifyID == ID && nb.LanguageID == UserLanguageID select nb).FirstOrDefault <NotificationBase>(); if (notification.UniqueNotifyID != System.Guid.Empty) { CommunityNews news = new CommunityNews(notification.UniqueNotifyID, notification.CommunityID, notification.SentDate, notification.Day, notification.Message, notification.ModuleID); iResponse.Add(news); } } } catch (Exception ex) { iResponse = new List <CommunityNews>(); } } return(iResponse); }
public List <CommunityNews> GetCommunityNews(bool OnlySummary, DateTime StartDay, int PersonID, int CommunityID, int UserLanguageID, int DefaultLanguageID, int PageSize, int PageIndex) { List <CommunityNews> iResponse = null; using (ISession session = NHSessionHelper.GetSession()) { try { IQueryable <PersonNotification> p; p = (from n in session.Linq <PersonNotification>() where n.PersonID == PersonID && n.isDeleted == false && n.Day == StartDay && n.CommunityID == CommunityID orderby n.SentDate descending select n).Skip(PageSize * PageIndex).Take(PageSize); List <PersonNotification> pp = p.ToList <PersonNotification>(); IQueryable <NotificationBase> t; t = (from n in session.Linq <NotificationBase>() where n.CommunityID == CommunityID && n.LanguageID == UserLanguageID && n.Day == StartDay select n); List <NotificationBase> tt = t.ToList <NotificationBase>(); iResponse = (from NotificationBase nb in tt join PersonNotification pn in pp on nb.UniqueNotifyID equals pn.NotificationUniqueID select new CommunityNews() { CommunityID = CommunityID, Day = StartDay, Message = nb.Message, ModuleID = nb.ModuleID, SentDate = nb.SentDate, UniqueID = nb.UniqueNotifyID }).ToList <CommunityNews>(); } catch (Exception ex) { iResponse = new List <CommunityNews>(); } } return(iResponse); }
public List <dtoCommunityWithNews> GetPersonalCommunityWithNews(int PersonID) { List <dtoCommunityWithNews> reminders = null; using (ISession session = NHSessionHelper.GetSession()) { try { session.BeginTransaction(); List <CommunityNewsSummary> news = (from CommunityNewsSummary r in session.Linq <CommunityNewsSummary>() where r.PersonID == PersonID && r.ActionCount > 0 orderby r.CommunityID select r).ToList <CommunityNewsSummary>(); reminders = (from CommunityNewsSummary r in news select new dtoCommunityWithNews(r)).ToList <dtoCommunityWithNews>(); session.CommitTransaction(); } catch (Exception ex) { if (session.isInTransaction()) { session.RollbackTransaction(); } reminders = new List <dtoCommunityWithNews>(); } return(reminders); } }
public int GetCommunityNewsCount(bool OnlySummary, DateTime StartDay, int PersonID, int CommunityID, int UserLanguageID, int DefaultLanguageID) { int iResponse = 0; using (ISession session = NHSessionHelper.GetSession()) { try { iResponse = (from n in session.Linq <PersonNotification>() where n.PersonID == PersonID && n.isDeleted == false && n.Day == StartDay && n.CommunityID == CommunityID select n.ID).Count(); } catch (Exception ex) { } } return(iResponse); }
public long SaveTemplate(dtoTemplateMessage template) { using (ISession session = NHSessionHelper.GetSession()) { try { session.BeginTransaction(); DatabaseContext dc = new lm.Notification.Core.DataLayer.DatabaseContext(session); TemplateMessage t = session.Get <TemplateMessage>(template.ID); if (t == null || t.ID == 0) { t = new TemplateMessage(); t.ActionID = template.ActionID; t.LanguageID = template.LanguageID; t.ModuleCode = template.ModuleCode; t.ModuleID = template.ModuleID; t.Type = (TemplateType)template.Type; } t.Name = template.Name; t.Message = template.Message; if (template.Message == "" && t.ID == 0) { return(0); } else if (template.Message == "" && t.ID > 0) { session.Delete(t); } else { session.SaveOrUpdate(t); } session.CommitTransaction(); return(t.ID); } catch (Exception ex) { session.RollbackTransaction(); return(0); } } }
public void UpdateCommunityNewsCount(dtoCommunityWithNews previous) { CommunityNewsSummary reminder = null; using (ISession session = NHSessionHelper.GetSession()) { try { session.BeginTransaction(); reminder = (from CommunityNewsSummary r in session.Linq <CommunityNewsSummary>() where r.PersonID == previous.PersonID && r.CommunityID == previous.CommunityID orderby r.CommunityID select r).FirstOrDefault <CommunityNewsSummary>(); if (reminder != null) { if (previous.LastUpdate == null || previous.LastUpdate == new DateTime()) { reminder.ActionCount = 0; } else if (previous.LastUpdate == reminder.LastUpdate) { reminder.ActionCount = 0; } else if (previous.ActionCount < reminder.ActionCount) { reminder.ActionCount = reminder.ActionCount - previous.ActionCount; } reminder.LastUpdate = DateTime.Now; session.SaveOrUpdate(reminder); session.CommitTransaction(); } } catch (Exception ex) { if (session.isInTransaction()) { session.RollbackTransaction(); } } } }
public List <dtoCommunityWithNews> GetPersonalCommunityWithNews(int PersonID) { List <dtoCommunityWithNews> reminders = null; using (ISession session = NHSessionHelper.GetSession()) { try { reminders = (from CommunityNewsSummary r in session.Linq <CommunityNewsSummary>() where r.PersonID == PersonID && r.ActionCount > 0 orderby r.CommunityID select new dtoCommunityWithNews(r)).ToList <dtoCommunityWithNews>(); } catch (Exception ex) { reminders = new List <dtoCommunityWithNews>(); } return(reminders); } }
public List <DateTime> GetMonthDaysWithNews(DateTime StartDay, int PersonID, int CommunityID) { List <DateTime> MonthDays = null; using (ISession session = NHSessionHelper.GetSession()) { try { DateTime PreviousMonth = StartDay.AddMonths(-1); MonthDays = (from NotificationSummary ns in session.Linq <NotificationSummary>() where ns.PersonID == PersonID && (CommunityID < 0 || ns.CommunityID == CommunityID) && (ns.Day >= PreviousMonth || ns.Day <= StartDay) orderby ns.Day ascending select ns.Day).Distinct().ToList <DateTime>(); } catch (Exception ex) { MonthDays = new List <DateTime>(); } } return(MonthDays); }
public Boolean RemoveNewsSummary(Guid NotificationID) { using (ISession session = NHSessionHelper.GetSession()) { try { session.BeginTransaction(); NotificationSummary nm = session.Get <NotificationSummary>(NotificationID); if (nm != null && nm.ID != System.Guid.Empty) { session.Delete(nm); session.CommitTransaction(); return(true); } return(false); } catch (Exception ex) { session.RollbackTransaction(); return(false); } } }