public CustomTemplateModel getCustomTemplate(int?CustomTemplateId, string TemplateName) { EmailTemplateDA EmailTemplateDA = new EmailTemplateDA(); CustomTemplateModel resultData = EmailTemplateDA.getCustomTemplate(CustomTemplateId, TemplateName); return(resultData); }
/// <summary> /// Index /// </summary> /// <returns></returns> public ActionResult Index() { CustomTemplateModel model = new CustomTemplateModel(); List <SelectListItem> columns = customColumnService.PopulateCustomColumn(); model.AvailableCustomColumn = columns; return(View(model)); }
/// <summary> /// Method to get custom template list /// </summary> /// <param name="page"></param> /// <param name="pageSize"></param> /// <param name="sort"></param> /// <param name="sortdir"></param> /// <returns></returns> public ActionResult CustomTemplateList(int page = 1, int pageSize = 1, string sort = "CreatedAt", string sortdir = "DESC") { var model = new CustomTemplateModel(); try { model = customTemplateService.GetCustomTemplates(sort, sortdir, page, intPageSize); } catch (Exception exception) { commonService.LogException(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, exception); } return(PartialView("_CustomTemplateView", model)); }
public bool wellcomeEmail(string Email) { //variables string HtmlBody = string.Empty; string Subject = string.Empty; string From = SystemVariableServ.GetSystemVariableValue("EmailApiEmail"); string EmailMainTemplate = EmailTemplateServ.getMasterEmailTemplate("EmailEgulfBasicTemplate"); //instances CustomTemplateModel CustomTemplate = new CustomTemplateModel(); List <CustomTemplateSectionModel> CustomTemplateSections = new List <CustomTemplateSectionModel>(); //we get email templates CustomTemplate = EmailTemplateServ.getCustomTemplate(null, "WellcomeTemplate"); CustomTemplateSections = EmailTemplateServ.getCustomTemplateSections(CustomTemplate.CustomTemplateId); //we load basic template things and remove innecesary stuffs EmailMainTemplate = getReadyMainTemplate(EmailMainTemplate); EmailMainTemplate = removeTable(EmailMainTemplate); //we get template custom sections EmailMainTemplate = buildTemplateSections(EmailMainTemplate, CustomTemplateSections); EmailMainTemplate = EmailMainTemplate.Replace("#btn-url#", ""); EmailMainTemplate = EmailMainTemplate.Replace("#btn-start#", ""); EmailMainTemplate = EmailMainTemplate.Replace("#btn-end#", ""); HtmlBody = EmailMainTemplate; Subject = CustomTemplate.Subject; MailParameters parameters = new MailParameters(); parameters.from = From; parameters.to = Email; parameters.subject = Subject; parameters.html = HtmlBody; MailGunResponse result = sendEmail(parameters, null); if (!string.IsNullOrEmpty(result.id)) { return(true); } else { return(false); } }
/// <summary> /// Get all custom templates for grid /// </summary> /// <param name="sortOrder"></param> /// <param name="sortdir"></param> /// <param name="page"></param> /// <param name="pageSize"></param> /// <returns></returns> public CustomTemplateModel GetCustomTemplates(string sortOrder, string sortdir, int page, int pageSize) { CustomTemplateModel model = new CustomTemplateModel(); try { model.CustomTemplate = new PagedList <CustomTemplateModel>(); IQueryable <CustomTemplateDataModel> query = dbContext.CustomTemplate; model.CustomTemplateCount = query.Where(x => x.Status == EnumStatus.Active.ToString()).Count(); var param = Expression.Parameter(typeof(CustomTemplateDataModel), "i"); Expression conversion = Expression.Convert(Expression.Property(param, sortOrder), typeof(object)); var mySortExpression = Expression.Lambda <Func <CustomTemplateDataModel, object> >(conversion, param); var queryValues = (from customTemplate in dbContext.CustomTemplate where customTemplate.Status != EnumStatus.Deleted.ToString() join customColumn in dbContext.CustomColumn on customTemplate.CustomColumnId equals customColumn.CustomColumnId select new CustomTemplateModel { CustomTemplateId = customTemplate.CustomTemplateId, SectionName = customColumn.Name, CustomColumnId = customTemplate.CustomColumnId, FileLocation = customTemplate.FileLocation, Notes = customTemplate.Notes, ColumnText = customTemplate.ColumnText, CreatedAt = customTemplate.CreatedAt, CreatedBy = customTemplate.CreatedBy }).ToList(); model.CustomTemplate.Content = queryValues.OrderBy(x => x.CustomTemplateId + " " + sortdir) .Skip((page - 1) * pageSize) .Take(pageSize) .ToList(); model.CustomTemplate.TotalRecords = query.Count(); model.CustomTemplate.CurrentPage = page; model.CustomTemplate.PageSize = pageSize; } catch (Exception exception) { commonService.LogException(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, exception); } return(model); }
public CustomTemplateModel getCustomTemplate(int?CustomTemplateId, string TemplateName) { CustomTemplateModel Data = new CustomTemplateModel(); using (var db = new EGULFEntities()) { Data = (from ct in db.CustomTemplate.ToList() where ct.CustomTemplateId == CustomTemplateId || ct.TemplateName == TemplateName select new CustomTemplateModel { CustomTemplateId = ct.CustomTemplateId, TemplateName = ct.TemplateName, Subject = ct.Subject }).FirstOrDefault(); } return(Data); }
// GET: CustomTemplate /// <summary> /// Index /// </summary> /// <param name="page"></param> /// <param name="pageSize"></param> /// <param name="sort"></param> /// <param name="sortdir"></param> /// <returns></returns> public ActionResult Index(int page = 1, int pageSize = 1, string sort = "CreatedAt", string sortdir = "DESC") { CustomTemplateModel CustomTemplate = new CustomTemplateModel(); try { commonService.CheckLoggedIn(); CustomTemplate = customTemplateService.GetCustomTemplates(sort, sortdir, page, intPageSize); List <SelectListItem> columns = customColumn.PopulateCustomColumn(); CustomTemplate.AvailableCustomColumn = columns; if (Request.UrlReferrer != null) { CustomTemplate.PreviousPageUrl = Request.UrlReferrer.AbsoluteUri; } } catch (Exception exception) { commonService.LogException(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, exception); } return(View(CustomTemplate)); }
public ActionResult AddCustomTemplate(string customColumnId, string notes, string columnText) { CustomTemplateModel customTemplate = new CustomTemplateModel(); if (Request.UrlReferrer != null) { customTemplate.PreviousPageUrl = Request.UrlReferrer.AbsoluteUri; } string result = string.Empty; var currentUser = commonService.GetCurrentUser(); if (currentUser == null) { result = "Login"; return(Json(result)); } string fileName = string.Empty; string directoryPath = ""; try { if (!string.IsNullOrEmpty(customColumnId)) { var customTemplateExist = customTemplateService.GetCustomTemplateById(Convert.ToInt32(customColumnId)); if (customTemplateExist == null) { CustomTemplateDataModel model = new CustomTemplateDataModel(); if (model != null) { #region Attachment Uploads IList <HttpPostedFileBase> files = new List <HttpPostedFileBase>(); if (Request.Files != null) { if (Request.Files.Count > 0) { var requestFile = Request.Files[0]; files.Add(requestFile); fileName = Path.GetFileName(requestFile.FileName); if (!string.IsNullOrEmpty(fileName)) { directoryPath = Server.MapPath(customTemplatePath + customColumnId + "//"); if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } var path = Path.Combine(directoryPath, fileName); requestFile.SaveAs(path); model.FileLocation = Path.Combine(customColumnId + "//" + fileName); } } } #endregion model.CustomColumnId = Convert.ToInt32(customColumnId); model.CreatedAt = DateTime.Now; model.CreatedBy = currentUser.UserId; model.UpdatedAt = DateTime.Now; model.Status = CommonService.EnumStatus.Active.ToString(); model.ColumnText = columnText; model.Notes = notes; customTemplateService.AddcustomTemplate(model); result = "True"; } } else { result = "Existing"; } } } catch (Exception exception) { commonService.LogException(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, exception); } return(Json(result)); }