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