// Check
public string EmailDistributionListLanguageModelOK(EmailDistributionListLanguageModel emailDistributionListLanguageModel)
{
string retStr = FieldCheckNotZeroInt(emailDistributionListLanguageModel.EmailDistributionListID, ServiceRes.EmailDistributionListID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.LanguageOK(emailDistributionListLanguageModel.Language);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndMinMaxLengthString(emailDistributionListLanguageModel.EmailListName, ServiceRes.EmailListName, 2, 250);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(emailDistributionListLanguageModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
public EmailDistributionListLanguageModel GetEmailDistributionListLanguageModelWithEmailDistributionListIDAndLanguageDB(int EmailDistributionListID, LanguageEnum Language)
{
EmailDistributionListLanguageModel emailDistributionListLanguageModel = (from c in db.EmailDistributionListLanguages
where c.EmailDistributionListID == EmailDistributionListID &&
c.Language == (int)Language
select new EmailDistributionListLanguageModel
{
Error = "",
EmailDistributionListLanguageID = c.EmailDistributionListLanguageID,
DBCommand = (DBCommandEnum)c.DBCommand,
EmailDistributionListID = c.EmailDistributionListID,
Language = (LanguageEnum)c.Language,
EmailListName = c.EmailListName,
TranslationStatus = (TranslationStatusEnum)c.TranslationStatus,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <EmailDistributionListLanguageModel>();
if (emailDistributionListLanguageModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.EmailDistributionListLanguage, ServiceRes.EmailDistributionListID + "," + ServiceRes.Language, EmailDistributionListID + "," + Language)));
}
return(emailDistributionListLanguageModel);
}
// Post
public EmailDistributionListLanguageModel PostAddEmailDistributionListLanguageDB(EmailDistributionListLanguageModel emailDistributionListLanguageModel)
{
string retStr = EmailDistributionListLanguageModelOK(emailDistributionListLanguageModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
EmailDistributionListLanguageModel emailDistributionListLanguageModelExist = GetEmailDistributionListLanguageModelWithEmailDistributionListIDAndLanguageDB(emailDistributionListLanguageModel.EmailDistributionListID, emailDistributionListLanguageModel.Language);
if (string.IsNullOrWhiteSpace(emailDistributionListLanguageModelExist.Error))
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.EmailDistributionListLanguage)));
}
EmailDistributionListLanguage emailDistributionListLanguageNew = new EmailDistributionListLanguage();
retStr = FillEmailDistributionListLanguageModel(emailDistributionListLanguageNew, emailDistributionListLanguageModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.EmailDistributionListLanguages.Add(emailDistributionListLanguageNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("EmailDistributionListLanguages", emailDistributionListLanguageNew.EmailDistributionListLanguageID, LogCommandEnum.Add, emailDistributionListLanguageNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetEmailDistributionListLanguageModelWithEmailDistributionListIDAndLanguageDB(emailDistributionListLanguageNew.EmailDistributionListID, (LanguageEnum)emailDistributionListLanguageNew.Language));
}
// Fill
public string FillEmailDistributionListLanguageModel(EmailDistributionListLanguage emailDistributionListLanguage, EmailDistributionListLanguageModel emailDistributionListLanguageModel, ContactOK contactOK)
{
try
{
emailDistributionListLanguage.DBCommand = (int)emailDistributionListLanguageModel.DBCommand;
emailDistributionListLanguage.EmailDistributionListID = emailDistributionListLanguageModel.EmailDistributionListID;
emailDistributionListLanguage.Language = (int)emailDistributionListLanguageModel.Language;
emailDistributionListLanguage.EmailListName = emailDistributionListLanguageModel.EmailListName;
emailDistributionListLanguage.TranslationStatus = (int)emailDistributionListLanguageModel.TranslationStatus;
emailDistributionListLanguage.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
emailDistributionListLanguage.LastUpdateContactTVItemID = 2;
}
else
{
emailDistributionListLanguage.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("");
}
public EmailDistributionListLanguageModel PostUpdateEmailDistributionListLanguageDB(EmailDistributionListLanguageModel emailDistributionListLanguageModel)
{
string retStr = EmailDistributionListLanguageModelOK(emailDistributionListLanguageModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
EmailDistributionListLanguage emailDistributionListLanguageToUpdate = GetEmailDistributionListLanguageWithEmailDistributionListIDAndLanguageDB(emailDistributionListLanguageModel.EmailDistributionListID, emailDistributionListLanguageModel.Language);
if (emailDistributionListLanguageToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.EmailDistributionListLanguage)));
}
retStr = FillEmailDistributionListLanguageModel(emailDistributionListLanguageToUpdate, emailDistributionListLanguageModel, 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("EmailDistributionListLanguages", emailDistributionListLanguageToUpdate.EmailDistributionListLanguageID, LogCommandEnum.Change, emailDistributionListLanguageToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetEmailDistributionListLanguageModelWithEmailDistributionListIDAndLanguageDB(emailDistributionListLanguageToUpdate.EmailDistributionListID, (LanguageEnum)emailDistributionListLanguageToUpdate.Language));
}
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));
}
