public void AddItem(Plot plot)
{
var tempOrderId = GetTempOrderId();
var order = DataContext.Orders.FirstOrDefault(x => tempOrderId == x.Guid.ToString());
if (order != null)
{
order.Plots.Add(plot);
}
else
{
var plotList = new EntitySet <Plot> {
plot
};
order = new Order()
{
Guid = new Guid(tempOrderId),
Plots = plotList
};
DataContext.Orders.InsertOnSubmit(order);
}
try
{
DataContext.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public bool FinalizePurchase(string orderId)
{
var result = false;
// Begin transaction
using (var transaction = new TransactionScope())
{
try
{
var dbOrder = DataContext.Orders.FirstOrDefault(x => new Guid(orderId) == x.Guid);
if (dbOrder == null)
{
throw new ArgumentException("Order Not Found");
}
dbOrder.DateOfCompletion = DateTime.Now;
DataContext.SubmitChanges();
result = true;
transaction.Complete();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
return(result);
}
public int TieAccountClient(string email, string firstName, string lastName, DateTime dateOfBirth)
{
var userData = DataContext.AspNetUsers.FirstOrDefault(x => x.Email == email);
var client = new Client()
{
UserID = userData.Id,
DateOfBirth = dateOfBirth,
FirstName = firstName,
LastName = lastName
};
DataContext.Clients.InsertOnSubmit(client);
DataContext.SubmitChanges();
var dbClient = DataContext.Clients.First(x => x.UserID == client.UserID);
return(dbClient.ClientID);
}