public int AddPerson(Person newPerson)
{
CheckAndCreatePersonTable();
long newId;
using (SQLiteConnection connection = new SQLiteConnection(GetConnectionString()))
{
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(connection))
{
command.CommandText = "INSERT INTO Persons (FirstName, Surname, EMail, Age, Salary) VALUES($FirstName,$Surname,$EMail,$Age,$Salary)";
command.Parameters.AddWithValue("$FirstName", newPerson.FirstName);
command.Parameters.AddWithValue("$Surname", newPerson.Surname);
command.Parameters.AddWithValue("$EMail", newPerson.EMail);
command.Parameters.AddWithValue("$Age", newPerson.Age);
command.Parameters.AddWithValue("$Salary", newPerson.Salary);
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
command.CommandText = "SELECT last_insert_rowid()";
newId = (long)command.ExecuteScalar();
}
connection.Close();
}
return (int)newId;
}
public void UpdatePerson(Person personToUpdate)
{
CheckAndCreatePersonTable();
using (SQLiteConnection connection = new SQLiteConnection(GetConnectionString()))
{
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(connection))
{
command.CommandText = "UPDATE Persons SET FirstName = $FirstName, Surname = $Surname, EMail = $EMail, Age = $Age, Salary = $Salary WHERE RecordId = $RecordId";
command.Parameters.AddWithValue("$RecordId", personToUpdate.RecordId);
command.Parameters.AddWithValue("$FirstName", personToUpdate.FirstName);
command.Parameters.AddWithValue("$Surname", personToUpdate.Surname);
command.Parameters.AddWithValue("$EMail", personToUpdate.EMail);
command.Parameters.AddWithValue("$Age", personToUpdate.Age);
command.Parameters.AddWithValue("$Salary", personToUpdate.Salary);
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
}
connection.Close();
}
}
