public ActionResult Pickup(int?id, int?oid) { var result = db.Delivers.SingleOrDefault(m => m.deliver_id == id); if (result != null) { var uid = result.driver_id; var driverdetail = db.Users.Where(u => u.user_id == uid).FirstOrDefault(); var driverName = driverdetail.name; var driverPhone = driverdetail.phone; result.deliver_status = "In Progress"; db.SaveChanges(); var result2 = db.Orders.SingleOrDefault(m => m.order_id == oid); if (result2 != null) { result2.order_status = "Order Dispatched"; db.SaveChanges(); } var deliverydetail = db.Delivers.Where(c => c.order_id == oid && c.deliver_id == id).FirstOrDefault(); var customerid = deliverydetail.customer_id; var userdetail = db.Users.Where(u => u.user_id == customerid).FirstOrDefault(); var useremail = userdetail.email; var message = @String.Format("<div> Your Order has been dispatched !! <br /> Driver Details Given Below <br /> Driver Name : {0} <br /> Driver Phone : {1} <br /> </div>", driverName, driverPhone); EmailController email = new EmailController(); email.SendOrderEmail(useremail, "ABC Cafe - Order Update", message); var result3 = db.Users.SingleOrDefault(m => m.user_id == uid); if (result3 != null) { result3.status = "Un-Available"; db.SaveChanges(); } } return(View("DeliveryAgentPanel")); }
public ActionResult Delivered(int?id, int?oid) { var result = db.Delivers.SingleOrDefault(m => m.deliver_id == id); if (result != null) { var uid = result.driver_id; result.deliver_status = "Delivered"; db.SaveChanges(); var result2 = db.Orders.SingleOrDefault(m => m.order_id == oid); if (result != null) { result2.order_status = "Delivered"; db.SaveChanges(); } var result3 = db.Users.SingleOrDefault(m => m.user_id == uid); if (result3 != null) { result3.status = "Available"; db.SaveChanges(); } var deliverydetail = db.Delivers.Where(c => c.order_id == oid && c.deliver_id == id).FirstOrDefault(); var customerid = deliverydetail.customer_id; var userdetail = db.Users.Where(u => u.user_id == customerid).FirstOrDefault(); var useremail = userdetail.email; var message = @String.Format("<div> Thank you for ordering through Cafe ABC!! <br /> Have a nice day and enjoy your meal!! </div>"); EmailController email = new EmailController(); email.SendOrderEmail(useremail, "ABC Cafe - Enjoy!!", message); } return(View("DeliveryAgentPanel")); }