public void insertData(ScineEntity entity)
{
System.Data.IDbCommand dbcmd = getDbCommand();
dbcmd.CommandText =
"INSERT INTO " + TABLE_NAME
+ " ( "
+ KEY_NAME + ", "
+ PRICE + ", "
+ IS_BOUGHT + " ) "
+ "VALUES ( '"
+ entity.name + "', "
+ entity.price + ", "
+ entity.isBought + " )";
dbcmd.ExecuteNonQuery();
}
public List <ScineEntity> getScines()
{
List <ScineEntity> list = new List <ScineEntity>();
System.Data.IDataReader reader = getAllData();
int fieldCount = reader.FieldCount;
while (reader.Read())
{
ScineEntity entity = new ScineEntity(reader[0].ToString(),
int.Parse(reader[1].ToString()),
int.Parse(reader[2].ToString()));
list.Add(entity);
}
return(list);
}
