public static List <ReducedPriceProduct> GetProductsOnSoldNow(string m_id)
{
ISession session = SessionManager.GetSession();
List <ReducedPriceProduct> products = new List <ReducedPriceProduct>();
if (session == null)
{
return(null);
}
var productsData = session.Execute("select * from \"Product_reduced_price\" where \"market_id\" = '" + m_id + "'");
foreach (var productData in productsData)
{
ReducedPriceProduct product = new ReducedPriceProduct();
product.ID = productData["id"] != null ? productData["id"].ToString() : string.Empty;
product.MarketID = productData["market_id"] != null ? productData["market_id"].ToString() : string.Empty;
product.OldCost = productData["old_cost"] != null ? productData["old_cost"].ToString() : string.Empty;
product.NewCost = productData["new_cost"] != null ? productData["new_cost"].ToString() : string.Empty;
product.DateTo = productData["date_to"] != null ? productData["date_to"].ToString() : string.Empty;
product.DateFrom = productData["date_from"] != null ? productData["date_from"].ToString() : string.Empty;
if (DateTime.Compare(Convert.ToDateTime(product.DateTo), DateTime.Now) >= 0 && DateTime.Compare(Convert.ToDateTime(product.DateFrom), DateTime.Now) <= 0)
{
products.Add(product);
}
}
return(products);
}
public static ReducedPriceProduct GetProduct(string date_to, string date_from, string m_id, string id)
{
ISession session = SessionManager.GetSession();
ReducedPriceProduct product = new ReducedPriceProduct();
if (session == null)
{
return(null);
}
Row productData = session.Execute("select * from \"Product_reduced_price\" where \"id\"= '" + id + "' " +
"and \"market_id\"= '" + m_id + "'").FirstOrDefault();
if (productData != null)
{
product.ID = productData["id"] != null ? productData["id"].ToString() : string.Empty;
product.MarketID = productData["market_id"] != null ? productData["market_id"].ToString() : string.Empty;
product.OldCost = productData["old_cost"] != null ? productData["old_cost"].ToString() : string.Empty;
product.NewCost = productData["new_cost"] != null ? productData["new_cost"].ToString() : string.Empty;
product.DateTo = productData["date_to"] != null ? productData["date_to"].ToString() : string.Empty;
product.DateFrom = productData["date_from"] != null ? productData["date_from"].ToString() : string.Empty;
return(product);
}
return(null);
}
