private static void AddOneCabinWithCampers(CampSleepawayContext context) { NextOfKin next = context.NextOfKins.Find(1); List <NextOfKin> nextOfKins = new List <NextOfKin>(); nextOfKins.Add(next); List <Camper> campers = new List <Camper> { new Camper { FirstName = "Karl", LastName = "Ekman", NextOfKins = nextOfKins }, new Camper { FirstName = "Berit", LastName = "Ekman", NextOfKins = nextOfKins }, new Camper { FirstName = "Lisa", LastName = "Ekdhal", NextOfKins = nextOfKins } }; Cabin cabin = context.Cabins.Find(1); cabin.Counselor = context.Counselors.Find(2); context.Cabins.Add(cabin); context.SaveChanges(); }
private static void AddOneCamper(CampSleepawayContext context) { context.Campers.Add(new Camper { FirstName = "Anton", LastName = "Arnberg" }); context.SaveChanges(); }
private static void CheckInCamper() { using (CampSleepawayContext context = new CampSleepawayContext()) { string bigfirstname = MenuUtils.AskForString("Vad heter målsmannen i förnamn?"); string biglastname = MenuUtils.AskForString("Vad heter målsmannen i efternamn?"); bool oneMore = true; List <Camper> family = new List <Camper>(); while (oneMore) { string firstname = MenuUtils.AskForString("Vad heter kamparen i förnamn?"); string lastname = MenuUtils.AskForString("Vad heter kamparen i efternamn?"); family.Add(new Camper { FirstName = firstname, LastName = lastname }); oneMore = MenuUtils.AlternetivesMenu(1, new string[] { "Ja", "Nej" }, "Var det alla?") == 0 ? false : true; } NextOfKin nextOfKin = new NextOfKin { FirstName = bigfirstname, LastName = biglastname, Campers = family }; context.NextOfKins.Add(nextOfKin); // Let user choose cabin for all campers. bool chooseCabin = MenuUtils.AlternetivesMenu(1, new string[] { "Ja, nu på en gång.", "Nej, det kan göras senare." }, "Vill du välja stugor själv?") == 0 ? true : false; if (chooseCabin) { foreach (var camper in nextOfKin.Campers) { var cabins = (from emptyCabins in context.Cabins where emptyCabins.Campers.Count <= 3 select emptyCabins).ToList(); // Will query for all empty cabins string[] cabinText = new string[cabins.Count()]; int y = 0; foreach (var cabin in cabins) { context.Entry(cabin).Collection(c => c.Campers).Load(); cabinText[y] = String.Format($"{cabin.Name}: {3 - cabin.Campers.Count}"); } // Let user choose from cabins, and see remaining spots. int cabinChoice = MenuUtils.AlternetivesMenu(0, cabinText, "välj cabin för " + camper.FirstName + "."); y++; camper.Cabin = cabins[cabinChoice]; cabins[cabinChoice].Campers.Add(camper); // Loop until all campers has a cabin. } } context.SaveChanges(); } }
private static void AddOneNextOfKin(CampSleepawayContext context) { NextOfKin nextOfKin = new NextOfKin { FirstName = "Bro" }; context.NextOfKins.Add(nextOfKin); context.SaveChanges(); }
private static void AddOneCabin(CampSleepawayContext context) { Cabin cabin = new Cabin { Name = "Moonbase" }; context.Cabins.Add(cabin); context.SaveChanges(); }
private static void AddCampersToCabin(CampSleepawayContext context) { Cabin cabin = context.Cabins.Find(5); Camper camper = new Camper { FirstName = "Ante", LastName = "Berg" }; context.Entry(cabin).Collection(c => c.Campers).Load(); context.Campers.Add(camper); cabin.Campers.Add(camper); context.SaveChanges(); }
private static void AddOneCouncelour(CampSleepawayContext context) { Counselor counselor = new Counselor { FirstName = "Gösta Ekman" }; context.Counselors.Add(counselor); Cabin rock = context.Cabins.Find(1); rock.Counselor = counselor; //moonbase.Counselor = counselor; context.SaveChanges(); }
private static void AddOneNextOfKinToCamper(CampSleepawayContext context) { NextOfKin nextOfKin = new NextOfKin { FirstName = "Päron till farsa", Campers = new List <Camper> { new Camper { FirstName = "Åberg" }, new Camper { FirstName = "Lus" } } }; context.NextOfKins.Add(nextOfKin); context.SaveChanges(); }
private static void CheckOutCamper() { using (CampSleepawayContext context = new CampSleepawayContext()) { // Ask for Next of kin info string bigfirstname = MenuUtils.AskForString("Vad heter målsmannen i förnamn?"); string biglastname = MenuUtils.AskForString("Vad heter målsmannen i efternamn?"); // Query data from next of kin NextOfKin nextOfKin = (from nextOfKins in context.NextOfKins where nextOfKins.FirstName == bigfirstname && nextOfKins.LastName == biglastname select nextOfKins).FirstOrDefault(); context.Entry(nextOfKin).Collection(c => c.Campers).Load(); int campersCount = nextOfKin.Campers.Count(); string[] campersFirstName = new string[campersCount]; string[] campersLastName = new string[campersCount]; int[] camperIds = new int[campersCount]; int i = 0; foreach (var campersInQuery in nextOfKin.Campers) { campersFirstName[i] = campersInQuery.FirstName; campersLastName[i] = campersInQuery.LastName; camperIds[i] = campersInQuery.CamperId; i++; } // Checks out and prints all the campers of the next of kin. int choice = MenuUtils.AlternetivesMenu(0, campersFirstName, "Vilken unge vill du hämta?"); //var camperQuery = (from camper in context.Campers // where camper.LastName == campersLastName[choice] && // camper.FirstName == campersFirstName[choice] // select camper.Cabin).ToList(); int camperId = camperIds[choice]; context.Campers.RemoveRange(context.Campers.Where(c => c.CamperId == camperId)); context.SaveChanges(); } }
private static void CreateNewCabinAndCounselour() { using (CampSleepawayContext context = new CampSleepawayContext()) { string bigfirstname = MenuUtils.AskForString("Vad heter Lägerledaren i förnamn?"); string biglastname = MenuUtils.AskForString("Vad heter Lägerledaren i efternamn?"); string cabinName = MenuUtils.AskForString("Vad ska kabinen heta?"); Counselor counselor = new Counselor { FirstName = bigfirstname, LastName = biglastname }; Cabin cabin = new Cabin { Name = cabinName, Counselor = counselor }; context.Cabins.Add(cabin); context.SaveChanges(); } }