Ytukyg

1.txt:

Origination,destination,datetime,price

YYZ,YTC,2016-04-01 12:30,$550

YYZ,YTC,2016-04-01 12:30,$550

LKC,LKP,2016-04-01 12:30,$550

2.txt:

Origination|destination|datetime|price

YYZ|YTC|2016-04-01 12:30|$550

AMV|YRk|2016-06-01 12:30|$630

LKC|LKP|2016-12-01 12:30|$990

I have two text files with ',' and '|' as separators, and I want to create a console app in C# which reads these two files when I pass an origination and destination location from command prompt.

While searching, I want to ignore duplicate lines, and I want to display the results in order by price.

The output should be { origination } -> { destination } -> datetime -> price

Need help how to perform.

Here's a simple solution that works for your example files. It doesn't have any error checking for if the file is in a bad format.

using System;

using System.Collections.Generic;



class Program

{

    class entry

    {

        public string origin;

        public string destination;

        public DateTime time;

        public double price;

    }



    static void Main(string args)

    {

        List<entry> data = new List<entry>();



        //parse the input files and add the data to a list

        ParseFile(data, args[0], ',');

        ParseFile(data, args[1], '|');



        //sort the list (by price first)

        data.Sort((a, b) =>

        {

            if (a.price != b.price)

                return a.price > b.price ? 1 : -1;

            else if (a.origin != b.origin)

                return string.Compare(a.origin, b.origin);

            else if (a.destination != b.destination)

                return string.Compare(a.destination, b.destination);

            else

                return DateTime.Compare(a.time, b.time);

        });



        //remove duplicates (list must be sorted for this to work)

        int i = 1;

        while (i < data.Count)

        {

            if (data[i].origin == data[i - 1].origin

                && data[i].destination == data[i - 1].destination

                && data[i].time == data[i - 1].time

                && data[i].price == data[i - 1].price)

                data.RemoveAt(i);

            else

                i++;

        }



        //print the results

        for (i = 0; i < data.Count; i++)

            Console.WriteLine("{0}->{1}->{2:yyyy-MM-dd HH:mm}->${3}",

                data[i].origin, data[i].destination, data[i].time, data[i].price);



        Console.ReadLine();

    }



    private static void ParseFile(List<entry> data, string filename, char separator)

    {

        using (System.IO.FileStream fs = System.IO.File.Open(filename, System.IO.FileMode.Open))

        using (System.IO.StreamReader reader = new System.IO.StreamReader(fs))

            while (!reader.EndOfStream)

            {

                string line = reader.ReadLine().Split(separator);

                if (line.Length == 4)

                {

                    entry newitem = new entry();

                    newitem.origin = line[0];

                    newitem.destination = line[1];

                    newitem.time = DateTime.Parse(line[2]);

                    newitem.price = double.Parse(line[3].Substring(line[3].IndexOf('$') + 1));

                    data.Add(newitem);

                }

            }

    }

}

I'm not 100% clear on what the output of your program is supposed to be, so I'll leave that part of the implementation up to you. My strategy was to use a constructor method that takes a string (that you will read from a file) and a delimiter (since it varies) and use that to create objects which you can manipulate (e.g. add to hash sets, etc).

PriceObject.cs

using System;

using System.Globalization;



namespace ConsoleApplication1

{

class PriceObject

{

    public string origination { get; set; }

    public string destination { get; set; }

    public DateTime time { get; set; }

    public decimal price { get; set; }







    public PriceObject(string inputLine, char delimiter)

    {

        string parsed = inputLine.Split(new char { delimiter }, 4);

        origination = parsed[0];

        destination = parsed[1];

        time = DateTime.ParseExact(parsed[2], "yyyy-MM-dd HH:mm", CultureInfo.InvariantCulture);

        price = Decimal.Parse(parsed[3], NumberStyles.Currency, new CultureInfo("en-US"));

    }





    public override bool Equals(object obj)

    {

        var item = obj as PriceObject;

        return origination.Equals(item.origination) &&

            destination.Equals(item.destination) &&

            time.Equals(item.time) &&

            price.Equals(item.price);

    }



    public override int GetHashCode()

    {



        unchecked

        {

            var result = 17;

            result = (result * 23) + origination.GetHashCode();

            result = (result * 23) + destination.GetHashCode();

            result = (result * 23) + time.GetHashCode();

            result = (result * 23) + price.GetHashCode();

            return result;

        }

    }





}

}

Program.cs

using System;

using System.Collections.Generic;

using System.IO;

using System.Linq;



namespace ConsoleApplication1

{

class Program

{

    static void Main(string args)

    {

        HashSet<PriceObject> list1 = new HashSet<PriceObject>();

        HashSet<PriceObject> list2 = new HashSet<PriceObject>();



        using (StreamReader reader = File.OpenText(args[0]))

        {

            string line = reader.ReadLine(); // this will remove the header row



            while (!reader.EndOfStream)

            {

                line = reader.ReadLine();

                if (String.IsNullOrEmpty(line))

                    continue;

                // add each line to our list

                list1.Add(new PriceObject(line, ','));

            }



        }



        using (StreamReader reader = File.OpenText(args[1]))

        {

            string line = reader.ReadLine(); // this will remove the header row



            while (!reader.EndOfStream)

            {

                line = reader.ReadLine();

                if (String.IsNullOrEmpty(line))

                    continue;

                // add each line to our list

                list2.Add(new PriceObject(line, '|'));

            }



        }



        // merge the two hash sets, order by price

        list1.UnionWith(list2);

        List<PriceObject> output = list1.ToList();



        output.OrderByDescending(x => x.price).ToList();



        // display output here, e.g. define your own ToString method, etc

        foreach (var item in output)

        {

            Console.WriteLine(item.ToString());

        }



        Console.ReadLine();

    }

}

}