private static void CreateRequestFile() { try { String strRawRequest = File.ReadAllText(rowRequestFilePath); String[] strStockRequestInfos = strRawRequest.Split(';'); StockRequestInfos o_StockRequestInfos = new StockRequestInfos(); o_StockRequestInfos.ListOfStockRequests = new List <StockRequestInfo>(); foreach (String strTempRequest in strStockRequestInfos) { if (!String.IsNullOrEmpty(strTempRequest)) { String[] t = strTempRequest.Split(' '); StockRequestInfo obj = new StockRequestInfo(); obj.Ticker = t[0].Trim(); obj.URL = t[1].Trim(); o_StockRequestInfos.ListOfStockRequests.Add(obj); } } if (o_StockRequestInfos.ListOfStockRequests != null && o_StockRequestInfos.ListOfStockRequests.Count > 0) { o_StockRequestInfos.ListOfStockRequests = o_StockRequestInfos.ListOfStockRequests.OrderBy(x => x.Ticker).ToList(); SerializationHelper.WriteXML <StockRequestInfos>(o_StockRequestInfos, requestFilePath); } else { ApplicationLog.Instance.WriteError("List of request is not created. please check raw file"); } } catch (Exception ex) { ApplicationLog.Instance.WriteException(ex); } }
void Main() { if (!File.Exists(requestFilePath)) { CreateRequestFile(); } StockRequestInfos stockInfosFromFile = SerializationHelper.LoadXML <StockRequestInfos>(requestFilePath); if (stockInfosFromFile != null) { List <StockRequestInfo> listOfStockInfos = stockInfosFromFile.ListOfStockRequests; foreach (StockRequestInfo stockRequestInfo in listOfStockInfos) { MarketValueInfo marketValue = GetTickerInfo(stockRequestInfo); if (marketValue != null) { CreateExcel(marketValue); if (!UpdateExcel(marketValue)) { ApplicationLog.Instance.WriteError(String.Format("Excel update failed for {0}", stockRequestInfo.Ticker)); } Console.WriteLine(String.Format("Symbole done {0}", marketValue.SYMBOL)); } } } else { ApplicationLog.Instance.WriteError("Request file not in correct format."); } }