public void CreateInvoice(int userId, DateTime date)
{
DateTime startOfMonth = new DateTime(date.Year, date.Month, 1);
DateTime endOfMonth = new DateTime(startOfMonth.Year, startOfMonth.Month, DateTime.DaysInMonth(startOfMonth.Year, startOfMonth.Month));
var orders = context.Orders.Where(x => x.Customer.UserId == userId &&
x.Date > startOfMonth && x.Date < endOfMonth
);
if (orders.Count() > 0)
{
Invoice inv = new Invoice
{
Date = DateTime.Now,
Customer = context.Users.Find(userId),
Orders = orders.ToList()
};
context.Invoices.Add(inv);
context.SaveChanges();
}
}
public void InsertWeekOrder(WeekOrder weekOrder)
{
context.WeekOrders.Add(weekOrder);
context.SaveChanges();
}
public void InsertOrder(Order order)
{
context.Orders.Add(order);
context.SaveChanges();
}
public void InsertUser(User user)
{
context.Users.Add(user);
context.SaveChanges();
}