public async Task <IActionResult> PutOrderItemDetails([FromRoute] int id, [FromBody] OrderItemDetails orderItemDetails)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != orderItemDetails.id)
{
return(BadRequest());
}
_context.Entry(orderItemDetails).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!OrderItemDetailsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
/// <summary>
/// Creates a new order
/// </summary>
public static int InsertOrder(ShoppingCart shoppingCart,
string shippingMethod, decimal shipping, string shippingFirstName,
string shippingLastName, string shippingStreet, string shippingPostalCode,
string shippingCity, string shippingState, string shippingCountry,
string customerEmail, string customerPhone, string customerFax, string transactionID)
{
using (TransactionScope scope = new TransactionScope())
{
string userName = BizObject.CurrentUserName;
// insert the master order
OrderDetails order = new OrderDetails(0, DateTime.Now,
userName, 1, "", shippingMethod, shoppingCart.Total, shipping,
shippingFirstName, shippingLastName, shippingStreet, shippingPostalCode,
shippingCity, shippingState, shippingCountry, customerEmail, customerPhone,
customerFax, DateTime.MinValue, transactionID, "");
int orderID = SiteProvider.Store.InsertOrder(order);
// insert the child order items
foreach (ShoppingCartItem item in shoppingCart.Items)
{
OrderItemDetails orderItem = new OrderItemDetails(0, DateTime.Now, userName,
orderID, item.ID, item.Title, item.SKU, item.UnitPrice, item.Quantity);
SiteProvider.Store.InsertOrderItem(orderItem);
}
BizObject.PurgeCacheItems("store_order");
scope.Complete();
return(orderID);
}
}
internal OrderItemResourceData(ResourceIdentifier id, string name, ResourceType resourceType, SystemData systemData, IDictionary <string, string> tags, AzureLocation location, OrderItemDetails orderItemDetails, AddressDetails addressDetails, DateTimeOffset?startOn, string orderId) : base(id, name, resourceType, systemData, tags, location)
{
OrderItemDetails = orderItemDetails;
AddressDetails = addressDetails;
StartOn = startOn;
OrderId = orderId;
}
///// <summary>
/////
///// </summary>
///// <param name="employeeID"></param>
///// <returns></returns>
public List <OrderDetails> GetOrderDetailsForApproval(int employeeID)
{
List <OrderDetails> OrderDetailsEntities = new List <OrderDetails>();
using (bookmytableEntities1 Context = new bookmytableEntities1())
{
//all orders
var result = Context.Sp_GetOrderDetailsToEmployee(employeeID, null).ToList();
// iterate on single order
foreach (var item in result)
{
OrderDetails orderdetail = new OrderDetails();
List <OrderItemDetails> orderItemDetails = new List <OrderItemDetails>();
if (item != null)
{
orderdetail.OrderID = item.OrderId;
orderdetail.TotalAmount = Convert.ToDecimal(item.TotalAmount);
//orderdetail.TotalQuantity = Convert.ToInt32(item.);
orderdetail.HotelId = item.HotelId.Value;
orderdetail.TableID = Convert.ToInt32(item.TableID);
orderdetail.IsApproveStatus = item.IsApproveStatus.Value;
//getting single order items list.
var orderItemListDetails = Context.Sp_GetOrderDetailsForWaiter(item.OrderId).ToList();
// iterating on all items of single order
for (int i = 0; i < orderItemListDetails.Count; i++)
{
var orderitem = new OrderItemDetails()
{
OrderId = orderItemListDetails[i].orderid,
TableId = orderItemListDetails[i].tableid.Value,
CustomerID = orderItemListDetails[i].customerid,
HotelId = orderItemListDetails[i].HotelId.Value,
Quantity = orderItemListDetails[i].Quantity.Value,
DishId = orderItemListDetails[i].DishId,
DishName = orderItemListDetails[i].DishName,
DishDescription = orderItemListDetails[i].DishDescription,
DishUnitPrice = orderItemListDetails[i].DishUnitPrice.Value,
DishTotalAmount = orderItemListDetails[i].DishTotalAmount.Value,
IsVeg = orderItemListDetails[i].IsVeg.Value,
imagePath = orderItemListDetails[i].imagePath
};
orderItemDetails.Add(orderitem); // adding order item to item list // creating list of order items.
}
orderdetail.OrderItemDetails = orderItemDetails; // adding order items list to order basic details
}
OrderDetailsEntities.Add(orderdetail); // finally creating list of orders with there order items inside them
} // iterate on single order ends
};
return(OrderDetailsEntities);
}
public async Task <IActionResult> PostOrderItemDetails([FromBody] OrderItemDetails orderItemDetails)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.orderItem.Add(orderItemDetails);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetOrderItemDetails", new { id = orderItemDetails.id }, orderItemDetails));
}
public OrderItemResourceData(AzureLocation location, OrderItemDetails orderItemDetails, AddressDetails addressDetails, string orderId) : base(location)
{
if (orderItemDetails == null)
{
throw new ArgumentNullException(nameof(orderItemDetails));
}
if (addressDetails == null)
{
throw new ArgumentNullException(nameof(addressDetails));
}
if (orderId == null)
{
throw new ArgumentNullException(nameof(orderId));
}
OrderItemDetails = orderItemDetails;
AddressDetails = addressDetails;
OrderId = orderId;
}
public OrderDetails GetEditOrderDetails(int OrderID, int CustomerId)
{
OrderDetails orderDetail = new OrderDetails();
bookmytableEntities1 Context = new bookmytableEntities1();
List <OrderItemDetails> orderitemDetails = new List <OrderItemDetails>();
var userData = (from cus in Context.CustomerTables where cus.Id == CustomerId
select new UserVw()
{
CustomerId = cus.Id, CustomerName = cus.CustomerName, Email = cus.EmailID
}).FirstOrDefault();
orderDetail.EmailID = userData.Email;
orderDetail.CustomerName = userData.CustomerName == null ? "" : userData.CustomerName;
orderDetail.IsApproveStatus = Context.salesOrderTables.Where(x => x.OrderID == OrderID).Select(x => x.IsApproveStatus.Value).FirstOrDefault();
var orderItemListDetails = Context.Sp_GetEditOrderDetails(OrderID, CustomerId).ToList();
for (int i = 0; i < orderItemListDetails.Count; i++)
{
var orderitem = new OrderItemDetails()
{
OrderId = orderItemListDetails[i].orderid,
TableId = orderItemListDetails[i].tableid.Value,
CustomerID = orderItemListDetails[i].customerid,
HotelId = orderItemListDetails[i].HotelId.Value,
Quantity = orderItemListDetails[i].Quantity.Value,
DishId = orderItemListDetails[i].DishId,
DishName = orderItemListDetails[i].DishName,
DishDescription = orderItemListDetails[i].DishDescription,
DishUnitPrice = orderItemListDetails[i].DishUnitPrice.Value,
DishTotalAmount = orderItemListDetails[i].DishTotalAmount.Value,
IsVeg = orderItemListDetails[i].IsVeg.Value,
imagePath = orderItemListDetails[i].imagePath
};
orderitemDetails.Add(orderitem);
}
orderDetail.OrderItemDetails = orderitemDetails;
return(orderDetail);
}
/// <summary>
///
/// </summary>
/// <param name="OrderID"></param>
/// <returns></returns>
public OrderDetails GetOrderDetails(int OrderID, string emailID)
{
OrderDetails orderDetails = new OrderDetails();
List <OrderItemDetails> orderitemDetails = new List <OrderItemDetails>();
using (bookmytableEntities1 Context = new bookmytableEntities1())
{
var result = Context.Sp_GetOrderDetails(OrderID, emailID).FirstOrDefault();
if (result != null)
{
orderDetails.OrderID = result.OrderID;
orderDetails.EmailID = result.EmailID;
orderDetails.TotalAmount = Convert.ToDecimal(result.TotalAmount);
orderDetails.TotalQuantity = Convert.ToInt32(result.TotalQuantity);
orderDetails.TableID = Convert.ToInt32(result.TableId);
orderDetails.CustomerID = Convert.ToInt32(result.CustomerId);
orderDetails.IsApproveStatus = result.IsApproveStatus.Value;
var orderItemListDetails = Context.Sp_GetEditOrderDetails(OrderID, result.CustomerId).ToList();
for (int i = 0; i < orderItemListDetails.Count; i++)
{
var orderitem = new OrderItemDetails()
{
OrderId = orderItemListDetails[i].orderid,
TableId = orderItemListDetails[i].tableid.Value,
CustomerID = orderItemListDetails[i].customerid,
HotelId = orderItemListDetails[i].HotelId.Value,
Quantity = orderItemListDetails[i].Quantity.Value,
DishId = orderItemListDetails[i].DishId,
DishName = orderItemListDetails[i].DishName,
DishUnitPrice = orderItemListDetails[i].DishUnitPrice.Value,
DishTotalAmount = orderItemListDetails[i].DishTotalAmount.Value,
IsVeg = orderItemListDetails[i].IsVeg.Value,
imagePath = orderItemListDetails[i].imagePath
};
orderitemDetails.Add(orderitem);
}
orderDetails.OrderItemDetails = orderitemDetails;
}
}
return(orderDetails);
}
/// <summary>
/// Inserts a new order item
/// </summary>
public override int InsertOrderItem(OrderItemDetails orderItem)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("tbh_Store_InsertOrderItem", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = orderItem.AddedDate;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = orderItem.AddedBy;
cmd.Parameters.Add("@OrderID", SqlDbType.Int).Value = orderItem.OrderID;
cmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = orderItem.ProductID;
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = orderItem.Title;
cmd.Parameters.Add("@SKU", SqlDbType.NVarChar).Value = orderItem.SKU;
cmd.Parameters.Add("@UnitPrice", SqlDbType.Money).Value = orderItem.UnitPrice;
cmd.Parameters.Add("@Quantity", SqlDbType.Int).Value = orderItem.Quantity;
cmd.Parameters.Add("@OrderItemID", SqlDbType.Int).Direction = ParameterDirection.Output;
cn.Open();
int ret = ExecuteNonQuery(cmd);
return((int)cmd.Parameters["@OrderItemID"].Value);
}
}
public IEnumerable <OrderItemDetails> GetAllOrderItemInfo(string s)
{
var orderId = Convert.ToInt32(s);
using (SqlConnection Connection = new SqlConnection(connectionString))
{
ICollection <OrderItemDetails> orderItemDetailses = new Collection <OrderItemDetails>();
SqlCommand Command = new SqlCommand();
Command.Connection = Connection;
Command.CommandText = "sp_OrderIntemDetails";
Command.CommandType = CommandType.StoredProcedure;
SqlParameter parameter = new SqlParameter("@OrderID", orderId);
Command.Parameters.Add(parameter);
Connection.Open();
SqlDataReader reader = Command.ExecuteReader();
while (reader.Read())
{
OrderItemDetails details = new OrderItemDetails();
details.ProductName = reader["ProductName"].ToString();
details.ProductQuantity = Convert.ToInt32(reader["Quantity"]);
details.ProductTotapPrice = Convert.ToInt64(reader["TotalPrice"]);
orderItemDetailses.Add(details);
}
reader.Close();
Connection.Close();
return(orderItemDetailses);
}
}
internal static OrderItemResourceData DeserializeOrderItemResourceData(JsonElement element)
{
IDictionary <string, string> tags = default;
AzureLocation location = default;
ResourceIdentifier id = default;
string name = default;
ResourceType type = default;
SystemData systemData = default;
OrderItemDetails orderItemDetails = default;
AddressDetails addressDetails = default;
Optional <DateTimeOffset> startTime = default;
string orderId = default;
foreach (var property in element.EnumerateObject())
{
if (property.NameEquals("tags"))
{
Dictionary <string, string> dictionary = new Dictionary <string, string>();
foreach (var property0 in property.Value.EnumerateObject())
{
dictionary.Add(property0.Name, property0.Value.GetString());
}
tags = dictionary;
continue;
}
if (property.NameEquals("location"))
{
location = new AzureLocation(property.Value.GetString());
continue;
}
if (property.NameEquals("id"))
{
id = new ResourceIdentifier(property.Value.GetString());
continue;
}
if (property.NameEquals("name"))
{
name = property.Value.GetString();
continue;
}
if (property.NameEquals("type"))
{
type = new ResourceType(property.Value.GetString());
continue;
}
if (property.NameEquals("systemData"))
{
systemData = JsonSerializer.Deserialize <SystemData>(property.Value.ToString());
continue;
}
if (property.NameEquals("properties"))
{
if (property.Value.ValueKind == JsonValueKind.Null)
{
property.ThrowNonNullablePropertyIsNull();
continue;
}
foreach (var property0 in property.Value.EnumerateObject())
{
if (property0.NameEquals("orderItemDetails"))
{
orderItemDetails = OrderItemDetails.DeserializeOrderItemDetails(property0.Value);
continue;
}
if (property0.NameEquals("addressDetails"))
{
addressDetails = AddressDetails.DeserializeAddressDetails(property0.Value);
continue;
}
if (property0.NameEquals("startTime"))
{
if (property0.Value.ValueKind == JsonValueKind.Null)
{
property0.ThrowNonNullablePropertyIsNull();
continue;
}
startTime = property0.Value.GetDateTimeOffset("O");
continue;
}
if (property0.NameEquals("orderId"))
{
orderId = property0.Value.GetString();
continue;
}
}
continue;
}
}
return(new OrderItemResourceData(id, name, type, systemData, tags, location, orderItemDetails, addressDetails, Optional.ToNullable(startTime), orderId));
}
public OrderItemViewModel(OrderItemDetails orderItem)
{
}
/// <summary>
/// Inserts a new order item
/// </summary>
public override int InsertOrderItem(OrderItemDetails orderItem)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("tbh_Store_InsertOrderItem", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = orderItem.AddedDate;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = orderItem.AddedBy;
cmd.Parameters.Add("@OrderID", SqlDbType.Int).Value = orderItem.OrderID;
cmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = orderItem.ProductID;
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = orderItem.Title;
cmd.Parameters.Add("@SKU", SqlDbType.NVarChar).Value = orderItem.SKU;
cmd.Parameters.Add("@UnitPrice", SqlDbType.Money).Value = orderItem.UnitPrice;
cmd.Parameters.Add("@Quantity", SqlDbType.Int).Value = orderItem.Quantity;
cmd.Parameters.Add("@OrderItemID", SqlDbType.Int).Direction = ParameterDirection.Output;
cn.Open();
int ret = ExecuteNonQuery(cmd);
return (int)cmd.Parameters["@OrderItemID"].Value;
}
}
