public Asshole GetAssholeById(long id)
{
try
{
string sql = "SELECT * FROM Assholes WHERE ID = @param1";
con.Open();
var cmd = new SQLiteCommand(sql, con);
cmd.Parameters.AddWithValue("@param1", id);
SQLiteDataReader reader = cmd.ExecuteReader();
reader.Read();
var asshole = new Asshole
{
ID = (long)reader["ID"],
Name = (string)reader["Name"],
Debit = (int)reader["Debit"]
};
con.Close();
return asshole;
}
catch (Exception e)
{
Console.WriteLine("Error: {0}\n{1}", e.Message, e.StackTrace);
}
return null;
}
public IEnumerable<Asshole> GetAssholes()
{
List<Asshole> assholes = null;
try
{
string sql = "SELECT * FROM Assholes";
con.Open();
var cmd = new SQLiteCommand(sql, con);
SQLiteDataReader reader = cmd.ExecuteReader();
Asshole asshole;
assholes = new List<Asshole>();
while (reader.Read())
{
asshole = new Asshole
{
ID = (long)reader["ID"],
Name = (string)reader["Name"],
Debit = (int)reader["Debit"]
};
assholes.Add(asshole);
}
con.Close();
}
catch (Exception e)
{
Console.WriteLine("Error: {0}\n{1}", e.Message, e.StackTrace);
}
return assholes;
}
public void UpdateAsshole(Asshole asshole)
{
try
{
string sql = "UPDATE Assholes WHERE ID = @id SET Name = @name, Debit = @debit";
var cmd = new SQLiteCommand(sql, con);
cmd.Parameters.AddWithValue("@id", asshole.ID);
cmd.Parameters.AddWithValue("@name", asshole.Name);
cmd.Parameters.AddWithValue("@debit", asshole.Debit);
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
Console.WriteLine("Error: {0}\n{1}", e.Message, e.StackTrace);
}
}
public void InsertAsshole(Asshole asshole)
{
try
{
con.Open();
string sql = "INSERT INTO Assholes (Name, Debit) VALUES (@param1, @param2)";
var cmd = new SQLiteCommand(sql, con);
cmd.Parameters.AddWithValue("@param1", asshole.Name);
cmd.Parameters.AddWithValue("@param2", asshole.Debit);
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
Console.WriteLine("Error: {0}\n{1}", e.Message, e.StackTrace);
}
}