/// <summary>
/// Return All Product By Specific Cellar Area ID
/// </summary>
/// <param name="CellarAreaID">CellarAreaID</param>
/// <returns>All Product</returns>
public static Tuple <ErrorObject, List <tblProduct> > GetProductToCellarArea(int CellarAreaID)
{
List <tblProduct> data = new List <tblProduct>();
List <int> ids = new List <int>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
//ids = (from C in db.tblCellar where C.idcellarArea == CellarAreaID select (int)C.idProduct).ToList();
//data = db.tblProduct.ToList();
//for (int v = 0; v < ids.Count; v++)
//{
// var itemToRemove = data.SingleOrDefault(r => r.id == ids[v]);
// if (itemToRemove != null)
// data.Remove(itemToRemove);
//}
data = db.SP_Product_SelectProduct("GetProductToCellarArea", CellarAreaID, 0, 0).ToList();
};
return(new Tuple <ErrorObject, List <tblProduct> >(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblProduct> >(erros, data));
}
}
/// <summary>
/// Return All Product To Cellar Category and Category Father IDs
/// </summary>
/// <param name="CellarAreaID">CellarAreaID</param>
/// <param name="Category">Category</param>
/// <param name="FatherCateogryID">FatherCateogryID</param>
/// <returns></returns>
public static Tuple <ErrorObject, List <tblProduct> > GetProductListByDepartmentAndCategory(int CellarAreaID, int Category, int FatherCateogryID)
{
List <tblProduct> data = new List <tblProduct>();
erros = new ErrorObject();
try
{
using (EileenGaldamezEntities db = new EileenGaldamezEntities())
{
data = db.SP_Product_SelectProduct("GetProductListByDepartmentAndCategory", CellarAreaID, Category, FatherCateogryID).ToList();
};
return(new Tuple <ErrorObject, List <tblProduct> >(erros.IfError(false), data));
}
catch (Exception ex)
{
erros.InfoError(ex);
return(new Tuple <ErrorObject, List <tblProduct> >(erros, data));
}
}