toPI post test | C# Online Compiler

toPI post test by Aurelien Suiz

using System;
using System.IO;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
using Microsoft.VisualBasic.FileIO;

namespace CMCIC_CSV_to_PI
{
	class Program
	{
		static void Main(string[] args)
		{
			string stratBond = null;
			string isinBond = null;
			string isinBond2 = null;
			if (args.Length != 2)
			{
				Console.WriteLine("Must supply input & output file");
				System.Environment.Exit(-1);
			}

			try
			{
				using (var output = new StreamWriter(args[1]))
				{
					using (var input = new TextFieldParser(args[0]))
					{
						input.SetDelimiters(",");
						input.HasFieldsEnclosedInQuotes = true;
						output.WriteLine("Type,Name,ISIN,Strat,Amount");
						Row eqsRow = new Row();
						while (!input.EndOfData)
						{
							Row row = new Row(input);
							if (stratBond != row.Strat)
							{
								stratBond = row.Strat;
								isinBond = "";
								isinBond2 = "";
								if (row.Type == "ConvertibleBond")
								{
									isinBond = row.Isin;
								}
							}
							else
							{
								if (row.Name.StartsWith("BON") && row.Type == "ConvertibleBond")
								{
									isinBond2 = row.Isin;
								}
							}

							if (row.Name.StartsWith("IndexSwap"))
							{
								if (isinBond2 == "" && isinBond!="")
									row.isin = isinBond;
								else if (isinBond2 != "" && isinBond !="")
									{
									if (row.Name.Substring(row.Name.Length - 2) == isinBond.Substring(isinBond.Length - 2))
										row.isin = isinBond;
									else if (row.Name.Substring(row.Name.Length - 2) == isinBond2.Substring(isinBond2.Length - 2))
										row.isin = isinBond2;
									}
							}

							if (row.Type == "IRSwap")
							{
								List<string> tableau = new List<string>();
								while (row.Type == "IRSwap")
								{
									tableau.Add(row.Type);
									tableau.Add(row.Name);
									tableau.Add(row.Isin);
									tableau.Add(row.Strat);
									tableau.Add(row.Amount.ToString());
									string[] split = row.Isin.Split('/');
									tableau.Add(split[0]);
									tableau.Add(split[1]);
									Row row1 = new Row(input);
									row = row1;
								}

								for (int i = 5; i < tableau.Count - 1; i += 7)
								{
									for (int k = 7; k < tableau.Count - i; k += 7)
									{
										if (tableau[i] == tableau[i + k + 1] && tableau[i+1] == tableau[i+k])
										{
											double Montant = Convert.ToDouble(tableau[i - 1]);
											Montant += Double.Parse(tableau[i + k - 1]);
											tableau[i - 1] = Montant.ToString();
											tableau.RemoveRange(i + k - 5, 7);
										}
									}
								}

								eqsRow.writeRow(output);
								for (int i = 0; i < tableau.Count - 5; i += 7)
								{
									output.WriteLine("{0},{1},{2},{3},{4}", tableau[i], tableau[i + 1], tableau[i + 2], tableau[i + 3], tableau[i + 4]);
								}
							}

							if (row.Type == "EquitySwap")
							{
								if (!eqsRow.combineAmounts(row))
								{
									eqsRow.writeRow(output);
									eqsRow = row;
								}
							}
							else
							{
								eqsRow.writeRow(output);
								row.writeRow(output);
							}
						}

						eqsRow.writeRow(output);
					}
				}
			}
			catch (Exception e)
			{
				Console.WriteLine("Failed " + e);
				System.Environment.Exit(-1);
			}
		}

		private class Row
		{
			private string type;
			private string strat;
			private string name;
			public string isin;
			private double amount;
			public string Type
			{
				get
				{
					return type;
				}
			}

			public string Strat
			{
				get
				{
					return strat;
				}
			}

			public string Name
			{
				get
				{
					return name;
				}
			}

			public string Isin
			{
				get
				{
					return isin;
				}
			}

			public double Amount
			{
				get
				{
					return amount;
				}
			}

			public Row()
			{
			}

			public Row(TextFieldParser input)
			{
				var fields = input.ReadFields();
				name = fields[3];
				type = getType(fields[3]);
				if (type != null)
				{
					strat = fields[0];
					isin = fields[4];
					if (type == "IRSwap")
					{
						if (fields[2] == "P")
							amount = Double.Parse(fields[8]);
						else if (fields[2] == "E")
							amount = -Double.Parse(fields[8]);
						else
							throw new ApplicationException("Unknown Sens flag " + fields[2] + " for " + name);
					}
					else
					{
						amount = Double.Parse(fields[8]);
					}

					if (type == "IRSwap")
					{
						isin = fields[5];
					}
					else if (type == "BondFutures" || type == "IRFutures")
					{
						StringBuilder sbFut = new StringBuilder(fields[3]);
						sbFut.Replace(" ", null);
						string sbFutString = sbFut.ToString();
						isin = sbFutString;
					}
				}
			}

