Question

the language i wan used in C# is visual basic.Create a console program that contains the following

·         A Class named Account with the following properties:

o   public int Id { get; set; }

o   public string Firstname { get; set; }

o   public string Lastname { get; set; }

o   public double Balance { get; set; }

o   public DateTime CreationDate { get; set; }

o   Create a constructor that initializes all of the properties.

o   Create a ToString Account method which returns a string containing all of the properties with at least one space between property values in the string.

·         In the main method of the console program create a list of accounts.

·         Add 10 accounts to the list with the following data:

ID	first name	last name	balance	creation date
1006	John	Doe	100	1/18/2014
1009	Jane	Doe	300	1/18/2014
1002	Richard	Doe	548	1/18/2015
1003	John	Deer	28	3/18/2014
1004	Bob	Reindeer	396	1/22/2016
1005	Patricia	Rabbit	1523.72	7/8/2013
1000	Bill	Rabbit	152	6/28/2013
1007	Steve	Bear	768	9/18/2015
1008	Rita	Slowwalker	23.19	12/23/2015
1001	Cindy	Deer	10004.95	1/18/2014

·         Write a LINQ query to list and sort items in the list of accounts by Id.

·         Print the query result set.

·         Write a LINQ query to list accounts created before 2014/01/18, order by creation date.

·         Print the query result set.

·         Write a LINQ query to list the first name, last name and balance of accounts order by account balance descending.

·         Print the query result set.

·         Write a LINQ query to Display account Id and creation date ordered by creation date.

·         Print the query result set.

Answer 1

Screenshot

Program

using System;
using System.Globalization;
using System.Linq;
namespace LinqQueryUsage
{
    //Create a class Account
    class Account
    {
        //Attributes
        private int id;
        private string firstName;
        private string lastName;
        private double balance;
        private DateTime creationtime;
        //Constructor
        public Account(int id,string fname,string lname,double bal,DateTime t)
        {
            this.id = id;
            firstName = fname;
            lastName = lname;
            balance = bal;
            creationtime = t;
        }
        //Setters and getters
        public int Id { get { return id; } set { id = value; } }
        public string Firstname { get { return firstName; } set { firstName = value; } }
        public string Lastname { get { return lastName; } set { lastName = value; } }
        public double Balance { get { return balance; } set { balance = value; } }
        public DateTime CreationDate { get { return creationtime; } set { creationtime = value; } }
        //Overriding tostring method
        public override string ToString()
        {
            return id+" "+string.Format("{0:20} {1,-10}",firstName, lastName)+" "+balance.ToString("#.##")+"    "+ string.Format("{0:d}",creationtime);
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            //Create 10 accounts of list
            Account[] accounts = new Account[10];
            accounts[0] = new Account(1006, "John", "Doe", 100,Convert.ToDateTime("1/18/2014", new CultureInfo("en-US")));
            accounts[1] = new Account(1009, "Jane", "Doe", 300, Convert.ToDateTime("1/18/2014", new CultureInfo("en-US")).Date);
            accounts[2] = new Account(1002, "Richard", "Doe",548, Convert.ToDateTime("1/18/2015", new CultureInfo("en-US")).Date);
            accounts[3] = new Account(1003, "John", "Deer", 28, Convert.ToDateTime("3/18/2014", new CultureInfo("en-US")).Date);
            accounts[4] = new Account(1004, "Bob", "Reindeer",396, Convert.ToDateTime("1/22/2016", new CultureInfo("en-US")).Date);
            accounts[5] = new Account(1005, "Patricia", "Rabbit",1532.72, Convert.ToDateTime("7/8/2013", new CultureInfo("en-US")).Date);
            accounts[6] = new Account(1000, "Bill", "Rabbit", 152, Convert.ToDateTime("6/28/2013", new CultureInfo("en-US")).Date);
            accounts[7] = new Account(1007, "Steve", "Bear",768, Convert.ToDateTime("9/18/2015", new CultureInfo("en-US")).Date);
            accounts[8] = new Account(1008, "Rita", "Slowwalker", 23.19, Convert.ToDateTime("12/23/2015", new CultureInfo("en-US")).Date);
            accounts[9] = new Account(1001, "Cindy", "Deer", 10004.95, Convert.ToDateTime("1/18/2014", new CultureInfo("en-US")).Date);
            //Write a LINQ query to list and sort items in the list of accounts by Id.
            var sorted = from account in accounts
                       orderby account.Id
                       select account;
            //Print
            Console.WriteLine("Display sorted using ID:");
            foreach (var account in sorted)
                Console.WriteLine(account);
            //Write a LINQ query to list accounts created before 2014/01/18, order by creation date.
            sorted = from acc in accounts
                     where acc.CreationDate<Convert.ToDateTime("2014/01/18", new CultureInfo("en-US")).Date
                     orderby acc.CreationDate
                     select acc;
            //Print
            Console.WriteLine("\nDisplay sorted using creation date less than 2014/01/18:");
            foreach (var account in sorted)
                Console.WriteLine(account);
            //Write a LINQ query to list the first name, last name and balance of accounts
            //order by account balance descending.
            sorted = from account in accounts
                     orderby account.Balance descending
                     select account;
            //Print
            Console.WriteLine("\nDisplay sorted using balance descending:") ;
            foreach (var account in sorted)
                Console.WriteLine(account.Firstname+" "+account.Lastname+" "+account.Balance.ToString("#.##"));
            //Write a LINQ query to Display account Id and creation date ordered by creation date.
            sorted = from account in accounts
                     orderby account.CreationDate
                     select account;
            //Print
            Console.WriteLine("\n\nDisplay sorted using creation date:");
            foreach (var account in sorted)
                Console.WriteLine(account.Id + " " + account.CreationDate);
        }
    }
}

Output

Display sorted using ID:
1000 Bill Rabbit      152    28-06-2013
1001 Cindy Deer        10004.95    18-01-2014
1002 Richard Doe         548    18-01-2015
1003 John Deer        28    18-03-2014
1004 Bob Reindeer    396    22-01-2016
1005 Patricia Rabbit      1532.72    08-07-2013
1006 John Doe         100    18-01-2014
1007 Steve Bear        768    18-09-2015
1008 Rita Slowwalker 23.19    23-12-2015
1009 Jane Doe         300    18-01-2014

Display sorted using creation date less than 2014/01/18:
1000 Bill Rabbit      152    28-06-2013
1005 Patricia Rabbit      1532.72    08-07-2013

Display sorted using balance descending:
Cindy Deer 10004.95
Patricia Rabbit 1532.72
Steve Bear 768
Richard Doe 548
Bob Reindeer 396
Jane Doe 300
Bill Rabbit 152
John Doe 100
John Deer 28
Rita Slowwalker 23.19

Display sorted using creation date:
1000 28-06-2013 00:00:00
1005 08-07-2013 00:00:00
1006 18-01-2014 00:00:00
1009 18-01-2014 00:00:00
1001 18-01-2014 00:00:00
1003 18-03-2014 00:00:00
1002 18-01-2015 00:00:00
1007 18-09-2015 00:00:00
1008 23-12-2015 00:00:00
1004 22-01-2016 00:00:00