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 + ")"); }