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