//TODO:4 import data
public List<person> ImportPeople()
{
//load people
using (fvsfdsdfEntities context = new fvsfdsdfEntities())
{
//return temp storage
List<person> temp = new List<person>();
var queryPeople = (from pe in context.people select pe);
foreach (var p in queryPeople)
{
//Console.WriteLine($"{p.ID} {p.name} {p.rank} {p.unit01.name}");
temp.Add(p);
}
return temp;
}
}
//TODO:5 export data
//create temp sorage to hold data
public void ExportToDB(List<person> outPut)
{
using (fvsfdsdfEntities server = new fvsfdsdfEntities())
{
foreach (var person in outPut)
{
var queryPerson = (from p in server.people
where p.ID == person.ID
select p);
foreach (var perp in queryPerson)
{
perp.ID = person.ID;
perp.name = person.name;
perp.rank = person.rank;
perp.unit01 = person.unit01;
perp.unitID= person.unitID;
}
}
}
}