/// <summary>
/// If error send a mail to the configured mail id's.
/// </summary>
/// <param name="exceptionMessage"></param>
/// <param name="insuredCode"></param>
/// <param name="insuranceType"></param>
/// <param name="agency"></param>
/// <param name="isOracle"></param>
public void SendMailLogError(string exceptionMessage, string insuredCode, string insuranceType, string agency, bool isOracle)
{
MailMessageResponse mailResponseMessage = new MailMessageResponse();
MailSendRequestWithoutCCAndBcc newRequest = new MailSendRequestWithoutCCAndBcc();
EmailMessageAudit emailMessageAudit = new EmailMessageAudit();
if (!isOracle)
{
mailResponseMessage = GetMessageByKey(BKIC.SellingPoint.DL.Constants.MailMessageKey.PolicyInsertFailed);
emailMessageAudit.MessageKey = BKIC.SellingPoint.DL.Constants.MailMessageKey.PolicyInsertFailed;
}
else
{
mailResponseMessage = GetMessageByKey(BKIC.SellingPoint.DL.Constants.MailMessageKey.OraclePolicyInsertFailed);
emailMessageAudit.MessageKey = BKIC.SellingPoint.DL.Constants.MailMessageKey.OraclePolicyInsertFailed;
}
newRequest.Subject = mailResponseMessage.Subject.Replace("{{Site_name}}", /*Constants.MailMessageKey.SiteName*/ "");
newRequest.Personalizations = new List <Personalization>()
{
new Personalization()
{
ToRecipient = new List <MailRecipientDetails>()
{
new MailRecipientDetails()
{
Email = mailResponseMessage.Email
}
}
}
};
newRequest.Contents = new List <ContentDetail>()
{
new ContentDetail()
{
Value = mailResponseMessage.Message
}
};
new Task(() =>
{
sendWithOutAttachementMail(newRequest);
}).Start();
emailMessageAudit.InsuranceType = insuranceType;
emailMessageAudit.InsuredCode = insuredCode;
emailMessageAudit.Message = exceptionMessage;
emailMessageAudit.Agency = agency;
new Task(() =>
{
InsertEmailMessageAudit(emailMessageAudit);
}).Start();
}
public async Task GetAsyncTestUnhappy()
{
// Arrange
var mockMailMessageRepository = GetDefaultIMailMessageRepositoryInstance();
var mockIUnitOfWork = GetDefaultIUnitOfWorkInstance();
var mockCoordinatorRepository = GetDefaultICoordinatorRepositoryInstance();
var mailMessageId = 1;
var service = new MailMessageService(mockMailMessageRepository.Object, mockCoordinatorRepository.Object, mockIUnitOfWork.Object);
// Act
MailMessageResponse result = await service.GetByIdAsync(mailMessageId);
var message = result.Message;
// Assert
message.Should().Be("mail message not found");
}
/// <summary>
/// Sender key.
/// </summary>
/// <param name="key">Key</param>
/// <returns></returns>
public MailMessageResponse GetMessageByKey(string key)
{
try
{
MailMessageResponse response = new MailMessageResponse();
response.IsTransactionDone = true;
List <SPOut> outParams = new List <SPOut>()
{
new SPOut()
{
OutPutType = SqlDbType.NVarChar, ParameterName = "@Message", Size = int.MaxValue
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, Size = 250, ParameterName = "@SendMailTo"
},
new SPOut()
{
OutPutType = SqlDbType.NVarChar, Size = int.MaxValue, ParameterName = "@Subject"
}
};
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@Key", key)
};
object[] dataSet = BKICSQL.GetValues(StoredProcedures.Mail.GetMessageBykey, para, outParams);
response.Message = dataSet[0].ToString();
response.Email = Convert.ToString(dataSet[1]);
response.Subject = Convert.ToString(dataSet[2]);
return(response);
}
catch (Exception exc)
{
return(new MailMessageResponse()
{
IsTransactionDone = false,
TransactionErrorMessage = exc.Message
});
}
}
public async Task PutAsyncTest()
{
// Arrange
var mockMailMessageRepository = GetDefaultIMailMessageRepositoryInstance();
var mockIUnitOfWork = GetDefaultIUnitOfWorkInstance();
var mockCoordinatorRepository = GetDefaultICoordinatorRepositoryInstance();
Coordinator coordinator = new Coordinator();
int coordinatorId = 1;
coordinator.Id = coordinatorId;
MailMessage mailMessage = new MailMessage();
var mailMessageId = 1;
mailMessage.Id = mailMessageId;
mailMessage.CoordinatorId = coordinatorId;
mailMessage.DocumentLink = "drive.sem5";
MailMessage mailMessageExpected = new MailMessage();
mailMessageExpected.CoordinatorId = 1;
mailMessageExpected.DocumentLink = "mega.sem5";
mockMailMessageRepository.Setup(r => r.FindById(mailMessageId))
.Returns(Task.FromResult <MailMessage>(mailMessage));
mockCoordinatorRepository.Setup(r => r.FindById(coordinatorId))
.Returns(Task.FromResult <Coordinator>(coordinator));
var service = new MailMessageService(mockMailMessageRepository.Object, mockCoordinatorRepository.Object, mockIUnitOfWork.Object);
// Act
MailMessageResponse result = await service.UpdateASync(mailMessageId, mailMessage.CoordinatorId, mailMessageExpected);
// Assert
Assert.AreEqual(mailMessageExpected.DocumentLink, result.Resource.DocumentLink);
}
public async Task PostAsyncTestHappy()
{
// Arrange
var mockMailMessageRepository = GetDefaultIMailMessageRepositoryInstance();
var mockIUnitOfWork = GetDefaultIUnitOfWorkInstance();
var mockCoordinatorRepository = GetDefaultICoordinatorRepositoryInstance();
MailMessage mailMessage = new MailMessage();
var mailMessageId = 1;
mailMessage.Id = mailMessageId;
var service = new MailMessageService(mockMailMessageRepository.Object, mockCoordinatorRepository.Object, mockIUnitOfWork.Object);
// Act
MailMessageResponse result = await service.SaveAsync(mailMessage, 1);
// Assert
var message = result.Message;
message.Should().Be("");
}
public async Task GetAsyncTestHappy()
{
// Arrange
var mockMailMessageRepository = GetDefaultIMailMessageRepositoryInstance();
var mockIUnitOfWork = GetDefaultIUnitOfWorkInstance();
var mockCoordinatorRepository = GetDefaultICoordinatorRepositoryInstance();
MailMessage mailMessage = new MailMessage();
var mailMessageId = 1;
mailMessage.Id = mailMessageId;
mockMailMessageRepository.Setup(r => r.FindById(mailMessageId))
.Returns(Task.FromResult <MailMessage>(mailMessage));
var service = new MailMessageService(mockMailMessageRepository.Object, mockCoordinatorRepository.Object, mockIUnitOfWork.Object);
// Act
MailMessageResponse result = await service.GetByIdAsync(mailMessageId);
// Assert
Assert.AreEqual(mailMessage, result.Resource);
}
// Sending Orders of the customer to respective suppliers
public bool SendCustomerOrders(int dayTotalHours, string subjectLine, int dayTotalMinutes, Boolean isHourBased, string orderFromEmail, string supportEmail)
{
//ResendEmail();
// Getting
List <Supplier> supplierList = _supplierService.GetSuppliersForSendingOrder();
if (supplierList == null || supplierList.Count <= 0)
{
return(false);
}
foreach (Supplier supplier in supplierList)
{
if (supplier.SupplierOrderPolicies == null || supplier.SupplierOrderPolicies.Count <= 0)
{
continue;
}
Boolean sendOrder = true;
if (sendOrder != true)
{
continue;
}
List <Customer_Order> customerOrderList = _customerOrderService.GetNewOrders(supplier.SupplierId);
Logger.Info($"Pending Orders For {supplier.Name} = {customerOrderList.Count}");
foreach (Customer_Order customerOrder in customerOrderList)
{
try
{
if (!supplier.SupplierOrderPolicies.ToList()[0].SendOrderViaEmail || (string.IsNullOrEmpty(supplier.SupplierOrderPolicies.ToList()[0].OrderEmailAddress)))
{
continue;
}
var role = customerOrder.Customer.UserRolesInCustomers.FirstOrDefault(i => i.AspNetUserId == customerOrder.CreatedByUserId) ??
customerOrder.Customer.UserRolesInCustomers.FirstOrDefault(i => i.AspNetRole.Name == "Admin");
var user = role?.AspNetUser;
if (user == null)
{
continue;
}
string[] orderSubjctline = subjectLine.Split(',');
var emailSubject = user.LanguageCode == LanguageCode.English ? orderSubjctline[0] : orderSubjctline[1];
Boolean supplierEmployeeLimitForOrder = true;
if (customerOrder.Customer.NoOfEmployee < supplier.SupplierOrderPolicies.ToList()[0].MinEmployeeLimitForOrder)
{
supplierEmployeeLimitForOrder = false;
if (string.IsNullOrEmpty(supplier.InternalSupportEmailForSpecialSituations))
{
continue;
}
}
var response = SaveCaseStatus(customerOrder.ForSupplierId, customerOrder.FromCustomerId, customerOrder.FromDepartmentId, user.Id, supplierEmployeeLimitForOrder, customerOrder.Id);
if (response != null && response.IsSuccess)
{
var emailHtmlBody = "";
if (customerOrder.IsJson == null || customerOrder.IsJson == false)
{
Logger.Info($"Orders# {customerOrder.Id} = is XML");
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(customerOrder.OrderXML);
//XmlNode XmlOrder = xmlDoc.SelectSingleNode("//Order");
XmlNode xmlOrderDetail = xmlDoc.SelectSingleNode("//OrderDetail");
XmlElement fieldNode = xmlDoc.CreateElement("Field");
xmlOrderDetail.AppendChild(fieldNode);
//Creating Child Node of the Key
XmlElement childKey = xmlDoc.CreateElement("Key");
//childKey.Attributes.Append(xmlDoc.CreateAttribute("name", "trackTid"));
childKey.InnerText = "CaseId";
fieldNode.AppendChild(childKey);
//Creating Child Node of the Value
XmlElement childValue = xmlDoc.CreateElement("Value");
childValue.InnerText = response.CaseId.ToString();
fieldNode.AppendChild(childValue);
customerOrder.OrderXML = xmlDoc.OuterXml;
emailHtmlBody = new XSLTransformHelper().CreateHTML(customerOrder.OrderXML, user.LanguageCode);
}
else
{
Logger.Info($"Orders# {customerOrder.Id} = is XML");
emailHtmlBody = _formService.ConvertToHTML(customerOrder.OrderXML, response.CaseId, customerOrder.Id).Message;
}
Logger.Info("Orders# {0} HTML = " + emailHtmlBody, customerOrder.Id);
if (!string.IsNullOrEmpty(emailHtmlBody))
{
HtmlDocument doc = new HtmlAgilityPack.HtmlDocument();
doc.LoadHtml(emailHtmlBody);
var tbl = doc.GetElementbyId("tbl");
var nodes = tbl.SelectNodes("tr/td");
foreach (var node in nodes)
{
if (node.InnerText.Contains(response.CaseId.ToString()))
{
node.Attributes.Append("name", "trackTid");
}
}
emailHtmlBody = doc.DocumentNode.InnerHtml;
}
// department email, and support email.
orderFromEmail = customerOrder.OrderEmail.Equals(supportEmail)
? orderFromEmail
: customerOrder.Department.InternalEmail;
var attachments = GetEmailAttachment(customerOrder);
Logger.Info(String.Format("Orders# {0} has attachments = " + attachments?.Count,
customerOrder.Id));
if (supplierEmployeeLimitForOrder)
{
string recipientEmail = (string.IsNullOrEmpty(customerOrder.OrderEmail)
? supplier.SupplierOrderPolicies.ToList()[0].OrderEmailAddress
: customerOrder.OrderEmail);
////get email attachments
MailMessageResponse message = SaveMailMessage(user.Id, supplier.Name, emailSubject,
emailHtmlBody, user.InternalEmail, recipientEmail, response.CaseId,
customerOrder.FromCustomerId, customerOrder.FromDepartmentId);
if (customerOrder.CustomerOrderAttachments.Count > 0)
{
SaveCustomerAttachmentsInMailMessage(customerOrder.CustomerOrderAttachments,
message.MessageId);
}
SendEmail(user, emailHtmlBody, recipientEmail,
customerOrder.Customer.ChannelId.ToString(), orderFromEmail, user.LanguageCode,
supplier.Name, customerOrder.Customer.CustomerName, attachments);
var html = _formService.GetOrderQuestionsHtml(customerOrder.Id);
SendOrderToPrimaryEmail(user, emailSubject, html, response.CaseId,
supplier.Name, attachments, customerOrder.Customer.ChannelId.ToString(),
customerOrder.FromCustomerId, customerOrder.FromDepartmentId,
customerOrder.CustomerOrderAttachments);
}
else
{
MailMessageResponse message = SaveMailMessage(user.Id, supplier.Name, emailSubject,
emailHtmlBody, user.InternalEmail,
supplier.InternalSupportEmailForSpecialSituations, response.CaseId,
customerOrder.FromCustomerId, customerOrder.FromDepartmentId);
if (customerOrder.CustomerOrderAttachments.Count > 0)
{
SaveCustomerAttachmentsInMailMessage(customerOrder.CustomerOrderAttachments,
message.MessageId);
}
// Sending Email to Supplier
SendEmail(user, emailHtmlBody, supplier.InternalSupportEmailForSpecialSituations,
customerOrder.Customer.ChannelId.ToString(), orderFromEmail, user.LanguageCode,
supplier.Name, customerOrder.Customer.CustomerName, attachments);
var html = _formService.GetOrderQuestionsHtml(customerOrder.Id);
SendOrderToPrimaryEmail(user, emailSubject, html, response.CaseId,
supplier.Name, attachments, customerOrder.Customer.ChannelId.ToString(),
customerOrder.FromCustomerId, customerOrder.FromDepartmentId,
customerOrder.CustomerOrderAttachments);
}
customerOrder.Status = OrderStatus.Sent;
customerOrder.SentDateTimeUtc = DateTime.UtcNow;
_customerOrderService.SaveCustomerOrder(customerOrder);
}
}
catch (Exception ex)
{
Logger.Fatal(ex, $"Orders #{customerOrder.Id} has exception");
}
}
}
return(true);
}
