protected void Page_Load(object sender, EventArgs e)
{
if (this.Attributes["mode"] != null)
{
int mode = int.Parse(this.Attributes["mode"]);
TimePeriods timePeriod = new TimePeriods();
switch (mode)
{
case 1:
timePeriod.SetLast30Days();
break;
case 2:
timePeriod.SetWeekDays();
break;
case 3:
timePeriod.SetMonthDays();
break;
case 4:
timePeriod.SetYearDays();
break;
}
CanDashboardServices canDasboardServices = new CanDashboardServices();
idlingTimeList = canDasboardServices.GetDriverIdlingTime(timePeriod.StartDate, timePeriod.EndDate, null);
idlingTimeList.Sort(delegate(IdlingTime it1, IdlingTime it2) { return(it2.IdlingSeconds.CompareTo(it1.IdlingSeconds)); });
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Attributes["mode"] != null)
{
int mode = int.Parse(this.Attributes["mode"]);
TimePeriods timePeriod = new TimePeriods();
switch (mode)
{
case 1:
timePeriod.SetLast30Days();
break;
case 2:
timePeriod.SetWeekDays();
break;
case 3:
timePeriod.SetMonthDays();
break;
case 4:
timePeriod.SetYearDays();
break;
}
ordersByStateDS = GetDataSimple(timePeriod.StartDate, timePeriod.EndDate);
}
}
public Candle[] GetCandles(string instrumentName, TimePeriods period, DateTime dateFrom, DateTime dateTo)
{
var sw = new Stopwatch();
sw.Start();
if (_cache.Any(o => o.InstrumentName == instrumentName && o.DateFrom == dateFrom && o.DateTo == dateTo && o.Period == period))
{
sw.Stop();
//Logger.Log(string.Format("Obtained data from CACHE for {0}, period {1} from {2} to {3} [{4} ms]", instrumentName, period, dateFrom, dateTo, sw.ElapsedMilliseconds));
return(_cache.First(o => o.InstrumentName == instrumentName && o.DateFrom == dateFrom && o.DateTo == dateTo && o.Period == period).Candles);
}
var cmd = new StringBuilder();
cmd.AppendLine("SELECT [Open], [High], [Low], [Close], [DateTimeStamp], [Ticker] FROM StockDataSet");
cmd.AppendLine(string.Format("JOIN ItemsSet ON StockDataSet.ItemId = ItemsSet.Id AND ItemsSet.Period = {0}", (int)period));
cmd.AppendLine(string.Format("JOIN InstrumentsSet ON InstrumentsSet.Id = ItemsSet.InstrumentId AND InstrumentsSet.Name='{0}'", instrumentName));
cmd.AppendLine(string.Format("WHERE StockDataSet.DateTimeStamp >= CONVERT(DATETIME, '{0}-{1}-{2} {3}:{4}:{5}.000', 121)", dateFrom.Year, dateFrom.Month, dateFrom.Day, dateFrom.Hour, dateFrom.Minute, dateFrom.Second));
cmd.AppendLine(string.Format("AND StockDataSet.DateTimeStamp <= CONVERT(DATETIME, '{0}-{1}-{2} {3}:{4}:{5}.000', 121) ORDER BY DateTimeStamp ASC;", dateTo.Year, dateTo.Month, dateTo.Day, dateTo.Hour, dateTo.Minute, dateTo.Second));
var query = new SqlCommand(cmd.ToString(), _connection);
var candles = new List <Candle>();
using (var dataReader = query.ExecuteReader())
{
while (dataReader.Read())
{
candles.Add(new Candle()
{
DateTimeStamp = (DateTime)dataReader["DateTimeStamp"],
Close = (float)dataReader["Close"],
Open = (float)dataReader["Open"],
High = (float)dataReader["High"],
Low = (float)dataReader["Low"],
Ticker = dataReader["Ticker"].ToString()
});
}
dataReader.Close();
}
if (!_cache.Any(o => o.InstrumentName == instrumentName && o.DateFrom == dateFrom && o.DateTo == dateTo && o.Period == period))
{
_cache.Add(new DBCandlesCache()
{
InstrumentName = instrumentName,
DateFrom = dateFrom,
DateTo = dateTo,
Candles = candles.ToArray(),
Period = period
});
}
if (_cache.Count > maxCacheSize)
{
_cache = _cache.Skip(maxCacheSize - 1).ToList();
}
sw.Stop();
//Logger.Log(string.Format("Obtained data from DB for {0}, period {1} from {2} to {3} [{4} ms]", instrumentName, period, dateFrom, dateTo, sw.ElapsedMilliseconds));
return(candles.ToArray());
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Attributes["mode"] != null)
{
int mode = int.Parse(this.Attributes["mode"]);
TimePeriods timePeriod = new TimePeriods();
switch (mode)
{
case 1:
timePeriod.SetLast30Days();
break;
case 2:
timePeriod.SetWeekDays();
break;
case 3:
timePeriod.SetMonthDays();
break;
case 4:
timePeriod.SetYearDays();
break;
}
CanDashboardServices canDasboardServices = new CanDashboardServices();
fuelConsumptionList = canDasboardServices.GetDriverFuelConsumption(timePeriod.StartDate, timePeriod.EndDate, null);
fuelConsumptionList.Sort(delegate(FuelConsumption fc2, FuelConsumption fc1) { return(fc2.MPG.CompareTo(fc1.MPG)); });
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Attributes["mode"] != null)
{
int mode = int.Parse(this.Attributes["mode"]);
TimePeriods timePeriod = new TimePeriods();
switch (mode)
{
case 1:
timePeriod.SetLast30Days();
break;
case 2:
timePeriod.SetWeekDays();
break;
case 3:
timePeriod.SetMonthDays();
break;
case 4:
timePeriod.SetYearDays();
break;
}
fleetIdlingTime = DashboardDataAccess.getFleetIdling(timePeriod.StartDate, timePeriod.EndDate);
if (fleetIdlingTime > 20)
{
fleetIdlingTime = 20;
}
}
}
public void UpdateChannelCoveredTimePeriods(int channelId, TimePeriods timePeriods)
{
var channels = _db.GetCollection <MongoChannel>("channels");
var filter = Builders <MongoChannel> .Filter.Eq("channelId", channelId);
channels.UpdateOne(filter, Builders <MongoChannel> .Update.Set("coveredTimePeriods", timePeriods));
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Attributes["mode"] != null)
{
int mode = int.Parse(this.Attributes["mode"]);
TimePeriods timePeriod = new TimePeriods();
switch (mode)
{
case 1:
timePeriod.SetLast30Days();
break;
case 2:
timePeriod.SetWeekDays();
break;
case 3:
timePeriod.SetMonthDays();
break;
case 4:
timePeriod.SetYearDays();
break;
}
CanDashboardServices canDasboardServices = new CanDashboardServices();
infringementList = canDasboardServices.GetDriverOverReving(timePeriod.StartDate, timePeriod.EndDate, null);
infringementList.Sort(delegate(InfringementCount ic1, InfringementCount ic2) { return(ic2.Count.CompareTo(ic1.Count)); });
}
}
public async Task <IActionResult> CheckAvaibillities(int roomId, DateTime date)
{
var timePeriods = await _context.Reservations.Where(x => x.RoomId == roomId && x.Date.Date == date).Select(x => x.TimePeriod).ToListAsync();
var Times = TimePeriods.GetAvaibillities(timePeriods);
return(Ok(Times));
}
public IQueryable <TimePeriod> GetMyTimePeriods(IPrincipal User)
{
ApplicationUser currentUser = GetUser(User.Identity);
if (currentUser == null)
{
return(Enumerable.Empty <TimePeriod>().AsQueryable());
}
return(TimePeriods.Where(tp => tp.Activity.Task.Project.User.Id == currentUser.Id));
}
public void StopTimer()
{
// Close the last time period if existing.
TimePeriod lastPeriod = TimePeriods.LastOrDefault();
if (lastPeriod != null && !lastPeriod.EndTime.HasValue)
{
lastPeriod.EndTime = DateTime.Now;
}
}
public object Clone()
{
ExchangeIntraday ei = new ExchangeIntraday();
ei.nativeCycle = nativeCycle;
ei.showFirstXLabel = showFirstXLabel;
ei.timeZone = timeZone;
ei.yahooDelay = yahooDelay;
ei.TimePeriods = (TimePeriod[])TimePeriods.Clone();
return(ei);
}
private bool changedNextTime()
{
DateTime nextTime = TimeProbeManager.GetProbeTime(TimePeriods?.ToArray(), LastestTime);
if (nextTime != NextTime)
{
NextTime = nextTime;
return(true);
}
return(false);
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Attributes["mode"] != null)
{
int mode = int.Parse(this.Attributes["mode"]);
TimePeriods timePeriod = new TimePeriods();
switch (mode)
{
case 1:
timePeriod.SetLast30Days();
break;
case 2:
timePeriod.SetWeekDays();
break;
case 3:
timePeriod.SetMonthDays();
break;
case 4:
timePeriod.SetYearDays();
break;
}
CanDashboardServices canDasboardServices = new CanDashboardServices();
fuelConsumptionList = canDasboardServices.GetVehicleFuelConsumption(timePeriod.StartDate, timePeriod.EndDate, null);
double mpgTotal = 0;
double litres = 0;
foreach (FuelConsumption fuelConsumption in fuelConsumptionList)
{
mpgTotal += fuelConsumption.MPG;
litres += fuelConsumption.FuelLitres;
}
if (fuelConsumptionList.Capacity == 0)
{
fleetFuelConsumption = 0;
litres = 0;
}
else
{
fleetFuelConsumption = mpgTotal / fuelConsumptionList.Capacity;
if (fleetFuelConsumption > 20)
{
fleetFuelConsumption = 20;
}
fleetFuelLitres = litres / fuelConsumptionList.Capacity;
}
}
}
public void StartTimer()
{
// Check if the last time period is still running. If so do nothing.
TimePeriod lastPeriod = TimePeriods.LastOrDefault();
if (lastPeriod != null && !lastPeriod.EndTime.HasValue)
{
return;
}
// Otherwise add a new timing period.
TimePeriods.Add(new TimePeriod {
StartTime = DateTime.Now
});
}
public TimePeriodKeyValuePair(TimePeriods period, string value)
{
this.Key = period;
this.Value = value;
}
public void ShouldBeReturnTrueForPeriod8To9()
{
Assert.AreEqual(TimePeriods.GetAvaibillities(new List <string> {
"8h - 9h"
}).Count, 23);
}
public void ShouldBeContainSlot01AndSlot24()
{
Assert.AreEqual(TimePeriods.GetTimePeriod()[0], "0h - 1h");
Assert.AreEqual(TimePeriods.GetTimePeriod()[23], "23h - 24h");
}
public void ShouldBeContain24Slots()
{
Assert.AreEqual(TimePeriods.GetTimePeriod().Count, 24);
}
/// <summary>編集するTimePeriodsオブジェクトを設定する</summary>
/// <param name="timePeriods">編集するTimePeriodsオブジェクト</param>
public void SetTimePeriods(TimePeriods timePeriods)
{
//編集中のTimePeriodsオブジェクトがあればイベント通知を解除
if (this.timePeriods != null)
{
this.timePeriods.NameChangeEvent -= new TimePeriods.NameChangeEventHandler(timePeriods_NameChangeEvent);
this.timePeriods.TimePeriodAddEvent -= new TimePeriods.TimePeriodAddEventHandler(timePeriods_TimePeriodAddEvent);
this.timePeriods.TimePeriodChangeEvent -= new TimePeriods.TimePeriodChangeEventHandler(timePeriods_TimePeriodChangeEvent);
this.timePeriods.TimePeriodRemoveEvent -= new TimePeriods.TimePeriodRemoveEventHandler(timePeriods_TimePeriodRemoveEvent);
}
//編集中のTimePeriodsオブジェクトを更新
this.timePeriods = timePeriods;
//TimePeriodsオブジェクトのイベント通知を受ける
timePeriods.NameChangeEvent += new TimePeriods.NameChangeEventHandler(timePeriods_NameChangeEvent);
timePeriods.TimePeriodAddEvent += new TimePeriods.TimePeriodAddEventHandler(timePeriods_TimePeriodAddEvent);
timePeriods.TimePeriodChangeEvent += new TimePeriods.TimePeriodChangeEventHandler(timePeriods_TimePeriodChangeEvent);
timePeriods.TimePeriodRemoveEvent += new TimePeriods.TimePeriodRemoveEventHandler(timePeriods_TimePeriodRemoveEvent);
//コントロール削除時にイベント通知を解除
this.Disposed += delegate(object sender, EventArgs e) {
timePeriods.NameChangeEvent -= new TimePeriods.NameChangeEventHandler(timePeriods_NameChangeEvent);
timePeriods.TimePeriodAddEvent -= new TimePeriods.TimePeriodAddEventHandler(timePeriods_TimePeriodAddEvent);
timePeriods.TimePeriodChangeEvent -= new TimePeriods.TimePeriodChangeEventHandler(timePeriods_TimePeriodChangeEvent);
timePeriods.TimePeriodRemoveEvent -= new TimePeriods.TimePeriodRemoveEventHandler(timePeriods_TimePeriodRemoveEvent);
};
//リストボックスを初期化
lbxTimePeriods.Items.Clear();
for (int i = 0; i < timePeriods.Count; i++) lbxTimePeriods.Items.Add(timePeriods.GetTimePeriodName(i));
//時間帯が一つの場合は削除ボタンを操作不能にする
if (lbxTimePeriods.Items.Count <= 1) btnRemove.Enabled = false;
//一つ目の時間帯を選択
if (0 < lbxTimePeriods.Items.Count) lbxTimePeriods.SelectedIndex = 0;
//Seasonsの名称を設定
initializing = true;
tbxTimePeriodsName.Text = timePeriods.Name;
initializing = false;
}
public static CalculationOrder CreateNew(string insName, DateTime dateFrom, DateTime dateTo, TimePeriods period, float[] parameters)
{
return(new CalculationOrder()
{
InstrumentName = insName,
DateFrom = dateFrom,
DateTo = dateTo,
Status = CalculationOrderStatus.Waiting,
Period = period,
Parameters = parameters,
Id = Guid.NewGuid()
});
}
public void AddOrdersToRemoteCalulation(Guid idCalculation, string insName, DateTime dateFrom, DateTime dateTo, TimePeriods period, FromToValue[] parameters, float stopLoss, bool ignoreNightCandles, float daySpread, float nightSpread)
{
var rc = _remoteCalculators.Single(o => o.Id == idCalculation);
if (rc == null)
{
return;
}
try
{
_collector = new int[parameters.Count()];
rc.OrdersPool.Lock();
CreateOrdersForMultipleParams(idCalculation, insName, dateFrom, dateTo, period, parameters, stopLoss, ignoreNightCandles, daySpread, nightSpread);
}
catch (Exception ex)
{
Logger.Log(ex.ToString());
}
finally
{
rc.OrdersPool.UnLock();
}
}
public void AddOrderToRemoteCalulation(Guid idCalculation, string insName, DateTime dateFrom, DateTime dateTo, TimePeriods period, float[] parameters, float stopLoss, bool ignoreNightCandles, float daySpread, float nightSpread)
{
var rc = _remoteCalculators.Single(o => o.Id == idCalculation);
if (rc == null)
{
return;
}
rc.OrdersPool.AddNewOrderForCalculation(insName, dateFrom, dateTo, period, parameters, stopLoss, ignoreNightCandles, daySpread, nightSpread);
}
public TimePeriodKeyValuePair(TimePeriods period, string value)
{
this.Key = period;
this.Value = value;
}
// Returns a list of selected time periods
private List <TimePeriod> GetSelectedTimePeriods()
{
var filtered = TimePeriods.FindAll((tp) => tp.IsChecked).ConvertAll((tp) => tp.TimePeriod);
return(filtered);
}
private void CreateOrdersForMultipleParams(Guid idCalculation, string insName, DateTime dateFrom, DateTime dateTo, TimePeriods period, FromToValue[] parameters, float stopLoss, bool ignoreNightCandles, float daySpread, float nightSpread, int num = 0)
{
_collector[num] = (int)parameters[num].From - 1;
while (_collector[num] < parameters[num].To)
{
_collector[num]++;
var newVal = new float[parameters.Count()];
for (var i = 0; i < _collector.Count(); i++)
{
newVal[i] = _collector[i];
}
if (num == _collector.Count() - 1)
{
AddOrderToRemoteCalulation(idCalculation, insName, dateFrom, dateTo, period, newVal, stopLoss, ignoreNightCandles, daySpread, nightSpread);
}
if (num < _collector.Count() - 1)
{
CreateOrdersForMultipleParams(idCalculation, insName, dateFrom, dateTo, period, parameters, stopLoss, ignoreNightCandles, daySpread, nightSpread, num + 1);
}
}
}
public Guid AddNewOrderForCalculation(string insName, DateTime dateFrom, DateTime dateTo, TimePeriods period, float[] parameters, float stopLoss, bool ignoreNightCandles, float daySpread, float nightSpread)
{
var order = CalculationOrder.CreateNew(insName, dateFrom, dateTo, period, parameters);
order.StopLoss = stopLoss;
order.IgnoreNightCandles = ignoreNightCandles;
order.DaySpread = daySpread;
order.NightSpread = nightSpread;
_ordersQueue.Enqueue(order);
return(order.Id);
}
public IActionResult Times()
{
return(Ok(TimePeriods.GetTimePeriod()));
}
