/// <summary> /// Saves page and child items. /// </summary> /// <instructions> /// Set inputItem.Id to null when creating a new object. /// </instructions> /// <param name="site">Name of site to which page is related.</param> /// <param name="area">Area where page resides.</param> /// <param name="inputItem">Subscriber object.</param> /// <returns>Returns save status and messages. If successful, returns an identifier via ReturnId.</returns> public static async Task <Result> Save(string site, Area area, models.Subscriber inputItem) { var messages = new List <string>(); if (inputItem == null) { return(new Result(ResultStatus.Failed, "Subscriber cannot be null.")); } Tables.dbo.Site siteItem = await dbRead.Site.Item(site); if (siteItem == null) { return(new Result(ResultStatus.Failed, "No site was found with that name.")); } Rules.StringRequiredMaxLength(inputItem.FirstName, "Name", 50, ref messages); Rules.StringRequiredMaxLength(inputItem.LastName, "Name", 50, ref messages); if (Rules.StringRequiredMaxLength(inputItem.EmailAddress, "Email Address", 255, ref messages) == Rules.Passed.Yes) { Rules.ValidateEmailAddress(inputItem.EmailAddress, "Email Address", ref messages); } if (messages.Any()) { return(new Result(ResultStatus.Failed, messages)); } models.Subscriber existingItem = await Item(site, area, inputItem.EmailAddress); Guid returnId = existingItem?.Id ?? Guid.NewGuid(); int areaId = Enumerators.Values.Area(area); var saveItem = new Tables.dbo.Subscriber { Id = returnId, SiteId = siteItem.Id, AreaId = areaId, FirstName = inputItem.FirstName, LastName = inputItem.LastName, EmailAddress = inputItem.EmailAddress }; Result saveSubscriberResult = await dbWrite.Item(site, saveItem); messages = saveSubscriberResult.Messages; return(new Result(saveSubscriberResult.Status, messages, returnId)); }
/// <summary> /// Saves testimonial and child items. /// </summary> /// <instructions> /// Set inputItem.Id to null when creating a new object. /// </instructions> /// <param name="site">Name of site related to testimonial.</param> /// <param name="inputItem">Testimonial object.</param> /// <returns>Returns save status and messages. If successful, returns an identifier via ReturnId.</returns> public static async Task <Result> Save(string site, models.Testimonial inputItem) { var saveStatus = ResultStatus.Undetermined; var messages = new List <string>(); if (inputItem == null) { return(new Result(ResultStatus.Failed, "Testimonial cannot be null.")); } Tables.dbo.Site siteItem = await dbRead.Site.Item(site); if (siteItem == null) { return(new Result(ResultStatus.Failed, "No site was found with that name.")); } Tables.dbo.Work convertedWork = Work.Convert(inputItem.Work, siteItem.Id); if (convertedWork == null) { return(new Result(ResultStatus.Failed, "Could not convert work model to table.")); } Tables.dbo.Image convertedPortrait = Image.Convert(inputItem.Portrait, siteItem.Id); if (convertedPortrait == null) { return(new Result(ResultStatus.Failed, "Could not convert portrait model to table.")); } // Disabled until portraits are used for testimonials rather than covers. //Result savePortraitResult = await Image.Save(site, inputItem.Portrait); //if (savePortraitResult.Status == SaveStatus.Failed) //{ // return savePortraitResult; //} inputItem.Portrait.Id = convertedPortrait.Id; Rules.StringRequiredMaxLength(inputItem.Name, "Name", 100, ref messages); if (Rules.StringRequiredMaxLength(inputItem.EmailAddress, "Email Address", 256, ref messages) == Rules.Passed.Yes) { Rules.ValidateEmailAddress(inputItem.EmailAddress, "Email Address", ref messages); } if (messages.Any()) { return(new Result(ResultStatus.Failed, messages)); } var saveItem = new Tables.dbo.Testimonial { Id = inputItem.Id, SiteId = siteItem.Id, WorkId = convertedWork.Id, PortraitImageId = convertedPortrait.Id, Name = inputItem.Name, EmailAddress = inputItem.EmailAddress, Approved = inputItem.Approved }; Result saveTestimonialResult = await dbWrite.Item(site, saveItem); if (saveTestimonialResult.Status == ResultStatus.Failed) { return(saveTestimonialResult); } // ReSharper disable once ForeachCanBePartlyConvertedToQueryUsingAnotherGetEnumerator foreach (Models.ProfessionalTranslator.Net.Localized.Testimonial localizedPage in inputItem.Entries) { var saveLocalization = new Tables.Localization.Testimonial { Id = saveItem.Id, Html = localizedPage.Html, Lcid = localizedPage.Lcid }; Result localizedResult = await DatabaseOperations.Localization.Write.Testimonial.Item(site, saveLocalization); if (localizedResult.Status != ResultStatus.Failed) { continue; } saveStatus = ResultStatus.Failed; messages.AddRange(localizedResult.Messages); break; } if (saveStatus == ResultStatus.Undetermined) { saveStatus = ResultStatus.Succeeded; } return(new Result(saveStatus, messages, inputItem.Id)); }
/// <summary> /// Saves client and client uploads. /// </summary> /// <instructions> /// Set inputItem.Id to null when creating a new object. /// </instructions> /// <param name="site">Name of site related to testimonial.</param> /// <param name="inputItem">Client object.</param> /// <returns>Returns save status and messages. If successful, returns an identifier via ReturnId.</returns> public static async Task <Result> Save(string site, models.Client inputItem) { var saveStatus = ResultStatus.Undetermined; var messages = new List <string>(); if (inputItem == null) { return(new Result(ResultStatus.Failed, "Client cannot be null.")); } Tables.dbo.Site siteItem = await dbRead.Site.Item(site); if (siteItem == null) { return(new Result(ResultStatus.Failed, "No site was found with that name.")); } Rules.StringRequiredMaxLength(inputItem.Name, "Name", 150, ref messages); if (Rules.StringRequiredMaxLength(inputItem.EmailAddress, "Email Address", 256, ref messages) == Rules.Passed.Yes) { Rules.ValidateEmailAddress(inputItem.EmailAddress, "Email Address", ref messages); } foreach (Models.ProfessionalTranslator.Net.Upload.Client uploads in inputItem.Uploads) { Rules.StringRequiredMaxLength(uploads.GeneratedFilename, "Generated filename", 45, ref messages); Rules.StringRequiredMaxLength(uploads.OriginalFilename, "Original filename", 256, ref messages); } if (messages.Any()) { return(new Result(ResultStatus.Failed, messages)); } var saveItem = new Tables.dbo.Client { Id = inputItem.Id, SiteId = siteItem.Id, Name = inputItem.Name, EmailAddress = inputItem.EmailAddress }; Result saveClientResult = await dbWrite.Item(site, saveItem); if (saveClientResult.Status == ResultStatus.Failed) { return(saveClientResult); } // ReSharper disable once ForeachCanBePartlyConvertedToQueryUsingAnotherGetEnumerator foreach (Models.ProfessionalTranslator.Net.Upload.Client uploads in inputItem.Uploads) { var saveUpload = new Tables.Upload.Client { Id = uploads.Id, ClientId = saveItem.Id, GeneratedFilename = uploads.GeneratedFilename, OriginalFilename = uploads.OriginalFilename }; Result uploadResult = await DatabaseOperations.Upload.Write.Client.Item(saveUpload); if (uploadResult.Status != ResultStatus.Failed) { continue; } saveStatus = ResultStatus.PartialSuccess; messages.AddRange(uploadResult.Messages); } if (saveStatus == ResultStatus.Undetermined) { saveStatus = ResultStatus.Succeeded; } return(new Result(saveStatus, messages, inputItem.Id)); }