public static IEnumerable <User> ReadUsers()
{
using (var command = new SQLiteCommand(DataAccess.Instance.Connection))
{
command.CommandText = "SELECT id, name, userrole FROM users";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var id = reader.GetInt64(0);
var userRole = UserRoleData.Find(reader.GetInt64(2));
var user = new User()
{
Id = id, Name = reader[1].ToString(), UserRole = userRole
};
yield return(user);
}
reader.Close();
}
}
}
private void CreateDemoData()
{
DiscountData.CreateDemoData();
UserRoleData.CreateDemoData();
UserData.CreateDemoData();
}
