/// <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)); } }