// Async select task don't work correctly. Insert to database is ok, but select query takes a long time to return a value. Come back to non async solution.
public List <EventModel> GetAll()
{
using (var db = new MenadzerZespolowDBContext())
{
var result = db.Events.ToList();
return(result);
}
}
// Same problem as above
public List <EventModel> GetEventByData(DateTime date)
{
DateTime temp = date.Date;
using (var db = new MenadzerZespolowDBContext())
{
var result = (from b in db.Events
where b.Date == temp
select b).ToList();
return(result);
}
}
public async Task AddEvent(string name, string type, DateTime date)
{
using (var db = new MenadzerZespolowDBContext())
{
db.Events.Add(new EventModel
{
Name = name,
Type = type,
Date = date
});
await db.SaveChangesAsync();
}
}