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 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 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 NotificationRepository(ISession session, List <TemplateMessage> templates)
{
this.session = session;
this.dc = new lm.Notification.Core.DataLayer.DatabaseContext(this.session);
_PreloadedTempaltes = templates;
}
public NotificationRepository(ISession session)
{
this.session = session;
this.dc = new lm.Notification.Core.DataLayer.DatabaseContext(this.session);
_PreloadedTempaltes = null;
}