			static private Regex matchAssetSwap = new Regex("^BON.*BO[0-9]+$");
			private static string getType(string name)
			{
				if (name.StartsWith("BON"))
				{
					if (false && matchAssetSwap.IsMatch(name))
						return "AssetSwap";
					else
						return "ConvertibleBond";
				}

				if (name.StartsWith("FUT FUTURE TNOTE") || name.StartsWith("FUT FUTURE EURO") || name.StartsWith("FUT FUTURE GILT") || name.StartsWith("FUT FUTURE SWISS 10Y"))
					return "BondFutures";
				if (name.StartsWith("FUT FUTURE") && name.Contains("3M"))
					return "IRFutures";
				if (name.StartsWith("FUT FUTURE"))
					return "IndexFutures";
				if (name.StartsWith("Swap"))
					return "IRSwap";
				if (name.StartsWith("EQU") || name.StartsWith("PTFSWAP"))
					return "Equity";
				if (name.StartsWith("EQS"))
					return "EquitySwap";
				if (name.StartsWith("IndexSwap"))
					return "ConvertibleBond";
				return null;
			}

			public bool combineAmounts(Row r)
			{
				if (type == r.type && strat == r.strat && isin == r.isin)
				{
					amount += r.amount;
					return true;
				}
				else
				{
					return false;
				}
			}

			//Type,Name,ISIN,Strat,Amount
			public void writeRow(StreamWriter output)
			{
				if (type != null)
				{
					output.WriteLine("{0},{1},{2},{3},{4}", type, name, isin, strat, amount);
					type = null;
				}
			}
		}
	}
}

​x
 
