protected override FetchResult <RFilterVM> _fetch(int?Skip, int?Count, NgControllerInstruct[] filters)
{
using (var l = new MessagesModuleLogic()) {
var items = l.GetAll <tblRecepientFilter>()
.Select(x => PocoConstructor.MakeFromObj(x, RFilterVM.tblRecepientFilterPR));
return(FetchResult <RFilterVM> .Succes(items, items.Count()));
}
}
protected override FetchResult <TemplateVM> _fetch(int?Skip, int?Count, NgControllerInstruct[] filters)
{
using (var l = new MessagesModuleLogic()) {
var queryResult = l.GetAll <tblTemplate>()
.Select(x => PocoConstructor.MakeFromObj(x, TemplateVM.tblTemplatePR));
return(FetchResult <TemplateVM> .Succes(queryResult, queryResult.Count()));
}
}
public JsonResult ClearPendingMessagesQueue()
{
using (var l = new MessagesModuleLogic())
{
var messages = l.GetAll <tblPendingMessagesQueue>();
l.DeleteRange(messages);
var msgBuilder = new StringBuilder();
msgBuilder.AppendLine(DEBS.Translate("MessageMdl.Pending messages queue was cleaned"));
var msg = msgBuilder.ToString();
return(NgResultToJsonResult(NgResult.Succes(msg)));
}
}
static DateTime getStartDate()
{
//returns last invokation end Data + 1 milisecond
using (var l = new MessagesModuleLogic()) {
var last = l.GetAll <tblBatchCreationManagerData>().FirstOrDefault();
if (last == null)
{
return(DateTime.Now.AddYears(-1));
}
return(last.LastEndTime.AddMilliseconds(1));
}
}
protected override FetchResult <RFilterTableVM> _fetch(int?Skip, int?Count, NgControllerInstruct[] filters)
{
using (var l = new MessagesModuleLogic()) {
var items = l.GetAll <tblRecepientFilterTableName>().Select(x =>
PocoConstructor.MakeFromObj(x, RFilterTableVM.tblRecepientFilterTableNamePR)
);
if (items.Count() == 0)
{
return(FetchResult <RFilterTableVM> .Fail(DEBS.Translate("MessageMdl.There is no base tables in database")));
}
return(FetchResult <RFilterTableVM> .Succes(items, items.Count()));
}
}
void WriteEndDate(DateTime end)
{
if (_NoPeriod)
{
throw new InvalidOperationException("Can't save job period, cos no period was setted");
}
var single = Logic.GetAll <tblBatchCreationManagerData>().FirstOrDefault();
if (single == null)
{
single = Logic.Create <tblBatchCreationManagerData>();
}
single.LastStartTime = periodStart;
single.LastEndTime = periodStart;
Logic.Save(single);
}
