public IHttpActionResult GetAll()
{
using (var repository = new MinisBackContext())
{
var retVal = repository.Sandwichs.Include(x => x.Ingredients).ToList();
return(Ok(retVal));
}
}
public IHttpActionResult CompleteOrder()
{
using (var repository = new MinisBackContext())
{
var orderDB = new Data.Model.OrderEntity()
{
Completed = true,
};
repository.Orders.Add(orderDB);
repository.SaveChanges();
return(Ok(repository.Orders.Include(x => x.OrderItems).FirstOrDefault(x => x.Id == orderDB.Id)));
}
}
public IHttpActionResult PayOrder(OrderViewModel vm)
{
using (var repository = new MinisBackContext())
{
var orderDB = new Data.Model.OrderEntity()
{
DatePaid = DateTime.UtcNow,
Paid = true,
};
repository.Orders.Add(orderDB);
repository.SaveChanges();
return(Ok(repository.Orders.Include(x => x.OrderItems).FirstOrDefault(x => x.Id == orderDB.Id)));
}
}
public IHttpActionResult Search()
{
using (var repository = new MinisBackContext())
{
var dateFrom = DateTime.UtcNow.AddHours(-12);
var dateTo = DateTime.UtcNow;
var retVal = repository.Orders
.Include(x => x.OrderItems)
.Include(x => x.OrderItems.Select(y => y.Order))
.Where(x => x.DateMade >= dateFrom && x.DateMade <= dateTo)
.ToList();
return(Ok(retVal));
}
}
public IHttpActionResult AddOrder(OrderViewModel vm)
{
using (var repository = new MinisBackContext())
{
var orderDB = new Data.Model.OrderEntity()
{
Price = vm.Price,
DateMade = DateTime.UtcNow,
DatePaid = null,
Completed = false,
Paid = false,
};
int[] IdsArray = new int[vm.OrderItems.Count];
var counter = new int();
foreach (var orderItemVM in vm.OrderItems)
{
orderDB.OrderItems.Add(new OrderItemEntity()
{
SandwichId = orderItemVM.SandwichId,
Quantity = orderItemVM.Quantiy,
SandwichPrice = orderItemVM.SandwichPrice,
TotalPrice = orderItemVM.TotalPrice,
});
IdsArray[counter] = orderItemVM.SandwichId;
}
foreach (var IdsA in IdsArray)
{
using (MinisBackContext context = new MinisBackContext())
{
/* Queries needed to set the chain of commands.
* var QIngredients = from SandwichIngredient in context.Ingredients where SandwichEntity.Id == IdsA select context.Ingredients;
* var QSandwich = from SandwichEntity in repository.SandwichTypes where SandwichEntity.Id == IdsA;
* var QSandwichType = from SandwichTypeEntity in repository.Sandwichs select SandwichTypeEntity;
*/
//Testing variables
var Command = "";
var RIngredients = "1,2";
var RSalsa = "1";
var RCut = "1";
var RCompressed = true;
Command = "";
Command += "Addb()+";
Command += "AddIng(" + RIngredients + ")+";
if (RSalsa == "2")
{
Command += "AddS()+";
}
Command += "Addb()+";
if (RCompressed)
{
Command += "Compress()+";
}
if (RSalsa == "1")
{
Command += "Cut(" + RCut + ")+"; Command += "AddS()";
}
else
{
Command += "Cut(" + RCut + ")";
}
var Machine = new MachineService();
/* Queries needed to OrderId the chain of commands.
*
*
* QOrderID = FROM OrdersEntity WHERE id = (SELECT MAX(id) Select id)
*
*/
/* Queries needed to OrderItemId the chain of commands.
*
*
* QOrderID = FROM OrdersItemsEntity WHERE id = (SELECT MAX(id) Select id)
*
*/
int OrderId = 1;
int OrderItemId = 1;
Machine.ProcessInbounds(Command, OrderItemId, OrderId, counter);
}
}
repository.Orders.Add(orderDB);
repository.SaveChanges();
return(Ok(repository.Orders.Include(x => x.OrderItems).FirstOrDefault(x => x.Id == orderDB.Id)));
}
}
