// 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(""); }