public ActionResult DeleteFromWaitlist(DeleteFromWaitlistViewModel vm)
{
string sql = null;
// Get client ranking on waitlist
sql = String.Format("SELECT Ranking FROM waitlist WHERE ClientID = {0} AND SiteID = {1}", vm.ClientID, vm.SiteID);
object ranking = SqlHelper.ExecuteScalar(sql);
//Redo rankings decreasing ranking for anything lower on the list than selected client.
sql = String.Format("UPDATE waitlist SET Ranking = Ranking - 1 WHERE Ranking > {0} AND SiteID = {1}", int.Parse(ranking.ToString()), vm.SiteID);
SqlHelper.ExecuteNonQuery(sql);
//Delete selected client.
sql = String.Format("DELETE FROM waitlist WHERE ClientID = {0} AND SiteID = {1}", vm.ClientID, vm.SiteID);
SqlHelper.ExecuteNonQuery(sql);
vm.DeleteCompleted = true;
return(View(vm));
}
public ActionResult DeleteFromWaitlist(string clientID)
{
// Get the logged in Site ID from the session
int?SiteID = Session["SiteID"] as int?;
// if there is none, they can't do anything so redirect to the login page
if (!SiteID.HasValue)
{
return(RedirectToAction("Login", "Account"));
}
// start setting up the view model
DeleteFromWaitlistViewModel vm = new DeleteFromWaitlistViewModel();
vm.SiteID = SiteID.Value;
vm.ClientID = int.Parse(clientID);
return(View(vm));
}
