static void Main(string[] args) { string conn = ""; //костыль для одноразового запуска IExchnageRateRepository _repo = new ExchangeRateRepository(conn); Parser p = new Parser(); var a = _repo.AddRangeAsync(p.RequestArchive()).Result; }
public JsonResult GetBankData() { var exchangeRepo = new ExchangeRateRepository(); var rates = exchangeRepo.GetActiveBanksRatesByDate(GetTodayDateTime()).Where(i => i.BankId != 99).ToList(); return(Json(new BankRateModelView() { Rates = rates, DateControl = DateTime.UtcNow.AddHours(-6).ToString("yyyy-MM-dd HH:mm:ss") })); }
public UnitOfWork(ApplicationDbContext context) { _context = context; Accounts = new AccountRepository(_context); Assets = new AssetRepository(_context); Bonds = new BondRepository(_context); Contacts = new ContactRepository(_context); Partners = new PartnerRepository(_context); Institutions = new InstitutionRepository(_context); Banks = new InstitutionRepository(_context); Currencies = new CurrencyRepository(_context); Countries = new CountryRepository(_context); Messages = new MessageRepository(_context); Portfolios = new PortfolioRepository(_context); Tasks = new TaskRepository(_context); Reports = new ReportRepository(_context); ExchangeRates = new ExchangeRateRepository(_context); Returns = new ReturnRepository(_context); HoldingPeriodReturns = new ReturnRepository(_context); TileWidgets = new TileWidgetRepository(_context); }
public static void UpdateExchangeRateHistory() { try { TimeSpan ts = TimeSpan.Parse(AppSettings.CustomerCurrency); Time = TimeSpan.Parse(DateTime.Now.ToString("HH:mm")); if (Time >= ts) { FrayteStatus mailstatus = new ExchangeRateRepository().ExchangeRateHistoryUpdateStatus(); if (mailstatus.HistoryStatus == false) { new ExchangeRateRepository().SaveExchnageRateHistory(); } } } catch (Exception ex) { Logger _log = Get_Log(); _log.Info("Error due to update exchange rate"); _log.Error(ex); } }
public JsonResult GetBancoCentral() { var exchangeRepo = new ExchangeRateRepository(); return(Json(exchangeRepo.GetCentralBankRate(GetTodayDateTime()))); }
public static void SendFuelSurchargeAndCurrencyEmail() { try { TimeSpan ts = TimeSpan.Parse(AppSettings.FuelSurCharge); TimeSpan ts1 = TimeSpan.Parse(AppSettings.CustomerCurrency); Time = TimeSpan.Parse(DateTime.Now.ToString("HH:mm")); current = Frayte.Services.CommonConversion.ConvertToDateTime(DateTime.UtcNow.ToString("MM/dd/yyyy")); DateTime comparedate = Frayte.Services.CommonConversion.ConvertToDateTime(DateTime.UtcNow.Month + "/23/" + DateTime.UtcNow.Year); for (int i = 1; i < 3; i++) { FrayteStatus mailstatus = new FuelSurChargeRepository().GetSendMailStatus(DateTime.UtcNow, i); var setting = new ReportSettingRepository().GetAllUserDetail(); if (setting != null) { foreach (var status in setting) { if (status.IsFuelSurCharge == true) { if (Time >= ts && comparedate == current) { if (mailstatus.FuelMailSentOn != current) { if (i == 1) { FrayteStatus updatestatus = new FuelSurChargeRepository().UpdateStatus(DateTime.UtcNow, i); if (updatestatus.IsFuelSurCharge == false) { new ReportSettingRepository().FuelSurChargeSendEmail(status.Email, Frayte.Schedular.Utility.AppSettings.HKEmail, status.UserName, "", i); } } else if (i == 2) { FrayteStatus updatestatus = new FuelSurChargeRepository().UpdateStatus(DateTime.UtcNow, i); if (updatestatus.IsFuelSurCharge == false) { new ReportSettingRepository().FuelSurChargeSendEmail(status.Email, Frayte.Schedular.Utility.AppSettings.UKEmail, status.UserName, "", i); } } } } } } } } for (int j = 1; j < 3; j++) { FrayteStatus mailstatus = new ExchangeRateRepository().GetSendMailStatus(j); var setting = new ReportSettingRepository().GetAllUserDetail(); if (setting != null) { foreach (var status in setting) { if (status.IsCurrecy == true) { if (Time >= ts1) { if (j == 1) { if (mailstatus.CurrencyMailSentOn != current) { new ReportSettingRepository().ExchangeRateSendEmail(status.Email, "", status.UserName, "", j); } } else if (j == 2) { if (mailstatus.CurrencyMailSentOn != current) { new ReportSettingRepository().ExchangeRateSendEmail(status.Email, "", status.UserName, "", j); } } } } } } } } catch (Exception ex) { Logger _log = Get_Log(); _log.Info("Error due to fuel sur charge and exchange rate"); _log.Error(ex); } }
public List <FrayteExchangeRateHistory> ExchangeRateHistory(FrayteSearchExchangeHistory search) { List <FrayteExchangeRateHistory> _rate = new ExchangeRateRepository().GetExchangeRateHistory(search); return(_rate); }
public List <FrayteExchangeMonth> DistinctMonth(int OperationZoneId, string Type) { List <FrayteExchangeMonth> _month = new ExchangeRateRepository().GetDistinctMonth(OperationZoneId, Type); return(_month); }
public List <int> DistinctYear(int OperationZoneId, string Type) { List <int> _year = new ExchangeRateRepository().GetDistinctYear(OperationZoneId, Type); return(_year); }
public List <CurrencyType> GetCurrencyDetail() { var list = new ExchangeRateRepository().GetCurrency(); return(list); }
public List <FrayteExchangeRate> GetOperationExchangeRate(int operationZoneId) { var list = new ExchangeRateRepository().GetOperationExchangeRateDetail(operationZoneId); return(list); }