/// <summary> /// Insert the standard Value to the db /// </summary> private static void InserStandarData() { Console.WriteLine("adding StandrdData"); using (var dataList = new HFABDataList()) { var locations = new[] { "0101", "0102", "0103", "0201", "0202", "0301", "0302", "VAKT", "SOPRUM", "TVÄTT" }; var events = new[] { "DÖUT", "DÖIN", "FDIN", "FDUT" }; var doorNames = new[] { "LGH0101", "LGH0102", "LGH0103", "LGH0201", "LGH0202", "LGH0301", "LGH0302", "BLK0101", "BLK0102", "BLK0103", "BLK0201", "BLK0202", "BLK0301", "BLK0302", "VAKT", "SOPRUM", "TVÄTT", "UT" }; foreach (var location in locations) { dataList.Locations.Add(new Models.Location { Name = location }); dataList.SaveChanges(); } foreach (var eventCode in events) { dataList.Events.Add(new Models.Event { Code = eventCode }); dataList.SaveChanges(); } foreach (var doorName in doorNames) { dataList.DoorNames.Add(new Models.DoorName { Name = doorName }); dataList.SaveChanges(); } var persons = new[, ] { { "Liam", "Jönsson", "0101A", "1" }, { "Elias", "Petterson", "0102A", "2" }, { "Wilma", "Johansson", "0102B", "2" }, { "Alicia", "Sanchez", "0103A", "3" }, { "Aaron", "Sanchez", "0103B", "3" }, { "Olivia", "Erlander", "0201A", "4" }, { "William", "Erlander", "0201B", "4" }, { "Alexander", "Erlander", "0201C", "4" }, { "Astrid", "Erlander", "0201D", "4" }, { "Lucas", "Adolfsson", "0202A", "5" }, { "Ebba", "Adolfsson", "0202B", "5" }, { "Lilly", "Adolfsson", "0202C", "5" }, { "Ella", "Ahlström", "0301A", "6" }, { "Alma", "Alfredsson", "0301B", "6" }, { "Elsa", "Ahlström", "0301C", "6" }, { "Maja", "Ahlström", "0301D", "6" }, { "Noah", "Almgren", "0302A", "7" }, { "Adam", "Andersen", "0302B", "7" }, { "Kattis", "Backman", "0302C", "7" }, { "Oscar", "Chen", "0302D", "7" }, { "Vaktmästare", "", "VAKT01", "8" } }; for (int i = 0; i < persons.GetLength(0); i++) { dataList.Persons.Add(new Models.Person { FirstName = persons[i, 0], LastName = persons[i, 1], Tag = persons[i, 2], Location = dataList.Locations.FirstOrDefault(l => l.ID == int.Parse(persons[i, 3])) }); dataList.SaveChanges(); } } Console.WriteLine("Standrad data done"); }
/// <summary> /// cheack if data need to be added /// </summary> public static void CheackIfDataExist() { using (var dataList = new HFABDataList()) { Console.WriteLine("Check if data need to be added to DB"); var standardDataList = dataList.Persons.Take(2).ToList(); var DemonDataList = dataList.Loggs.Take(2).ToList(); if (standardDataList.Count == 0) { InserStandarData(); } if (DemonDataList.Count == 0) { DemonData(); } Console.Clear(); } }