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();
}
}
