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