// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
// ReSharper disable once UnusedMember.Global
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, IHostApplicationLifetime life)
{
AppLog.ShowLogOnError(app);
BaseModel.IsDev = env.IsDevelopment();
TZ.Init(env.IsDevelopment());
Config.Initialize(env);
Security.DenyFrame(app);
StaticFiles.Configure(app);
Route.CreateRoutes();
Rewrite.TestThemAll(app);
Context.Set(app);
Error.AddHandlers(app, env);
Orm.Config(app, life);
Context.SetLanguage(app, env);
Access.Run(app);
Route.Execute(app);
}
public void Remove(TZ entity)
{
Delete delete = new Delete("TZ");
delete.AddCriterions("KeyID", entity.Id, CriteriaOperator.Equal);
dataFactory.Remove(delete);
}
static InternetTime()
{
TimeZones = new List<TZ> { new TZ (@"([\-\+])(\d\d)(\:|)(\d\d)$", m =>
{
var neg = m.Groups[1].Value == "-";
var h = int.Parse (m.Groups[2].Value) + int.Parse (m.Groups[4].Value) / 60.0;
if (neg)
h *= -1;
var o = TimeSpan.FromHours (h);
return o;
}), new TZ (@"Z$", m => TimeSpan.Zero), new TZ (@" GMT\+00\:00", m => TimeSpan.Zero), new TZ (@" \+0000$", m => TimeSpan.Zero), new TZ (@" \+0000 ", m => TimeSpan.Zero), new TZ (@" Z$", m => TimeSpan.Zero), new TZ (@" GMT$", m => TimeSpan.Zero), new TZ (@" UTC$", m => TimeSpan.Zero) };
try {
using (var f = File.OpenText ("TimeZones.txt")) {
for (var line = f.ReadLine (); line != null; line = f.ReadLine ()) {
var m = TZRE.Match (line);
if (m.Success) {
var d = ParseTimeSpan(m.Groups[2].Value);
var tz = new TZ(
" " + m.Groups[1].Value.Trim() + "$",
match => d
);
TimeZones.Add(tz);
}
}
}
} catch (Exception ex) {
Console.WriteLine ("! " + ex);
}
TimeZones.Add (new TZ (@" [A-Z]+$", m => TimeSpan.Zero));
// Catch all
}
public void Setup(DateTime[] eventDates, TZ tz_)
{
if (eventDates == null)
_cache[tz_] = new DateTime[0];
else
_cache[tz_] = eventDates;
}
internal DateTime[] GetYourDates(DBHelper db_, TZ tz_)
{
string tableName = "eventTimesGMT";
switch (tz_)
{
case TZ.HK: tableName = "eventTimesHK"; break;
case TZ.LN: tableName = "eventTimesLN"; break;
case TZ.NY: tableName = "eventTimesNY"; break;
case TZ.GMT: tableName = "eventTimesGMT"; break;
}
var sql = string.Format("select eventTimeLocal from {1} where eventID={0} order by eventTimeGMT", EventID, tableName);
var ds = db_.Execute(sql);
if (DBHelper.HasData(ds))
{
var list = new List<DateTime>();
foreach (DataRow row in ds.Tables[0].Rows)
list.Add((DateTime)row[0]);
return list.ToArray();
}
return null;
}
public TZ FindBy(Guid id)
{
Query query = new Query("TZ");
query.AddCriterion("KeyID", id, CriteriaOperator.Equal);
DataTable table = dataFactory.Query(query);
if (table.Rows.Count > 0)
{
TZ result = new TZ();
result.TableName = table.Rows[0]["TableName"].ToString().Trim();
result.KeyID = (Guid)table.Rows[0]["KeyID"];
result.ProductLineID = int.Parse(table.Rows[0]["ProductLineID"].ToString().Trim());
result.ReportID = int.Parse(table.Rows[0]["ReportID"].ToString().Trim());
result.Date = table.Rows[0]["Date"].ToString().Trim();
result.CreationDate = (DateTime)table.Rows[0]["CreationDate"];
result.ModifierID = table.Rows[0]["ModifierID"].ToString().Trim();
result.Version = (DateTime)table.Rows[0]["Version"];
result.ModifiedFlag = (bool)table.Rows[0]["ModifiedFlag"];
result.Remarks = table.Rows[0]["Remarks"].ToString().Trim();
return result;
}
else
{
return new TZ();
}
}
public TZ FindBy(Guid id)
{
Query query = new Query("TZ");
query.AddCriterion("KeyID", id, CriteriaOperator.Equal);
DataTable table = dataFactory.Query(query);
if (table.Rows.Count > 0)
{
TZ result = new TZ();
result.TableName = table.Rows[0]["TableName"].ToString().Trim();
result.KeyID = (Guid)table.Rows[0]["KeyID"];
result.ProductLineID = int.Parse(table.Rows[0]["ProductLineID"].ToString().Trim());
result.ReportID = int.Parse(table.Rows[0]["ReportID"].ToString().Trim());
result.Date = table.Rows[0]["Date"].ToString().Trim();
result.CreationDate = (DateTime)table.Rows[0]["CreationDate"];
result.ModifierID = table.Rows[0]["ModifierID"].ToString().Trim();
result.Version = (DateTime)table.Rows[0]["Version"];
result.ModifiedFlag = (bool)table.Rows[0]["ModifiedFlag"];
result.Remarks = table.Rows[0]["Remarks"].ToString().Trim();
return(result);
}
else
{
return(new TZ());
}
}
public void Setup(ConstructGen<double> input_, TZ tz_)
{
if (input_ == null)
_cache[tz_] = new DateTime[0];
else
_cache[tz_] = m_builderFunction(input_);
}
/********************************************************************************************/
public void Save(TZ entity)
{
Update <TZ> update = new Update <TZ>("TZ", entity);
update.AddCriterion("KeyID", entity.Id, CriteriaOperator.Equal);
update.AddExcludeField("KeyID");
dataFactory.Save <TZ>(update);
}
public virtual async Task<DateTime[]> GetEvents(TZ tz_, CarbonClient cc_)
{
if (_cache.ContainsKey(tz_))
return _cache[tz_];
_cache[tz_] = await getEventInner(tz_, cc_);
return _cache.ContainsKey(tz_) ? _cache[tz_] : null;
}
public TZResponse GetTZInformationByKeyID(TZRequest request)
{
TZ tz = tzRepository.FindBy(request.KeyID);
TZResponse response = new TZResponse
{
TZView = tz.ConvertToView()
};
return(response);
}
public static IDictionary<DateTime, DatedDataCollectionGen<double>> Go(string eventCode_, TZ tz_, DateTime earliestEventDate_, DateTime latestEventDate_, string futureStart_, TimeSpan timeBeforeEvent_, TimeSpan priceFrequency_)
{
var eventGroup = Singleton<EventDefs>.Instance.Where(x => x.EventCode.Equals(eventCode_)).FirstOrDefault();
if (eventGroup == null) return null;
var eventTimesLocal = eventGroup.GetEvents(tz_, new CarbonClient("uat")).Result.Where(x => x >= earliestEventDate_ && x <= latestEventDate_).ToArray();
return Go(tz_, eventTimesLocal, futureStart_, timeBeforeEvent_, priceFrequency_);
}
protected static TimeZoneInfo GetTimezone(TZ tz_)
{
switch (tz_)
{
case TZ.HK: return HK_TimeZoneInfo;
case TZ.LN: return LN_TimezoneInfo;
case TZ.NY: return NY_TimeZoneInfo;
}
return TimeZoneInfo.Local; // should never get here
}
public static string GetEventDatesAsXml(EventGroup eg_, TZ tz_, DateTime minDate_, DateTime maxDate_)
{
DateTime[] dates = null;
using (var db = new DBHelper())
{
dates = eg_.GetYourDates(db, tz_);
}
return dates == null ? null : dates
.Where(x=>x >=minDate_ && x<=maxDate_)
.Select(x => new { Date = x.ToString("dd-MMM-yyyy HH:mm:ss") }).ToGenericTableXml();
}
private void updateConfig(ConfigInfo info, Config config)
{
if (info.Language != null && !PlainText.AcceptLanguage(info.Language))
{
throw Error.LanguageUnknown.Throw();
}
if (info.TimeZone != null && !TZ.IsValid(info.TimeZone))
{
throw Error.TimeZoneUnknown.Throw();
}
if (!String.IsNullOrEmpty(info.Language))
{
config.Language = info.Language;
}
if (!String.IsNullOrEmpty(info.TimeZone))
{
config.TimeZone = info.TimeZone;
}
if (info.UseCategories.HasValue)
{
config.UseCategories = info.UseCategories.Value;
}
if (info.UseAccountsSigns.HasValue)
{
config.UseAccountsSigns = info.UseAccountsSigns.Value;
}
if (info.MoveCheck.HasValue)
{
config.MoveCheck = info.MoveCheck.Value;
}
if (info.SendMoveEmail.HasValue)
{
config.SendMoveEmail = info.SendMoveEmail.Value;
}
if (info.Wizard.HasValue)
{
config.Wizard = info.Wizard.Value;
}
repos.Config.Update(config);
}
public static TZ ConvertToTz(this TZView item)
{
TZ result = new TZ();
result.KeyID = item.KeyID;
result.TableName = item.TableName;
result.ModifiedFlag = item.ModifiedFlag;
result.Date = item.Date;
result.Version = item.Version;
result.CreationDate = item.CreationDate;
result.ModifierID = item.ModifierID;
result.ReportID = item.ReportID;
result.ProductLineID = item.ProductLineID;
result.Remarks = item.Remarks;
return result;
}
public static TZ ConvertToTz(this TZView item)
{
TZ result = new TZ();
result.KeyID = item.KeyID;
result.TableName = item.TableName;
result.ModifiedFlag = item.ModifiedFlag;
result.Date = item.Date;
result.Version = item.Version;
result.CreationDate = item.CreationDate;
result.ModifierID = item.ModifierID;
result.ReportID = item.ReportID;
result.ProductLineID = item.ProductLineID;
result.Remarks = item.Remarks;
return(result);
}
public static string GetDataAsXml(StaticFuture sf_, DateTime startDate_, DateTime endDate_, TZ timezone_, int freqNum_, DataFrequencyType freqType_)
{
Constructs.ConstructGen<double> con = null;
if (estimateReturnRowCount(startDate_, endDate_, freqNum_, freqType_) > _maxReturnRowCount)
return XmlStringForGenericTableErrorMessage(string.Format("Call would exceed max row return row count of {0}", _maxReturnRowCount));
using (var db = new DBHelper())
{
con = GetHistData(sf_, startDate_, endDate_, timezone_, freqNum_, freqType_, db);
}
if (con == null) return null;
return con.Dates.Select(x => new { Date = x.ToString("dd-MMM-yyyy HH:mm"), Price = con.GetValue(x, 0) }).ToGenericTableXml();
}
public Service(String task)
{
this.task = EnumX.Parse <Task>(task);
TZ.Init(false);
service = new ServiceAccess(getTicket, getSite);
if (this.task != Task.Check)
{
service.Current.Set(Cfg.RobotEmail, Cfg.RobotPassword, false);
}
if (this.task == Task.Wipe)
{
s3 = new S3();
}
}
public static TZView ConvertToView(this TZ item)
{
return(new TZView
{
KeyID = item.KeyID,
TableName = item.TableName,
CreationDate = item.CreationDate,
Date = item.Date,
ModifiedFlag = item.ModifiedFlag,
ModifierName = GetModifierName(item.ModifierID),
ModifierID = item.ModifierID,
ProductLineName = GetProductLineName(item.ProductLineID),
ProductLineID = item.ProductLineID,
Remarks = item.Remarks,
Version = item.Version,
ReportName = GetReportNameById(item.ReportID),
ReportID = item.ReportID
});
}
private static Constructs.ConstructGen<double> GetHistData(StaticFuture sf_, DateTime startDate_, DateTime endDate_, TZ timezone_, int freqNum_, DataFrequencyType freqType_, DBHelper db_)
{
var retriever = DataRetrievers.RetrieverBase.GetRetriever(timezone_, freqType_, startDate_, endDate_);
var rawData = retriever.GetData(db_, sf_);
if (rawData == null || rawData.Dates == null || rawData.Dates.Count == 0)
return null;
SLog.log.Debug(string.Format("RawDataCount from Database: {0}", rawData.Dates.Count.ToString()));
var timespan = getTimespan(freqType_, freqNum_);
var filled = rawData.GetSubsetOnTimespan(startDate_, timespan);
SLog.log.Debug(string.Format("After fillout, datacount is: {0}", filled.Dates.Count.ToString()));
if (filled.NeedsToSortKeys()) filled.SortKeys();
return filled;
}
public static void Start()
{
Cfg.Init();
setLogName();
setRepositories();
log("General", "BeforeTestRun");
TZ.Init(false);
ControlMap.IsTest = true;
SessionFactoryManager.Initialize <UserMap, User>(Cfg.DB);
SessionManager.Init(getTicketKey);
service = new ServiceAccess(getTicket, getSite);
PlainText.Initialize(runPath);
}
public string SaveAnotherFormulaYear(string tableName,IList<FormulaYear> childrenValues, TZ tzValue)
{
Guid newKeyID = Guid.NewGuid();
using (TransactionScope scope = new TransactionScope())
{
foreach (var item in childrenValues)
{
item.KeyID = newKeyID;
Insert<FormulaYear> insert = new Insert<FormulaYear>(tableName, item);
insert.AddExcludeField("Id");
dataFactory.Save<FormulaYear>(insert);
}
tzValue.KeyID = newKeyID;
Insert<TZ> insertTz = new Insert<TZ>("TZ", tzValue);
insertTz.AddExcludeField("Id");
dataFactory.Save<TZ>(insertTz);
scope.Complete();
}
return "1";
}
static InternetTime()
{
TimeZones = new List <TZ> {
new TZ(@"([\-\+])(\d\d)(\:|)(\d\d)$", m =>
{
var neg = m.Groups[1].Value == "-";
var h = int.Parse(m.Groups[2].Value) + int.Parse(m.Groups[4].Value) / 60.0;
if (neg)
{
h *= -1;
}
var o = TimeSpan.FromHours(h);
return(o);
}), new TZ(@"Z$", m => TimeSpan.Zero), new TZ(@" GMT\+00\:00", m => TimeSpan.Zero), new TZ(@" \+0000$", m => TimeSpan.Zero), new TZ(@" \+0000 ", m => TimeSpan.Zero), new TZ(@" Z$", m => TimeSpan.Zero), new TZ(@" GMT$", m => TimeSpan.Zero), new TZ(@" UTC$", m => TimeSpan.Zero)
};
try {
using (var f = File.OpenText("TimeZones.txt")) {
for (var line = f.ReadLine(); line != null; line = f.ReadLine())
{
var m = TZRE.Match(line);
if (m.Success)
{
var d = ParseTimeSpan(m.Groups[2].Value);
var tz = new TZ(
" " + m.Groups[1].Value.Trim() + "$",
match => d
);
TimeZones.Add(tz);
}
}
}
} catch (Exception ex) {
Console.WriteLine("! " + ex);
}
TimeZones.Add(new TZ(@" [A-Z]+$", m => TimeSpan.Zero));
// Catch all
}
public IEnumerable <TZ> FindBy(Query query)
{
IList <TZ> result = new List <TZ>();
DataTable table = dataFactory.Query(query);
foreach (DataRow row in table.Rows)
{
TZ tz = new TZ();
tz.KeyID = (Guid)row["KeyID"];
tz.ProductLineID = int.Parse(row["ProductLineID"].ToString().Trim());
tz.ReportID = int.Parse(row["ReportID"].ToString().Trim());
tz.TableName = row["TableName"].ToString().Trim();
tz.Date = row["Date"].ToString().Trim();
tz.CreationDate = (DateTime)row["CreationDate"];
tz.ModifierID = row["ModifierID"].ToString().Trim();
if (row["Version"].ToString().Trim() != "")
{
tz.Version = (DateTime)row["Version"];
}
tz.ModifiedFlag = (bool)row["ModifiedFlag"];
tz.Remarks = row["Remarks"].ToString().Trim();
//result.Add(new TZ
//{
// KeyID = (Guid)row["KeyID"],
// ProductLineID = int.Parse(row["ProductLineID"].ToString().Trim()),
// ReportID = int.Parse(row["ReportID"].ToString().Trim()),
// Date = row["Date"].ToString().Trim(),
// CreationDate = (DateTime)row["CreationDate"],
// ModifierID = row["ModifierID"].ToString().Trim(),
// Version = (DateTime)row["Version"],
// ModifiedFlag = (bool)row["ModifiedFlag"],
// Remarks = row["Remarks"].ToString().Trim()
//});
result.Add(tz);
}
return(result);
}
// TODO: Use Olson TZ database names
// See http://www.opengroup.org/onlinepubs/007908799/xbd/envvar.html
// http://www.twinsun.com/tz/tz-link.htm
// http://blogs.msdn.com/bclteam/archive/2006/04/03/567119.aspx
public static bool TryParseTimeZone(string timeZoneEnvSpec, out TimeZone timeZone)
{
if (String.IsNullOrEmpty(timeZoneEnvSpec))
{
timeZone = TimeZone.CurrentTimeZone;
return(true);
}
if (_tzPattern == null)
{
// TODO: we require offset and don't recognize DST rules
_tzPattern = new Regex(@"^\s*
(?<std>[^-+:,0-9\0]{3,})
(?<sh>[+-]?[0-9]{1,2})((:(?<sm>[0-9]{1,2}))?(:(?<ss>[0-9]{1,2}))?)?
",
RegexOptions.IgnorePatternWhitespace | RegexOptions.CultureInvariant
);
}
Match match = _tzPattern.Match(timeZoneEnvSpec);
if (!match.Success)
{
timeZone = null;
return(false);
}
timeZone = new TZ(
new TimeSpan(
-Int32.Parse(match.Groups["sh"].Value, CultureInfo.InvariantCulture),
match.Groups["sm"].Success ? Int32.Parse(match.Groups["sm"].Value, CultureInfo.InvariantCulture) : 0,
match.Groups["ss"].Success ? Int32.Parse(match.Groups["ss"].Value, CultureInfo.InvariantCulture) : 0
),
match.Groups["std"].Value
);
return(true);
}
public string SaveAnotherByGrid(string myJsonData, string tableName)
{
string m_GridJson = myJsonData;
//DataContractJsonSerializer m_JsonDs = new DataContractJsonSerializer(typeof(ReportDataSaveAnother<FormulaYear, TZView>));
//MemoryStream m_JsonStringMs = new MemoryStream(System.Text.Encoding.UTF8.GetBytes(myJsonData));
//ReportDataSaveAnother<FormulaYear, TZView> m_ReportDataGroup = (ReportDataSaveAnother<FormulaYear, TZView>)m_JsonDs.ReadObject(m_JsonStringMs);
try
{
ReportDataSaveAnother <FormulaYear, TZView> saveAnotherObject = (ReportDataSaveAnother <FormulaYear, TZView>)JsonHelper.JsonToObject(m_GridJson, new ReportDataSaveAnother <FormulaYear, TZView>());
TZ tzValue = saveAnotherObject.TzValue.FirstOrDefault().ConvertToTz();
tzValue.Version = DateTime.Now;
ReportDataHelper dataHelper = new ReportDataHelper();
string result = dataHelper.SaveAnotherFormulaYear(tableName, saveAnotherObject.ChildrenValue, tzValue);
return(result);
}
catch
{
return("-1");
}
}
public static IDictionary<DateTime,DatedDataCollectionGen<double>> Go(TZ tz_, DateTime[] eventTimesLocal, string futureStart_, TimeSpan timeBeforeEvent_, TimeSpan priceFrequency_)
{
var ret = new SortedDictionary<DateTime, DatedDataCollectionGen<double>>();
foreach (var eventTime in eventTimesLocal)
{
var startDate = eventTime - timeBeforeEvent_;
var future = Singleton<IntradayFutures>.Instance.Where(x => x.BbgTicker.StartsWith(futureStart_)
&& x.FirstTrade < startDate.Date
&& x.LastTrade > startDate.Date)
.OrderBy(x => x.LastTrade)
.First();
Logger.Debug(string.Format("{0} => contract = {1}", eventTime.ToString("dd-MMM-yyyy HH:mm"), future.BbgTicker),typeof(Helper));
var pxs = future.GetPrices(tz_, startDate, eventTime+timeBeforeEvent_, priceFrequency_, false);
ret.Add(eventTime, pxs);
}
return ret;
}
public Vector3D GetVector(double t)
{
return(new Vector3D(TX.Transform(t), TY.Transform(t), TZ.Transform(t)));
}
public static DateTime ConvertGmtToLocalTime(TZ tz, DateTime datetimeGmt)
{
DateTime localTime = new DateTime();
switch (tz)
{
case TZ.LN: localTime = ConvertGmtTimeToLondon(datetimeGmt);
break;
case TZ.GMT:
{
// 'local' will be gmt already
}
break;
case TZ.NY: localTime = ConvertGmtTimeToNewYork(datetimeGmt);
break;
case TZ.HK: localTime = ConvertGmtTimeToHongKong(datetimeGmt);
break;
}
return new DateTime(localTime.Year, localTime.Month, localTime.Day, localTime.Hour, localTime.Minute, localTime.Second, DateTimeKind.Local);
}
public static DateTime ConvertLocalTimeToGmt(TZ tz, DateTime datetimeLocal)
{
DateTime utcDateTime = new DateTime();
switch (tz)
{
case TZ.LN: utcDateTime = ConvertLondonTimeToGmt(datetimeLocal);
break;
case TZ.GMT:
{
// 'local' will be gmt already
}
break;
case TZ.NY: utcDateTime = ConvertNewYorkTimeToGmt(datetimeLocal);
break;
case TZ.HK: utcDateTime = ConvertHongKongTimeToGmt(datetimeLocal);
break;
}
return new DateTime(utcDateTime.Year, utcDateTime.Month, utcDateTime.Day, utcDateTime.Hour, utcDateTime.Minute, utcDateTime.Second, DateTimeKind.Utc);
}
/********************************************************************************************/
public void Save(TZ entity)
{
Update<TZ> update = new Update<TZ>("TZ", entity);
update.AddCriterion("KeyID", entity.Id, CriteriaOperator.Equal);
update.AddExcludeField("KeyID");
dataFactory.Save<TZ>(update);
}
/// <summary>
/// Initializes this instance of the <see cref="Vector3DTransform"/> class.
/// </summary>
public void Init(Vector3D v0, Vector3D v1, double t0 = 0, double t1 = 1)
{
TX.Init(t0, t1, v0.X, v1.X);
TY.Init(t0, t1, v0.Y, v1.Y);
TZ.Init(t0, t1, v0.Z, v1.Z);
}
/// <summary>
/// Gets the transformed point.
/// </summary>
public Point3D Transform(Point3D pt)
{
return(new Point3D(TX.Transform(pt.X),
TY.Transform(pt.Y), TZ.Transform(pt.Z)));
}
/// <summary>
/// Initializes this instance of the <see cref="Point3DTransform"/> class.
/// </summary>
public void Init(Point3D p0, Point3D p1, double t0 = 0, double t1 = 1)
{
TX.Init(t0, t1, p0.X, p1.X);
TY.Init(t0, t1, p0.Y, p1.Y);
TZ.Init(t0, t1, p0.Z, p1.Z);
}
public string SaveAnotherFormulaYear(string tableName, IList <FormulaYear> childrenValues, TZ tzValue)
{
Guid newKeyID = Guid.NewGuid();
using (TransactionScope scope = new TransactionScope())
{
foreach (var item in childrenValues)
{
item.KeyID = newKeyID;
Insert <FormulaYear> insert = new Insert <FormulaYear>(tableName, item);
insert.AddExcludeField("Id");
dataFactory.Save <FormulaYear>(insert);
}
tzValue.KeyID = newKeyID;
Insert <TZ> insertTz = new Insert <TZ>("TZ", tzValue);
insertTz.AddExcludeField("Id");
dataFactory.Save <TZ>(insertTz);
scope.Complete();
}
return("1");
}
public void Add(TZ entity)
{
Insert <TZ> insert = new Insert <TZ>("TZ", entity);
dataFactory.Save <TZ>(insert);
}
public virtual DateTime Now()
{
return(TZ.Now(Config.TimeZone));
}
public DateTime[] getInitialEvents(TZ tz_)
{
return m_func(tz_);
}
public void Remove(TZ entity)
{
Delete delete = new Delete("TZ");
delete.AddCriterions("KeyID", entity.Id, CriteriaOperator.Equal);
dataFactory.Remove(delete);
}
/// <summary>
/// Gets the transformed vector.
/// </summary>
public Vector3D Transform(Vector3D v)
{
return(new Vector3D(TX.Transform(v.X),
TY.Transform(v.Y), TZ.Transform(v.Z)));
}
public AllRetriever(DateTime startDate_, DateTime endDate_, TZ tz_)
: base(startDate_, endDate_, tz_)
{
}
/// <summary>
/// Gets the inverse transformed vector.
/// </summary>
public Vector3D BackTransform(Vector3D v)
{
return(new Vector3D(TX.BackTransform(v.X),
TY.BackTransform(v.Y), TZ.BackTransform(v.Z)));
}
/// <summary>
/// Method used to add a property to the instance. Will be placed in the correct class Property.
/// </summary>
/// <param name="input">The vCard.Property to add.</param>
public void AddProperty(Props.IProperty input)
{
if (input == null || input.IsValueNull)
{
return;
}
switch (input.Property)
{
case KnownProperties.ADR:
ADR.AddIfNotNull(input as Props.ADR);
break;
case KnownProperties.ANNIVERSARY:
ANNIVERSARY = input as Props.ANNIVERSARY;
break;
case KnownProperties.BDAY:
BDAY = input as Props.BDAY;
break;
case KnownProperties.CALADRURI:
CALADRURI.AddIfNotNull(input as Props.CALADRURI);
break;
case KnownProperties.CALURI:
CALURI.AddIfNotNull(input as Props.CALURI);
break;
case KnownProperties.CATEGORIES:
CATEGORIES.AddIfNotNull(input as Props.CATEGORIES);
break;
case KnownProperties.CLIENTPIDMAP:
CLIENTPIDMAP.AddIfNotNull(input as Props.CLIENTPIDMAP);
break;
case KnownProperties.EMAIL:
EMAIL.AddIfNotNull(input as Props.EMAIL);
break;
case KnownProperties.FBURL:
FBURL.AddIfNotNull(input as Props.FBURL);
break;
case KnownProperties.FN:
FN.AddIfNotNull(input as Props.FN);
break;
case KnownProperties.GENDER:
GENDER = input as Props.GENDER;
break;
case KnownProperties.GEO:
GEO.AddIfNotNull(input as Props.GEO);
break;
case KnownProperties.IMPP:
IMPP.AddIfNotNull(input as Props.IMPP);
break;
case KnownProperties.KEY:
KEY.AddIfNotNull(input as Props.KEY);
break;
case KnownProperties.KIND: {
char k = (input as Props.KIND).Value.ToLower()[0];
if (k == 'i')
{
KIND = Kinds.Individual;
}
else if (k == 'g')
{
KIND = Kinds.Group;
}
else if (k == 'o')
{
KIND = Kinds.Org;
}
else if (k == 'l')
{
KIND = Kinds.Location;
}
else
{
KIND = Kinds.Individual;
}
break;
}
case KnownProperties.LANG:
LANG.AddIfNotNull(input as Props.LANG);
break;
case KnownProperties.LOGO:
LOGO.AddIfNotNull(input as Props.LOGO);
break;
case KnownProperties.MEMBER:
MEMBER.AddIfNotNull(input as Props.MEMBER);
break;
case KnownProperties.N:
N = input as Props.N;
break;
case KnownProperties.NICKNAME:
NICKNAME.AddIfNotNull(input as Props.NICKNAME);
break;
case KnownProperties.NOTE:
NOTE.AddIfNotNull(input as Props.NOTE);
break;
case KnownProperties.ORG:
ORG.AddIfNotNull(input as Props.ORG);
break;
case KnownProperties.PHOTO:
PHOTO.AddIfNotNull(input as Props.PHOTO);
break;
case KnownProperties.PRODID:
PRODID = input as Props.PRODID;
break;
case KnownProperties.RELATED:
RELATED.AddIfNotNull(input as Props.RELATED);
break;
case KnownProperties.REV:
REV = input as Props.REV;
break;
case KnownProperties.ROLE:
ROLE.AddIfNotNull(input as Props.ROLE);
break;
case KnownProperties.SOUND:
SOUND.AddIfNotNull(input as Props.SOUND);
break;
case KnownProperties.SOURCE:
SOURCE.AddIfNotNull(input as Props.SOURCE);
break;
case KnownProperties.TEL:
TEL.AddIfNotNull(input as Props.TEL);
break;
case KnownProperties.TITLE:
TITLE.AddIfNotNull(input as Props.TITLE);
break;
case KnownProperties.TZ:
TZ.AddIfNotNull(input as Props.TZ);
break;
case KnownProperties.UID:
UID = input as Props.UID;
break;
case KnownProperties.URL:
URL.AddIfNotNull(input as Props.URL);
break;
case KnownProperties.VERSION:
VERSION = input as Props.VERSION;
break;
case KnownProperties.XML:
XML.AddIfNotNull(input as Props.XML);
break;
default:
return;
}
}
public Point3D GetPoint(double t)
{
return(new Point3D(TX.Transform(t), TY.Transform(t), TZ.Transform(t)));
}
protected virtual async Task<DateTime[]> getEventInner(TZ tz_, CarbonClient cc_)
{
if (_cache.ContainsKey(tz_))
return _cache[tz_];
if (!_cache.ContainsKey(TZ.GMT))
{
var gmtDates = await GetGmtDatesFromCarbon(cc_);
if (gmtDates == null)
{
Logger.Error(string.Format("Could not retrieve event dates for [{0}] from carbon", EventCode),
typeof (EventDef));
return null;
}
}
if (HasTimeElement == false)
return _cache[TZ.GMT];
switch (tz_)
{
case TZ.LN:
_cache[tz_] = _cache[TZ.GMT].Select(TimeZoneHelper.ConvertGmtTimeToLondon).ToArray();
break;
case TZ.NY:
_cache[tz_] = _cache[TZ.GMT].Select(TimeZoneHelper.ConvertGmtTimeToNewYork).ToArray();
break;
case TZ.HK:
_cache[tz_] = _cache[TZ.GMT].Select(TimeZoneHelper.ConvertGmtTimeToHongKong).ToArray();
break;
}
if (!_cache.ContainsKey(tz_))
{
Logger.Error(string.Format("Could not get event dates for event:[{0}]", EventCode), typeof (EventDef));
return null;
}
return _cache[tz_];
//string tableName = null;
//var list = new List<DateTime>();
//switch (tz_)
//{
// case TZ.LN: tableName = "eventTimesLN"; break;
// case TZ.NY: tableName = "eventTimesNY"; break;
// case TZ.HK: tableName = "eventTimesHK"; break;
// case TZ.GMT: tableName = "eventTimesGMT"; break;
//}
//var sql = string.Format("select eventTimeLocal from {1} where eventID={0} order by eventTimeGMT", EventID.ToString(), tableName);
//try
//{
// var ds = Singleton<SI.DB.ConnMngr>.Instance.Execute(SI.DB.DBNames.SQLSERVER_FUTURES, sql);
// if (SI.DB.ConnMngr.HasResult(ds))
// {
// foreach (DataRow row in ds.Tables[0].Rows)
// list.Add(Convert.ToDateTime(row[0]));
// }
// _cache[tz_] = list.ToArray();
//}
//catch (Exception ex_)
//{
// this.LogError(string.Format("Error getting events from database.", ex_));
//}
//return list.ToArray();
}
/// <summary>
/// Gets the inverse transformed point.
/// </summary>
public Point3D BackTransform(Point3D pt)
{
return(new Point3D(TX.BackTransform(pt.X),
TY.BackTransform(pt.Y), TZ.BackTransform(pt.Z)));
}
public IEnumerable<TZ> FindBy(Query query)
{
IList<TZ> result = new List<TZ>();
DataTable table = dataFactory.Query(query);
foreach (DataRow row in table.Rows)
{
TZ tz = new TZ();
tz.KeyID = (Guid)row["KeyID"];
tz.ProductLineID = int.Parse(row["ProductLineID"].ToString().Trim());
tz.ReportID = int.Parse(row["ReportID"].ToString().Trim());
tz.TableName = row["TableName"].ToString().Trim();
tz.Date = row["Date"].ToString().Trim();
tz.CreationDate = (DateTime)row["CreationDate"];
tz.ModifierID = row["ModifierID"].ToString().Trim();
if (row["Version"].ToString().Trim() != "")
{
tz.Version = (DateTime)row["Version"];
}
tz.ModifiedFlag = (bool)row["ModifiedFlag"];
tz.Remarks = row["Remarks"].ToString().Trim();
//result.Add(new TZ
//{
// KeyID = (Guid)row["KeyID"],
// ProductLineID = int.Parse(row["ProductLineID"].ToString().Trim()),
// ReportID = int.Parse(row["ReportID"].ToString().Trim()),
// Date = row["Date"].ToString().Trim(),
// CreationDate = (DateTime)row["CreationDate"],
// ModifierID = row["ModifierID"].ToString().Trim(),
// Version = (DateTime)row["Version"],
// ModifiedFlag = (bool)row["ModifiedFlag"],
// Remarks = row["Remarks"].ToString().Trim()
//});
result.Add(tz);
}
return result;
}
public static RetrieverBase GetRetriever(TZ tz_, DataFrequencyType freqType_, DateTime startDate_, DateTime endDate_)
{
RetrieverBase ret = null;
switch (freqType_)
{
case DataFrequencyType.D:
ret = new DailyRetriever(startDate_, endDate_, tz_);
break;
case DataFrequencyType.H:
case DataFrequencyType.M:
ret = new AllRetriever(startDate_, endDate_, tz_);
break;
}
return ret;
}
public void Add(TZ entity)
{
Insert<TZ> insert = new Insert<TZ>("TZ", entity);
dataFactory.Save<TZ>(insert);
}
public SetOverrideTimeMenuItem(DateAdjustmentModel model_, string text_, TZ zone_, string time_)
{
Text = text_;
m_zone = zone_;
m_model = model_;
m_time = time_;
}
public RetrieverBase(DateTime startDate_, DateTime endDate_, TZ tz_)
{
m_startDate = startDate_;
m_endDate = endDate_;
m_timezone = tz_;
}
protected override async Task<DateTime[]> getEventInner(TZ tz_, CarbonClient cc_)
{
if (m_func == null) return null;
return m_func(tz_);
}
public static DateTime ConvertToGmtTime(TZ sourceTimeZone_, DateTime date_)
{
var offset = GetTimezone(sourceTimeZone_).GetUtcOffset(date_.Date);
return date_.Add(-offset);
}
