Ejemplo n.º 1
0
        static void Main(string[] args)
        {
            // set database initializer
            Database.SetInitializer<LibraryContext>(new LibraryContextInitializer());

            LibraryContext db = new LibraryContext();
            db.Configuration.LazyLoadingEnabled = false;
            db.Configuration.ProxyCreationEnabled = false;

            Console.WriteLine("Database contains:");

            var titles = db.Titles.ToList();
            Console.WriteLine(string.Format("{0} Titles", titles.Count()));

            var copies = db.Copies.ToList();
            Console.WriteLine(string.Format("{0} Copies", copies.Count()));

            var members = db.Members.ToList();
            Console.WriteLine(string.Format("{0} Members", members.Count()));

            var loans = db.Loans.ToList();
            Console.WriteLine(string.Format("{0} Loans", loans.Count()));

            var categories = db.Categories.ToList();
            Console.WriteLine(string.Format("{0} Categories", categories.Count()));

             Console.ReadLine();
        }
Ejemplo n.º 2
0
        static void Main(string[] args)
        {
            // set database initializer
            Database.SetInitializer<LibraryContext>(new LibraryContextInitializer());

            LibraryContext db = new LibraryContext();
            db.Configuration.LazyLoadingEnabled = false;
            db.Configuration.ProxyCreationEnabled = false;

            Console.WriteLine("Database contains:");

            var titles = db.Titles.ToList();
            Console.WriteLine(string.Format("{0} Titles", titles.Count()));

            var copies = db.Copies.ToList();
            Console.WriteLine(string.Format("{0} Copies", copies.Count()));

            var members = db.Members.ToList();
            Console.WriteLine(string.Format("{0} Members", members.Count()));

            var loans = db.Loans.ToList();
            Console.WriteLine(string.Format("{0} Loans", loans.Count()));

            var categories = db.Categories.ToList();
            Console.WriteLine(string.Format("{0} Categories", categories.Count()));

            FormatClass<Title>.ForDisplay(titles[0]);

            Console.WriteLine("Press <ENTER> to execute Use Case 1");
            Console.ReadLine();
            Repository rep = new Repository();
            Member member1 = rep.GetMemberDetailsAndLoans(2);
            Console.WriteLine(FormatMember.ForDisplay(member1, FormatAssociationsEnum.Children));

            Console.WriteLine("Press <ENTER> to execute Use Case 2");
            Console.ReadLine();
            rep = new Repository();
            List<Title> titles2 = rep.GetTitlesforCategoryDescription("Thriller");
            foreach (Title t in titles2)
            {
                Console.WriteLine(FormatTitle.ForDisplay(t, FormatAssociationsEnum.Children));
            }

            Console.WriteLine("Press <ENTER> to execute Use Case 3");
            Console.ReadLine();
            rep = new Repository();
            List<Title> titles3 = rep.GetTitlesWithCopiesForCategoryDescription("Thriller", "Glasgow Caledonian University");
            foreach (Title t in titles3)
            {
                Console.WriteLine(FormatTitle.ForDisplay(t, FormatAssociationsEnum.Children));
            }

            Console.WriteLine("Press <ENTER> to execute Use Case 4");
            Console.ReadLine();
            rep = new Repository();
            List<Loan> loans4 = rep.GetMembersWhoHaveTitleOnLoan("Programming Entity Framework");
            foreach (Loan l in loans4)
            {
                Console.WriteLine(FormatLoan.ForDisplay(l, FormatAssociationsEnum.Parents));
            }

            Console.WriteLine("Press <ENTER> to execute Use Case 4A");
            Console.ReadLine();
            rep = new Repository();
            List<Loan> loans4A = rep.GetMembersWhoHaveTitleOnLoan("Programming Entity Framework");
            foreach (Loan l in loans4A)
            {
                Console.WriteLine(FormatLoan.ForDisplay(l, FormatAssociationsEnum.Parents));
            }

            Console.WriteLine("Press <ENTER> to execute Use Case 5");
            Console.ReadLine();
            rep = new Repository();
            Dictionary<Title, Member> TitlesLoaned5 = rep.GetTitlesLoanedByPeriod(new DateTime(2013, 2, 15), new DateTime(2013, 2, 22), "Glasgow Caledonian University", "Jenson");
            foreach (Title t in TitlesLoaned5.Keys)
            {
                Console.WriteLine(FormatTitle.ForDisplay(t, FormatAssociationsEnum.Children));
                Console.WriteLine(FormatMember.ForDisplay(TitlesLoaned5[t], FormatAssociationsEnum.Children));
            }

            Console.WriteLine("Press <ENTER> to execute Use Case 6");
            Console.ReadLine();
            rep = new Repository();
            Dictionary<string, int> TitlesLoaned6 = rep.GetLoansPerTitle();
            foreach (string t in TitlesLoaned6.Keys)
            {
                Console.WriteLine("{0} has {1} copies on loan", t, TitlesLoaned6[t]);
            }

            Console.WriteLine("Press <ENTER> to execute Use Case 7");
            Console.ReadLine();
            rep = new Repository();
            List<Loan> entireGraph = rep.GetEntireObjectGraph();
            foreach (Loan l in entireGraph)
            {
                Console.WriteLine(FormatTitle.ForDisplay(l.Copy.Title, FormatAssociationsEnum.Children));
                Console.WriteLine(FormatMember.ForDisplay(l.Member, FormatAssociationsEnum.Children));
            }

            Console.WriteLine("Press <ENTER> to execute Use Case 8");
            Console.ReadLine();
            rep = new Repository();
            Dictionary<Title, Member> TitlesLoaned8 = rep.GetTitlesLoanedByPeriodWithFilters(new DateTime(2013, 2, 15), new DateTime(2013, 2, 22), "Glasgow Caledonian University", "Jenson");
            foreach (Title t in TitlesLoaned8.Keys)
            {
                Console.WriteLine(FormatTitle.ForDisplay(t, FormatAssociationsEnum.Children));
                Console.WriteLine(FormatMember.ForDisplay(TitlesLoaned8[t], FormatAssociationsEnum.Children));
            }

            Console.WriteLine("\r\nPress <ENTER> to terminate");
            Console.ReadLine();
        }