public ActionResult DeleteConfirmed(string id)
{
COMMODITY cOMMODITY = db.COMMODITY.Find(id);
db.COMMODITY.Remove(cOMMODITY);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: COMMODITies/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
COMMODITY cOMMODITY = db.COMMODITY.Find(id);
if (cOMMODITY == null)
{
return(HttpNotFound());
}
return(View(cOMMODITY));
}
public ActionResult Edit([Bind(Include = "ID,NAME,PRICE,REGION")] COMMODITY cOMMODITY, [Bind(Include = "ID,NAME,PRICE,QUONTITY,SUBTOTAL,UPDATEHISTORY")] STOCK sTOCK)
{
if (ModelState.IsValid)
{
db.Entry(cOMMODITY).State = EntityState.Modified;
sTOCK.NAME = cOMMODITY.NAME;
sTOCK.PRICE = cOMMODITY.PRICE;
sTOCK.QUONTITY = (from x in db.STOCK where x.ID == cOMMODITY.ID select x.QUONTITY).Single();
sTOCK.SUBTOTAL = sTOCK.PRICE * sTOCK.QUONTITY;
sTOCK.UPDATEHISTORY = DateTime.Now;
db.Entry(sTOCK).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cOMMODITY));
}
public ActionResult Create([Bind(Include = "ID,NAME,PRICE,REGION")] COMMODITY cOMMODITY)
{
if (ModelState.IsValid)
{
db.COMMODITY.Add(cOMMODITY);
db.COMMODITY.Add(cOMMODITY);
db.STOCK.Add(sTOCK);
sTOCK.ID = cOMMODITY.ID;
sTOCK.NAME = cOMMODITY.NAME;
sTOCK.PRICE = cOMMODITY.PRICE;
sTOCK.QUONTITY = 0;
sTOCK.SUBTOTAL = 0;
sTOCK.UPDATEHISTORY = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cOMMODITY));
}
public ActionResult CreateActive(string title, string description, string code)
{
try
{
using (var ctx = DatabaseContext.Instance.Make())
{
var active = ctx.COMMODITY.FirstOrDefault(c => c.Title == title);
if (active != null)
{
return(Json(new
{
status = false,
errorString = string.Format("{0} '{1}' {2}", Resource.TitleTradingInstrument, title, Resource.TextAlreadyExists)
}, JsonRequestBehavior.AllowGet));
}
active = new COMMODITY
{
Title = title,
Description = description,
CodeFXI = code.ToIntSafe()
};
ctx.COMMODITY.Add(active);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
return(Json(new
{
status = false,
errorString = string.Format("{0}: {1}", Resource.ErrorMessageAdding, ex.Message)
}, JsonRequestBehavior.AllowGet));
}
return(Json(new
{
status = true,
errorString = ""
}, JsonRequestBehavior.AllowGet));
}
protected AddCOMMODITYViewModel(IEnumerable <COMMODITY_CODE> commodityCodes)
{
COMMODITY_CODES = new List <COMMODITY_CODE>(commodityCodes);
addCOMMODITY = new COMMODITY();
}
