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));
}
