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 EditIncident(int iKey) { string query = "SELECT * FROM shooters.incitingIncident where iKey= '" + iKey + "'"; var _model = TableUtils.queryToObject <incitingIncident>(query); return(View(_model)); }
public ActionResult ViewHealthDetails(string mName) { string query = "select * from shooters.massshootings where mName = '" + mName + "'"; massShooting ms = TableUtils.queryToObject <massShooting>(query); return(View(ms)); }
public ActionResult ViewShooterGuns(string first, string last) { actor _actor = TableUtils.queryToObject <actor>("SELECT * FROM shooters.shooter where first= '" + first + "' AND last = '" + last + "'"); List <gunPurchase> _list = TableUtils.queryToTable <gunPurchase>("SELECT * FROM shooters.gunPurchase where first= '" + first + "' AND last = '" + last + "'"); ShooterGP model = new ShooterGP(); model._actor = _actor; model._guns = _list; return(View(model)); }
public ActionResult EditGun(string gName) { gun _gun = TableUtils.queryToObject <gun>("SELECT * FROM shooters.gun where gName= '" + gName + "'"); GunSpec gs = new GunSpec(); gs._gun = _gun; List <gunType> _types = TableUtils.queryToTable <gunType>("SELECT * FROM shooters.gunTypeRel natural join shooters.gunType where gName= '" + gName + "'"); gs._specs = _types; ViewBag.gName = gName; return(View(gs)); }
public ActionResult GunTypeAdd(string gName) { List <gunType> _curTypes = TableUtils.queryToTable <gunType>("SELECT * FROM shooters.gunType natural join shooters.gunTypeRel where gName = '" + gName + "'"); List <gunType> _newTypes = TableUtils.queryToTable <gunType>("SELECT * FROM shooters.gunType"); gun _gun = TableUtils.queryToObject <gun>("SELECT * FROM shooters.gun where gName = '" + gName + "'"); GunTypeAdder _tAdder = new GunTypeAdder(); _tAdder._currTypes = _curTypes; _tAdder._newTypes = _newTypes; _tAdder._gun = _gun; return(View(_tAdder)); }
public ActionResult AddGunsToShooter(ShooterGuns _shooterGuns) { int pageSize = 10; int pageNumber = 1; PagedList <gun> _list = new PagedList <gun>(TableUtils.queryToTable <gun>("SELECT * FROM shooters.gun where gDesc LIKE '%" + _shooterGuns._search + "%'"), pageNumber, pageSize); List <gunsOwned> _owned = TableUtils.queryToTable <gunsOwned>("SELECT gName, gDesc, count(gName) as owned FROM shooters.gun natural join shooters.gunPurchase where first = '" + _shooterGuns._actorFirst + "' AND last = '" + _shooterGuns._actorLast + "' group by gName, gDesc"); actor _actor = TableUtils.queryToObject <actor>("SELECT * FROM shooters.shooter where first= '" + _shooterGuns._actorFirst + "' AND last = '" + _shooterGuns._actorLast + "'"); massShooting ms = TableUtils.queryToObject <massShooting>("select * from shooters.massshootings natural join shooters.massshootingrel where first = '" + _shooterGuns._actorFirst + "' AND last = '" + _shooterGuns._actorLast + "'"); _shooterGuns._massShooting = ms; _shooterGuns._guns = _list; _shooterGuns._gunsOwned = _owned; _shooterGuns._actor = _actor; return(View(_shooterGuns)); }
public ActionResult AddGunsToShooter(string first, string last, int?page) { int pageSize = 10; int pageNumber = page ?? 1; massShooting ms = TableUtils.queryToObject <massShooting>("select * from shooters.massshootings natural join shooters.massshootingrel where first = '" + first + "' AND last = '" + last + "'"); PagedList <gun> _list = new PagedList <gun>(TableUtils.queryToTable <gun>("SELECT * FROM shooters.gun"), pageNumber, pageSize); List <gunsOwned> _owned = TableUtils.queryToTable <gunsOwned>("SELECT gName, gDesc, count(gName) as owned FROM shooters.gun natural join shooters.gunPurchase where first = '" + first + "' AND last = '" + last + "' group by gName, gDesc"); actor _actor = TableUtils.queryToObject <actor>("SELECT * FROM shooters.shooter where first= '" + first + "' AND last = '" + last + "'"); ShooterGuns model = new ShooterGuns(); model._actorFirst = first; model._actorLast = last; model._massShooting = ms; model._guns = _list; model._gunsOwned = _owned; model._actor = _actor; return(View(model)); }
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")); }
public ActionResult EditSeller(string sName) { var model = TableUtils.queryToObject <gunSeller>("SELECT * FROM shooters.gunSeller where sName= '" + sName + "'"); return(View(model)); }
public ActionResult EditType(int tId) { gunType model = TableUtils.queryToObject <gunType>("SELECT * FROM shooters.gunType where tId ='" + tId + "'"); return(View(model)); }