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