public ActionResult MoreDescription() { string E_EID = Request.QueryString["E_EID"]; E_EID = E_EID.Replace(" ", "+"); String EID = dp.Decrypt(E_EID, "ETicket"); ViewBag.EID = Convert.ToInt32(EID); return(View()); }
public ActionResult DeleteEvent() { string E_EID = Request.QueryString["E_EID"]; E_EID = E_EID.Replace(" ", "+"); String EID = dp.Decrypt(E_EID, "ETicket"); int ID = Convert.ToInt32(EID); //Delete Cover and SeatMap string Cover = d.getStringByQuery("select * from Event where ID=" + ID, "ImageName"); string SeatMap = d.getStringByQuery("select * from Event where ID=" + ID, "SeatMap"); DeleteCover(Cover); DeleteSeatMap(SeatMap); //(1) Delete Event, Row, Seat, CustomerTicket d.ChangeByQuery("delete from CustomerTicket where SeatID in(select ID from Seat where EID=" + ID + ")"); d.ChangeByQuery("delete from Seat where EID=" + ID); d.ChangeByQuery("delete from Row where EID=" + ID); d.ChangeByQuery("delete from Event where ID=" + ID); return(RedirectToAction("Manage")); }