public static void SaveOrUpdate(VolumeEntry volumeEntry)
{
if (volumeEntry == null)
{
throw new ArgumentNullException("volumeEntry");
}
using (var cmd = db.CreateCommand())
{
cmd.CommandText = (volumeEntry.VolumeId > 0)
? "UPDATE volumes SET volumeServerId=?, volumeUsername=?, volumeGain=? WHERE volumeId=?"
: "INSERT INTO volumes (volumeServerId,volumeUsername,volumeGain) VALUES (?,?,?)";
cmd.Parameters.Add(new SQLiteParameter("serverId", volumeEntry.ServerId));
cmd.Parameters.Add(new SQLiteParameter("username", volumeEntry.Username));
cmd.Parameters.Add(new SQLiteParameter("gain", volumeEntry.Gain));
if (volumeEntry.VolumeId > 0)
{
cmd.Parameters.Add(new SQLiteParameter("id", volumeEntry.VolumeId));
}
cmd.ExecuteNonQuery();
}
}
public static void Delete(VolumeEntry volumeEntry)
{
if (volumeEntry == null)
{
throw new ArgumentNullException("volumeEntry");
}
if (volumeEntry.VolumeId < 1)
{
throw new ArgumentException("Can't delete a non-existent server", "volumeEntry");
}
using (var cmd = db.CreateCommand("DELETE FROM volumes WHERE (volumeId=?)"))
{
cmd.Parameters.Add(new SQLiteParameter("id", volumeEntry.VolumeId));
cmd.ExecuteNonQuery();
}
}