/// <summary>
/// Method to archive an order in the database.
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public async Task <Tuple <string, HttpStatusCode> > AchiveOrder(int order)
{
try
{
using (var db = new Database())
{
var orderToBeArchived = await db.Orders
.Include(o => o.DCRGraph)
.FirstOrDefaultAsync(o => o.Id == order);
//this order did not exist
if (orderToBeArchived == null)
{
return(new Tuple <string, HttpStatusCode>("The order did not exist in the Database", HttpStatusCode.InternalServerError));
}
//the order exists, better lock before we change anything.
var guid = Guid.NewGuid();
var tryLock = await this.LockGraph(guid, orderToBeArchived.DCRGraph.Id, db);
if (tryLock.Item1 == false)
{
return(new Tuple <string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError));
}
//change to archived
orderToBeArchived.Archived = true;
db.Entry(orderToBeArchived).State = EntityState.Modified;
//lets be absolutely sure we have the lock before we change the db
var checkLock = await this.CheckLock(guid, orderToBeArchived.DCRGraph.Id, db);
if (checkLock.Item1 == false)
{
return(new Tuple <string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError));
}
//save to db
await db.SaveChangesAsync();
//we're done, better unlock
var unlock = await this.Unlock(guid, orderToBeArchived.DCRGraph.Id, db);
if (unlock.Item1 == false)
{
return(new Tuple <string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError));
}
return(new Tuple <string, HttpStatusCode>("Success", HttpStatusCode.OK));
}
}
catch (Exception ex)
{
return(new Tuple <string, HttpStatusCode>(
ex.Message, HttpStatusCode.InternalServerError));
}
}
/// <summary>
/// Method to create new orders in the database.
/// It will create a new order with the information it receives and with the DCRGraph which is currently in the xml file which the API reads from.
/// </summary>
/// <param name="container"></param>
/// <param name="orderInfo"></param>
/// <returns></returns>
public async Task<Tuple<string, HttpStatusCode>> CreateOrder(EventAndRolesContainer container, NewOrderInfo orderInfo)
{
using (var db = new WebAPI.Models.DBObjects.Database())
{
try
{
//setup a new dcrgraph
var graph = new DCRGraph
{
AcceptingState = false,
Lock = false,
LockTime = DateTime.Now,
DCREvents = container.Events,
};
//setup a new order
var order = new Order()
{
DCRGraph = graph,
OrderDate = orderInfo.OrderDate,
Notes = orderInfo.Notes,
Table = orderInfo.Table,
OrderDetails = new List<OrderDetail>(),
OrderType = orderInfo.OrderType,
RestaurantId = orderInfo.Restaurant
};
//put items on the order. Can only put items that exists in the database on.
foreach (var iq in orderInfo.ItemsAndQuantity)
{
var item =
db.Items
.FirstOrDefaultAsync(i => i.Name == iq.Key.Name).Result;
if (!iq.Key.Name.ToLower().Equals(item.Name.ToLower()))
{
throw new Exception("Item '" + iq.Key.Name + "' did not exist in the database");
}
order.OrderDetails.Add(
new OrderDetail()
{
ItemId = item.Id,
Item = item,
Order = order,
Quantity = iq.Value
});
}
//Determine if there should be a customer on the order. We do not want cutstomers with the phone number 0.
if(orderInfo.Customer.Phone != 0)
{
//see if we already have customer with the same phone number, otherwise create a new one.
var customer =
await db.Customers
.FirstOrDefaultAsync(c => c.Phone == orderInfo.Customer.Phone) ?? new Customer
{
City = orderInfo.Customer.City ?? "n/a",
Email = orderInfo.Customer.Email ?? "n/a",
FirstName = orderInfo.Customer.FirstAndMiddleNames ?? "n/a",
LastName = orderInfo.Customer.LastName ?? "n/a",
Phone = orderInfo.Customer.Phone,
StreetAndNumber = orderInfo.Customer.StreetAndNumber ?? "n/a",
Zipcode = orderInfo.Customer.ZipCode,
Orders = new HashSet<Order> {order}
};
order.Customer = customer;
}
db.Orders.Add(order);
db.SaveChanges();
//put groups on events
foreach (var i in container.EventGroups)
{
var group = db.Groups.FirstOrDefaultAsync(x => x.Name.Equals(i.GroupName)).Result;
container.Events.Find(x => x.EventId.Equals(i.EventId)).Groups.Add(group);
}
//put roles on events
foreach (var i in container.EventRoles)
{
var role = db.Roles.FirstOrDefaultAsync(x => x.Name.Equals(i.RoleName)).Result;
container.Events.Find(x => x.EventId.Equals(i.EventId)).Roles.Add(role);
}
//put inclusions on events
foreach (var i in container.Inclusions)
{
var fromEvent = container.Events.Find(x => x.EventId.Equals(i.fromNodeId));
var toEvent = container.Events.Find(x => x.EventId.Equals(i.toNodeId));
container.Events.Find(e => e.Id == fromEvent.Id).Includes.Add(toEvent);
//InsertBySqlQuery(fromEvent.Id, toEvent.Id, "Includes");
}
//put exclusions on events
foreach (var i in container.Exclusions)
{
var fromEvent = container.Events.Find(x => x.EventId.Equals(i.fromNodeId));
var toEvent = container.Events.Find(x => x.EventId.Equals(i.toNodeId));
container.Events.Find(e => e.Id == fromEvent.Id).Excludes.Add(toEvent);
//InsertBySqlQuery(fromEvent.Id, toEvent.Id, "Excludes");
}
//put responses on events
foreach (var i in container.Responses)
{
var fromEvent = container.Events.Find(x => x.EventId.Equals(i.fromNodeId));
var toEvent = container.Events.Find(x => x.EventId.Equals(i.toNodeId));
container.Events.Find(e => e.Id == fromEvent.Id).Responses.Add(toEvent);
//InsertBySqlQuery(fromEvent.Id, toEvent.Id, "Milestones");
}
//put conditions on events
foreach (var i in container.Conditions)
{
var fromEvent = container.Events.Find(x => x.EventId.Equals(i.fromNodeId));
var toEvent = container.Events.Find(x => x.EventId.Equals(i.toNodeId));
container.Events.Find(e => e.Id == fromEvent.Id).Conditions.Add(toEvent);
//InsertBySqlQuery(fromEvent.Id, toEvent.Id, "Conditions");
}
//put milestones on events
foreach (var i in container.Milestones)
{
var fromEvent = container.Events.Find(x => x.EventId.Equals(i.fromNodeId));
var toEvent = container.Events.Find(x => x.EventId.Equals(i.toNodeId));
container.Events.Find(e => e.Id == fromEvent.Id).Milestones.Add(toEvent);
//InsertBySqlQuery(fromEvent.Id, toEvent.Id, "Milestones");
}
foreach (var e in container.Events)
{
db.Entry(e).State = EntityState.Modified;
}
await db.SaveChangesAsync();
//needs statuscode exception handling
DCREvent dcrEvent;
switch (orderInfo.OrderType)
{
case "For serving":
dcrEvent = order.DCRGraph.DCREvents.FirstOrDefault(e => e.Label == "Setup graph serving");
if (dcrEvent != null)
{
await new DbInteractions().ExecuteEvent(dcrEvent.Id, false);
break;
}
return new Tuple<string, HttpStatusCode>("The DCRGraph does not contain the relvant setup event",
HttpStatusCode.InternalServerError);
case "For takeaway":
dcrEvent = order.DCRGraph.DCREvents.FirstOrDefault(e => e.Label == "Setup graph takeaway");
if (dcrEvent != null)
{
await new DbInteractions().ExecuteEvent(dcrEvent.Id, false);
break;
}
return new Tuple<string, HttpStatusCode>("The DCRGraph does not contain the relvant setup event",
HttpStatusCode.InternalServerError);
case "For delivery":
dcrEvent = order.DCRGraph.DCREvents.FirstOrDefault(e => e.Label.Contains("Setup graph delivery"));
if (dcrEvent != null)
{
await new DbInteractions().ExecuteEvent(dcrEvent.Id, false);
break;
}
return new Tuple<string, HttpStatusCode>("The DCRGraph does not contain the relvant setup event",
HttpStatusCode.InternalServerError);
case "Bulk order":
dcrEvent = order.DCRGraph.DCREvents.FirstOrDefault(e => e.Label.Contains("Setup bulk order"));
if (dcrEvent != null)
{
await new DbInteractions().ExecuteEvent(dcrEvent.Id, false);
break;
}
return new Tuple<string, HttpStatusCode>("The DCRGraph does not contain the relvant setup event",
HttpStatusCode.InternalServerError);
default:
return new Tuple<string, HttpStatusCode>("ordertype id not match - " + orderInfo.OrderType,
HttpStatusCode.InternalServerError);
}
//scope.Complete();
return new Tuple<string, HttpStatusCode>("success", HttpStatusCode.OK);
}
catch (Exception ex)
{
return new Tuple<string, HttpStatusCode>(ex.Message, HttpStatusCode.InternalServerError);
}
//}
}
}
/// <summary>
/// Medthod to execute an event in the database. Will only execute the event if its relations allow it.
/// If the execution results in the DCRGraph which the event belongs to, entered or exiting acceting state, the state will be updated accordingly.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task<Tuple<string, HttpStatusCode>> PreExecuteEvent(int id, bool preLocked, Database db)
{
try
{
var eventToBeExecuted = await db.DCREvents
.Include(e => e.Groups)
.Include(e => e.Roles)
.Include(e => e.Conditions)
.Include(e => e.Excludes)
.Include(e => e.Includes)
.Include(e => e.Responses)
.Include(e => e.Milestones)
.FirstOrDefaultAsync(e => e.Id == id);
//preconditions:
//the event must be included
if (eventToBeExecuted.Included == false) return new Tuple<string, HttpStatusCode>("Trying to execute excluded event", HttpStatusCode.InternalServerError);
//check if conditions are executed
foreach (var condition in eventToBeExecuted.Conditions)
{
if (condition.Executed == false && condition.Included) return new Tuple<string, HttpStatusCode>("A condition is not executed", HttpStatusCode.InternalServerError);
}
//there must not be a pending milestone
foreach (var milestone in eventToBeExecuted.Milestones)
{
var mEvent = await db.DCREvents.FirstOrDefaultAsync(e => e.Id == milestone.Id);
if (milestone.Pending && milestone.Included) return new Tuple<string, HttpStatusCode>("There is a pending milestone", HttpStatusCode.InternalServerError);
}
//Preconditions have succeded!
//Better see if we can lock before we do anything else.
//If we were called by an update order, the order is already locked for us.
var guid = Guid.NewGuid();
Tuple<bool, string> tryLock = null;
if (!preLocked)
{
tryLock = await this.LockGraph(guid, eventToBeExecuted.DCRGraphId, db);
if (tryLock.Item1 == false)
return new Tuple<string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError);
}
//Setup postconditions:
eventToBeExecuted.Pending = false;
eventToBeExecuted.Executed = true;
//exclude related events
foreach (var e in eventToBeExecuted.Excludes)
{
e.Included = false;
}
//Include related events
foreach (var e in eventToBeExecuted.Includes)
{
e.Included = true;
}
//set related events pending
foreach (var e in eventToBeExecuted.Responses)
{
e.Pending = true;
}
//set state to modified and save.
db.Entry(eventToBeExecuted).State = EntityState.Modified;
if (!preLocked)
{
var checkLock = await this.CheckLock(guid, eventToBeExecuted.DCRGraphId, db);
if (checkLock.Item1 == false)
return new Tuple<string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError);
}
await db.SaveChangesAsync();
//get the modified order from the database to check whether it has gone into accepting state
var order = await (from o in db.Orders
.Include(o => o.DCRGraph.DCREvents)
where o.DCRGraph.Id == eventToBeExecuted.DCRGraphId
select o).FirstOrDefaultAsync();
//remove accepting state if we have left it.
if (order.DCRGraph.DCREvents.Any(dcrEvent => dcrEvent.Included && dcrEvent.Pending))
{
if (order.DCRGraph.AcceptingState)
{
order.DCRGraph.AcceptingState = false;
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
var order2 = await (from o in db.Orders
.Include(o => o.DCRGraph.DCREvents)
where o.DCRGraph.Id == eventToBeExecuted.DCRGraphId
select o).FirstOrDefaultAsync();
}
if (!preLocked)
{
var unlock1 = await this.Unlock(guid, eventToBeExecuted.DCRGraphId, db);
if (unlock1.Item1 == false)
return new Tuple<string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError);
}
return new Tuple<string, HttpStatusCode>("Success but not accepting state", HttpStatusCode.OK);
}
//if already accepting, leave it as is.
if (order.DCRGraph.AcceptingState)
{
if (!preLocked)
{
var unlock2 = await this.Unlock(guid, eventToBeExecuted.DCRGraphId, db);
if (unlock2.Item1 == false)
return new Tuple<string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError);
}
return new Tuple<string, HttpStatusCode>("Success and accepting state", HttpStatusCode.OK);
}
//if not already accepting, set accepting
order.DCRGraph.AcceptingState = true;
db.Entry(order.DCRGraph).State = EntityState.Modified;
await db.SaveChangesAsync();
if (!preLocked)
{
var unlock2 = await this.Unlock(guid, eventToBeExecuted.DCRGraphId, db);
if (unlock2.Item1 == false)
return new Tuple<string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError);
}
return new Tuple<string, HttpStatusCode>("Success and accepting state", HttpStatusCode.OK);
}
catch (Exception ex)
{
return new Tuple<string, HttpStatusCode>(ex.Message, HttpStatusCode.InternalServerError);
}
}
/// <summary>
/// Method to archive an order in the database.
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public async Task<Tuple<string, HttpStatusCode>> AchiveOrder(int order)
{
try
{
using (var db = new Database())
{
var orderToBeArchived = await db.Orders
.Include(o => o.DCRGraph)
.FirstOrDefaultAsync(o => o.Id == order);
//this order did not exist
if (orderToBeArchived == null)
return new Tuple<string, HttpStatusCode>("The order did not exist in the Database", HttpStatusCode.InternalServerError);
//the order exists, better lock before we change anything.
var guid = Guid.NewGuid();
var tryLock = await this.LockGraph(guid, orderToBeArchived.DCRGraph.Id, db);
if (tryLock.Item1 == false)
return new Tuple<string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError);
//change to archived
orderToBeArchived.Archived = true;
db.Entry(orderToBeArchived).State = EntityState.Modified;
//lets be absolutely sure we have the lock before we change the db
var checkLock = await this.CheckLock(guid, orderToBeArchived.DCRGraph.Id, db);
if (checkLock.Item1 == false)
return new Tuple<string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError);
//save to db
await db.SaveChangesAsync();
//we're done, better unlock
var unlock = await this.Unlock(guid, orderToBeArchived.DCRGraph.Id, db);
if (unlock.Item1 == false)
return new Tuple<string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError);
return new Tuple<string, HttpStatusCode>("Success", HttpStatusCode.OK);
}
}
catch (Exception ex)
{
return new Tuple<string, HttpStatusCode>(
ex.Message, HttpStatusCode.InternalServerError);
}
}
/// <summary>
/// Method to update an order in the database.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public async Task<Tuple<string, HttpStatusCode>> UpdateOrder(Tuple<DROM_Client.Models.BusinessObjects.Order, List<int>> data)
{
try
{
using (var db = new Database())
{
//try to lock the order
var guid = Guid.NewGuid();
var tryLock = await this.LockGraph(guid, data.Item1.DCRGraph.Id, db);
if (tryLock.Item1 == false)
return new Tuple<string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError);
//Execute edit events
foreach (var i in data.Item2)
{
var status = await this.PreExecuteEvent(i, true, db);
if (status.Item2 != HttpStatusCode.OK)
return status; //Preconditions were not meet
}
var orderToBeUpdated = await db.Orders
.Include(o => o.OrderDetails.Select(od => od.Item))
.Include(o => o.Customer)
.FirstOrDefaultAsync(o => o.Id == data.Item1.Id);
//update related customer - it is not possible to have the phone number 0.
if (data.Item1.Customer.Phone != 0)
{
if (orderToBeUpdated.Customer == null)
{
orderToBeUpdated.Customer = new DBObjects.Customer()
{
City = data.Item1.Customer.City,
Email = data.Item1.Customer.Email,
FirstName = data.Item1.Customer.FirstAndMiddleNames,
LastName = data.Item1.Customer.LastName,
Phone = data.Item1.Customer.Phone,
StreetAndNumber = data.Item1.Customer.StreetAndNumber,
Zipcode = data.Item1.Customer.ZipCode
};
db.Entry(orderToBeUpdated.Customer).State = EntityState.Added;
}
else
{
orderToBeUpdated.Customer.City = data.Item1.Customer.City;
orderToBeUpdated.Customer.Email = data.Item1.Customer.Email;
orderToBeUpdated.Customer.FirstName = data.Item1.Customer.FirstAndMiddleNames;
orderToBeUpdated.Customer.LastName = data.Item1.Customer.LastName;
orderToBeUpdated.Customer.Phone = data.Item1.Customer.Phone;
orderToBeUpdated.Customer.StreetAndNumber = data.Item1.Customer.StreetAndNumber;
orderToBeUpdated.Customer.Zipcode = data.Item1.Customer.ZipCode;
}
}
//update the order
orderToBeUpdated.Notes = data.Item1.Notes;
orderToBeUpdated.Table = data.Item1.Table;
orderToBeUpdated.OrderType = data.Item1.OrderType;
db.OrderDetails.RemoveRange(orderToBeUpdated.OrderDetails);
var newOrderDetails = new HashSet<OrderDetail>();
foreach (var iq in data.Item1.ItemsAndQuantity)
{
var item = await db.Items.FirstOrDefaultAsync(i => i.Id == iq.Item.Id);
var order = await db.Orders.FirstOrDefaultAsync(o => o.Id == data.Item1.Id);
newOrderDetails.Add(new OrderDetail()
{
Item = item,
ItemId = item.Id,
Order = order,
OrderId = order.Id,
Quantity = iq.Quantity
});
}
db.OrderDetails.AddRange(orderToBeUpdated.OrderDetails);
orderToBeUpdated.OrderDetails = newOrderDetails;
//Check if we have a lock before saving to db
var checkLock = await this.CheckLock(guid, data.Item1.DCRGraph.Id, db);
if (checkLock.Item1 == false)
return new Tuple<string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError);
//we have a lock! Saving to db
db.Entry(orderToBeUpdated).State = EntityState.Modified;
await db.SaveChangesAsync();
//unlock after are done saving
var unlock = await this.Unlock(guid, data.Item1.DCRGraph.Id, db);
if (unlock.Item1 == false)
return new Tuple<string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError);
return new Tuple<string, HttpStatusCode>("Success", HttpStatusCode.OK);
}
}
catch (Exception ex)
{
return new Tuple<string, HttpStatusCode>(ex.Message, HttpStatusCode.InternalServerError);
}
}
/// <summary>
/// Medthod to execute an event in the database. Will only execute the event if its relations allow it.
/// If the execution results in the DCRGraph which the event belongs to, entered or exiting acceting state, the state will be updated accordingly.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <Tuple <string, HttpStatusCode> > PreExecuteEvent(int id, bool preLocked, Database db)
{
try
{
var eventToBeExecuted = await db.DCREvents
.Include(e => e.Groups)
.Include(e => e.Roles)
.Include(e => e.Conditions)
.Include(e => e.Excludes)
.Include(e => e.Includes)
.Include(e => e.Responses)
.Include(e => e.Milestones)
.FirstOrDefaultAsync(e => e.Id == id);
//preconditions:
//the event must be included
if (eventToBeExecuted.Included == false)
{
return(new Tuple <string, HttpStatusCode>("Trying to execute excluded event", HttpStatusCode.InternalServerError));
}
//check if conditions are executed
foreach (var condition in eventToBeExecuted.Conditions)
{
if (condition.Executed == false && condition.Included)
{
return(new Tuple <string, HttpStatusCode>("A condition is not executed", HttpStatusCode.InternalServerError));
}
}
//there must not be a pending milestone
foreach (var milestone in eventToBeExecuted.Milestones)
{
var mEvent = await db.DCREvents.FirstOrDefaultAsync(e => e.Id == milestone.Id);
if (milestone.Pending && milestone.Included)
{
return(new Tuple <string, HttpStatusCode>("There is a pending milestone", HttpStatusCode.InternalServerError));
}
}
//Preconditions have succeded!
//Better see if we can lock before we do anything else.
//If we were called by an update order, the order is already locked for us.
var guid = Guid.NewGuid();
Tuple <bool, string> tryLock = null;
if (!preLocked)
{
tryLock = await this.LockGraph(guid, eventToBeExecuted.DCRGraphId, db);
if (tryLock.Item1 == false)
{
return(new Tuple <string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError));
}
}
//Setup postconditions:
eventToBeExecuted.Pending = false;
eventToBeExecuted.Executed = true;
//exclude related events
foreach (var e in eventToBeExecuted.Excludes)
{
e.Included = false;
}
//Include related events
foreach (var e in eventToBeExecuted.Includes)
{
e.Included = true;
}
//set related events pending
foreach (var e in eventToBeExecuted.Responses)
{
e.Pending = true;
}
//set state to modified and save.
db.Entry(eventToBeExecuted).State = EntityState.Modified;
if (!preLocked)
{
var checkLock = await this.CheckLock(guid, eventToBeExecuted.DCRGraphId, db);
if (checkLock.Item1 == false)
{
return(new Tuple <string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError));
}
}
await db.SaveChangesAsync();
//get the modified order from the database to check whether it has gone into accepting state
var order = await(from o in db.Orders
.Include(o => o.DCRGraph.DCREvents)
where o.DCRGraph.Id == eventToBeExecuted.DCRGraphId
select o).FirstOrDefaultAsync();
//remove accepting state if we have left it.
if (order.DCRGraph.DCREvents.Any(dcrEvent => dcrEvent.Included && dcrEvent.Pending))
{
if (order.DCRGraph.AcceptingState)
{
order.DCRGraph.AcceptingState = false;
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
var order2 = await(from o in db.Orders
.Include(o => o.DCRGraph.DCREvents)
where o.DCRGraph.Id == eventToBeExecuted.DCRGraphId
select o).FirstOrDefaultAsync();
}
if (!preLocked)
{
var unlock1 = await this.Unlock(guid, eventToBeExecuted.DCRGraphId, db);
if (unlock1.Item1 == false)
{
return(new Tuple <string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError));
}
}
return(new Tuple <string, HttpStatusCode>("Success but not accepting state", HttpStatusCode.OK));
}
//if already accepting, leave it as is.
if (order.DCRGraph.AcceptingState)
{
if (!preLocked)
{
var unlock2 = await this.Unlock(guid, eventToBeExecuted.DCRGraphId, db);
if (unlock2.Item1 == false)
{
return(new Tuple <string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError));
}
}
return(new Tuple <string, HttpStatusCode>("Success and accepting state", HttpStatusCode.OK));
}
//if not already accepting, set accepting
order.DCRGraph.AcceptingState = true;
db.Entry(order.DCRGraph).State = EntityState.Modified;
await db.SaveChangesAsync();
if (!preLocked)
{
var unlock2 = await this.Unlock(guid, eventToBeExecuted.DCRGraphId, db);
if (unlock2.Item1 == false)
{
return(new Tuple <string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError));
}
}
return(new Tuple <string, HttpStatusCode>("Success and accepting state", HttpStatusCode.OK));
}
catch (Exception ex)
{
return(new Tuple <string, HttpStatusCode>(ex.Message, HttpStatusCode.InternalServerError));
}
}
/// <summary>
/// Method to update an order in the database.
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public async Task <Tuple <string, HttpStatusCode> > UpdateOrder(Tuple <DROM_Client.Models.BusinessObjects.Order, List <int> > data)
{
try
{
using (var db = new Database())
{
//try to lock the order
var guid = Guid.NewGuid();
var tryLock = await this.LockGraph(guid, data.Item1.DCRGraph.Id, db);
if (tryLock.Item1 == false)
{
return(new Tuple <string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError));
}
//Execute edit events
foreach (var i in data.Item2)
{
var status = await this.PreExecuteEvent(i, true, db);
if (status.Item2 != HttpStatusCode.OK)
{
return(status); //Preconditions were not meet
}
}
var orderToBeUpdated = await db.Orders
.Include(o => o.OrderDetails.Select(od => od.Item))
.Include(o => o.Customer)
.FirstOrDefaultAsync(o => o.Id == data.Item1.Id);
//update related customer - it is not possible to have the phone number 0.
if (data.Item1.Customer.Phone != 0)
{
if (orderToBeUpdated.Customer == null)
{
orderToBeUpdated.Customer = new DBObjects.Customer()
{
City = data.Item1.Customer.City,
Email = data.Item1.Customer.Email,
FirstName = data.Item1.Customer.FirstAndMiddleNames,
LastName = data.Item1.Customer.LastName,
Phone = data.Item1.Customer.Phone,
StreetAndNumber = data.Item1.Customer.StreetAndNumber,
Zipcode = data.Item1.Customer.ZipCode
};
db.Entry(orderToBeUpdated.Customer).State = EntityState.Added;
}
else
{
orderToBeUpdated.Customer.City = data.Item1.Customer.City;
orderToBeUpdated.Customer.Email = data.Item1.Customer.Email;
orderToBeUpdated.Customer.FirstName = data.Item1.Customer.FirstAndMiddleNames;
orderToBeUpdated.Customer.LastName = data.Item1.Customer.LastName;
orderToBeUpdated.Customer.Phone = data.Item1.Customer.Phone;
orderToBeUpdated.Customer.StreetAndNumber = data.Item1.Customer.StreetAndNumber;
orderToBeUpdated.Customer.Zipcode = data.Item1.Customer.ZipCode;
}
}
//update the order
orderToBeUpdated.Notes = data.Item1.Notes;
orderToBeUpdated.Table = data.Item1.Table;
orderToBeUpdated.OrderType = data.Item1.OrderType;
db.OrderDetails.RemoveRange(orderToBeUpdated.OrderDetails);
var newOrderDetails = new HashSet <OrderDetail>();
foreach (var iq in data.Item1.ItemsAndQuantity)
{
var item = await db.Items.FirstOrDefaultAsync(i => i.Id == iq.Item.Id);
var order = await db.Orders.FirstOrDefaultAsync(o => o.Id == data.Item1.Id);
newOrderDetails.Add(new OrderDetail()
{
Item = item,
ItemId = item.Id,
Order = order,
OrderId = order.Id,
Quantity = iq.Quantity
});
}
db.OrderDetails.AddRange(orderToBeUpdated.OrderDetails);
orderToBeUpdated.OrderDetails = newOrderDetails;
//Check if we have a lock before saving to db
var checkLock = await this.CheckLock(guid, data.Item1.DCRGraph.Id, db);
if (checkLock.Item1 == false)
{
return(new Tuple <string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError));
}
//we have a lock! Saving to db
db.Entry(orderToBeUpdated).State = EntityState.Modified;
await db.SaveChangesAsync();
//unlock after are done saving
var unlock = await this.Unlock(guid, data.Item1.DCRGraph.Id, db);
if (unlock.Item1 == false)
{
return(new Tuple <string, HttpStatusCode>(tryLock.Item2, HttpStatusCode.InternalServerError));
}
return(new Tuple <string, HttpStatusCode>("Success", HttpStatusCode.OK));
}
}
catch (Exception ex)
{
return(new Tuple <string, HttpStatusCode>(ex.Message, HttpStatusCode.InternalServerError));
}
}
/// <summary>
/// Method to create new orders in the database.
/// It will create a new order with the information it receives and with the DCRGraph which is currently in the xml file which the API reads from.
/// </summary>
/// <param name="container"></param>
/// <param name="orderInfo"></param>
/// <returns></returns>
public async Task <Tuple <string, HttpStatusCode> > CreateOrder(EventAndRolesContainer container, NewOrderInfo orderInfo)
{
using (var db = new WebAPI.Models.DBObjects.Database())
{
try
{
//setup a new dcrgraph
var graph = new DCRGraph
{
AcceptingState = false,
Lock = false,
LockTime = DateTime.Now,
DCREvents = container.Events,
};
//setup a new order
var order = new Order()
{
DCRGraph = graph,
OrderDate = orderInfo.OrderDate,
Notes = orderInfo.Notes,
Table = orderInfo.Table,
OrderDetails = new List <OrderDetail>(),
OrderType = orderInfo.OrderType,
RestaurantId = orderInfo.Restaurant
};
//put items on the order. Can only put items that exists in the database on.
foreach (var iq in orderInfo.ItemsAndQuantity)
{
var item =
db.Items
.FirstOrDefaultAsync(i => i.Name == iq.Key.Name).Result;
if (!iq.Key.Name.ToLower().Equals(item.Name.ToLower()))
{
throw new Exception("Item '" + iq.Key.Name + "' did not exist in the database");
}
order.OrderDetails.Add(
new OrderDetail()
{
ItemId = item.Id,
Item = item,
Order = order,
Quantity = iq.Value
});
}
//Determine if there should be a customer on the order. We do not want cutstomers with the phone number 0.
if (orderInfo.Customer.Phone != 0)
{
//see if we already have customer with the same phone number, otherwise create a new one.
var customer =
await db.Customers
.FirstOrDefaultAsync(c => c.Phone == orderInfo.Customer.Phone) ?? new Customer
{
City = orderInfo.Customer.City ?? "n/a",
Email = orderInfo.Customer.Email ?? "n/a",
FirstName = orderInfo.Customer.FirstAndMiddleNames ?? "n/a",
LastName = orderInfo.Customer.LastName ?? "n/a",
Phone = orderInfo.Customer.Phone,
StreetAndNumber = orderInfo.Customer.StreetAndNumber ?? "n/a",
Zipcode = orderInfo.Customer.ZipCode,
Orders = new HashSet <Order> {
order
}
};
order.Customer = customer;
}
db.Orders.Add(order);
db.SaveChanges();
//put groups on events
foreach (var i in container.EventGroups)
{
var group = db.Groups.FirstOrDefaultAsync(x => x.Name.Equals(i.GroupName)).Result;
container.Events.Find(x => x.EventId.Equals(i.EventId)).Groups.Add(group);
}
//put roles on events
foreach (var i in container.EventRoles)
{
var role = db.Roles.FirstOrDefaultAsync(x => x.Name.Equals(i.RoleName)).Result;
container.Events.Find(x => x.EventId.Equals(i.EventId)).Roles.Add(role);
}
//put inclusions on events
foreach (var i in container.Inclusions)
{
var fromEvent = container.Events.Find(x => x.EventId.Equals(i.fromNodeId));
var toEvent = container.Events.Find(x => x.EventId.Equals(i.toNodeId));
container.Events.Find(e => e.Id == fromEvent.Id).Includes.Add(toEvent);
//InsertBySqlQuery(fromEvent.Id, toEvent.Id, "Includes");
}
//put exclusions on events
foreach (var i in container.Exclusions)
{
var fromEvent = container.Events.Find(x => x.EventId.Equals(i.fromNodeId));
var toEvent = container.Events.Find(x => x.EventId.Equals(i.toNodeId));
container.Events.Find(e => e.Id == fromEvent.Id).Excludes.Add(toEvent);
//InsertBySqlQuery(fromEvent.Id, toEvent.Id, "Excludes");
}
//put responses on events
foreach (var i in container.Responses)
{
var fromEvent = container.Events.Find(x => x.EventId.Equals(i.fromNodeId));
var toEvent = container.Events.Find(x => x.EventId.Equals(i.toNodeId));
container.Events.Find(e => e.Id == fromEvent.Id).Responses.Add(toEvent);
//InsertBySqlQuery(fromEvent.Id, toEvent.Id, "Milestones");
}
//put conditions on events
foreach (var i in container.Conditions)
{
var fromEvent = container.Events.Find(x => x.EventId.Equals(i.fromNodeId));
var toEvent = container.Events.Find(x => x.EventId.Equals(i.toNodeId));
container.Events.Find(e => e.Id == fromEvent.Id).Conditions.Add(toEvent);
//InsertBySqlQuery(fromEvent.Id, toEvent.Id, "Conditions");
}
//put milestones on events
foreach (var i in container.Milestones)
{
var fromEvent = container.Events.Find(x => x.EventId.Equals(i.fromNodeId));
var toEvent = container.Events.Find(x => x.EventId.Equals(i.toNodeId));
container.Events.Find(e => e.Id == fromEvent.Id).Milestones.Add(toEvent);
//InsertBySqlQuery(fromEvent.Id, toEvent.Id, "Milestones");
}
foreach (var e in container.Events)
{
db.Entry(e).State = EntityState.Modified;
}
await db.SaveChangesAsync();
//needs statuscode exception handling
DCREvent dcrEvent;
switch (orderInfo.OrderType)
{
case "For serving":
dcrEvent = order.DCRGraph.DCREvents.FirstOrDefault(e => e.Label == "Setup graph serving");
if (dcrEvent != null)
{
await new DbInteractions().ExecuteEvent(dcrEvent.Id, false);
break;
}
return(new Tuple <string, HttpStatusCode>("The DCRGraph does not contain the relvant setup event",
HttpStatusCode.InternalServerError));
case "For takeaway":
dcrEvent = order.DCRGraph.DCREvents.FirstOrDefault(e => e.Label == "Setup graph takeaway");
if (dcrEvent != null)
{
await new DbInteractions().ExecuteEvent(dcrEvent.Id, false);
break;
}
return(new Tuple <string, HttpStatusCode>("The DCRGraph does not contain the relvant setup event",
HttpStatusCode.InternalServerError));
case "For delivery":
dcrEvent = order.DCRGraph.DCREvents.FirstOrDefault(e => e.Label.Contains("Setup graph delivery"));
if (dcrEvent != null)
{
await new DbInteractions().ExecuteEvent(dcrEvent.Id, false);
break;
}
return(new Tuple <string, HttpStatusCode>("The DCRGraph does not contain the relvant setup event",
HttpStatusCode.InternalServerError));
case "Bulk order":
dcrEvent = order.DCRGraph.DCREvents.FirstOrDefault(e => e.Label.Contains("Setup bulk order"));
if (dcrEvent != null)
{
await new DbInteractions().ExecuteEvent(dcrEvent.Id, false);
break;
}
return(new Tuple <string, HttpStatusCode>("The DCRGraph does not contain the relvant setup event",
HttpStatusCode.InternalServerError));
default:
return(new Tuple <string, HttpStatusCode>("ordertype id not match - " + orderInfo.OrderType,
HttpStatusCode.InternalServerError));
}
//scope.Complete();
return(new Tuple <string, HttpStatusCode>("success", HttpStatusCode.OK));
}
catch (Exception ex)
{
return(new Tuple <string, HttpStatusCode>(ex.Message, HttpStatusCode.InternalServerError));
}
//}
}
}