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