public void Save(Entry entity)
{
SqlServerCeManager database = new SqlServerCeManager();
string querry = $"insert into Entries (Name, Value, EntryGroup, Editable, Type) " +
$"values('{entity.Name}', {entity.Value.ToString("F2", CultureInfo.InvariantCulture)}, " +
$"'{entity.Group}', '{entity.Editable}', {(int)entity.EntryType})";
database.ExecuteQuerryAsync(querry);
}
public void Update(Entry entity)
{
SqlServerCeManager database = new SqlServerCeManager();
string querry = $"update Entries set Name = '{entity.Name}', " +
$"Value = {entity.Value.ToString("F2", CultureInfo.InvariantCulture)}, " +
$"EntryGroup = '{entity.Group}', Editable = '{entity.Editable}', " +
$"Type = {(int)entity.EntryType} where Id = {entity.Id}";
database.ExecuteQuerryAsync(querry);
}
public async Task <Entry[]> GetAll()
{
List <Entry> list = new List <Entry>();
SqlServerCeManager database = new SqlServerCeManager();
string querry = $"select * from Entries";
var reader = await database.ExecuteReaderAsync(querry);
while (reader.Read())
{
Entry entry = new Entry
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Name = reader.GetString(reader.GetOrdinal("Name")),
Value = reader.GetDecimal(reader.GetOrdinal("Value")),
Group = reader.GetString(reader.GetOrdinal("EntryGroup")),
Editable = reader.GetBoolean(reader.GetOrdinal("Editable")),
EntryType = (EntryType)reader.GetInt32(reader.GetOrdinal("Type"))
};
list.Add(entry);
}
return(list.ToArray());
}
public void Delete(Entry entity)
{
SqlServerCeManager database = new SqlServerCeManager();
database.ExecuteQuerryAsync($"delete from Entries where Id = {entity.Id}");
}
