public void UpdateIncident(Incident incident)
{
this.Open();
string sql = String.Format("select * from incidents where incidentNumber={0}", incident.IncidentNumber);
SQLiteDataAdapter adapter = new SQLiteDataAdapter(sql, this.db);
SQLiteCommandBuilder cmdb = new SQLiteCommandBuilder(adapter);
cmdb.GetInsertCommand();
DataTable table = new DataTable();
adapter.Fill(table);
table.Rows[0].Delete();
incident.AddToDataTable(table);
adapter.Update(table);
Program.Log.Info("Database.UpdateIncident(" + incident.IncidentNumber + ")");
}
public void CreateIncident(Incident incident)
{
this.Open();
SQLiteDataAdapter adapter = new SQLiteDataAdapter("select * from incidents where 1 = 0", this.db);
SQLiteCommandBuilder cmdb = new SQLiteCommandBuilder(adapter);
cmdb.GetInsertCommand();
DataTable incidents = new DataTable();
adapter.Fill(incidents);
incident.AddToDataTable(incidents);
incidents.Rows[0].SetField <string>(0, null);
adapter.Update(incidents);
incident.IncidentNumber = (int)this.db.LastInsertRowId;
Program.Log.Info("Database.CreateIncident(" + incident.IncidentNumber + ")");
}
