public void SendEmailMessage(int Id, ActivityTypeContants ActivityType, DocEmailContent DocEmailContentSettings, string AttachmentProcedureName)
{
if (DocEmailContentSettings != null)
{
if (DocEmailContentSettings.ProcEmailContent != null && DocEmailContentSettings.ProcEmailContent != "")
{
SqlParameter SqlParameterId = new SqlParameter("@Id", Id);
IEnumerable <EmailContentViewModel> MailContent = db.Database.SqlQuery <EmailContentViewModel>("" + ConfigurationManager.AppSettings["DataBaseSchema"] + "." + DocEmailContentSettings.ProcEmailContent + " @Id", SqlParameterId);
foreach (EmailContentViewModel item in MailContent)
{
if (DocEmailContentSettings.AttachmentTypes != null && DocEmailContentSettings.AttachmentTypes != "")
{
string[] AttachmentTypeArr = DocEmailContentSettings.AttachmentTypes.Split(',');
for (int i = 0; i <= AttachmentTypeArr.Length - 1; i++)
{
if (item.FileNameList != "" && item.FileNameList != null)
{
item.FileNameList = item.FileNameList + ",";
}
if (AttachmentTypeArr[i].ToUpper() == "PDF")
{
item.FileNameList = item.FileNameList + ReportFiles.CreateFiles(AttachmentProcedureName, Id.ToString(), ReportFileTypeConstants.PDF, (string)System.Configuration.ConfigurationManager.AppSettings["CustomizePath"]);
}
else if (AttachmentTypeArr[i].ToUpper() == "EXCEL")
{
item.FileNameList = item.FileNameList + ReportFiles.CreateFiles(AttachmentProcedureName, Id.ToString(), ReportFileTypeConstants.Excel, (string)System.Configuration.ConfigurationManager.AppSettings["CustomizePath"]);
}
else if (AttachmentTypeArr[i].ToUpper() == "WORD")
{
item.FileNameList = item.FileNameList + ReportFiles.CreateFiles(AttachmentProcedureName, Id.ToString(), ReportFileTypeConstants.Word, (string)System.Configuration.ConfigurationManager.AppSettings["CustomizePath"]);
}
else
{
item.FileNameList = item.FileNameList + ReportFiles.CreateFiles(AttachmentProcedureName, Id.ToString(), ReportFileTypeConstants.PDF, (string)System.Configuration.ConfigurationManager.AppSettings["CustomizePath"]);
}
}
item.EmailBody = item.EmailBody.Replace("DomainName", (string)System.Configuration.ConfigurationManager.AppSettings["CurrentDomain"]);
}
SendEmail.SendEmailMsg(item);
}
}
}
}
public DocEmailContent Add(DocEmailContent pt)
{
_unitOfWork.Repository <DocEmailContent>().Insert(pt);
return(pt);
}
public void Delete(DocEmailContent pt)
{
_unitOfWork.Repository <DocEmailContent>().Delete(pt);
}
public void Update(DocEmailContent pt)
{
pt.ObjectState = ObjectState.Modified;
_unitOfWork.Repository <DocEmailContent>().Update(pt);
}
public DocEmailContent Create(DocEmailContent pt)
{
pt.ObjectState = ObjectState.Added;
_unitOfWork.Repository <DocEmailContent>().Insert(pt);
return(pt);
}
