public override string[] GetRolesForUser(string UserId)
{
int id = string.IsNullOrEmpty(UserId) ? 0 : Convert.ToInt32(UserId);
string[] roleName;
using (MayFlower dbContext = new MayFlower())
{
var user = dbContext.Users.SingleOrDefault(u => u.UserID == id);
if (user == null)
{
dbContext.Dispose();
return(new string[] { });
}
else
{
roleName = dbContext.UsersInRoles.Where(ui => ui.UserId == id).Select(e => e.Role.RoleName).ToArray();
dbContext.Dispose();
return(roleName == null ? new string[] { } : roleName);
}
}
}
private void OnTimerRHI(object sender, System.Timers.ElapsedEventArgs args)
{
MayFlower dbContext = null;
try
{
dbContext = dbContext ?? new MayFlower();
var ordersRHI = Components.PaymentCheck.DBQuery.GetOrdersRHI(dbContext, false, true);
List <string> mailMsg = new List <string>();
foreach (var order in ordersRHI.Select(x => x.SuperPNROrder).Distinct())
{
order.SuperPNR.LoadPaymentDetailList(true);
var groupedPaymentCurrencyDtl = order.SuperPNR.PaymentDetailsList.FirstOrDefault();
mailMsg.Add($"<li>" +
$"<b>{order.SuperPNR.SuperPNRNo}</b> ({order.BookingStatusCode})<br/>" +
$"<i>Main Product: {order.SuperPNR.MainProductType.ToString()},<br/>" +
$"Total Order Amount: {order.CurrencyCode} {order.GrandTotalAmt.ToString("n2")}<br/>" +
$"Success Payment Amount: {groupedPaymentCurrencyDtl.CurrencyCode} {groupedPaymentCurrencyDtl.TotalPaidAmount.ToString("n2")}</i>" +
$"</li>");
}
if (mailMsg.Count > 0)
{
string _msg = string.Join("", mailMsg);
string fromEmail = Alphareds.Module.Common.Core.GetAppSettingValueEnhanced("fromEmailAddress");
string sendToEmail = Alphareds.Module.Common.Core.GetAppSettingValueEnhanced("RHIReminderEmailList");
string _folderPath = System.AppDomain.CurrentDomain.BaseDirectory.ToLower().Replace(@"\bin\debug\", "").Replace(@"\bin\release\", "");
string _fullPath = _folderPath + @"\EmailTemplates\RHIEmailReminder.html";
bool fileExists = System.IO.File.Exists(_folderPath + @"\EmailTemplates\RHIEmailReminder.html");
if (fileExists)
{
string htmlTemplete = System.IO.File.ReadAllText(_fullPath);
htmlTemplete = htmlTemplete.Replace("{ItemListToReplace}", _msg);
Alphareds.Module.CommonController.CommonServiceController.InsertEmailQueue(null, fromEmail, sendToEmail, null, null,
"Mayflower RHI Booking List", htmlTemplete, null, true);
}
else
{
string msg = "Template files not found for the RHI reminder email. " + Environment.NewLine + Environment.NewLine + _msg;
eventLog1.WriteEntry(msg, EventLogEntryType.Warning);
logger.Warn(msg);
}
}
}
catch (Exception ex)
{
string msg = "Error Occured when preparing the RHI reminder email. " + Environment.NewLine + Environment.NewLine + ex.ToString();
eventLog1.WriteEntry(msg, EventLogEntryType.Warning);
logger.Warn(msg);
}
try
{
dbContext.Dispose();
}
catch
{
}
}
protected override void Dispose(bool disposing)
{
db.Dispose();
base.Dispose(disposing);
}
