// GET: Admin/Orders public ActionResult Orders(string id) { AdminOrderModel model = new AdminOrderModel(); var orders = _repository.GetOrders(id); model.Orders = orders.ToList(); return(View(model)); }
public ActionResult ViewOrderSup() { DashboardModel mm = new DashboardModel(); int memid = Convert.ToInt32(Session["MemberId"]); CommonData model = new CommonData(); AdminOrderModel m = new AdminOrderModel(); m.suplist = model.SupplierNName(); List <AdminOrderModel> lst = new List <AdminOrderModel>(); using (ProjectEntities1 db = new ProjectEntities1()) { var getdata = (from p in db.PateintOrderDetails join d in db.DrugDeliveries on p.OrderId equals d.OrderId join s in db.Suppliers on d.SupplierId equals s.SupplierId where s.MemberId == memid select new { p.OrderId, p.PateintId, p.OrderNumber, p.OrderStatus, p.OrderedDate, p.Quantity, p.DrugId, d.DeliveredDate, M = p.Patient.FirstName + " " + p.Patient.LastName, Drug_Name = p.Drug.DrugName }).ToList(); // var nxtdata = getdata.SingleOrDefault(a=>a.MemberId==memid); int count = getdata.Count; mm.TotalOrder = count; foreach (var item in getdata) { lst.Add(new AdminOrderModel { OrderId = item.OrderId, PatientId = item.PateintId, PateintName = item.M, Drugname = item.Drug_Name, DrugId = item.DrugId, OrderNumber = item.OrderNumber, Quantity = item.Quantity, DelieveredDate = Convert.ToDateTime(item.DeliveredDate), OrderedDate = item.OrderedDate, OrderStatus = item.OrderStatus, }); } //InboxModel inboxViewModel = new InboxModel(); m.lstAdmin = lst; return(View(m)); } }
public ActionResult PostorderAdmin(AdminOrderModel model) { using (ProjectEntities1 db = new ProjectEntities1()) { if (model.SupplierId > 0) { string assign = "Assigned"; db.InsertDrugDelivery(model.OrderId, model.SupplierId); db.UpdateAssign(model.OrderId, assign); return(Json("Assigned")); } else { return(Json("Error")); } } }
public ActionResult ViewOrder() { CommonData model = new CommonData(); AdminOrderModel m = new AdminOrderModel(); m.suplist = model.SupplierNName(); List <AdminOrderModel> lst = new List <AdminOrderModel>(); using (ProjectEntities1 db = new ProjectEntities1()) { var getdata = db.PateintOrderDetails.ToList(); foreach (var item in getdata) { string supname = null; if (item.OrderStatus != "Requested") { int orderid = item.OrderId; var nname = (from d in db.DrugDeliveries join s in db.Suppliers on d.SupplierId equals s.SupplierId where d.OrderId == orderid select new { s.FirstName, s.LastName }).FirstOrDefault(); supname = nname.FirstName + " " + nname.LastName; } lst.Add(new AdminOrderModel { SupplierName = supname, OrderId = item.OrderId, PatientId = item.PateintId, Drugname = item.Drug.DrugName, PateintName = item.Patient.FirstName + item.Patient.LastName, DrugId = item.DrugId, OrderNumber = item.OrderNumber, Quantity = item.Quantity, OrderedDate = Convert.ToDateTime(item.OrderedDate), OrderStatus = item.OrderStatus }); } //InboxModel inboxViewModel = new InboxModel(); m.lstAdmin = lst; return(View(m)); } }
public ActionResult PostViewSup(AdminOrderModel model) { using (ProjectEntities1 db = new ProjectEntities1()) { //Delievered string status = model.OrderStatus; if (status == "Dispatched") { db.UpdateOrStatus(model.OrderId, model.OrderStatus); return(Json("Updated")); } else { db.UpdateOrStatus(model.OrderId, model.OrderStatus); db.Updatedeleivery(model.OrderId, DateTime.Now); //model.DelieveredDate = DateTime.Now; return(Json("Updated")); } } }