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