// Check
public string EmailDistributionListModelOK(EmailDistributionListModel emailDistributionListModel)
{
string retStr = FieldCheckNotZeroInt(emailDistributionListModel.ParentTVItemID, ServiceRes.ParentTVItemID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotEmptyAndMaxLengthString(emailDistributionListModel.EmailListName, ServiceRes.Name, 100);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndWithinRangeInt(emailDistributionListModel.Ordinal, ServiceRes.Ordinal, 0, 1000);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(emailDistributionListModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
public EmailDistributionListModel GetEmailDistributionListModelWithEmailDistributionListIDDB(int EmailDistributionListID)
{
EmailDistributionListModel emailDistributionListModel = (from c in db.EmailDistributionLists
from cl in db.EmailDistributionListLanguages
where c.EmailDistributionListID == cl.EmailDistributionListID &&
c.EmailDistributionListID == EmailDistributionListID &&
cl.Language == (int)LanguageRequest
select new EmailDistributionListModel
{
Error = "",
EmailDistributionListID = c.EmailDistributionListID,
DBCommand = (DBCommandEnum)c.DBCommand,
ParentTVItemID = c.ParentTVItemID,
EmailListName = cl.EmailListName,
Ordinal = c.Ordinal,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <EmailDistributionListModel>();
if (emailDistributionListModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.EmailDistributionList, ServiceRes.EmailDistributionListID, EmailDistributionListID)));
}
return(emailDistributionListModel);
}
public PartialViewResult _emailDistributionListAddOrModify(int ParentTVItemID, int EmailDistributionListID)
{
ViewBag.ParentTVItemID = ParentTVItemID;
ViewBag.EmailDistributionListModel = null;
TVAuthEnum tvAuth = _TVItemService.GetTVAuthWithTVItemIDAndLoggedInUser(urlModel.TVItemIDList[0], null, null, null);
ViewBag.TVAuth = tvAuth;
EmailDistributionListModel emailDistributionListModel = _EmailDistributionListService.GetEmailDistributionListModelWithEmailDistributionListIDDB(EmailDistributionListID);
ViewBag.EmailDistributionListModel = emailDistributionListModel;
return(PartialView());
}
public EmailDistributionListModel PostEmailDistributionListMoveUpDB(int ParentTVItemID, int EmailDistributionListID)
{
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrWhiteSpace(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
List <EmailDistributionListModel> emailDistributionListModelList = GetEmailDistributionListModelWithParentTVItemIDDB(ParentTVItemID);
EmailDistributionListModel emailDistributionListModelRet = new EmailDistributionListModel();
using (TransactionScope ts = new TransactionScope())
{
for (int i = 0, count = emailDistributionListModelList.Count; i < count; i++)
{
if (emailDistributionListModelList[i].EmailDistributionListID == EmailDistributionListID)
{
int PrevOrdinal = emailDistributionListModelList[i - 1].Ordinal;
emailDistributionListModelList[i - 1].Ordinal = emailDistributionListModelList[i].Ordinal;
emailDistributionListModelList[i].Ordinal = PrevOrdinal;
emailDistributionListModelRet = PostUpdateEmailDistributionListDB(emailDistributionListModelList[i - 1]);
if (!string.IsNullOrWhiteSpace(emailDistributionListModelRet.Error))
{
return(ReturnError(emailDistributionListModelRet.Error));
}
emailDistributionListModelRet = PostUpdateEmailDistributionListDB(emailDistributionListModelList[i]);
if (!string.IsNullOrWhiteSpace(emailDistributionListModelRet.Error))
{
return(ReturnError(emailDistributionListModelRet.Error));
}
}
}
ts.Complete();
}
return(GetEmailDistributionListModelWithEmailDistributionListIDDB(emailDistributionListModelRet.EmailDistributionListID));
}
public JsonResult EmailDistributionListMoveUpJSON(int ParentTVItemID, int EmailDistributionListID)
{
EmailDistributionListModel emailDistributionListModel = _EmailDistributionListService.PostEmailDistributionListMoveUpDB(ParentTVItemID, EmailDistributionListID);
return(Json(emailDistributionListModel.Error, JsonRequestBehavior.AllowGet));
}
public JsonResult EmailDistributionListDeleteJSON(int EmailDistributionListID)
{
EmailDistributionListModel emailDistributionListModel = _EmailDistributionListService.PostDeleteEmailDistributionListDB(EmailDistributionListID);
return(Json(emailDistributionListModel.Error, JsonRequestBehavior.AllowGet));
}
public JsonResult EmailDistributionListSaveJSON(FormCollection fc)
{
EmailDistributionListModel emailDistributionListModel = _EmailDistributionListService.PostEmailDistributionListSaveDB(fc);
return(Json(emailDistributionListModel.Error, JsonRequestBehavior.AllowGet));
}
public EmailDistributionListModel PostUpdateEmailDistributionListDB(EmailDistributionListModel emailDistributionListModel)
{
string retStr = EmailDistributionListModelOK(emailDistributionListModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
EmailDistributionList emailDistributionListToUpdate = GetEmailDistributionListWithEmailDistributionListIDDB(emailDistributionListModel.EmailDistributionListID);
if (emailDistributionListToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.EmailDistributionList)));
}
retStr = FillEmailDistributionList(emailDistributionListToUpdate, emailDistributionListModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
retStr = DoUpdateChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("EmailDistributionLists", emailDistributionListToUpdate.EmailDistributionListID, LogCommandEnum.Change, emailDistributionListToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
foreach (LanguageEnum Lang in LanguageListAllowable)
{
if (Lang == LanguageRequest)
{
EmailDistributionListLanguageModel emailDistributionListLanguageModel = new EmailDistributionListLanguageModel()
{
DBCommand = DBCommandEnum.Original,
EmailDistributionListID = emailDistributionListToUpdate.EmailDistributionListID,
Language = Lang,
EmailListName = emailDistributionListModel.EmailListName,
TranslationStatus = TranslationStatusEnum.Translated,
};
EmailDistributionListLanguageModel emailDistributionListLanguageModelRet = _EmailDistributionListLanguageService.PostUpdateEmailDistributionListLanguageDB(emailDistributionListLanguageModel);
if (!string.IsNullOrEmpty(emailDistributionListLanguageModelRet.Error))
{
return(ReturnError(string.Format(ServiceRes.CouldNotAddError_, emailDistributionListLanguageModelRet.Error)));
}
}
}
ts.Complete();
}
return(GetEmailDistributionListModelWithEmailDistributionListIDDB(emailDistributionListToUpdate.EmailDistributionListID));
}
public EmailDistributionListModel PostEmailDistributionListSaveDB(FormCollection fc)
{
int EmailDistributionListID = 0;
int ParentTVItemID = 0;
string EmailListName = "";
int Ordinal = 0;
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrWhiteSpace(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
int.TryParse(fc["EmailDistributionListID"], out EmailDistributionListID);
// can be 0, if 0 then we want to add a new one
int.TryParse(fc["ParentTVItemID"], out ParentTVItemID);
if (ParentTVItemID == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.ParentTVItemID)));
}
EmailListName = fc["EmailListName"];
if (string.IsNullOrWhiteSpace(EmailListName))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.EmailListName)));
}
List <EmailDistributionListModel> emailDistributionListModelList = GetEmailDistributionListModelWithParentTVItemIDDB(ParentTVItemID);
if (emailDistributionListModelList.Count > 0)
{
Ordinal = emailDistributionListModelList.Last().Ordinal;
}
EmailDistributionListModel emailDistributionListModel = new EmailDistributionListModel();
if (EmailDistributionListID > 0)
{
emailDistributionListModel = GetEmailDistributionListModelWithEmailDistributionListIDDB(EmailDistributionListID);
if (!string.IsNullOrWhiteSpace(emailDistributionListModel.Error))
{
return(ReturnError(emailDistributionListModel.Error));
}
}
emailDistributionListModel.DBCommand = DBCommandEnum.Original;
emailDistributionListModel.ParentTVItemID = ParentTVItemID;
emailDistributionListModel.EmailListName = EmailListName;
emailDistributionListModel.Ordinal = Ordinal + 1;
EmailDistributionListModel emailDistributionListModelRet = new EmailDistributionListModel();
using (TransactionScope ts = new TransactionScope())
{
if (EmailDistributionListID == 0)
{
emailDistributionListModelRet = PostAddEmailDistributionListDB(emailDistributionListModel);
if (!string.IsNullOrWhiteSpace(emailDistributionListModelRet.Error))
{
return(ReturnError(emailDistributionListModelRet.Error));
}
}
else
{
emailDistributionListModelRet = PostUpdateEmailDistributionListDB(emailDistributionListModel);
if (!string.IsNullOrWhiteSpace(emailDistributionListModelRet.Error))
{
return(ReturnError(emailDistributionListModelRet.Error));
}
}
ts.Complete();
}
return(GetEmailDistributionListModelWithEmailDistributionListIDDB(emailDistributionListModelRet.EmailDistributionListID));
}
// Fill
public string FillEmailDistributionList(EmailDistributionList emailDistributionListNew, EmailDistributionListModel emailDistributionListModel, ContactOK contactOK)
{
emailDistributionListNew.DBCommand = (int)emailDistributionListModel.DBCommand;
emailDistributionListNew.EmailDistributionListID = emailDistributionListModel.EmailDistributionListID;
emailDistributionListNew.ParentTVItemID = emailDistributionListModel.ParentTVItemID;
emailDistributionListNew.Ordinal = emailDistributionListModel.Ordinal;
emailDistributionListNew.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
emailDistributionListNew.LastUpdateContactTVItemID = 2;
}
else
{
emailDistributionListNew.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
