// GET: api/ProductGroup/5 public IEnumerable <ProductGroup> Get(int id) { JalkahoitolaEntities entities = new JalkahoitolaEntities(); List <ProductGroup> items = new List <ProductGroup>(); List <ProductGroup> result = new List <ProductGroup>(); if (id == 0) { items = (from p in entities.ProductGroups select p).ToList(); } else { items = (from p in entities.ProductGroups where p.GroupId == id select p).ToList(); } foreach (ProductGroup item in items) { ProductGroup data = new ProductGroup(); data.GroupId = item.GroupId; data.Name = item.Name; //data.Products = item.Products; result.Add(data); } return(result); }
public IEnumerable <Product> Get(int id) { JalkahoitolaEntities entities = new JalkahoitolaEntities(); List <Product> items = (from o in entities.Products where o.GroupId == id select o).ToList(); entities.Dispose(); List <Product> result = new List <Product>(); foreach (Product item in items) { Product data = new Product(); data.ProductId = item.ProductId; data.Nmae = item.Nmae; data.Description = item.Description; data.Quantity = item.Quantity; data.UnitOfMeasure = item.UnitOfMeasure; data.GroupId = item.GroupId; data.Entery_Date = item.Entery_Date; data.Expire = item.Expire; data.Person_Name = item.Person_Name; //data.ProductGroup = item.ProductGroup; //data.Recieved_ammount = item.Recieved_ammount; result.Add(data); } return(result); }
public IEnumerable <Recieved_ammount> Get(int id) { JalkahoitolaEntities entities = new JalkahoitolaEntities(); List <Recieved_ammount> items = (from o in entities.Recieved_ammounts where o.ProductId == id select o).ToList(); entities.Dispose(); List <Recieved_ammount> result = new List <Recieved_ammount>(); foreach (Recieved_ammount item in items) { Recieved_ammount data = new Recieved_ammount(); if (item.UnitStock > 0) { data.ProductId = item.ProductId; data.SaapumiseranId = item.SaapumiseranId; data.VendorName = item.VendorName; data.ExpireDate = item.ExpireDate; data.Date = item.Date; data.Price = item.Price; data.UnitStock = item.UnitStock; result.Add(data); } } return(result); }
public int ProductCount() { JalkahoitolaEntities entities = new JalkahoitolaEntities(); int productCount = entities.Products.Count(); return(productCount); }
// GET: ProductGroups public ActionResult Index() { JalkahoitolaEntities entities = new JalkahoitolaEntities(); List <ProductGroup> model = entities.ProductGroups.ToList(); entities.Dispose(); return(View(model)); }
public ActionResult GetProducts(int id) { JalkahoitolaEntities entities = new JalkahoitolaEntities(); List <Product> products = (from o in entities.Products where o.GroupId == id select o).ToList(); return(View(products)); }
public ProductGroup Post([FromBody] ProductGroup value) { JalkahoitolaEntities entities = new JalkahoitolaEntities(); entities.ProductGroups.Add(value); entities.SaveChanges(); entities.Dispose(); return(value); }
// GET: api/ProductCount/5 public int?Get(int id) { JalkahoitolaEntities entities = new JalkahoitolaEntities(); List <int?> items = (from o in entities.Recieved_ammounts where o.ProductId == id select o.UnitStock).ToList(); entities.Dispose(); return(items.Sum()); }
public List <string> ProductList() { JalkahoitolaEntities entities = new JalkahoitolaEntities(); List <Product> ListOfProducts = (from p in entities.Products select p).ToList(); List <string> products = ListOfProducts.Select(p => p.Nmae).ToList(); return(products); }
// GET: api/ReduceProduct public IEnumerable <Recieved_ammount> Get(int?SaapumiseranId) { //Query entry from entity JalkahoitolaEntities entities = new JalkahoitolaEntities(); Recieved_ammount EntryToModify = (from p in entities.Recieved_ammounts where p.SaapumiseranId == SaapumiseranId select p).SingleOrDefault(); int?id = EntryToModify.ProductId; //Take the last one and remove if (EntryToModify.UnitStock == 1) { EntryToModify.UnitStock = EntryToModify.UnitStock - 1; //EntryToModify = null; entities.Recieved_ammounts.Remove(EntryToModify); entities.SaveChanges(); } //If there's more than one, just reduce the amount if (EntryToModify.UnitStock > 1) { EntryToModify.UnitStock = EntryToModify.UnitStock - 1; entities.SaveChanges(); } //Get updated list from db and return it to client List <Recieved_ammount> items = (from o in entities.Recieved_ammounts where o.ProductId == id select o).ToList(); entities.Dispose(); List <Recieved_ammount> result = new List <Recieved_ammount>(); foreach (Recieved_ammount item in items) { Recieved_ammount data = new Recieved_ammount(); if (item.UnitStock > 0) { data.ProductId = item.ProductId; data.SaapumiseranId = item.SaapumiseranId; data.VendorName = item.VendorName; data.ExpireDate = item.ExpireDate; data.Date = item.Date; data.Price = item.Price; data.UnitStock = item.UnitStock; result.Add(data); } } return(result); }
// GET: api/RemoveProduct/5 public int Get(int?id) { JalkahoitolaEntities entities = new JalkahoitolaEntities(); List <int?> items = (from o in entities.Recieved_ammounts where o.ProductId == id select o.UnitStock).ToList(); if (items.Sum() == 0 || items.Sum() == null) { Product ProductToBeRemoved = (from o in entities.Products where o.ProductId == id select o).First(); entities.Products.Remove(ProductToBeRemoved); entities.SaveChanges(); } entities.Dispose(); return(1); }
// GET: api/RemoveProductGroup // [HttpGet] public int Get(int id) { JalkahoitolaEntities entities = new JalkahoitolaEntities(); int items = (from p in entities.Products where p.GroupId == id select p).Count(); if (items == 0) { ProductGroup ProductGroupToBeRemoved = (from p in entities.ProductGroups where p.GroupId == id select p).First(); entities.ProductGroups.Remove(ProductGroupToBeRemoved); entities.SaveChanges(); } entities.Dispose(); return(items); }
public IEnumerable <Product> Get(string id) { //id = "Nitriili"; JalkahoitolaEntities entities = new JalkahoitolaEntities(); List <Product> items = (from o in entities.Products where o.Nmae == id select o).ToList(); entities.Dispose(); List <Product> result = new List <Product>(); foreach (Product item in items) { Product data = new Product(); data.Nmae = item.Nmae; data.Quantity = item.Quantity; data.UnitOfMeasure = item.UnitOfMeasure; result.Add(data); } return(result); }
public int Post([FromBody] Recieved_ammount value) { /* * Recieved_ammount testvalue = new Recieved_ammount(); * testvalue.ProductId = value.ProductId; * testvalue.SaapumiseränId = value.SaapumiseränId; * testvalue.Date = value.Date; * testvalue.ExpireDate = value.ExpireDate; * testvalue.Price = value.Price; * testvalue.VendorName = value.VendorName; * testvalue.LocationCode = value.LocationCode; * testvalue.Product = value.Product; * testvalue.Stocks = value.Stocks; * return testvalue; */ Recieved_ammount testvalue = new Recieved_ammount(); JalkahoitolaEntities entities = new JalkahoitolaEntities(); entities.Recieved_ammounts.Add(value); int result = entities.SaveChanges(); entities.Dispose(); return(result); }
// POST: api/Product public Product Post([FromBody] Product value) { JalkahoitolaEntities entities = new JalkahoitolaEntities(); /* Testing part * Product newProduct = new Product(); * newProduct.Nmae = value.Nmae; * newProduct.Description = value.Description; * newProduct.Quantity = value.Quantity; * newProduct.UnitOfMeasure = value.UnitOfMeasure; * newProduct.GroupId = value.GroupId; * newProduct.Entery_Date = value.Entery_Date; * newProduct.Expire = value.Expire; * newProduct.Person_Name = value.Person_Name; * entities.Products.Add(newProduct); * entities.SaveChanges(); * entities.Dispose(); * return newProduct; */ entities.Products.Add(value); entities.SaveChanges(); entities.Dispose(); return(value); }