public async Task <List <Item> > Get(int userid)
{
using (TimeTrackingDBContext context = new TimeTrackingDBContext())
{
var result = new CalculationResult();
// Get Calculation Config for Current User
var config = await context.Calculation.Where(a => a.userId == userid).SingleOrDefaultAsync();
var items = await context.Items.Where(i => i.userId == userid).ToListAsync();
var fahrtkosten = await context.Items.Where(i => i.userId == userid).ToListAsync();
result.inVoicedDays = items.Sum(a => a.hours) / 8;
result.averageHourlyRate = 65;
result.income = items.Sum(a => a.hours) * 65;
result.investmentExpenses = result.income * config.investmentTax;
result.adjustedIncome = result.income - result.investmentExpenses;
result.employerExpenses = result.income * config.employerDuties;
return(null);
}
}
public async Task <List <Item> > Get(int id)
{
using (TimeTrackingDBContext context = new TimeTrackingDBContext())
{
return(await context.Items.Where(a => a.user.Id == id).Include("project").OrderByDescending(a => a.date).AsNoTracking().ToListAsync());
}
}
public async Task <List <Project> > Get()
{
using (TimeTrackingDBContext context = new TimeTrackingDBContext())
{
return(await context.Projects.Include(p => p.Costumer).ToListAsync());
}
}
public async Task <long> Post([FromBody] Item item)
{
using (TimeTrackingDBContext context = new TimeTrackingDBContext())
{
item.userId = 1;
context.Items.Add(item);
await context.SaveChangesAsync();
return(item.id);
}
//Mapping
}
public async void Delete(int id)
{
using (TimeTrackingDBContext context = new TimeTrackingDBContext())
{
var item = await context.Items.SingleOrDefaultAsync(i => i.id == id);
if (item != null)
{
context.Items.Remove(item);
await context.SaveChangesAsync();
}
}
}
