/// <summary>
/// constructor by data row
/// </summary>
/// <param name="row"></param>
public BLOrderDetail(DataRow row)
{
Amount = int.Parse(row["Amount"].ToString());
Product = new BLProduct(row)
{
Price = (double.Parse(row["DetailPrice"].ToString())) / Amount
};
}
/// <summary>
///
/// </summary>
/// <param name="products"></param>
/// <param name="amounts"></param>
/// <returns> string that describe the list</returns>
public static string GetProductString(List <BLOrderDetailsDB> orderDetails)
{
string ProductString = "";
for (int i = 0; i < orderDetails.Count; i++)
{
BLOrderDetailsDB orderDetail = orderDetails[i];
BLProduct product = BLProduct.GetProductById(orderDetail.productId);
ProductString += "<br/>" + product.ToString() + " amount-" + orderDetail.amount;
}
return(ProductString);
}
/// <summary>
///
/// </summary>
/// <param name="products"></param>
/// <param name="product"></param>
/// <returns>the Index Of Product</returns>
public static int IndexOfProduct(List <BLProduct> products, BLProduct product)
{
for (var index = 0; index < products.Count; index++)
{
var p = products[index];
if (p.Id == product.Id)
{
return(index);
}
}
return(-1);
}
/// <summary>
/// search product
/// </summary>
/// <param name="SearchVal"></param>
/// <param name="shopId"></param>
/// <param name="isSearchName"></param>
/// <param name="orderBy"></param>
/// <returns>a list of BLProduct that match the searched value</returns>
public static List <BLProduct> Search(string SearchVal, int shopId, bool isSearchName, int orderBy)
{
string condition = "";
List <BLProduct> products = null;
if (shopId == -1)
{
if (isSearchName)
{
condition = $"WHERE Description='{SearchVal}'";
}
else
{
condition = "WHERE Price=" + SearchVal;
}
condition += setOrderBy(orderBy);
products = BLProduct.GetAllProducts(condition);
}
else
{
if (isSearchName)
{
condition = $"AND Description='{SearchVal}'";
}
else
{
condition = "AND Price=" + SearchVal;
}
condition += setOrderBy(orderBy);
products = BLProduct.GetAllProductsByShopId(shopId, condition);
}
if (products == null || products.Count == 0)
{
return(null);
}
return(products);
}
/// <summary>
/// constructor by BLOrderDetail
/// </summary>
/// <param name="orderDetailsDb"></param>
public BLOrderDetail(BLOrderDetailsDB orderDetailsDb)
{
Product = BLProduct.GetProductById(orderDetailsDb.productId);
Amount = orderDetailsDb.amount;
}
/// <summary>
/// constructor
/// </summary>
/// <param name="product"></param>
/// <param name="amount"></param>
public BLOrderDetail(BLProduct product, int amount)
{
Product = product;
Amount = amount;
}
