public void UpdateUser(Person person)
{
string query = QueryBuilder.Update("persons", "PersonId", person.personId.ToString(),
GetNameColumnPair(person.name),
GetFullNameColumnPair(person.fullName));
using (SQLiteCommand update = new SQLiteCommand(query, m_conn))
update.ExecuteNonQuery();
}
public PersonViewModel(Person person, AccountancyApplication accountancyApplication)
{
m_underlyingData = person;
Name = person.name;
FullName = person.fullName;
m_accountancyApplication = accountancyApplication;
UserAccounts = new ObservableCollection<AccountViewModel>(m_accountancyApplication.EnumUserAccounts(this));
}
public void DeleteUser(Person person)
{
string query = QueryBuilder.Delete("persons", "PersonId", person.personId.ToString());
using (SQLiteCommand delete = new SQLiteCommand(query, m_conn))
delete.ExecuteNonQuery();
}
public void AddUser(ref Person person)
{
person.personId = AddUser(person.name, person.fullName);
}
public void UpdateUnderlyingData()
{
m_underlyingData = new Person(Name, FullName, m_underlyingData.personId);
}
public IEnumerable<Account> EnumUserAccounts(Person person)
{
return EnumAllAccounts().Where(a => a.ownerPersonId == person.personId);
}
public void UpdateUser(Person person)
{
m_persons[person.personId] = person;
}
public long AddUser(string name, string fullName)
{
Person person = new Person(name, fullName, 0);
AddUser(ref person);
return person.personId;
}
public void DeleteUser(Person person)
{
m_persons.Remove(person.personId);
}
public IEnumerable<Account> EnumUserAccounts(Person person)
{
return Select(QueryBuilder.Select(Columns, "accounts",
"ownerPersonId", person.personId.ToString()));
}
public void AddUser(ref Person person)
{
person.personId = GetNewId();
m_persons.Add(person.personId, person);
}
public PersonViewModel GetPerson(Person p)
{
return GetPerson(p.personId);
}
public void AddUser(ref Person person)
{
m_usersManager.AddUser(ref person);
}
public void UpdateUser(Person person)
{
m_usersManager.UpdateUser(person);
}
public IEnumerable<Account> EnumUserAccounts(Person person)
{
return m_accountsManager.EnumUserAccounts(person);
}
public void DeleteUser(Person person)
{
m_usersManager.DeleteUser(person);
}
