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