private void generateEmaCsv(List <FurtherIssueModel> fList)
{
string emaFileDir = getEmaFileDir(fList);
//need to confirm
string csvFileName = string.Format("{0}\\WRT_QUA_{1}_Korea.csv", emaFileDir, DateTime.Today.ToString("ddMMMyyyy", new CultureInfo("en-US")));
List <List <string> > csvResList = new List <List <string> >();
List <string> head = new List <string>();
int line = 0;
head.Add("Logical_Key");
head.Add("Secondary_ID");
head.Add("Secondary_ID_Type");
head.Add("EH_Issue_Quantity");
head.Add("Issue_Quantity");
csvResList.Add(head);
if (File.Exists(csvFileName))
{
line = ReadLogic(csvFileName);
}
csvResList.AddRange(fList.Select((t, i) => new List <string>
{
(i + 1 + line).ToString(), t.Old_Isin, "ISIN", "N", t.New_Quanity
}));
if (File.Exists(csvFileName))
{
csvResList.RemoveAt(0);//remove head
OperateExcel.WriteToCSV(csvFileName, csvResList, FileMode.Append);
}
else
{
OperateExcel.WriteToCSV(csvFileName, csvResList, FileMode.Create);
}
TaskResultList.Add(new TaskResultEntry(Path.GetFileNameWithoutExtension(csvFileName), "", csvFileName, FileProcessType.Other));
}
private void generateEmaCsv(List <FurtherIssueModel> fList)
{
string emaFileDir = getEmaFileDir(fList);
//need to confirm
string csvFileName = string.Format("{0}\\WRT_QUA_{1}_Korea.csv", emaFileDir, DateTime.Today.ToString("ddMMMyyyy", new CultureInfo("en-US")));
List <List <string> > csvResList = new List <List <string> >();
List <string> head = new List <string>();
int line = 0;
head.Add("Logical_Key");
head.Add("Secondary_ID");
head.Add("Secondary_ID_Type");
head.Add("EH_Issue_Quantity");
head.Add("Issue_Quantity");
csvResList.Add(head);
if (File.Exists(csvFileName))
{
line = readLogic(csvFileName);
}
for (int i = 0; i < fList.Count; i++)
{
List <string> term = new List <string>();
term.Add((i + 1 + line).ToString());
term.Add(fList[i].Old_Isin);
term.Add("ISIN");
term.Add("N");
term.Add(fList[i].New_Quanity);
csvResList.Add(term);
}
if (File.Exists(csvFileName))
{
csvResList.RemoveAt(0);//remove head
OperateExcel.WriteToCSV(csvFileName, csvResList, FileMode.Append);
}
else
{
OperateExcel.WriteToCSV(csvFileName, csvResList, FileMode.Create);
}
AddResult(Path.GetFileNameWithoutExtension(csvFileName), csvFileName, "");
}
