protected override NgResult _delete(EmailSenderDataProviderVM[] models)
{
using (var l = new MessagesModuleLogic()) {
foreach (var model in models)
{
l.Delete <tblEmailSenderDataProvider>(model.Id);
}
}
return(NgResult.Succes(DEBS.Translate("MessageMdl.{0} email providers was removed", models.Count())));
}
public JsonResult GetOperatorsForType(string typename)
{
if (string.IsNullOrWhiteSpace(typename))
{
return(NgResultToJsonResult(NgResult.Fail(@DEBS.Translate("MessageModule.Typename is undefined"))));
}
var items = SqlOperator.GetAllowedForSqlType(typename);
return(NgResultToJsonResult(FetchResult <SqlOperator> .Succes(items, items.Count())));
}
protected override NgResult _delete(MessageScheduleVM[] models)
{
using (var l = new MessagesModuleLogic()) {
foreach (var model in models)
{
l.Delete <tblMessageSchedule>(model.Id);
}
}
return(NgResult.Succes(DEBS.Translate("MessageMdl.{0} schedules was removed", models.Count())));
}
protected override NgResult _update(EmailSenderDataProviderVM[] models)
{
using (var l = new MessagesModuleLogic()) {
foreach (var model in models)
{
var item = l.Get <tblEmailSenderDataProvider>(model.Id);
EmailSenderDataProviderVM.ReflectToTblEmailSenderDataProvider.Run(model, item);
l.SaveChanges(item);
}
}
return(NgResult.Succes(DEBS.Translate("MessageMdl.{0} email providers was modified", models.Count())));
}
protected override NgResult _create(EmailSenderDataProviderVM[] models)
{
using (var l = new MessagesModuleLogic()) {
foreach (var model in models)
{
var item = l.Create <tblEmailSenderDataProvider>();
EmailSenderDataProviderVM.ReflectToTblEmailSenderDataProvider.Run(model, item);
l.Add(item);
}
}
return(NgResult.Succes(DEBS.Translate("MessageMdl.{0} email sms providers was added", models.Count())));;
}
protected override NgResult _update(MessageScheduleVM[] models)
{
using (var l = new MessagesModuleLogic()) {
foreach (var model in models)
{
var item = l.Get <tblMessageSchedule>(model.Id);
MessageScheduleVM.ReflectToTblMessageSchedule.Run(model, item);
l.SaveChanges(item);
}
}
return(NgResult.Succes(DEBS.Translate("MessageMdl.{0} schedules was modified", models.Count())));
}
protected override NgResult _create(MessageScheduleVM[] models)
{
using (var l = new MessagesModuleLogic()) {
foreach (var model in models)
{
var item = l.Create <tblMessageSchedule>();
MessageScheduleVM.ReflectToTblMessageSchedule.Run(model, item);
l.Add(item);
}
}
return(NgResult.Succes(DEBS.Translate("MessageMdl.{0} new schedules was added", models.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)));
}
}
public JsonResult MockMessage(int templateId, int?MaxCount)
{
using (var l = new MessagesModuleLogic()) {
var tmpl = l.Get <tblTemplate>(templateId);
if (tmpl == null)
{
return(NgResultToJsonResult(NgResult.Fail(DEBS.Translate("MessageMdl.Server Error: cannot find template, try save it and re-open."))));
}
var items = TASK_PROTOTYPE.GetDemoMessages(l, tmpl, sqllogic, tmpl.IsSms, MaxCount ?? 0);
return(NgResultToJsonResult(FetchResult <Message> .Succes(items, items.Count)));
}
}
protected override NgResult _update(RFilterVM[] models)
{
using (var l = new MessagesModuleLogic()) {
foreach (var model in models)
{
var filt = l.Get <tblRecepientFilter>(model.Id);
filt.Name = model.Name;
filt.tblRecepientFilterTableNameId = model.BaseTableId;
l.SaveChanges(filt);
model.Id = filt.Id;
CreateAndUpdateRFilterParts(model, l);
}
}
return(NgResult.Succes());
}
public JsonResult SendImmediately(int ScheduleId)
{
using (var l = new MessagesModuleLogic()) {
var sched = l.Get <tblMessageSchedule>(ScheduleId);
if (sched == null)
{
return(NgResultToJsonResult(NgResult.Fail(DEBS.Translate("MessageMdl.Server Error: cannot find template, try save it and re-open."))));
}
var result = TASK_PROTOTYPE.RunImmediateBatchCreation(sched, 1, sqllogic, l);
var msgBuilder = new StringBuilder();
msgBuilder.AppendLine(DEBS.Translate("MessageMdl.Message Batch was created and will be sended as soon as possible."));
msgBuilder.AppendLine(DEBS.Translate("MessageMdl.It contains: {0} messages.", result.Messages.Count()));
var msg = msgBuilder.ToString();
return(NgResultToJsonResult(NgResult.Succes(msg)));
}
}
protected override NgResult _create(RFilterVM[] models)
{
//TODO OPTIMIZE
using (var l = new MessagesModuleLogic()) {
foreach (var model in models)
{
var filt = l.Create <tblRecepientFilter>();
filt.Name = model.Name;
filt.tblRecepientFilterTableNameId = model.BaseTableId;
l.Add(filt);
model.Id = filt.Id;
CreateAndUpdateRFilterParts(model, l);
}
}
return(NgResult.Succes());
}
public JsonResult GetColumns(int id)
{
string tablename;
using (var l = new MessagesModuleLogic()) {
var item = l.Get <tblRecepientFilterTableName>(id);
if (item == null)
{
return(NgResultToJsonResult(NgResult.Fail(DEBS.Translate("MessageMdl.There is no binded table in database with id: {0}", id))));
}
tablename = item.ReferncedTableName;
}
var data = sqlLogic.GetColomnsInfos(tablename);
return(NgResultToJsonResult(FetchResult <IDictionary <string, string> > .Succes(data, data.Count)));
}
