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(); } }