예제 #1
0
        public JsonResult BookTicket([FromBody] CustomerModel customer)
        {
            try
            {
                CommonMail         common       = new CommonMail();
                List <TblCustomer> tblCustomers = new List <TblCustomer>();
                string             SeatNumber   = "";
                for (int i = 0; i < customer.SeatNumber.Count; i++)
                {
                    SeatNumber += Convert.ToString(customer.SeatNumber[i]) + ',';
                }

                var customerName = new SqlParameter("CustomerName", customer.UserName);
                var Email        = new SqlParameter("Email", customer.Email);
                var SeatNumbers  = new SqlParameter("SeatNumbers", SeatNumber);

                var CustomerLst = cinemaBookingDBContext.TblCustomer
                                  .FromSqlRaw("EXECUTE dbo.SP_BookSheet @customerName,@Email,@SeatNumbers", customerName, Email, SeatNumbers)
                                  .ToList();

                if (CustomerLst.Count != 0)
                {
                    string MsgBody = "";
                    MsgBody += "Dear " + customer.UserName;
                    MsgBody += "<br/>";
                    MsgBody += "Greetings!!";
                    MsgBody += "<br/>";
                    MsgBody += "Thank you for choosing our Booking Cinema System. Your Ticket Has Been Booked.";
                    MsgBody += "<br/><table border=" + 1 + " cellpadding=" + 0 + " cellspacing=" + 0 + " width = " + 400 + "><tr><th>Seat Number</th><th>Secret Key</th></tr>";

                    for (int i = 0; i < CustomerLst.Count; i++)
                    {
                        MsgBody += "<tr><td>" + CustomerLst[i].SeatNumber + "</td><td>" + CustomerLst[i].SecretKey + "</td><tr>";
                    }
                    MsgBody += "</table><br/>";
                    MsgBody += "Thanks<br/>Cinema Booking System";

                    common.SendMail(customer.Email, MsgBody, "Confirmation Ticket Booking");
                    return(Json(1));
                }
                else
                {
                    return(Json(0));
                }
            }
            catch (Exception ex)
            {
                LogException(ex, "BookTicket");
                return(Json(0));
            }
        }
예제 #2
0
        public JsonResult UnBookTicket(int SeatNumber)
        {
            try
            {
                var TicketStatus = repository.GetById(SeatNumber); string UserMail = ""; CommonMail common = new CommonMail(); string UserName = ""; string MsgBody = "";

                if (TicketStatus != null && TicketStatus.BookingStatus == true)
                {
                    var CustomerInform = repositoryCustomer.GetById(TicketStatus.CustomerId);
                    UserMail = CustomerInform.Email;
                    UserName = CustomerInform.CustomerName;
                    repositoryCustomer.Delete(TicketStatus.CustomerId);
                    repositoryCustomer.Save();

                    TicketStatus.BookingStatus = false;
                    TicketStatus.CustomerId    = 0;

                    repository.Update(TicketStatus);
                    repository.Save();
                    MsgBody += "Dear " + UserName;
                    MsgBody += "<br/>";
                    MsgBody += "Greetings!!"; MsgBody += "<br/><br/>";

                    MsgBody += "Your Ticket (Seat Number) " + SeatNumber + "  Has Been Cancelled."; MsgBody += "<br/><br/>";
                    MsgBody += "Thanks <br/>";
                    MsgBody += "Cinema Booking System";
                    common.SendMail(UserMail, MsgBody, "Cancelled Ticket Update");
                }
                return(Json(1));
            }
            catch (Exception ex)
            {
                LogException(ex, "UnBookTicket");
                return(Json(0));
            }
        }