public ActionResult AddGuest(Guest guest) { //bool shouldKeepGenerating = true; //string newID = rsvpIdGenerator.GetNewRsvpId(); //while (shouldKeepGenerating) //{ // if (DAL.CountStatement(SqlStatements.CheckIfRsvpIdExistsSQL(), SqlStatements.CheckIfRsvpIdExistsParameters(newID)) == 0) // { // shouldKeepGenerating = false; // } // else // { // newID = rsvpIdGenerator.GetNewRsvpId(); // } //} //guest.RsvpId = newID; //if(DAL.InsertOrUpdate(SqlStatements.InsertNewGuestSQL(), SqlStatements.InsertOrUpdateGuestParameters(guest)) == 1) //{ // ViewBag.SuccessMessage = "Guest successfully added: " + guest.Name; // return View(); //} //else //{ // ViewBag.FailureMessage = "Failed to add guest! Contact Zach!"; return View(guest); //} }
public ActionResult EditGuest(Guest guest) { if (DAL.InsertOrUpdate(SqlStatements.UpdateGuestSQL(), SqlStatements.InsertOrUpdateGuestParameters(guest)) == 1) { ViewBag.SuccessMessage = "Guest Successfully Updated!"; } else { ViewBag.FailureMessage = "Update Failed! Contact Zach."; } return View(guest); }
public static DataTable InsertOrUpdateGuestParameters(Guest guest) { DataTable dtParameters = new DataTable(); //dtParameters.Columns.Add("Parameter"); //dtParameters.Columns.Add("Value"); //dtParameters.Rows.Add("@Name", guest.Name); //dtParameters.Rows.Add("@Email", guest.Email); //dtParameters.Rows.Add("@emailComment", guest.CommentForEmailSent); //dtParameters.Rows.Add("@rsvpComment", guest.CommentFromRSVP); //dtParameters.Rows.Add("@rsvpId", guest.RsvpId); //dtParameters.Rows.Add("@numPeopleAllowed", guest.NumPeopleAllowed); //dtParameters.Rows.Add("@numPeopleAttending", guest.NumPeopleAttending); //dtParameters.Rows.Add("@hasRSVPed", guest.HasRSVPed ? 1 : 0); //dtParameters.Rows.Add("@isAttending", guest.IsAttending ? 1 : 0); return dtParameters; }
public ActionResult GuestRSVP(Guest guest) { //Guest newGuest; //// check if guest has already rsvped, if not, allow post and redirect to success page //using (DataTable dtGuest = DAL.SelectStatement(SqlStatements.CheckIfRsvpIdHasAlreadyRespondedSQL(), SqlStatements.CheckIfRsvpIdHasAlreadyRespondedParameters(guest.RsvpId))) //{ // if(dtGuest.Rows.Count > 0) // { // newGuest = new Guest(dtGuest.Rows[0]); // if(newGuest.HasRSVPed == true) // { // // guest has already rsvped, tell them so // ViewBag.FailureMessage = "This Code Has Already RSVPed. If you need to change your RSVP, contact us."; // } // else // { // // update guest record in database // newGuest.HasRSVPed = true; // newGuest.IsAttending = guest.IsAttending; // newGuest.CommentFromRSVP = guest.CommentFromRSVP; // DAL.InsertOrUpdate(SqlStatements.UpdateGuestSQL(), SqlStatements.InsertOrUpdateGuestParameters(newGuest)); // ViewBag.SuccessMessage = "Thank you for RSVPing! Your choice has been saved and you will not be able to change it without contacting us."; // } // } // else // { // // rsvp id does not exist in the database, alert the user // ViewBag.FailureMessage = "RSVP Code Not Found."; // } //} // if already rsvped, throw an error saying so // return RedirectToAction("RSVP", "RSVP"); return View(); }
public ActionResult GuestRSVP() { Guest guest = new Guest(); return View(guest); }