private void GenerateOutputFile(Dictionary <string, List <string> > dicList, string path)
{
try
{
if (File.Exists(path))
{
File.Delete(path);
}
if (path.EndsWith(".csv"))
{
XlsOrCsvUtil.GenerateStringCsv(path, dicList);
}
else
{
XlsOrCsvUtil.GenerateXls0rCsv(path, dicList);
}
AddResult("ReportDiff", path, configObj.OutputFileType.ToString());
}
catch (Exception ex)
{
string msg = string.Format("\r\n ClassName: {0}\r\n MethodName: {1}\r\n Message: {2}",
System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name,
ex.Message);
Logger.Log(msg, Logger.LogType.Error);
}
}
private void generateXls(List <Dictionary <string, string> > propsCw, string path)
{
var dicList = new Dictionary <string, List <string> >();
var listTile = new List <string>()
{
"Effective Date",
"SYMBOL",
"DSPLY_NAME",
"RIC",
"OFFCL_CODE",
"EX_SYMBOL",
"BCKGRNDPAG",
"BCAST_REF",
"#INSTMOD_EXPIR_DATE",
"#INSTMOD_LONGLINK1",
"#INSTMOD_LONGLINK2",
"#INSTMOD_MATUR_DATE",
"#INSTMOD_OFFC_CODE2",
"#INSTMOD_STRIKE_PRC",
"#INSTMOD_WNT_RATIO",
"#INSTMOD_MNEMONIC",
"#INSTMOD_TDN_SYMBOL",
"#INSTMOD_LONGLINK3",
"EXL_NAME",
"Old Chain",
"New BCU",
"NDA Common Name",
"Primary Listing",
"Organisation Name DIRNAME",
"Issue Date",
"First Exercise Date",
"Last Exercise Date",
"Outstanding Warrant Quantity",
"Exercise Period"
};
dicList.Add("title", listTile);
//foreach (var dic in propsCw)
for (int index = 0; index < propsCw.Count; index++)
{
List <string> listBody = propsCw[index].Values.ToList();
dicList.Add(index.ToString(), listBody);
}
if (dicList == null || dicList.Count <= 1)
{
return;
}
XlsOrCsvUtil.GenerateXls0rCsv(path, dicList);
}
private void GenerateOutputFile(Dictionary <string, List <string> > dicList, string path)
{
try
{
try
{
if (File.Exists(path))
{
File.Delete(path);
}
}
catch (Exception ex)
{
Logger.Log(string.Format("delete alerday exist file: {0} error.msg:{1}", path, ex.Message), Logger.LogType.Error);
}
if (path.ToLower().EndsWith(".xls") || path.ToLower().EndsWith(".xlsx"))
{
XlsOrCsvUtil.GenerateXls0rCsv(path, dicList);
}
else if (path.ToLower().EndsWith(".csv"))
{
XlsOrCsvUtil.GenerateStringCsv(path, dicList);
}
else
{
MessageBox.Show("Output path must be end with .xls(x) or .csv");
}
}
catch (Exception ex)
{
string msg = string.Format("\r\n ClassName: {0}\r\n MethodName: {1}\r\n Message: {2}",
System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name,
ex.Message);
Logger.Log(msg, Logger.LogType.Error);
}
}
protected override void Start()
{
try
{
int i = 1;
var propsPc = new List <Dictionary <string, string> >();
foreach (Dictionary <string, string> infos in GetPages().Select(page => CleanInfos(GetInfos(page)))
.Where(infos => infos != null)
.Where(infos => infos["subject"] == "Adjustment"))
{
propsPc.Add(infos);
i++;
}
if (i > 1)
{
string path = string.Format("{0}Price_Change_{1}.xlsx", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM"));
List <string> title = new List <string>()
{
"RIC", "Symbol", "ISIN", "OLD_RATIO", "#INSTMOD_WNT_RATIO", "OLD_PRC", "#INSTMOD_STRIKE_PRC"
};
List <List <string> > bulkFile = new List <List <string> >();
bulkFile.Add(title);
FillInBulkFile(bulkFile, propsPc);
XlsOrCsvUtil.GenerateXls0rCsv(path, bulkFile);
AddResult(Path.GetFileNameWithoutExtension(path), path, "");
//var ndaDw1 = new Nda(FileMode.WriteOnly);
//ndaDw1.LoadFromTemplate(TemplateFm.ThPriceChange, propsPc);
//ndaDw1.Save(String.Format("{0}Price_Change_{1}.xlsx", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
//AddResult("Price change Nda bulk file", ndaDw1.Path, "nda");
}
}
catch (Exception ex)
{
throw new Exception("Task failed, error: " + ex.Message, ex);
}
}
