public Table GetQuery(string data)
{
List<Person> people = (from p in dataBase
select p).ToList();
Table table = new Table();
table.InitalizeTable(people);
return table;
}
public void UpdatePerson(Table table)
{
int id = int.Parse(table.ValuesList.First().First().ToString());
var person = db.People.First(i => i.ID == id);
List<object> values = table.ValuesList.First();
for (int i = 0; i < person.Length; i++)
{
person[i] = values[i];
}
db.SaveChanges();
}
public Table GetQuery(string data)
{
Table table = new Table();
table.InitalizeTable(db.CreateObjectSet<Person>());
return table;
}
private void ClientEvents_UpdateRecord(object sender, SocketEventArgs e)
{
Table table = new Table();
table.TypesList = e.Command.TypesList;
table.ValuesList = e.Command.ValuesList;
dao.UpdatePerson(table);
}
private void ClientEvents_AddRecord(object sender, SocketEventArgs e)
{
Table table = new Table();
dao.AddPerson(e.Command.ValuesList);
}
private void ClientEvents_UpdateRecord(object sender, SocketEventArgs e)
{
Table table = new Table();
table.TypesList = e.Command.TypesList;
table.ValuesList = e.Command.ValuesList;
dao.UpdatePerson(int.Parse(e.Command.ValuesList.First().First().ToString()), e.Command.ValuesList.First());
}