public IEnumerable <ProductModel> GetAllProductByCategory(int categoryid) { using (pos_androidEntities context = new pos_androidEntities()) { //string path = "http://103.233.79.234/Data/EverGreen_Android/ProductPictures/"; var result = (from p in context.productmasters where p.CategoryId == categoryid orderby p.ProductName select new ProductModel() { ProductId = p.ProductId, ProductName = p.ProductName, CategoryId = (int)p.CategoryId, UnitPrice = (decimal)p.UnitPrice, GST = (decimal)p.GST, Discount = (decimal)p.Discount, TaxType = p.TaxType, UOM = p.UOM, SweetsReset = p.SweetsReset, ProductDetails = p.ProductDetails, Lock = p.Lock, //StoreId = j4.StoreId }).ToList(); // var data = result.Select(p => new ProductModel() // { // ProductId = p.ProductId, // ProductName = p.ProductName, // CategoryId = (int)p.CategoryId, // UnitPrice = (decimal)p.UnitPrice, // GST = (decimal)p.GST, // Discount = (decimal)p.Discount, // TaxType = p.TaxType, // UOM = p.UOM, // HSN = p.HSN, // SweetsReset = p.SweetsReset, // ProductDetails = p.ProductDetails, // Lock = p.Lock, // //ProductPicturesUrl = path + p.ProductId + "ProductPictures.jpg", //}).ToList(); return(result); } }
//public IEnumerable<CategoryModel> GetAllCategoryList() //{ // using (pos_androidEntities context = new pos_androidEntities()) // { // // string path = "http://103.233.79.234/Data/EverGreen_Android/CategoryPictures/"; // var result = context.categorymasters.OrderBy(c => c.CategoryName); // var data = result.Select(c => new CategoryModel() // { // CategoryId = c.CategoryId, // CategoryName = c.CategoryName, // //CategoryDescription = c.CategoryDescription, // //StoreId = (int)c.StoreId, // //CategoryPictures = path + c.CategoryId + "CategoryPictures.jpg", // }).ToList(); // return data; // } //} public IEnumerable <CategoryModel> GetAllCategoryByMenuId(int storeid) { using (pos_androidEntities context = new pos_androidEntities()) { //string path = "http://103.233.79.234/Data/EverGreen_Android/CategoryPictures/"; var result = context.categorymasters.Where(c => c.StoreId == storeid).OrderBy(c => c.CategoryName); var data = result.Select(c => new CategoryModel() { CategoryId = c.CategoryId, CategoryName = c.CategoryName, CategoryDescription = c.CategoryDescription, StoreId = (int)c.StoreId, //CategoryPictures = path + c.CategoryId + "CategoryPictures.jpg", }).ToList(); return(data); } }