public ActionResult EditGunPurchase(int gpId = 9)
{
string query = "select * from shooters.gunPurchase where gpid = " + gpId;
gunPurchase gp = TableUtils.queryToObject <gunPurchase>(query);
return(View(gp));
}
public ActionResult CommitGPChanges(gunPurchase g)
{
gunSeller _obj = TableUtils.queryToObject <gunSeller>("select * from shooters.gunSeller where sName = '" + g.sName + "'");
if (_obj.sName == null)
{
//if seller does not exist in sellers, create it.
QueryUtils.query("insert into shooters.gunSeller (sName) values ('" + g.sName + "')");
}
string query = "update shooters.gunPurchase" +
" set sName = '" + g.sName + "'," +
" gpDate = '" + g.gpDate + "'," +
" gpCost = '" + g.gpCost + "'," +
" gName = '" + g.gName + "'," +
" gpDesc = '" + g.gpDesc + "'" +
" where gpId = '" + g.gpId + "'";
setSuccess(QueryUtils.query(query));
return(RedirectToAction("Guns"));
}
