public ActionResult Track(TrackV m) { var da = new Courier.Models.DbModel.CourierEntities(); var Q = da.Tracks.Where(a => a.TrackID == m.TrackID).SingleOrDefault(); if (Q != null) { ViewBag.msg = ""; m.packageName = Q.Order.Packagename; if (Q.CurrentLocation != null) { m.CurrentLatitude = Convert.ToDecimal(Q.CurrentLocation.Latitude); m.CurrentLogitude = Convert.ToDecimal(Q.CurrentLocation.Logitude); m.CurrentLocation = Q.CurrentLocation.Address; } else { ViewBag.msg = "Sorry this Package is not ready yet."; } m.DestinationLatitude = Convert.ToDecimal(Q.destination.Latitude); m.DestinationLogitude = Convert.ToDecimal(Q.destination.Logitude); m.Destination = Q.destination.Address; m.SourceLatitude = Convert.ToDecimal(Q.Source.Latitude); m.SourceLogitude = Convert.ToDecimal(Q.Source.Logitude); m.Source = Q.Source.address; } return(View(m)); }
public ActionResult Reciept(int id) { var da = new Courier.Models.DbModel.CourierEntities(); var orderid = da.Orders.Where(a => a.OrderID == id).Select(a => a.OrderID).SingleOrDefault(); var packageName = da.Orders.Where(a => a.OrderID == id).Select(a => a.Packagename).SingleOrDefault(); ViewBag.OrderID = orderid; ViewBag.PackageName = packageName; var rec = da.Receipts.Where(a => a.OrderID == id).Select(a => a.ReceiptID); if (rec != null) { ViewBag.RecID = rec.SingleOrDefault(); ViewBag.RecNO = rec; } else { ViewBag.RecID = "UNPAID"; ViewBag.RecNO = "NOT FOUND"; } ViewBag.Amount = da.Receipts.Where(a => a.OrderID == id).Select(a => a.Amount).SingleOrDefault(); ViewBag.des = da.destinations.Where(a => a.OrderID == id).Select(a => a.Address).SingleOrDefault(); ViewBag.track = da.Tracks.Where(a => a.OrderID == id).Select(a => a.TrackID).SingleOrDefault(); ViewBag.sou = da.Sources.Where(a => a.OrderID == id).Select(a => a.address).SingleOrDefault(); return(View()); }
public ActionResult Order(OrderV m) { string userId = User.Identity.GetUserId(); string PackageName; int OrderID; var CreateOrder = new Orders().createOrder(userId, m.Packagename, m.Description, m.weight, m.height); if (CreateOrder) { OrderID = Orders.OrderID; ViewBag.OrderID = OrderID; Session["OrderID"] = OrderID; var da = new Courier.Models.DbModel.CourierEntities(); PackageName = da.Orders.Where(a => a.OrderID == OrderID).Select(a => a.Packagename).SingleOrDefault(); Session["PackageName"] = PackageName; ViewBag.PackageName = PackageName; return(RedirectToAction("Location")); } else { ViewBag.Error = Orders.returnMsg; return(View("Error")); } // return View(); }
public ActionResult Index() { var da = new Courier.Models.DbModel.CourierEntities(); var q = from p in da.Users select p; return(View(q)); }
// GET: User public ActionResult Client(int?page) { var da = new Courier.Models.DbModel.CourierEntities(); string useremail = User.Identity.GetUserName(); #region Errors //// var myModel = new MultipleItems(); // ViewBag.Supports = (new SupportW().GetSupports(useremail)).Count(); // // //myModel.Supports = new SupportW().GetSupports(useremail); // ViewBag.Orders = (new Orders().GetOrders(useremail)).Count(); // // // myModel.Orders = new Orders().GetOrders(useremail); //ViewBag.Receipts = (new Receipts().GetReceipts(useremail)).Count(); // // // myModel.Receipts = new Receipts().GetReceipts(useremail); // ViewBag.Receipts = (new Receipts().GetReceipts(useremail)).Count(); // ViewBag.Quotas = (new Quotas().GetQuota(useremail)).Count(); // // myModel.Quotas = new Quotas().GetQuota(useremail); // var da = new Courier.Models.DbModel.CourierEntities(); // var orders = (from s in da.Orders // select s).OrderByDescending(a => a.DateSpam); // var tracks = (from s in da.Tracks // select s).OrderByDescending(a => a.Order.DateSpam); // return View(tracks); #endregion var q = da.Orders.Where(a => a.User.UserName == useremail).Select(a => a.OrderID).Count(); var supportno = new SupportW().GetSupports(useremail); ViewBag.Supports = supportno.Count();; ViewBag.Orders = q; ViewBag.Receipts = (new Receipts().GetReceipts(useremail)).Count(); ViewBag.Receipts = (new Receipts().GetReceipts(useremail)).Count(); ViewBag.Quotas = (new Quotas().GetQuota(useremail)).Count(); string userId = User.Identity.GetUserId(); var query = da.Tracks.Where(a => a.Order.userId == userId); query = query.OrderByDescending(s => s.Order.DateSpam); int pageSize = 10; int pageNumber = (page ?? 1); return(View(query.ToPagedList(pageNumber, pageSize))); }
public ActionResult Support(int?page) { string userEmail = User.Identity.GetUserName(); var da = new Courier.Models.DbModel.CourierEntities(); var query = (from a in da.supports where a.email == userEmail select a).OrderByDescending(a => a.dateSpam); int pageSize = 5; int pageNumber = (page ?? 1); return(View(query.ToPagedList(pageNumber, pageSize))); }
public ActionResult AddUserToAdminRole(string id) { var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context)); var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context)); var da = new Courier.Models.DbModel.CourierEntities(); var findUser = da.Users.Find(id); if (findUser != null) { //check if role exit UserManager.AddToRole(findUser.Id, regRole); TempData["view"] = 1; } return(RedirectToAction("Index")); }
public ActionResult OrderList(string sortOrder, string currentFilter, string searchString, int?page) { string userId = User.Identity.GetUserId(); ViewBag.CurrentSort = sortOrder; ViewBag.OrderID = String.IsNullOrEmpty(sortOrder) ? "orderId" : ""; ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; var da = new Courier.Models.DbModel.CourierEntities(); var query = da.Tracks.Where(a => a.Order.userId == userId); switch (sortOrder) { case "orderId": query = query.OrderByDescending(s => s.Order.OrderID); break; case "Date": query = query.OrderBy(s => s.Order.DateSpam); break; case "date_desc": query = query.OrderByDescending(s => s.Order.DateSpam); break; default: // Name ascending query = query.OrderByDescending(s => s.Order.DateSpam); break; } int pageSize = 10; int pageNumber = (page ?? 1); return(View(query.ToPagedList(pageNumber, pageSize))); }