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 void Delete(Entry entity) { SqlServerCeManager database = new SqlServerCeManager(); database.ExecuteQuerryAsync($"delete from Entries where Id = {entity.Id}"); }