protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int rowId = Int32.Parse(Session["rowId"].ToString());
int customerId = int.Parse(Session["Customer_Id"].ToString());
Response.Write(GridView1.Rows[rowId].Cells[1].Text);
int tk_id = Int32.Parse(GridView1.Rows[rowId].Cells[7].Text);
using (projectEntities1 context = new projectEntities1())
{
Seat_Details seatNo = (from s in context.Seat_Details
where s.Ticket_Id == tk_id
select s).FirstOrDefault();
Payment_Info payment = (from p in context.Payment_Info
where p.Ticket_Id == tk_id
select p).FirstOrDefault();
var user = (from c in context.Customer_Info
where c.Customer_Id == customerId
select c).FirstOrDefault();
Application OutlookApplication = new Application();
MailItem message = (MailItem)OutlookApplication.CreateItem(OlItemType.olMailItem);
MailAddress toAddress = new MailAddress(user.Email);
Booking_Details ticket = (from b in context.Booking_Details
where b.Ticket_Id == tk_id
select b).FirstOrDefault();
message.To = toAddress.ToString();
message.Subject = "Confirm Cancellation";
message.HTMLBody = "<div><h1>THANK YOU for using Let's book</h1>" + "<br/><br/>" + "Theater Name:" + "<br/><br/>" + ticket.Show_Info.Theater_Info.Theater_Name + "Movie:" + ticket.Show_Info.Movie_Info.Movie_Name + "<br/><br/>" + "Show Date:" + ticket.Show_Info.Show_Date + "<br/><br/>" + "Show Time:" + ticket.Show_Info.Start_Time + "<br/><br/>" + "No of Tickets:" + ticket.No_Of_Tickets + "<br/><br/>" + "Seat Numbers:" + seatNo.Seat_No + "<br/><br/>" + "Price:" + payment.Total_Price + "<br/><br/>" + "See you soon" + "</div>";
message.BodyFormat = OlBodyFormat.olFormatHTML;
context.Booking_Details.Remove(ticket);
context.SaveChanges();
message.Send();
Response.Redirect("default.aspx");
}
}
protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int rowId = Int32.Parse(Session["rowId"].ToString());
Response.Write(GridView2.Rows[rowId].Cells[1].Text);
int tk_id = Int32.Parse(GridView2.Rows[rowId].Cells[6].Text);
using (projectEntities1 context = new projectEntities1())
{
Booking_Details ticket = (from b in context.Booking_Details
where b.Ticket_Id == tk_id
select b).FirstOrDefault();
context.Booking_Details.Remove(ticket);
context.SaveChanges();
Response.Redirect("default.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Customer_Id"] == null)
{
Response.Redirect("~/User-Info/Log-In.aspx");
}
if (!IsPostBack)
{
DateTime todate = DateTime.UtcNow.Date;
int customerId = Int32.Parse(Session["Customer_Id"].ToString());
GridViewRow row = (GridViewRow)Session["Booking_Details"];
string Theater_Name = row.Cells[1].Text;
string Movie_Name = row.Cells[2].Text;
var Show_Date = row.Cells[3].Text;
var Show_Time = row.Cells[4].Text;
decimal Price = Decimal.Parse(row.Cells[5].Text);
Array seats = (Array)Session["seatNos"];
int show_id = Int32.Parse(row.Cells[6].Text);
int aLen = seats.Length;
decimal tot_price = aLen * Price;
string seatStr = Session["seatStr"].ToString();
using (projectEntities1 context = new projectEntities1())
{
Booking_Details book = new Booking_Details();
book.Customer_Id = customerId;
book.Show_Id = show_id;
book.No_Of_Tickets = aLen;
book.Booking_Date = todate;
context.Booking_Details.Add(book);
context.SaveChanges();
var tk_id = (from t in context.Show_Info
join b in context.Booking_Details on show_id equals b.Show_Id
join c in context.Customer_Info on customerId equals c.Customer_Id
where b.Booking_Date == DbFunctions.TruncateTime(DateTime.UtcNow)
select new
{
b.Ticket_Id
}).OrderByDescending(t => t.Ticket_Id).FirstOrDefault();
Seat_Details seatno = new Seat_Details();
Payment_Info pay = new Payment_Info();
pay.Ticket_Id = seatno.Ticket_Id = tk_id.Ticket_Id;
seatno.Seat_No = seatStr;
context.Seat_Details.Add(seatno);
pay.Total_Price = tot_price;
pay.Mode = "PayPal";
context.Payment_Info.Add(pay);
context.SaveChanges();
var user = (from c in context.Customer_Info
where c.Customer_Id == customerId
select c).FirstOrDefault();
Application OutlookApplication = new Application();
MailItem message = (MailItem)OutlookApplication.CreateItem(OlItemType.olMailItem);
MailAddress toAddress = new MailAddress(user.Email);
message.To = toAddress.ToString();
message.Subject = "Movie Ticket";
message.HTMLBody = "<h1>THANK YOU for using Let's book</h1>" + "<br/><br/>" + "Theater Name:" + "<br/><br/>" + Theater_Name + "Movie:" + Movie_Name + "<br/><br/>" + "Show Date:" + Show_Date + "<br/><br/>" + "Show Time:" + Show_Time + "<br/><br/>" + "No of Tickets:" + aLen.ToString() + "<br/><br/>" + "Seat Numbers:" + seatStr + "<br/><br/>" + "Price" + Price + "<br/><br/>" + "Enjoy your show";
message.BodyFormat = OlBodyFormat.olFormatHTML;
message.Send();
}
Label9.Text = Theater_Name;
Label10.Text = Movie_Name;
Label11.Text = Show_Date;
Label12.Text = Show_Time;
Label13.Text = aLen.ToString();
Label14.Text = seatStr;
Label15.Text = tot_price.ToString();
Label16.Text = "Done";
}
}