private void NotifyUser(int Id, ActivityTypeContants ActivityType) { PurchaseOrderCancelHeader Header = new PurchaseOrderCancelHeaderService(_unitOfWork).Find(Id); PurchaseOrderSetting PurchaseOrderCancelSettings = new PurchaseOrderSettingService(_unitOfWork).GetPurchaseOrderSettingForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId); DocEmailContent DocEmailContentSettings = new DocEmailContentService(_unitOfWork).GetDocEmailContentForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId, ActivityType); DocNotificationContent DocNotificationContentSettings = new DocNotificationContentService(_unitOfWork).GetDocNotificationContentForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId, ActivityType); DocSmsContent DocSmsContentSettings = new DocSmsContentService(_unitOfWork).GetDocSmsContentForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId, ActivityType); new NotifyUserController(_unitOfWork).SendEmailMessage(Id, ActivityType, DocEmailContentSettings, PurchaseOrderCancelSettings.SqlProcDocumentPrint); new NotifyUserController(_unitOfWork).SendNotificationMessage(Id, ActivityType, DocNotificationContentSettings, User.Identity.Name); new NotifyUserController(_unitOfWork).SendSmsMessage(Id, ActivityType, DocSmsContentSettings); }
public void SendSmsMessage(int Id, ActivityTypeContants ActivityType, DocSmsContent DocSmsContentSettings) { if (DocSmsContentSettings != null) { if (DocSmsContentSettings.ProcSmsContent != null && DocSmsContentSettings.ProcSmsContent != "") { SqlParameter SqlParameterId = new SqlParameter("@Id", Id); IEnumerable <SmsContentViewModel> SmsContent = db.Database.SqlQuery <SmsContentViewModel>("" + ConfigurationManager.AppSettings["DataBaseSchema"] + "." + DocSmsContentSettings.ProcSmsContent + " @Id", SqlParameterId); foreach (SmsContentViewModel item in SmsContent) { } } } }
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 void SendNotificationMessage(int Id, ActivityTypeContants ActivityType, DocNotificationContent DocNotificationContentSettings, string NotificationCreatedBy) { if (DocNotificationContentSettings != null) { if (DocNotificationContentSettings.ProcNotificationContent != null && DocNotificationContentSettings.ProcNotificationContent != "") { SqlParameter SqlParameterId = new SqlParameter("@Id", Id); IEnumerable <NotificationContentViewModel> NotificationContent = db.Database.SqlQuery <NotificationContentViewModel>("" + ConfigurationManager.AppSettings["DataBaseSchema"] + "." + DocNotificationContentSettings.ProcNotificationContent + " @Id", SqlParameterId); foreach (NotificationContentViewModel item in NotificationContent) { Notification Note = new Notification(); Note.NotificationSubjectId = item.NotificationSubjectId; Note.NotificationText = item.NotificationText; Note.NotificationUrl = item.NotificationUrl; Note.UrlKey = item.UrlKey; Note.ExpiryDate = item.ExpiryDate; Note.IsActive = true; Note.CreatedBy = NotificationCreatedBy; Note.ModifiedBy = NotificationCreatedBy; Note.CreatedDate = DateTime.Now; Note.ModifiedDate = DateTime.Now; //new NotificationService(_unitOfWork).Create(Note); string[] UserNameArr = item.UserNameList.Split(','); foreach (string UserName in UserNameArr) { NotificationUser NoteUser = new NotificationUser(); NoteUser.NotificationId = Note.NotificationId; NoteUser.UserName = UserName; new NotificationUserService(_unitOfWork).Create(NoteUser); } } } } }
public DocEmailContent GetDocEmailContentForDocument(int DocTypeId, int DivisionId, int SiteId, ActivityTypeContants ActivityType) { return((from p in db.DocEmailContent where p.DocTypeId == DocTypeId && p.DivisionId == DivisionId && p.SiteId == SiteId && p.ActivityTypeId == (int)ActivityType select p ).FirstOrDefault()); }