public EmailDistributionListContactModel GetEmailDistributionListContactModelWithEmailDistributionListContactIDDB(int EmailDistributionListContactID)
{
EmailDistributionListContactModel emailDistributionListContactModel = (from c in db.EmailDistributionListContacts
from cl in db.EmailDistributionListContactLanguages
where c.EmailDistributionListContactID == cl.EmailDistributionListContactID &&
c.EmailDistributionListContactID == EmailDistributionListContactID &&
cl.Language == (int)LanguageRequest
select new EmailDistributionListContactModel
{
Error = "",
EmailDistributionListContactID = c.EmailDistributionListContactID,
DBCommand = (DBCommandEnum)c.DBCommand,
IsCC = c.IsCC,
Agency = cl.Agency,
Name = c.Name,
Email = c.Email,
CMPRainfallSeasonal = c.CMPRainfallSeasonal,
CMPWastewater = c.CMPWastewater,
EmergencyWeather = c.EmergencyWeather,
EmergencyWastewater = c.EmergencyWastewater,
ReopeningAllTypes = c.ReopeningAllTypes,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <EmailDistributionListContactModel>();
if (emailDistributionListContactModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.EmailDistributionListContact, ServiceRes.EmailDistributionListContactID, EmailDistributionListContactID)));
}
return(emailDistributionListContactModel);
}
public PartialViewResult _emailDistributionListContactAddOrModify(int EmailDistributionListID, int EmailDistributionListContactID)
{
ViewBag.EmailDistributionListID = EmailDistributionListID;
ViewBag.EmailDistributionListContactModel = null;
EmailDistributionListContactModel emailDistributionListContactModel = _EmailDistributionListContactService.GetEmailDistributionListContactModelWithEmailDistributionListContactIDDB(EmailDistributionListContactID);
ViewBag.EmailDistributionListContactModel = emailDistributionListContactModel;
return(PartialView());
}
public JsonResult EmailDistributionListContactDeleteJSON(int EmailDistributionListContactID)
{
EmailDistributionListContactModel emailDistributionListContactModel = _EmailDistributionListContactService.PostDeleteEmailDistributionListContactDB(EmailDistributionListContactID);
return(Json(emailDistributionListContactModel.Error, JsonRequestBehavior.AllowGet));
}
public JsonResult EmailDistributionListContactSaveJSON(FormCollection fc)
{
EmailDistributionListContactModel emailDistributionListContactModel = _EmailDistributionListContactService.PostEmailDistributionListContactSaveDB(fc);
return(Json(emailDistributionListContactModel.Error, JsonRequestBehavior.AllowGet));
}
// Check
public string EmailDistributionListContactModelOK(EmailDistributionListContactModel emailDistributionListContactModel)
{
string retStr = FieldCheckNotZeroInt(emailDistributionListContactModel.EmailDistributionListID, ServiceRes.EmailDistributionListID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndMinMaxLengthString(emailDistributionListContactModel.Agency, ServiceRes.Agency, 1, 20);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndMinMaxLengthString(emailDistributionListContactModel.Name, ServiceRes.Name, 1, 100);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndMinMaxLengthString(emailDistributionListContactModel.Email, ServiceRes.Email, 1, 200);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = EmailOK(emailDistributionListContactModel.Email);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullBool(emailDistributionListContactModel.CMPRainfallSeasonal, ServiceRes.CMPRainfallSeasonal);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullBool(emailDistributionListContactModel.CMPWastewater, ServiceRes.CMPWastewater);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullBool(emailDistributionListContactModel.EmergencyWeather, ServiceRes.EmergencyWeather);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullBool(emailDistributionListContactModel.EmergencyWastewater, ServiceRes.EmergencyWastewater);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullBool(emailDistributionListContactModel.ReopeningAllTypes, ServiceRes.ReopeningAllTypes);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(emailDistributionListContactModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
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));
}
// Post
public EmailDistributionListContactModel PostEmailDistributionListContactSaveDB(FormCollection fc)
{
int EmailDistributionListContactID = 0;
int EmailDistributionListID = 0;
bool IsCC = false;
string Agency = "";
string Name = "";
string Email = "";
bool CMPRainfallSeasonal = false;
bool CMPWastewater = false;
bool EmergencyWeather = false;
bool EmergencyWastewater = false;
bool ReopeningAllTypes = false;
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrWhiteSpace(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
int.TryParse(fc["EmailDistributionListContactID"], out EmailDistributionListContactID);
// can be 0, if 0 then we want to add a new one
int.TryParse(fc["EmailDistributionListID"], out EmailDistributionListID);
if (EmailDistributionListID == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.EmailDistributionListID)));
}
if (!string.IsNullOrWhiteSpace(fc["IsCC"]))
{
IsCC = true;
}
Agency = fc["Agency"];
if (string.IsNullOrWhiteSpace(Agency))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.Agency)));
}
Name = fc["Name"];
if (string.IsNullOrWhiteSpace(Name))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.Name)));
}
Email = fc["Email"];
if (string.IsNullOrWhiteSpace(Email))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.Email)));
}
if (!string.IsNullOrWhiteSpace(fc["CMPRainfallSeasonal"]))
{
CMPRainfallSeasonal = true;
}
if (!string.IsNullOrWhiteSpace(fc["CMPWastewater"]))
{
CMPWastewater = true;
}
if (!string.IsNullOrWhiteSpace(fc["EmergencyWeather"]))
{
EmergencyWeather = true;
}
if (!string.IsNullOrWhiteSpace(fc["EmergencyWastewater"]))
{
EmergencyWastewater = true;
}
if (!string.IsNullOrWhiteSpace(fc["ReopeningAllTypes"]))
{
ReopeningAllTypes = true;
}
EmailDistributionListContactModel emailDistributionListContactModel = new EmailDistributionListContactModel();
if (EmailDistributionListContactID > 0)
{
emailDistributionListContactModel = GetEmailDistributionListContactModelWithEmailDistributionListContactIDDB(EmailDistributionListContactID);
if (!string.IsNullOrWhiteSpace(emailDistributionListContactModel.Error))
{
return(ReturnError(emailDistributionListContactModel.Error));
}
}
emailDistributionListContactModel.DBCommand = DBCommandEnum.Original;
emailDistributionListContactModel.EmailDistributionListID = EmailDistributionListID;
emailDistributionListContactModel.IsCC = IsCC;
emailDistributionListContactModel.Agency = Agency;
emailDistributionListContactModel.Name = Name;
emailDistributionListContactModel.Email = Email;
emailDistributionListContactModel.CMPRainfallSeasonal = CMPRainfallSeasonal;
emailDistributionListContactModel.CMPWastewater = CMPWastewater;
emailDistributionListContactModel.EmergencyWeather = EmergencyWeather;
emailDistributionListContactModel.EmergencyWastewater = EmergencyWastewater;
emailDistributionListContactModel.ReopeningAllTypes = ReopeningAllTypes;
EmailDistributionListContactModel emailDistributionListModelContactRet = new EmailDistributionListContactModel();
using (TransactionScope ts = new TransactionScope())
{
if (EmailDistributionListContactID == 0)
{
emailDistributionListModelContactRet = PostAddEmailDistributionListContactDB(emailDistributionListContactModel);
if (!string.IsNullOrWhiteSpace(emailDistributionListModelContactRet.Error))
{
return(ReturnError(emailDistributionListModelContactRet.Error));
}
}
else
{
emailDistributionListModelContactRet = PostUpdateEmailDistributionListContactDB(emailDistributionListContactModel);
if (!string.IsNullOrWhiteSpace(emailDistributionListModelContactRet.Error))
{
return(ReturnError(emailDistributionListModelContactRet.Error));
}
}
ts.Complete();
}
return(GetEmailDistributionListContactModelWithEmailDistributionListContactIDDB(emailDistributionListModelContactRet.EmailDistributionListContactID));
}
// Fill
public string FillEmailDistributionListContact(EmailDistributionListContact emailDistributionListContactNew, EmailDistributionListContactModel emailDistributionListContactModel, ContactOK contactOK)
{
emailDistributionListContactNew.DBCommand = (int)emailDistributionListContactModel.DBCommand;
emailDistributionListContactNew.EmailDistributionListID = emailDistributionListContactModel.EmailDistributionListID;
emailDistributionListContactNew.IsCC = emailDistributionListContactModel.IsCC;
//emailDistributionListContactNew.Agency = emailDistributionListContactModel.Agency;
emailDistributionListContactNew.Name = emailDistributionListContactModel.Name;
emailDistributionListContactNew.Email = emailDistributionListContactModel.Email;
emailDistributionListContactNew.CMPRainfallSeasonal = emailDistributionListContactModel.CMPRainfallSeasonal;
emailDistributionListContactNew.CMPWastewater = emailDistributionListContactModel.CMPWastewater;
emailDistributionListContactNew.EmergencyWeather = emailDistributionListContactModel.EmergencyWeather;
emailDistributionListContactNew.EmergencyWastewater = emailDistributionListContactModel.EmergencyWastewater;
emailDistributionListContactNew.ReopeningAllTypes = emailDistributionListContactModel.ReopeningAllTypes;
emailDistributionListContactNew.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
emailDistributionListContactNew.LastUpdateContactTVItemID = 2;
}
else
{
emailDistributionListContactNew.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