using System;
using System.IO;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
using Microsoft.VisualBasic.FileIO;
​
namespace CMCIC_CSV_to_PI
{
    class Program
    {
        static void Main(string[] args)
        {
            string stratBond = null;
            string isinBond = null;
            string isinBond2 = null;
            if (args.Length != 2)
            {
                Console.WriteLine("Must supply input & output file");
                System.Environment.Exit(-1);
            }
​
            try
            {
                using (var output = new StreamWriter(args[1]))
                {
                    using (var input = new TextFieldParser(args[0]))
                    {
                        input.SetDelimiters(",");
                        input.HasFieldsEnclosedInQuotes = true;
                        output.WriteLine("Type,Name,ISIN,Strat,Amount");
                        Row eqsRow = new Row();
                        while (!input.EndOfData)
                        {
                            Row row = new Row(input);
                            if (stratBond != row.Strat)
                            {
                                stratBond = row.Strat;
                                isinBond = "";
                                isinBond2 = "";
                                if (row.Type == "ConvertibleBond")
                                {
                                    isinBond = row.Isin;
                                }
                            }
                            else
                            {
                                if (row.Name.StartsWith("BON") && row.Type == "ConvertibleBond")
                                {
                                    isinBond2 = row.Isin;
                                }
                            }
​
                            if (row.Name.StartsWith("IndexSwap"))
                            {
                                if (isinBond2 == "" && isinBond!="")
                                    row.isin = isinBond;
                                else if (isinBond2 != "" && isinBond !="")
                                    {
                                    if (row.Name.Substring(row.Name.Length - 2) == isinBond.Substring(isinBond.Length - 2))
                                        row.isin = isinBond;
                                    else if (row.Name.Substring(row.Name.Length - 2) == isinBond2.Substring(isinBond2.Length - 2))
                                        row.isin = isinBond2;
                                    }
                            }
​
                            if (row.Type == "IRSwap")
                            {
                                List<string> tableau = new List<string>();
                                while (row.Type == "IRSwap")
                                {
                                    tableau.Add(row.Type);
                                    tableau.Add(row.Name);
                                    tableau.Add(row.Isin);
                                    tableau.Add(row.Strat);
                                    tableau.Add(row.Amount.ToString());
                                    string[] split = row.Isin.Split('/');
                                    tableau.Add(split[0]);
                                    tableau.Add(split[1]);
                                    Row row1 = new Row(input);
                                    row = row1;
                                }
​
                                for (int i = 5; i < tableau.Count - 1; i += 7)
                                {
                                    for (int k = 7; k < tableau.Count - i; k += 7)
                                    {
                                        if (tableau[i] == tableau[i + k + 1] && tableau[i+1] == tableau[i+k])
                                        {
                                            double Montant = Convert.ToDouble(tableau[i - 1]);
                                            Montant += Double.Parse(tableau[i + k - 1]);
                                            tableau[i - 1] = Montant.ToString();
                                            tableau.RemoveRange(i + k - 5, 7);
                                        }
                                    }
                                }
​
                                eqsRow.writeRow(output);
                                for (int i = 0; i < tableau.Count - 5; i += 7)
                                {
                                    output.WriteLine("{0},{1},{2},{3},{4}", tableau[i], tableau[i + 1], tableau[i + 2], tableau[i + 3], tableau[i + 4]);
                                }
                            }
​
                            if (row.Type == "EquitySwap")
                            {
                                if (!eqsRow.combineAmounts(row))
                                {
                                    eqsRow.writeRow(output);
                                    eqsRow = row;
                                }
                            }
                            else
                            {
                                eqsRow.writeRow(output);
                                row.writeRow(output);
                            }
                        }
​
                        eqsRow.writeRow(output);
                    }
                }
            }
            catch (Exception e)
            {
                Console.WriteLine("Failed " + e);
                System.Environment.Exit(-1);
            }
        }
​
        private class Row
        {
            private string type;
            private string strat;
            private string name;
            public string isin;
            private double amount;
            public string Type
            {
                get
                {
                    return type;
                }
            }
​
            public string Strat
            {
                get
                {
                    return strat;
                }
            }
​
            public string Name
            {
                get
                {
                    return name;
                }
            }
​
            public string Isin
            {
                get
                {
                    return isin;
                }
            }
​
            public double Amount
            {
                get
                {
                    return amount;
                }
            }
​
            public Row()
            {
            }
​
            public Row(TextFieldParser input)
            {
                var fields = input.ReadFields();
                name = fields[3];
                type = getType(fields[3]);
                if (type != null)
                {
                    strat = fields[0];
                    isin = fields[4];
                    if (type == "IRSwap")
                    {
                        if (fields[2] == "P")
                            amount = Double.Parse(fields[8]);
                        else if (fields[2] == "E")
                            amount = -Double.Parse(fields[8]);
                        else
                            throw new ApplicationException("Unknown Sens flag " + fields[2] + " for " + name);
                    }
                    else
                    {
                        amount = Double.Parse(fields[8]);
                    }
​
                    if (type == "IRSwap")
                    {
                        isin = fields[5];
                    }
                    else if (type == "BondFutures" || type == "IRFutures")
                    {
                        StringBuilder sbFut = new StringBuilder(fields[3]);
                        sbFut.Replace(" ", null);
                        string sbFutString = sbFut.ToString();
                        isin = sbFutString;
                    }
                }
            }
​
            static private Regex matchAssetSwap = new Regex("^BON.*BO[0-9]+$");
            private static string getType(string name)
            {
                if (name.StartsWith("BON"))
                {
                    if (false && matchAssetSwap.IsMatch(name))
                        return "AssetSwap";
                    else
                        return "ConvertibleBond";
                }
​
                if (name.StartsWith("FUT FUTURE TNOTE") || name.StartsWith("FUT FUTURE EURO") || name.StartsWith("FUT FUTURE GILT") || name.StartsWith("FUT FUTURE SWISS 10Y"))
                    return "BondFutures";
                if (name.StartsWith("FUT FUTURE") && name.Contains("3M"))
                    return "IRFutures";
                if (name.StartsWith("FUT FUTURE"))
                    return "IndexFutures";
                if (name.StartsWith("Swap"))
                    return "IRSwap";
                if (name.StartsWith("EQU") || name.StartsWith("PTFSWAP"))
                    return "Equity";
                if (name.StartsWith("EQS"))
                    return "EquitySwap";
                if (name.StartsWith("IndexSwap"))
                    return "ConvertibleBond";
                return null;
            }
​
            public bool combineAmounts(Row r)
            {
                if (type == r.type && strat == r.strat && isin == r.isin)
                {
                    amount += r.amount;
                    return true;
                }
                else
                {
                    return false;
                }
            }
​
            //Type,Name,ISIN,Strat,Amount
            public void writeRow(StreamWriter output)
            {
                if (type != null)
                {
                    output.WriteLine("{0},{1},{2},{3},{4}", type, name, isin, strat, amount);
                    type = null;
                }
            }
        }
    }
}

View IL Code