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