// 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"));
}
}
}
