using System;

using System.Collections.Generic;

using System.Linq;

public class Program

{

    public static void Main()

    {

        var AccountsInfo = new List<Accounts>() {

                                new Accounts() { AccName = "Raja", AccNo = 101, AccType = "Savings", AccBalance = 500.25 },

                                new Accounts() { AccName = "Sekhar", AccNo = 102, AccType = "Current", AccBalance = 600.35 },

                                new Accounts() { AccName = "Raju", AccNo = 103, AccType = "PF", AccBalance = 700.45 },

                                new Accounts() { AccName = "Ranjith", AccNo = 104, AccType = "Savings", AccBalance = 800.55 },

                                new Accounts() { AccName = "Praja", AccNo = 105, AccType = "Current", AccBalance = 900.65 },

                                new Accounts() { AccName = "Ruthvik", AccNo = 106, AccType = "PF", AccBalance = 100.65 },

                                new Accounts() { AccName = "Saraswathamma", AccNo = 107, AccType = "Savings", AccBalance = 200.65 },

                                new Accounts() { AccName = "Venkat", AccNo = 108, AccType = "Current", AccBalance = 300.65 },

                                new Accounts() { AccName = "Sameer", AccNo = 109, AccType = "PF", AccBalance = 400.65 },

                                new Accounts() { AccName = "Bindhu", AccNo = 110, AccType = "Savings", AccBalance = 500.65 },

                                new Accounts() { AccName = "Sachin", AccNo = 111, AccType = "Current", AccBalance = 600.65 },

                                new Accounts() { AccName = "Vivek", AccNo = 112, AccType = "PF", AccBalance = 700.65 },

                                new Accounts() { AccName = "Srini", AccNo = 113, AccType = "Savings", AccBalance = 1000.65 },

                                new Accounts() { AccName = "Arun", AccNo = 114, AccType = "Current", AccBalance = 1100.65 },

                                new Accounts() { AccName = "Anurag", AccNo = 115, AccType = "PF", AccBalance = 1200.65 },

                                new Accounts() { AccName = "Pandu", AccNo = 116, AccType = "Savings", AccBalance = 1300.65 },

                                new Accounts() { AccName = "Bunny", AccNo = 117, AccType = "Current", AccBalance = 1400.65 },

                                new Accounts() { AccName = "Cherry", AccNo = 118, AccType = "PF", AccBalance = 1500.65 },

                                new Accounts() { AccName = "Rini", AccNo = 119, AccType = "Savings", AccBalance = 1600.65 },

                                new Accounts() { AccName = "Joshi", AccNo = 120, AccType = "Current", AccBalance = 1700.65 },

            };

         var myacc = from ac in AccountsInfo

                        select ac;

​

            foreach (var item in myacc)

            {

                Console.WriteLine("************************");

                Console.WriteLine(item.AccName);

                Console.WriteLine(item.AccNo);

                Console.WriteLine(item.AccType);

                Console.WriteLine(item.AccBalance);

            }

        var mysavingsacc = from ac in AccountsInfo

                               where ac.AccType == "Savings" && ac.AccBalance > 1000

                               select ac;

​

            foreach (var item in mysavingsacc)

            {

                Console.WriteLine("************************");

                Console.WriteLine(item.AccName);

                Console.WriteLine(item.AccNo);

                Console.WriteLine(item.AccType);

                Console.WriteLine(item.AccBalance);

            }

        var myAccountPrintlist = from ac in AccountsInfo

                                     orderby ac.AccType

                                     select ac;

​

            foreach (var item in myAccountPrintlist)

            {

                Console.WriteLine("************************");

                Console.WriteLine(item.AccName + "\t" + item.AccNo + "\t" + item.AccType + "\t" + item.AccBalance + "\t");

​

            }

        var myAccountReportlist = from ac in AccountsInfo

                                      where ac.AccType == "Savings" 

                                      orderby ac.AccBalance,ac.AccName

                                      select ac;

​

            foreach (var item in myAccountReportlist)

            {

                Console.WriteLine("************************");

                Console.WriteLine(item.AccName + "\t" + item.AccNo + "\t" + item.AccType + "\t" + item.AccBalance + "\t");

​

            }

        var myAccount = from ac in AccountsInfo

                            select new { ac.AccNo, ac.AccBalance };

            foreach (var item in myAccount)

            {

                Console.WriteLine("************************");

                Console.WriteLine(item.AccNo + "\t" + item.AccBalance);

​

            }

        var myAccount1 = from ac in AccountsInfo

                             select new

                             {

                                 AccountNumber = ac.AccNo,

                                 AccountBalance = ac.AccBalance,

                                 Interest = ac.AccBalance * 0.1

                             };

​

​

​

            foreach (var item in myAccount1)

            {

                Console.WriteLine("************************");

                Console.WriteLine(item.AccountNumber + "\t" + item.AccountBalance + "\t" + item.Interest);

            }

        var totalAccounts = (from ac in AccountsInfo

                                 select ac.AccNo).Count();

        var totalSavingsBalance = (from ac in AccountsInfo

                                 select ac.AccBalance).Sum();

​

​

​

            Console.WriteLine("Total Accounts are: " + totalAccounts);

            Console.WriteLine("Total Balance With Bank : " + totalSavingsBalance);

        var totalAccounts1 = from ac in AccountsInfo

                                 group ac by ac.AccType into g

                                 select new { accountType = g.Key,

                                     Count = g.Count(),

                                     TotalBalance = g.Sum(a => a.AccBalance),

                                     MinSalary = g.Min(a=>a.AccBalance),

                                     MaxSalary=g.Max(a => a.AccBalance)

​

                                 };

​

            foreach (var item in totalAccounts1)

            {

                Console.WriteLine("************************");

                Console.WriteLine(item.accountType + "\t" + item.Count+"\t"+item.TotalBalance + "\t" + item.MinSalary + "\t" + item.MaxSalary);

            }

    }

}

public class Accounts

    {

        public int AccNo { get; set; }

        public string AccName { get; set; }

​

        public string AccType { get; set; }

​

        public double AccBalance { get; set; }

​

    }