/// <summary> /// Called with 'CANCEL a reservation' /// </summary> /// <returns></returns> public ActionResult Cancel(BookingCancellation bookingCancellationDetails) { //var bookingCancellationDetails = new Models.BookingCancellation { BookingId = "A1234", ReservationId = "B1234" }; SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["defaultConnection"].ConnectionString); SqlCommand cmd = new SqlCommand("sp_cancel_room", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ReservationNumber", bookingCancellationDetails.ReservationId); cmd.Parameters.AddWithValue("@CancellationRemarks", string.Empty); SqlParameter param = new SqlParameter("@RtnValue", SqlDbType.Int); param.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(param); conn.Open(); cmd.ExecuteScalar(); conn.Close(); if ((int)cmd.Parameters["@RtnValue"].Value != 0) { return(null); } return(View(bookingCancellationDetails)); }
private void BOOKINGCANCELLATIONToolStripMenuItem_Click_1(System.Object sender, System.EventArgs e) { Master.Completed(); BookingCancellation b1 = new BookingCancellation(); b1.MdiParent = this; b1.Show(); b1.BringToFront(); }