public static long? AddPerson(Person person)
{
string _query = string.Format("INSERT INTO Person (FirstName, LastName, AddressID, DateOfBirth, PersonType, Email, Password) " +
"VALUES('{0}', '{1}', {2}, '{3}', '{4}', '{5}', '{6}')",
person.FirstName, person.LastName,
person.Address.AddressID, person.DateOfBirth,
person.PersonType, person.Email, person.Password);
return CaseStudyDB.ExecuteNonQuery(_query);
}
public static Person GetPersonFromReader(SqlCeDataReader reader)
{
if (reader != null)
{
Person person = new Person();
person.PersonID = (long)reader["PersonID"];
person.FirstName = reader["FirstName"].ToString();
person.LastName = reader["LastName"].ToString();
person.SetAddress(AddressDB.GetAddressFromReader(reader));
person.DateOfBirth = DateTime.Parse(reader["DateOfBirth"].ToString());
Person.PersonTypes personType;
Enum.TryParse<Person.PersonTypes>(reader["PersonType"].ToString(), out personType);
person.PersonType = personType;
person.Email = reader["Email"].ToString();
person.Password = reader["Password"].ToString();
return person;
}
return null;
}
public static void SetUser(Person person)
{
_currentUser = person;
}
public static void Logout()
{
_currentUser = null;
}
internal static void UpdatePerson(Person person)
{
string _query = string.Format("UPDATE Person " +
"SET FirstName='{0}', LastName='{1}', AddressID={2}, DateOfBirth='{3}'," +
" PersonType='{4}', Email='{5}', Password='******' WHERE PersonID = {7}",
person.FirstName, person.LastName, person.Address.AddressID,
person.DateOfBirth, person.PersonType, person.Email, person.Password, person.PersonID);
CaseStudyDB.ExecuteNonQuery(_query);
}