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 ActionResult DeleteConfirmed(int id)
{
Recieved_ammount recieved_ammount = db.Recieved_ammounts.Find(id);
db.Recieved_ammounts.Remove(recieved_ammount);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "SaapumiseränId,ProductId,Date,ExpireDate,Price,VendorName,LocationCode")] Recieved_ammount recieved_ammount)
{
if (ModelState.IsValid)
{
db.Entry(recieved_ammount).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductId = new SelectList(db.Products, "ProductId", "Nmae", recieved_ammount.ProductId);
return(View(recieved_ammount));
}
// 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: EditRecievedAmmount/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Recieved_ammount recieved_ammount = db.Recieved_ammounts.Find(id);
if (recieved_ammount == null)
{
return(HttpNotFound());
}
return(View(recieved_ammount));
}
// GET: EditRecievedAmmount/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Recieved_ammount recieved_ammount = db.Recieved_ammounts.Find(id);
if (recieved_ammount == null)
{
return(HttpNotFound());
}
ViewBag.ProductId = new SelectList(db.Products, "ProductId", "Nmae", recieved_ammount.ProductId);
return(View(recieved_ammount));
}
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);
}