/// <summary> /// Saves/Updates master configuration /// </summary> /// <param name="masterConfigDto"></param> /// <returns>int</returns> public int SaveMasterConfiguration(tblMasterConfigurationDto masterConfigDto) { Mapper.CreateMap<tblMasterConfigurationDto, tblMasterConfig>(); int result = 0; try { using (var masterConfigContext = new FPConfigEntities()) { var masterConfig = new tblMasterConfig(); //Update mode if (masterConfigDto.Id > 0) { masterConfig = masterConfigContext.tblMasterConfigs.Find(masterConfigDto.Id); Mapper.Map(masterConfigDto, masterConfig); result = masterConfigContext.SaveChanges(); } //New configuration else { Mapper.Map(masterConfigDto, masterConfig); masterConfigContext.tblMasterConfigs.Add(masterConfig); result = masterConfigContext.SaveChanges(); } } } catch { return -1; } return result; }
/// <summary> /// Saves email log and remove email queue /// </summary> /// <param name="masterConfigDto"></param> /// <returns>int</returns> public int SaveEmailLog(tblEmailLogDto emailLogDto, int emailQueueId) { Mapper.CreateMap<tblEmailLogDto, tblEmailLog>(); int result = 0; try { using (var fpCofigDataContext = new FPConfigEntities()) { // save email log var emailLog = new tblEmailLog(); Mapper.Map(emailLogDto, emailLog); fpCofigDataContext.tblEmailLogs.Add(emailLog); // remove email queue var emailQueue = fpCofigDataContext.tblEmailQueues.Find(emailQueueId); fpCofigDataContext.tblEmailQueues.Remove(emailQueue); //save transaction result = fpCofigDataContext.SaveChanges(); } } catch { return -1; } return result; }
/// <summary> /// Delete page specfic place holder /// </summary> /// <param name="pageSpecificPlaceholderId"></param> /// <param name="pageSpecificPlaceholder"></param> /// <returns></returns> public bool DeletePageSpecificPlaceholderConfig(int pageSpecificPlaceholderId, SolutionEnums.PageSpecificPlaceholder pageSpecificPlaceholder) { int result = 0; using (var fpCofigDataContext = new FPConfigEntities()) { var pageSpecificTempletePlaceHolder = fpCofigDataContext.tblPageSpecificPlaceholderConfigs.Find(pageSpecificPlaceholderId); switch (pageSpecificPlaceholder) { case SolutionEnums.PageSpecificPlaceholder.Top: pageSpecificTempletePlaceHolder.TopFrameHTML = string.Empty; break; case SolutionEnums.PageSpecificPlaceholder.Left: pageSpecificTempletePlaceHolder.LeftFrameHTML = string.Empty; break; case SolutionEnums.PageSpecificPlaceholder.Right: pageSpecificTempletePlaceHolder.RightFrameHTML = string.Empty; break; case SolutionEnums.PageSpecificPlaceholder.Bottom: pageSpecificTempletePlaceHolder.BottomFrameHTML = string.Empty; break; } result = fpCofigDataContext.SaveChanges(); } return true; }
/// <summary> /// Updates email queue /// </summary> /// <param name="masterConfigDto"></param> /// <returns>int</returns> public int UpdateEmailQueue(tblEmailQueueDto emailQueueDto) { Mapper.CreateMap<tblEmailQueueDto, tblEmailQueue>(); int result = 0; try { using (var fpCofigDataContext = new FPConfigEntities()) { var emailQueue = fpCofigDataContext.tblEmailQueues.Find(emailQueueDto.Id); Mapper.Map(emailQueueDto, emailQueue); result = fpCofigDataContext.SaveChanges(); } } catch { return -1; } return result; }
/// <summary> /// Delete ProcessEmailTemplate /// </summary> /// <param name="masterConfigDto"></param> /// <returns>int</returns> public bool DeleteProcessEmailTemplate(int processEmailTemplateId) { try { using (var FPConfigEntities = new FPConfigEntities()) { var processEmailTemplate = FPConfigEntities.tblProcessEmailTemplates.Find(processEmailTemplateId); if (processEmailTemplateId > 0) { FPConfigEntities.tblProcessEmailTemplates.Remove(processEmailTemplate); FPConfigEntities.SaveChanges(); } } } catch { return false; } return true; }
/// <summary> /// Saves/Updates ProcessEmailTemplate /// </summary> /// <param name="masterConfigDto"></param> /// <returns>int</returns> public int SaveProcessEmailTemplate(tblProcessEmailTemplateDto processEmailTemplateDto) { Mapper.CreateMap<tblProcessEmailTemplateDto, tblProcessEmailTemplate>() .ForMember(dest => dest.tblProcess, opt => opt.Ignore()); int result = 0; try { using (var FPConfigEntities = new FPConfigEntities()) { var processEmailTemplate = new tblProcessEmailTemplate(); //Update mode if (processEmailTemplateDto.Id > 0) { processEmailTemplate = FPConfigEntities.tblProcessEmailTemplates.Find(processEmailTemplateDto.Id); Mapper.Map(processEmailTemplateDto, processEmailTemplate); result = FPConfigEntities.SaveChanges(); } //New configuration else { Mapper.Map(processEmailTemplateDto, processEmailTemplate); FPConfigEntities.tblProcessEmailTemplates.Add(processEmailTemplate); result = FPConfigEntities.SaveChanges(); } } } catch { return -1; } return result; }
/// <summary> /// Save Page Specific Placeholder /// </summary> /// <param name="tblPageSpecificPlaceholderConfigDto"></param> /// <returns></returns> public int SavePageSpecificPlaceholder(tblPageSpecificPlaceholderConfigDto tblPageSpecificPlaceholderConfigDto) { using (var fpCofigDataContext = new FPConfigEntities()) { int result = 0; Mapper.CreateMap<tblPageSpecificPlaceholderConfigDto, tblPageSpecificPlaceholderConfig>(); //update if (tblPageSpecificPlaceholderConfigDto.Id > 0) { var tblPageSpecificPlaceholderConfig = fpCofigDataContext.tblPageSpecificPlaceholderConfigs.Find(tblPageSpecificPlaceholderConfigDto.Id); tblPageSpecificPlaceholderConfigDto.CreatedBy = tblPageSpecificPlaceholderConfig.CreatedBy; tblPageSpecificPlaceholderConfigDto.CreatedOn = tblPageSpecificPlaceholderConfig.CreatedOn; Mapper.Map(tblPageSpecificPlaceholderConfigDto, tblPageSpecificPlaceholderConfig); fpCofigDataContext.SaveChanges(); result = tblPageSpecificPlaceholderConfig.Id; }//add else { var tblPageSpecificPlaceholderConfig = new tblPageSpecificPlaceholderConfig(); Mapper.Map(tblPageSpecificPlaceholderConfigDto, tblPageSpecificPlaceholderConfig); fpCofigDataContext.tblPageSpecificPlaceholderConfigs.Add(tblPageSpecificPlaceholderConfig); fpCofigDataContext.SaveChanges(); result = tblPageSpecificPlaceholderConfig.Id; } return result; } }