// Check
public string EmailDistributionListContactLanguageModelOK(EmailDistributionListContactLanguageModel emailDistributionListContactLanguageModel)
{
string retStr = FieldCheckNotZeroInt(emailDistributionListContactLanguageModel.EmailDistributionListContactID, ServiceRes.EmailDistributionListContactID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.LanguageOK(emailDistributionListContactLanguageModel.Language);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndMinMaxLengthString(emailDistributionListContactLanguageModel.Agency, ServiceRes.Agency, 2, 250);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(emailDistributionListContactLanguageModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
public EmailDistributionListContactLanguageModel GetEmailDistributionListContactLanguageModelWithEmailDistributionListContactIDAndLanguageDB(int EmailDistributionListContactID, LanguageEnum Language)
{
EmailDistributionListContactLanguageModel emailDistributionListContactLanguageModel = (from c in db.EmailDistributionListContactLanguages
where c.EmailDistributionListContactID == EmailDistributionListContactID &&
c.Language == (int)Language
select new EmailDistributionListContactLanguageModel
{
Error = "",
EmailDistributionListContactLanguageID = c.EmailDistributionListContactLanguageID,
DBCommand = (DBCommandEnum)c.DBCommand,
EmailDistributionListContactID = c.EmailDistributionListContactID,
Language = (LanguageEnum)c.Language,
Agency = c.Agency,
TranslationStatus = (TranslationStatusEnum)c.TranslationStatus,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <EmailDistributionListContactLanguageModel>();
if (emailDistributionListContactLanguageModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.EmailDistributionListContactLanguage, ServiceRes.EmailDistributionListContactID + "," + ServiceRes.Language, EmailDistributionListContactID + "," + Language)));
}
return(emailDistributionListContactLanguageModel);
}
// Post
public EmailDistributionListContactLanguageModel PostAddEmailDistributionListContactLanguageDB(EmailDistributionListContactLanguageModel emailDistributionListContactLanguageModel)
{
string retStr = EmailDistributionListContactLanguageModelOK(emailDistributionListContactLanguageModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
EmailDistributionListContactLanguageModel emailDistributionListContactLanguageModelExist = GetEmailDistributionListContactLanguageModelWithEmailDistributionListContactIDAndLanguageDB(emailDistributionListContactLanguageModel.EmailDistributionListContactID, emailDistributionListContactLanguageModel.Language);
if (string.IsNullOrWhiteSpace(emailDistributionListContactLanguageModelExist.Error))
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.EmailDistributionListContactLanguage)));
}
EmailDistributionListContactLanguage emailDistributionListContactLanguageNew = new EmailDistributionListContactLanguage();
retStr = FillEmailDistributionListContactLanguageModel(emailDistributionListContactLanguageNew, emailDistributionListContactLanguageModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.EmailDistributionListContactLanguages.Add(emailDistributionListContactLanguageNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("EmailDistributionListContactLanguages", emailDistributionListContactLanguageNew.EmailDistributionListContactLanguageID, LogCommandEnum.Add, emailDistributionListContactLanguageNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetEmailDistributionListContactLanguageModelWithEmailDistributionListContactIDAndLanguageDB(emailDistributionListContactLanguageNew.EmailDistributionListContactID, (LanguageEnum)emailDistributionListContactLanguageNew.Language));
}
// Fill
public string FillEmailDistributionListContactLanguageModel(EmailDistributionListContactLanguage emailDistributionListContactLanguage, EmailDistributionListContactLanguageModel emailDistributionListContactLanguageModel, ContactOK contactOK)
{
try
{
emailDistributionListContactLanguage.DBCommand = (int)emailDistributionListContactLanguageModel.DBCommand;
emailDistributionListContactLanguage.EmailDistributionListContactID = emailDistributionListContactLanguageModel.EmailDistributionListContactID;
emailDistributionListContactLanguage.Language = (int)emailDistributionListContactLanguageModel.Language;
emailDistributionListContactLanguage.Agency = emailDistributionListContactLanguageModel.Agency;
emailDistributionListContactLanguage.TranslationStatus = (int)emailDistributionListContactLanguageModel.TranslationStatus;
emailDistributionListContactLanguage.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
emailDistributionListContactLanguage.LastUpdateContactTVItemID = 2;
}
else
{
emailDistributionListContactLanguage.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("");
}
public EmailDistributionListContactLanguageModel PostUpdateEmailDistributionListContactLanguageDB(EmailDistributionListContactLanguageModel emailDistributionListContactLanguageModel)
{
string retStr = EmailDistributionListContactLanguageModelOK(emailDistributionListContactLanguageModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
EmailDistributionListContactLanguage emailDistributionListContactLanguageToUpdate = GetEmailDistributionListContactLanguageWithEmailDistributionListContactIDAndLanguageDB(emailDistributionListContactLanguageModel.EmailDistributionListContactID, emailDistributionListContactLanguageModel.Language);
if (emailDistributionListContactLanguageToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.EmailDistributionListContactLanguage)));
}
retStr = FillEmailDistributionListContactLanguageModel(emailDistributionListContactLanguageToUpdate, emailDistributionListContactLanguageModel, 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("EmailDistributionListContactLanguages", emailDistributionListContactLanguageToUpdate.EmailDistributionListContactLanguageID, LogCommandEnum.Change, emailDistributionListContactLanguageToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetEmailDistributionListContactLanguageModelWithEmailDistributionListContactIDAndLanguageDB(emailDistributionListContactLanguageToUpdate.EmailDistributionListContactID, (LanguageEnum)emailDistributionListContactLanguageToUpdate.Language));
}
public EmailDistributionListContactModel PostUpdateEmailDistributionListContactDB(EmailDistributionListContactModel emailDistributionListContactModel)
{
string retStr = EmailDistributionListContactModelOK(emailDistributionListContactModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
EmailDistributionListContact emailDistributionListContactToUpdate = GetEmailDistributionListContactWithEmailDistributionListContactIDDB(emailDistributionListContactModel.EmailDistributionListContactID);
if (emailDistributionListContactToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.EmailDistributionListContact)));
}
retStr = FillEmailDistributionListContact(emailDistributionListContactToUpdate, emailDistributionListContactModel, 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("EmailDistributionListContacts", emailDistributionListContactToUpdate.EmailDistributionListContactID, LogCommandEnum.Change, emailDistributionListContactToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
foreach (LanguageEnum Lang in LanguageListAllowable)
{
if (Lang == LanguageRequest)
{
EmailDistributionListContactLanguageModel emailDistributionListContactLanguageModel = new EmailDistributionListContactLanguageModel()
{
DBCommand = DBCommandEnum.Original,
EmailDistributionListContactID = emailDistributionListContactToUpdate.EmailDistributionListContactID,
Language = Lang,
Agency = emailDistributionListContactModel.Agency,
TranslationStatus = TranslationStatusEnum.Translated,
};
EmailDistributionListContactLanguageModel emailDistributionListContactLanguageModelRet = _EmailDistributionListContactLanguageService.PostUpdateEmailDistributionListContactLanguageDB(emailDistributionListContactLanguageModel);
if (!string.IsNullOrEmpty(emailDistributionListContactLanguageModelRet.Error))
{
return(ReturnError(string.Format(ServiceRes.CouldNotAddError_, emailDistributionListContactLanguageModelRet.Error)));
}
}
}
ts.Complete();
}
return(GetEmailDistributionListContactModelWithEmailDistributionListContactIDDB(emailDistributionListContactToUpdate.EmailDistributionListContactID));
}
