public int UpdateCurrencyExchangeRates()
{
try
{
//new up everything
IMailService mailerService = new MaintainanceMailer();
CurrencyExchangeService ces = new CurrencyExchangeService(mailerService);
//get all the currencies
using (var _db = new PortVillasContext())
{
var currencies = _db.CurrencyExchanges.ToList();
foreach (var currency in currencies)
{
ces.UpdateCurrency(currency);
}
}
return 0;
}
catch (Exception ex)
{
}
return -1;
}
public static List <BookingExternal> GetExternalBookingsForAProperty(long propertyID)
{
using (var db = new PortVillasContext())
{
var bookings = db.BookingExternals.ToList();
return(bookings);
}
}
public static List <AirportDestination> GetAllAirportDestinations()
{
{
using (var portCon = new PortVillasContext())
{
return(portCon.AirportDestinations.ToList());
}
}
}
public ActionResult GetACustomer(int CustomerID)
{
using (var _db = new PortVillasContext())
{
var data = _db.Customers.Where(x => x.CustomerID == CustomerID).FirstOrDefault();
ViewData["currentCustomer"] = data;
return PartialView("CustomerEdit", data);
}
}
public static List<AirportDestination> GetAllAirportDestinations()
{
{
using (var portCon = new PortVillasContext())
{
return portCon.AirportDestinations.ToList();
}
}
}
public static List<BookingExternal> GetExternalBookingsForAProperty(long propertyID)
{
using (var db = new PortVillasContext())
{
var bookings = db.BookingExternals.ToList();
return bookings;
}
}
public ActionResult Edit(Customer customer)
{
if (ModelState.IsValid)
{
using (var db = new PortVillasContext())
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
}
return RedirectToAction("Index");
}
//
// GET: /TestAjax/
public ActionResult Index()
{
using (var _db = new PortVillasContext())
{
var data = _db.Customers.ToList();
ViewData["currentCustomer"] = _db.Customers.Where(x => x.CustomerID == 1).FirstOrDefault();
return View(data);
}
}
public static List <Booking> GetExternalBookingsAsBookings(long propertyID)
{
using (var db = new PortVillasContext())
{
var bookings = db.BookingExternals.Where(x => x.PropertyID == propertyID).ToList();
List <Booking> cal = new List <Booking>();
foreach (var bookingExternal in bookings)
{
cal.Add(new Booking
{
StartDate = bookingExternal.StartDate,
EndDate = bookingExternal.EndDate,
PropertyID = bookingExternal.PropertyID,
Confirmed = true,
Cancelled = false
});
}
return(cal);
}
}
public static List<Booking> GetExternalBookingsAsBookings(long propertyID)
{
using (var db = new PortVillasContext())
{
var bookings = db.BookingExternals.Where(x=>x.PropertyID == propertyID).ToList();
List<Booking> cal = new List<Booking>();
foreach (var bookingExternal in bookings)
{
cal.Add(new Booking
{
StartDate = bookingExternal.StartDate,
EndDate = bookingExternal.EndDate,
PropertyID = bookingExternal.PropertyID,
Confirmed = true,
Cancelled = false
});
}
return cal;
}
}
public int UpdateCurrency(CurrencyExchange theCurrency)
{
try
{
theCurrency.CurrencyExchangeRate = MakeCurrencyExchangeRequest(theCurrency);
theCurrency.LastUpdated = DateTime.Now;
//update the db
using (var db = new PortVillasContext())
{
db.Entry(theCurrency).State = EntityState.Modified;
db.SaveChanges();
return 0;
}
}
catch (Exception ex)
{
//log
/* this.mailService.Mail("[email protected]!", "Problem in PRC with currency converter");*/
throw ex;
}
}
public void TestCurrencyService()
{
//new up everything
IMailService mailerService = new MaintainanceMailer();
CurrencyExchangeService ces = new CurrencyExchangeService(mailerService);
//send a cheeky testmail
//get all the currencies
using (var _db = new PortVillasContext())
{
var currencies = _db.CurrencyExchanges.ToList();
foreach (var currency in currencies)
{
ces.UpdateCurrency(currency);
}
}
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
WebApiConfig.Register(GlobalConfiguration.Configuration);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
AuthConfig.RegisterAuth();
var binder = new BootstrapVillas.CustomModelBinders.DateTimeUKModelBinder();
ModelBinders.Binders.Add(typeof(DateTime), binder);
ModelBinders.Binders.Add(typeof(DateTime?), binder);
Database.SetInitializer<PortugalVillasContext>(null);
Database.SetInitializer<UsersContext>(null);
//membership provider
if (!WebSecurity.Initialized)
{
WebSecurity.InitializeDatabaseConnection("PortugalVillasContext", "UserProfile", "UserId", "UserName",
true);
}
//update currency
try
{
var autoMate = new PRCAutomations();
var ok = autoMate.UpdateCurrencyExchangeRates();
}
catch (Exception ex)
{
//ignore
}
//get a token for the translator every 500 seconds and store it in the viewbag
Timer translateTimer = new Timer(600000);
translateTimer.Elapsed += translateTimer_Elapsed;
Application["TranslateToken"] = GetBingAPITranslationToken();
translateTimer.Enabled = true;
GC.KeepAlive(translateTimer);
//update currency every hr
Timer currencyUpdateTimer = new Timer(3600000);
currencyUpdateTimer.Elapsed += currencyUpdateTimer_Elapsed;
currencyUpdateTimer.Enabled = true;
GC.KeepAlive(currencyUpdateTimer);
InitCache();
var defaultCurrencyEnum = (CurrencyEnum)Enum.Parse(typeof(CurrencyEnum), ConfigurationManager.AppSettings["defaultCurrency"]);
var currencies = new List<CurrencyExchange>();
using (var db = new PortVillasContext())
{
currencies = db.CurrencyExchanges.ToList();
}
//structuremap
IContainer container = new Container(cfg =>
{
cfg.Scan(x => x.WithDefaultConventions());
cfg.For<ICurrencyConvert>()
.Singleton()
.Use(() => CurrencyConverterFactory.GetCurrencyConverter(defaultCurrencyEnum, currencies));
}
);
DependencyResolver.SetResolver(new StructureMapDependencyResolver(container));
}
protected void TestSetup()
{
db = new PortVillasContext();
}
public ActionResult ProcessForm(Customer obj)
{
using (var _db = new PortVillasContext())
{
var data = _db.Customers.Where(x => x.CustomerID == obj.CustomerID).SingleOrDefault();
ViewData["currentCustomer"] = data;
return PartialView("CustomerEdit", data);
}
}
