/// <summary>
/// update status by orderproduct with the OrderId
/// </summary>
/// <param name="OrderId"></param>
/// <param name="Status"></param>
public void UpdateOrderProductStatusByOrderId(int OrderId, Statustype Status)
{
string query = "UPDATE [Order_Product] SET Status = @Status WHERE OrderId = @OrderId";
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("Status", (int)Status),
new SqlParameter("OrderId", OrderId)
};
ExecuteEditQuery(query, sqlParameters);
}
/// <summary>
/// update all orderproduct with an status
/// </summary>
/// <param name="orderProducts"></param>
/// <param name="Status"></param>
public void UpdateAllOrderProduct(List <OrderProduct> orderProducts, Statustype Status)
{
foreach (OrderProduct orderProduct in orderProducts)
{
dbConnection.Open();
SqlCommand command = new SqlCommand("UPDATE Order_Product SET Status = @Status WHERE Id = @OrderProductId", dbConnection);
command.Parameters.AddWithValue("@Status", (int)Status);
command.Parameters.AddWithValue("@OrderProductId", orderProduct.OrderProductId);
SqlDataReader reader = command.ExecuteReader();
dbConnection.Close();
}
}
/// <summary>
/// update status by orderproduct with the tablenumber
/// </summary>
/// <param name="Tablenumber"></param>
/// <param name="Status"></param>
/// <param name="type"></param>
public void UpdateOrderProductStatusByTablenumber(int Tablenumber, Statustype Status, string Type)
{
//string query = "UPDATE [Order_Product] SET Order_Product.Status = @Status FROM [Order_Product] AS P JOIN [Order] AS O ON P.OrderId = O.OrderId WHERE O.TableNumber = @Tablenumber AND P.ProductId " + type + " 22";
string query = "UPDATE [Order_Product] SET Order_Product.Status = @Status FROM[Order] AS O JOIN[Order_Product] AS OP ON O.OrderId = OP.OrderId JOIN[Product] AS P ON OP.ProductId = P.ProductId WHERE O.TableNumber = @Tablenumber AND P.ProductType = @Type";
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("Status", Status),
new SqlParameter("TableNumber", Tablenumber),
new SqlParameter("Type", Type)
};
ExecuteEditQuery(query, sqlParameters);
}
/// <summary>
/// update orderproducts by orderID
/// </summary>
/// <param name="OrderId"></param>
/// <param name="Status"></param>
public void UpdateOrderProductStatusByOrderId(int OrderId, Statustype Status)
{
DAO_OrderProduct.UpdateOrderProductStatusByOrderId(OrderId, Status);
}
/// <summary>
/// update orderproducts by tablenumber
/// </summary>
/// <param name="TableNumber"></param>
/// <param name="Status"></param>
/// <param name="type"></param>
public void UpdateOrderProductStatus(int TableNumber, Statustype Status, string type)
{
DAO_OrderProduct.UpdateOrderProductStatusByTablenumber(TableNumber, Status, type);
}
/// <summary>
/// update all status for all orderproduct in the list
/// </summary>
/// <param name="orderProduct"></param>
/// <param name="status"></param>
public void UpdateAllStatus(List <OrderProduct> orderProduct, Statustype status)
{
DAO_OrderProduct.UpdateAllOrderProduct(orderProduct, status);
}
/// <summary>
/// This method communicates with the OrderProduct_Service and asks to update the OrderProduct.Status Where Order.TableNumber is equal to the given parameter 'TableNumber' and Where Product.Id is greater or smaller than type.
/// </summary>
/// <param name="TableNumber"></param>
/// <param name="Status"></param>
/// <param name="type"></param>
public void UpdateOrderProductStatus(int TableNumber, Statustype Status, string type)
{
OrderProductService.UpdateOrderProductStatus(TableNumber, Status, type);
}
