public string GetNote() { string s = ""; if (Type == NoticeType.UploadDone) { s = string.Format("{0}: {1}", FullPath, Note); } if (Type == NoticeType.AddFileDone) { s = string.Format("{0}: {1} files added.", FullPath, JobDone); } if (Type == NoticeType.UploadException || Type == NoticeType.Exception) { s = string.Format("{0}: {1}", FullPath, Note); } if (Type == NoticeType.Upload) { s = string.Format("{0}: {1} {2}/{3} - {4}%", FullPath, Note, JobDone, JobTotal, Percentage); } if (Type == NoticeType.AddFile) { s = string.Format("{0}: {1} files", FullPath, JobDone); } if (Type == NoticeType.DownloadDone) { s = string.Format("{0}: {1}", FullPath, Note); } s = Datetime.ToString() + " " + s; return(s); }
public new string ToString() { var datetime = Datetime.ToString("yyyy-MM-dd HH:mm:ss.fff"); return $"{datetime} {Type,-12}{Text}"; }
public string Ident(bool utc) { return(StarSystem + ":" + StationName + " on " + ((utc) ? Datetime.ToString() : Datetime.ToLocalTime().ToString())); }
/// <summary> /// Get Message to string /// </summary> /// <returns></returns> public new string ToString() { return(string.Format("{0}\t {1}\n", Datetime.ToString(CultureInfo.InvariantCulture), Text)); }
/// <summary> /// Get Message to string /// </summary> /// <returns></returns> public new string ToString() { return(Datetime.ToString(CultureInfo.InvariantCulture) + "\t" + Text + "\n"); }
private static void handleResponseEvent(Event eventObj, List <SecurityModel> securities, ILogger log) { StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Prices] "); sb.Append("(security_id, ask, bid, px_last, date_time) VALUES"); log.LogInformation("EventType =" + eventObj.Type); foreach (Message message in eventObj.GetMessages()) { log.LogInformation("correlationID=" + message.CorrelationID); log.LogInformation("messageType =" + message.MessageType); Element elmSecurityDataArray = message["securityData"]; for (int valueIndex = 0; valueIndex < elmSecurityDataArray.NumValues; valueIndex++) { Element elmSecurityData = elmSecurityDataArray.GetValueAsElement(valueIndex); string security = elmSecurityData.GetElementAsString("security"); log.LogInformation("about to log security"); log.LogInformation(security); bool hasFieldErrors = elmSecurityData.HasElement("fieldExceptions", true); if (hasFieldErrors) { Element elmFieldErrors = elmSecurityData["fieldExceptions"]; for (int errorIndex = 0; errorIndex < elmFieldErrors.NumValues; errorIndex++) { Element fieldError = elmFieldErrors.GetValueAsElement(errorIndex); string fieldId = fieldError.GetElementAsString("fieldId"); Element errorInfo = fieldError["errorInfo"]; string source = errorInfo.GetElementAsString("source"); int code = errorInfo.GetElementAsInt32("code"); string category = errorInfo.GetElementAsString("category"); string strMessage = errorInfo.GetElementAsString("message"); string subCategory = errorInfo.GetElementAsString("subcategory"); log.LogInformation("\tfield error: " + security); log.LogInformation(string.Format("\tfieldId = {0}", fieldId)); log.LogInformation(string.Format("\tsource = {0}", source)); log.LogInformation(string.Format("\tcode = {0}", code)); log.LogInformation(string.Format("\tcategory = {0}", category)); log.LogInformation(string.Format("\terrorMessage = {0}", strMessage)); log.LogInformation(string.Format("\tsubCategory = {0}", subCategory)); } } bool isSecurityError = elmSecurityData.HasElement("securityError", true); if (isSecurityError) { Element secError = elmSecurityData["securityError"]; string source = secError.GetElementAsString("source"); int code = secError.GetElementAsInt32("code"); string category = secError.GetElementAsString("category"); string errorMessage = secError.GetElementAsString("message"); string subCategory = secError.GetElementAsString("subcategory"); log.LogInformation("\tsecurity error"); log.LogInformation(string.Format("\tsource = {0}", source)); log.LogInformation(string.Format("\tcode = {0}", code)); log.LogInformation(string.Format("\tcategory = {0}", category)); log.LogInformation(string.Format("\terrorMessage = {0}", errorMessage)); log.LogInformation(string.Format("\tsubCategory = {0}", subCategory)); } else { Element elmFieldData = elmSecurityData["fieldData"]; double pxLast = elmFieldData.GetElementAsFloat64("PX_LAST"); double bid = elmFieldData.GetElementAsFloat64("BID"); double ask = elmFieldData.GetElementAsFloat64("ASK"); string ticker = elmFieldData.GetElementAsString("TICKER"); log.LogInformation("\tPX_LAST = " + pxLast.ToString()); log.LogInformation("\tBID = " + bid.ToString()); log.LogInformation("\tASK = " + ask.ToString()); if (elmFieldData.HasElement("TRADEABLE_DT", true)) { Datetime trDate = elmFieldData.GetElementAsDatetime("TRADEABLE_DT"); DateTime trDateSystem = elmFieldData.GetElementAsDatetime("TRADEABLE_DT").ToSystemDateTime(); //convenient conversion to C# DateTime object log.LogInformation("\tTRADEABLE_DT = " + trDate.ToString()); } SecurityModel bloombergSecurity = securities.Find(s => s.Name == security); log.LogInformation("bloomberg security id"); log.LogInformation(bloombergSecurity.Id.ToString()); if (bloombergSecurity.Id > 0) { var dbDateTime = DateTime.Now; sb.Append(" (" + bloombergSecurity.Id.ToString() + ", " + ask.ToString() + ", " + bid.ToString() + ", " + pxLast.ToString() + ", '" + dbDateTime.ToString() + "')"); if (valueIndex == elmSecurityDataArray.NumValues - 1) { sb.Append(";"); } else { sb.Append(","); } } //TRADEABLE_DT bool excludeNullElements = true; if (elmFieldData.HasElement("CHAIN_TICKERS", excludeNullElements)) //be careful, the excludeNullElements argument is false by default { Element chainTickers = elmFieldData["CHAIN_TICKERS"]; for (int chainTickerValueIndex = 0; chainTickerValueIndex < chainTickers.NumValues; chainTickerValueIndex++) { Element chainTicker = chainTickers.GetValueAsElement(chainTickerValueIndex); string strChainTicker = chainTicker.GetElementAsString("Ticker"); log.LogInformation("\tCHAIN_TICKER = " + strChainTicker.ToString()); } } else { log.LogInformation("\tNo CHAIN_TICKER information"); } } } } var str = Environment.GetEnvironmentVariable("bloombergsql"); String sql = sb.ToString(); log.LogInformation("here is my sql query string"); log.LogInformation(sql); using (SqlConnection conn = new SqlConnection(str)) { conn.Open(); SqlCommand command = new SqlCommand(sql, conn); command.ExecuteNonQuery(); log.LogInformation("all done"); } }
private static void handleResponseEvent(Event eventObj) { Console.WriteLine(); Console.WriteLine(); Console.WriteLine("EventType =" + eventObj.Type); foreach (Message message in eventObj.GetMessages()) { Console.WriteLine(); Console.WriteLine(); Console.WriteLine("correlationID=" + message.CorrelationID); Console.WriteLine("messageType =" + message.MessageType); Element elmSecurityDataArray = message["securityData"]; for (int valueIndex = 0; valueIndex < elmSecurityDataArray.NumValues; valueIndex++) { Element elmSecurityData = elmSecurityDataArray.GetValueAsElement(valueIndex); string security = elmSecurityData.GetElementAsString("security"); Console.WriteLine(security); bool hasFieldErrors = elmSecurityData.HasElement("fieldExceptions", true); if (hasFieldErrors) { Element elmFieldErrors = elmSecurityData["fieldExceptions"]; for (int errorIndex = 0; errorIndex < elmFieldErrors.NumValues; errorIndex++) { Element fieldError = elmFieldErrors.GetValueAsElement(errorIndex); string fieldId = fieldError.GetElementAsString("fieldId"); Element errorInfo = fieldError["errorInfo"]; string source = errorInfo.GetElementAsString("source"); int code = errorInfo.GetElementAsInt32("code"); string category = errorInfo.GetElementAsString("category"); string strMessage = errorInfo.GetElementAsString("message"); string subCategory = errorInfo.GetElementAsString("subcategory"); Console.Error.WriteLine(); Console.Error.WriteLine(); Console.Error.WriteLine("\tfield error: " + security); Console.Error.WriteLine(string.Format("\tfieldId = {0}", fieldId)); Console.Error.WriteLine(string.Format("\tsource = {0}", source)); Console.Error.WriteLine(string.Format("\tcode = {0}", code)); Console.Error.WriteLine(string.Format("\tcategory = {0}", category)); Console.Error.WriteLine(string.Format("\terrorMessage = {0}", strMessage)); Console.Error.WriteLine(string.Format("\tsubCategory = {0}", subCategory)); } } bool isSecurityError = elmSecurityData.HasElement("securityError", true); if (isSecurityError) { Element secError = elmSecurityData["securityError"]; string source = secError.GetElementAsString("source"); int code = secError.GetElementAsInt32("code"); string category = secError.GetElementAsString("category"); string errorMessage = secError.GetElementAsString("message"); string subCategory = secError.GetElementAsString("subcategory"); Console.Error.WriteLine(); Console.Error.WriteLine(); Console.Error.WriteLine("\tsecurity error"); Console.Error.WriteLine(string.Format("\tsource = {0}", source)); Console.Error.WriteLine(string.Format("\tcode = {0}", code)); Console.Error.WriteLine(string.Format("\tcategory = {0}", category)); Console.Error.WriteLine(string.Format("\terrorMessage = {0}", errorMessage)); Console.Error.WriteLine(string.Format("\tsubCategory = {0}", subCategory)); } else { Element elmFieldData = elmSecurityData["fieldData"]; double pxLast = elmFieldData.GetElementAsFloat64("PX_LAST"); double bid = elmFieldData.GetElementAsFloat64("BID"); double ask = elmFieldData.GetElementAsFloat64("ASK"); string ticker = elmFieldData.GetElementAsString("TICKER"); Console.WriteLine(); Console.WriteLine(); Console.WriteLine("\tPX_LAST = " + pxLast.ToString()); Console.WriteLine("\tBID = " + bid.ToString()); Console.WriteLine("\tASK = " + ask.ToString()); Console.WriteLine("\tTICKER = " + ticker.ToString()); if (elmFieldData.HasElement("TRADEABLE_DT", true)) { Datetime trDate = elmFieldData.GetElementAsDatetime("TRADEABLE_DT"); DateTime trDateSystem = elmFieldData.GetElementAsDatetime("TRADEABLE_DT").ToSystemDateTime(); //convenient conversion to C# DateTime object Console.WriteLine("\tTRADEABLE_DT = " + trDate.ToString()); } //TRADEABLE_DT bool excludeNullElements = true; if (elmFieldData.HasElement("CHAIN_TICKERS", excludeNullElements)) //be careful, the excludeNullElements argument is false by default { Element chainTickers = elmFieldData["CHAIN_TICKERS"]; for (int chainTickerValueIndex = 0; chainTickerValueIndex < chainTickers.NumValues; chainTickerValueIndex++) { Element chainTicker = chainTickers.GetValueAsElement(chainTickerValueIndex); string strChainTicker = chainTicker.GetElementAsString("Ticker"); Console.WriteLine("\tCHAIN_TICKER = " + strChainTicker.ToString()); } } else { Console.WriteLine("\tNo CHAIN_TICKER information"); } } } } }