コード例 #1
0
        static void Main(string[] args)
        {
            GringottsContext gringotts = new GringottsContext();

            gringotts.Database.Initialize(true);
            try
            {
                WizardDeposits deposit = new WizardDeposits
                {
                    FirstName             = "Albus",
                    LastName              = "Dumbledore",
                    Age                   = 150,
                    MagicWandCreator      = "Antioch Paverell",
                    MagicWandSize         = 15,
                    DepositStartDate      = new DateTime(2016, 10, 20),
                    DepositExpirationDate = new DateTime(2020, 10, 20),
                    DepositAmount         = 20000.24m,
                    DepositCharge         = 0.2m,
                    IsDepositGroup        = false
                };
                gringotts.Deposits.Add(deposit);
                gringotts.SaveChanges();
            }
            catch (DbEntityValidationException ex)
            {
                foreach (DbEntityValidationResult dbEntityValidationResult in ex.EntityValidationErrors)
                {
                    foreach (DbValidationError dbValidationError in dbEntityValidationResult.ValidationErrors)
                    {
                        Console.WriteLine(dbValidationError.ErrorMessage);
                    }
                }
            }
        }
コード例 #2
0
        public static void Main()
        {
            var context = new GringottsContext();
            var uniqueWizardFirstLetters = context.WizzardDeposits
                                           .Where(w => w.DepositGroup == "Troll Chest")
                                           .Select(w => w.FirstName.Substring(0, 1))
                                           .Distinct()
                                           .ToArray();

            foreach (var letter in uniqueWizardFirstLetters)
            {
                Console.WriteLine(letter);
            }
        }
コード例 #3
0
        static void Main(string[] args)
        {
            var           context = new GringottsContext();
            StringBuilder content = new StringBuilder();

            #region//First Letter
            //var uniqueFirstLetterGringotts = context.WizzardDeposits
            //.Where(d => d.DepositGroup == "Troll Chest")
            //.Select(d => d.FirstName.Substring(0, 1))
            //.Distinct()
            //.OrderBy(d => d);
            //foreach (var letters in uniqueFirstLetterGringotts)
            //{
            //    content.AppendLine($"{letters}");
            //}
            #endregion

            Console.WriteLine(content);
        }
コード例 #4
0
        static void Main(string[] args)
        {
            Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;

            GringottsContext context = new GringottsContext();

            //Tasks 1 and 2 Deposits Sum for Ollivander Family

            var depositGroups =
                context.WizzardDeposits.Where(x => x.MagicWandCreator == "Ollivander family")
                .GroupBy(y => new { y.DepositGroup })
                .Select(g => new { DepositGroup = g.Key.DepositGroup, Sum = g.Sum(x => x.DepositAmount) }).Where(arg => arg.Sum.Value < 150000)
                .OrderByDescending(arg => arg.Sum);

            foreach (var element in depositGroups)
            {
                Console.WriteLine($"{element.DepositGroup} - {element.Sum}");
            }
        }
コード例 #5
0
        static void Main(string[] args)
        {
            WizardDeposit dumbledore = new WizardDeposit()
            {
                FirstName             = "Albus",
                LastName              = "Dumbledore",
                Age                   = 150,
                MagicWandCreator      = "Antioch Peverell",
                MagicWandSize         = 15,
                DepositStartDate      = new DateTime(2016, 10, 20),
                DepositExpirationDate = new DateTime(2020, 10, 20),
                DepositAmount         = 20000.24m,
                DepositCharge         = 0.2m,
                IsDepositExpired      = false
            };
            var context = new GringottsContext();

            context.WizardDeposits.Add(dumbledore);
            context.SaveChanges();
        }
コード例 #6
0
        static void Main()
        {
            GringottsContext context = new GringottsContext();
            WizardDeposits   deposit = new WizardDeposits
            {
                FirstName             = "Stoyan",
                LastName              = "Ivanov",
                Age                   = 37,
                MagicWandCreator      = "magic creator",
                MagicWandSize         = 15,
                DepositStartDate      = new DateTime(2016, 10, 20),
                DepositExpirationDate = new DateTime(2020, 10, 20),
                DepositAmount         = 20000.24m,
                DepositCharge         = 0.2,
                IsDepositeExpired     = false
            };
            User user = new User
            {
                Username     = "******",
                Password     = "******",
                Email        = "*****@*****.**",
                Age          = 37,
                IsDeleted    = false,
                RegisteredOn = DateTime.Now
            };

            Album album = new Album()
            {
                Name = "FirstAlbum",
            };

            user.Albums.Add(album);
            //context.WizardDepositses.Add(deposit);
            context.Users.Add(user);
            context.SaveChanges();
        }