Пример #1
0
        public ActionResult DeleteConfirmed(long id)
        {
            FoodOrderDetail foodOrderDetail = db.FoodOrderDetails.Find(id);

            db.FoodOrderDetails.Remove(foodOrderDetail);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Пример #2
0
 public ActionResult Edit([Bind(Include = "FdOdrDtID,FdOdrID,FdID,Qty")] FoodOrderDetail foodOrderDetail)
 {
     if (ModelState.IsValid)
     {
         db.Entry(foodOrderDetail).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.FdID    = new SelectList(db.Foods, "FdID", "FdNm", foodOrderDetail.FdID);
     ViewBag.FdOdrID = new SelectList(db.FoodOrders, "FdOdrID", "Ttl", foodOrderDetail.FdOdrID);
     return(View(foodOrderDetail));
 }
Пример #3
0
        // GET: FoodOrderDetails/Details/5
        public ActionResult Details(long?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            FoodOrderDetail foodOrderDetail = db.FoodOrderDetails.Find(id);

            if (foodOrderDetail == null)
            {
                return(HttpNotFound());
            }
            return(View(foodOrderDetail));
        }
Пример #4
0
        // GET: FoodOrderDetails/Edit/5
        public ActionResult Edit(long?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            FoodOrderDetail foodOrderDetail = db.FoodOrderDetails.Find(id);

            if (foodOrderDetail == null)
            {
                return(HttpNotFound());
            }
            ViewBag.FdID    = new SelectList(db.Foods, "FdID", "FdNm", foodOrderDetail.FdID);
            ViewBag.FdOdrID = new SelectList(db.FoodOrders, "FdOdrID", "Ttl", foodOrderDetail.FdOdrID);
            return(View(foodOrderDetail));
        }
Пример #5
0
        protected void btnPay_Click(object sender, EventArgs e)
        {
            // Customer Id
            string userId = "";

            // Reservation Detail
            string type = "";

            // Food Order
            string food_id   = "";
            string food_name = "";
            string qty       = "";

            // Payment
            decimal totalPrice = 0;

            if (!string.IsNullOrEmpty(Session["Id"] as string))
            {
                userId = Session["id"].ToString();

                if (Page.IsValid)
                {
                    int    randomId;
                    Random random   = new Random();
                    bool   repeatId = false;
                    string cust_id;

                    // Booking
                    string   bookingId = "";
                    int      person    = 0;
                    string   seatArea  = "";
                    DateTime dt;

                    // Booking
                    person   = int.Parse(Session["person"].ToString());
                    seatArea = Session["seatArea"].ToString();
                    dt       = DateTime.Parse(Session["datetime"].ToString());

                    // Generate Booking Id
                    do
                    {
                        randomId  = random.Next(10000, 999999);
                        bookingId = "RES" + randomId;
                        var p = OneDB.ReservationBKs.SingleOrDefault(b => b.resID == bookingId);

                        if (p == null)
                        {
                            repeatId = true;
                        }
                    } while (repeatId == false);

                    //For random code generate
                    var chars       = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
                    var stringChars = new char[8];

                    for (int i = 0; i < stringChars.Length; i++)
                    {
                        stringChars[i] = chars[random.Next(chars.Length)];
                    }
                    var finalString = new String(stringChars);

                    cust_id = userId;
                    ReservationBK book = new ReservationBK
                    {
                        resID        = bookingId,
                        resHeadCount = person,
                        resArea      = seatArea,
                        resDate      = dt,
                        customer_ID  = cust_id
                    };
                    OneDB.ReservationBKs.InsertOnSubmit(book);
                    OneDB.SubmitChanges();


                    // Reservation Detail
                    string rd_id;
                    type = Session["reserveType"].ToString();
                    string res_id;
                    res_id = bookingId;

                    // Generate Reservation Detail Id
                    do
                    {
                        randomId = random.Next(10000, 999999);
                        rd_id    = "RD" + randomId;
                        var p = OneDB.Reservation_Details.SingleOrDefault(b => b.resDetail_iD == rd_id);

                        if (p == null)
                        {
                            repeatId = true;
                        }
                    } while (repeatId == false);

                    //For random code generate
                    var RDchars       = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
                    var RDstringChars = new char[8];

                    for (int i = 0; i < RDstringChars.Length; i++)
                    {
                        RDstringChars[i] = chars[random.Next(RDchars.Length)];
                    }
                    var RDfinalString = new String(RDstringChars);

                    // Insert in Reservation Detail Table
                    Reservation_Detail resDetail = new Reservation_Detail
                    {
                        resDetail_iD   = rd_id,
                        resDetail_type = type,
                        reservation_ID = res_id
                    };
                    OneDB.Reservation_Details.InsertOnSubmit(resDetail);
                    OneDB.SubmitChanges();

                    // Food Order
                    food_name = Session["foodname"].ToString();
                    qty       = Session["foodquantity"].ToString();

                    // Generate Reservation Id
                    do
                    {
                        randomId = random.Next(10000, 999999);
                        food_id  = "FO" + randomId;
                        var p = OneDB.Food_Orders.SingleOrDefault(b => b.foodID == food_id);

                        if (p == null)
                        {
                            repeatId = true;
                        }
                    } while (repeatId == false);

                    //For random code generate
                    var FOchars       = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
                    var FOstringChars = new char[8];

                    for (int i = 0; i < FOstringChars.Length; i++)
                    {
                        FOstringChars[i] = chars[random.Next(FOchars.Length)];
                    }
                    var FOfinalString = new String(FOstringChars);

                    // Insert in Food Order
                    Food_Order order = new Food_Order
                    {
                        foodID = food_id,
                    };
                    OneDB.Food_Orders.InsertOnSubmit(order);
                    OneDB.SubmitChanges();

                    // Food Order Detail
                    string orderid = "";
                    food_name = Session["foodname"].ToString();
                    qty       = Session["foodquantity"].ToString();
                    var id = food_id;

                    // Generate Reservation Id
                    do
                    {
                        randomId = random.Next(10000, 999999);
                        orderid  = "FD" + randomId;
                        var p = OneDB.FoodOrderDetails.SingleOrDefault(b => b.OrderId == orderid);

                        if (p == null)
                        {
                            repeatId = true;
                        }
                    } while (repeatId == false);

                    //For random code generate
                    var FDchars       = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
                    var FDstringChars = new char[8];

                    for (int i = 0; i < FDstringChars.Length; i++)
                    {
                        FDstringChars[i] = chars[random.Next(FDchars.Length)];
                    }
                    var FDfinalString = new String(FDstringChars);

                    // Insert in Food Order Detail
                    FoodOrderDetail od = new FoodOrderDetail
                    {
                        OrderId  = food_id,
                        Id       = orderid,
                        foodName = food_name,
                        quantity = qty
                    };
                    OneDB.FoodOrderDetails.InsertOnSubmit(od);
                    OneDB.SubmitChanges();

                    // Address
                    string address_id;
                    string firstName = txtFirst.Text;
                    string lastName  = txtLast.Text;
                    string address   = txtAddress.Text;
                    string postcode  = txtPostcode.Text;
                    string state     = txtState.Text;
                    cust_id = userId;

                    // Generate Reservation Id
                    do
                    {
                        randomId   = random.Next(10000, 999999);
                        address_id = "ADD" + randomId;
                        var p = OneDB.Addresses.SingleOrDefault(b => b.Id == address_id);

                        if (p == null)
                        {
                            repeatId = true;
                        }
                    } while (repeatId == false);

                    //For random code generate
                    var ADchars       = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
                    var ADstringChars = new char[8];

                    for (int i = 0; i < ADstringChars.Length; i++)
                    {
                        ADstringChars[i] = chars[random.Next(ADchars.Length)];
                    }
                    var ADfinalString = new String(ADstringChars);

                    // Insert in Address
                    Address a = new Address()
                    {
                        Id          = address_id,
                        FirstName   = firstName,
                        LastName    = lastName,
                        AddressLine = address,
                        Postcode    = postcode,
                        State       = state,
                        Customer_ID = cust_id
                    };
                    OneDB.Addresses.InsertOnSubmit(a);
                    OneDB.SubmitChanges();

                    // Payment
                    string pay_id;
                    totalPrice = decimal.Parse(Session["total"].ToString());
                    DateTime payDate = DateTime.Now;
                    cust_id = userId;
                    string payFoodid = food_id;

                    // Generate Reservation Id
                    do
                    {
                        randomId = random.Next(10000, 999999);
                        pay_id   = "P" + randomId;
                        var p = OneDB.Checkouts.SingleOrDefault(b => b.paymentID == pay_id);

                        if (p == null)
                        {
                            repeatId = true;
                        }
                    } while (repeatId == false);

                    //For random code generate
                    var Pchars       = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
                    var PstringChars = new char[8];

                    for (int i = 0; i < PstringChars.Length; i++)
                    {
                        PstringChars[i] = chars[random.Next(Pchars.Length)];
                    }
                    var PfinalString = new String(PstringChars);

                    // Insert in Checkout
                    Checkout c = new Checkout()
                    {
                        paymentID   = pay_id,
                        totalPrice  = totalPrice,
                        paymentDate = payDate,
                        Customer_ID = cust_id,
                        foodID      = food_id
                    };
                    OneDB.Checkouts.InsertOnSubmit(c);
                    OneDB.SubmitChanges();

                    // Check In
                    string chk_code = "";

                    // Generate Reservation Id
                    randomId = random.Next(10000, 999999);
                    chk_code = randomId.ToString();

                    //For random code generate
                    var CHKchars       = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
                    var CHKstringChars = new char[6];

                    for (int i = 0; i < CHKstringChars.Length; i++)
                    {
                        CHKstringChars[i] = chars[random.Next(CHKchars.Length)];
                    }
                    var    CHKfinalString = new String(CHKstringChars);
                    string booking        = "Booking";
                    string status         = "Pending";

                    // Insert in Check in
                    Check_In chk = new Check_In
                    {
                        check_code   = CHKfinalString,
                        check_type   = booking,
                        check_status = status
                    };
                    OneDB.Check_Ins.InsertOnSubmit(chk);
                    OneDB.SubmitChanges();

                    var email = Session["email"];
                    // Send Email
                    try
                    {
                        MailMessage mailMessage = new MailMessage();
                        mailMessage.To.Add(email.ToString());
                        mailMessage.From    = new MailAddress("*****@*****.**");
                        mailMessage.Subject = "Verification Mail";
                        mailMessage.Body    = "<h3>hi</h3> " +
                                              "<h2>your booking verification code are</h2> <p>" +
                                              "<h1>" + CHKfinalString + "</h1>";
                        mailMessage.IsBodyHtml = true;
                        SmtpClient smtpClient = new SmtpClient();

                        smtpClient.Host = "smtp.gmail.com";

                        smtpClient.Port        = 587;
                        smtpClient.Credentials = new System.Net.NetworkCredential
                                                     ("*****@*****.**", "cornhub666lol");
                        smtpClient.EnableSsl = true;
                        smtpClient.Send(mailMessage);
                    }
                    catch (Exception ex)
                    {
                        Response.Write("Unable to send the e-mail <br/>" + ex.Message);
                    }
                    displayStatus.Text = "Payment Successful!";
                    Server.Transfer("~/Reservation/PaymentSuccessful.aspx");
                }
            }
        }
        public ActionResult Addfood(Food createVM)
        {
            var             userid    = Convert.ToInt32(Session["Usrid"]);
            FoodOrderDetail fdodrdtls = new FoodOrderDetail();
            Food            fd        = db.Foods.Where(x => x.FdID == createVM.FdID).FirstOrDefault();
            FoodOrder       fdodrobj  = db.FoodOrders.Where(f => f.UserID == userid && f.isPaid == false).FirstOrDefault();

            if (fdodrobj != null)
            {
                fdodrobj.Ttl             = fdodrobj.Ttl + Convert.ToInt64(fd.FdRt) * Convert.ToInt64(createVM.FdRt);//qty
                db.Entry(fdodrobj).State = EntityState.Modified;
                db.SaveChanges();
                fdodrdtls.FdID    = fd.FdID;
                fdodrdtls.Qty     = Convert.ToInt64(createVM.FdRt);
                fdodrdtls.FdOdrID = fdodrobj.FdOdrID;
                db.FoodOrderDetails.Add(fdodrdtls);
                db.SaveChanges();
            }
            else
            {
                fdodrobj        = new FoodOrder();
                fdodrobj.Date   = DateTime.Now;
                fdodrobj.isPaid = false;
                fdodrobj.UserID = userid;
                fdodrobj.RstID  = createVM.RstID;
                fdodrobj.Ttl    = Convert.ToInt64(fd.FdRt) * Convert.ToInt64(createVM.FdRt);
                db.FoodOrders.Add(fdodrobj);
                db.SaveChanges();
                fdodrdtls.FdID    = fd.FdID;
                fdodrdtls.Qty     = Convert.ToInt64(createVM.FdRt);
                fdodrdtls.FdOdrID = fdodrobj.FdOdrID;
                db.FoodOrderDetails.Add(fdodrdtls);
                db.SaveChanges();
            }
            var food = db.FoodOrderDetails.Where(f => f.FdOdrID == fdodrobj.FdOdrID);

            //FoodOrderDetail fd2 = db.FoodOrderDetails.Where(f => f.FdOdrID == fdodrobj.FdOdrID);
            //if (fd.FdNm != null && fdodrobj.Date == null )
            //{
            //    fdodr.Date = DateTime.Now;
            //    fdodr.isPaid = false;
            //    fdodr.UserID = userid;
            //    fdodr.Ttl = 0;
            //    db.FoodOrders.Add(fdodr);
            //    db.SaveChanges();
            //    fdodrdtls.FdID = fd.FdID;
            //    fdodrdtls.Qty = 1;
            //    fdodrdtls.FdOdrID = fdodrobj.FdOdrID;
            //    db.FoodOrderDetails.Add(fdodrdtls);
            //    db.SaveChanges();
            //    return View();
            //}
            //else
            //{
            //    fdodrdtls.Qty = fdodrdtls.Qty + 1;
            //    db.Entry(fdodrdtls).State = EntityState.Modified;
            //    db.SaveChanges();
            //    fdodr.Ttl = 100;
            //    db.Entry(fdodr).State = EntityState.Modified;
            //    db.SaveChanges();
            //    return View();
            //}
            return(RedirectToAction("Viewfood", "Foods", new { id = createVM.RstID }));
        }