public ActionResult FoodBank(FoodBankViewModel vm)
{
// insert a new Food Bank based on the logged in users Site ID
int?SiteID = Session["SiteID"] as int?;
// Insert into foodbank table the user's Site ID
string sql = String.Format(
"INSERT INTO foodbank (SiteID) VALUES ({0}); ", SiteID.Value.ToString());
SqlHelper.ExecuteNonQuery(sql);
vm.SiteID = SiteID.Value; // set the ID since it now exists
vm.StatusMessage = "Succesfully added!";
return(View(vm));
}
public ActionResult FoodBank()
{
// Get the logged in Site ID from the session
int?SiteID = Session["SiteID"] as int?;
// if there is none, redirect to the login page
if (!SiteID.HasValue)
{
return(RedirectToAction("Login", "Account"));
}
FoodBankViewModel vm = new FoodBankViewModel();
// find out if we have a food bank for this site already or not
string sql = String.Format("SELECT COUNT(*) FROM foodbank WHERE SiteID = {0}; ", SiteID.Value.ToString());
vm.FoodBankExists = Int32.Parse(SqlHelper.ExecuteScalar(sql).ToString()) > 0;
return(View(vm));
}
