// GET: AssayOrder/Edit/5
public ActionResult Edit(int?id, int?WorkOrderID)
{
AssayOrderWithTestResults assayOrderWithTestResults = new AssayOrderWithTestResults();
ViewBag.WorkOrderID = WorkOrderID;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AssayOrder assayOrder = db.AssayOrders.Find(id);
if (assayOrder == null)
{
return(HttpNotFound());
}
ViewBag.PriorityLevelID = new SelectList(db.PriorityLevels, "PriorityLevelID", "ModifiedBy", assayOrder.PriorityLevelID);
ViewBag.AssayID = new SelectList(db.ProtocolNotebooks, "AssayID", "AssayName", assayOrder.AssayID);
assayOrderWithTestResults.AssayOrder = assayOrder;
IEnumerable <TestResult> TestResList = db.TestResults.ToList();
foreach (TestResult val in TestResList)
{
if (val.AssayOrderID == assayOrder.AssayOrderID)
{
assayOrderWithTestResults.testResults.Add(val);
}
}
return(View(assayOrderWithTestResults));
}
public ActionResult ClientAddAssay(int workorderid, int LTNumber,
[Bind(Include = "AssayOrderID,WorkOrderID,PriorityLevelID,AssayID,ModifiedBy,ModifiedDate,CreatedBy,CreatedDate,CompoundID")] AssayOrder assayorder)
{
ViewBag.PriorityLevelID = new SelectList(db.PriorityLevels, "PriorityLevelID", "WorkDaysProcessing");
ViewBag.AssayID = new SelectList(db.ProtocolNotebooks, "AssayID", "AssayName");
Compound compound = new Compound();
IEnumerable <Compound> compoundList = db.Compounds.ToList();
foreach (Compound item in compoundList)
{
if (item.LTNumber == LTNumber)
{
compound.CompoundName = item.CompoundName;
}
}
compound.LTNumber = LTNumber;
compound.SequenceCode = 1;//needs function to increment sequence code
compound.ModifiedBy = "Client " + GetClientID();
compound.ModifiedDate = DateTime.Now;
compound.CreatedBy = "Client " + GetClientID();
compound.CreatedDate = DateTime.Now;
db.Compounds.Add(compound);
db.SaveChanges();
assayorder.WorkOrderID = workorderid;
assayorder.CompoundID = compound.CompoundID;
assayorder.ModifiedBy = "Client " + GetClientID();
assayorder.ModifiedDate = DateTime.Now;
assayorder.CreatedBy = "Client " + GetClientID();
assayorder.CreatedDate = DateTime.Now;
db.AssayOrders.Add(assayorder);
db.SaveChanges();
NewClientOrder newClientOrder = new NewClientOrder();
newClientOrder.workOrder = db.WorkOrders.Find(workorderid);
IEnumerable <AssayOrder> allAssay = db.AssayOrders.ToList();
foreach (AssayOrder item in allAssay)
{
if (item.WorkOrderID == newClientOrder.workOrder.WorkOrderID)
{
CompoundAssayOrder myCompoundAssayOrder = new CompoundAssayOrder();
myCompoundAssayOrder.assayOrder = item;
myCompoundAssayOrder.compound = db.Compounds.Find(item.CompoundID);
newClientOrder.compoundAssayOrderList.Add(myCompoundAssayOrder);
}
}
foreach (var item in newClientOrder.compoundAssayOrderList)
{
item.assayOrder.ProtocolNotebook = db.ProtocolNotebooks.Find(item.assayOrder.AssayID);
item.assayOrder.PriorityLevel = db.PriorityLevels.Find(item.assayOrder.PriorityLevelID);
}
return(View("WorkOrderMain", newClientOrder));
}
public ActionResult DeleteConfirmed(int id)
{
AssayOrder assayOrder = db.AssayOrders.Find(id);
db.AssayOrders.Remove(assayOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "AssayOrderID,WorkOrderID,PriorityLevelID,AssayID,ModifiedBy,ModifiedDate,CreatedBy,CreatedDate,CompoundID")] AssayOrder assayOrder)
{
if (ModelState.IsValid)
{
db.AssayOrders.Add(assayOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PriorityLevelID = new SelectList(db.PriorityLevels, "PriorityLevelID", "ModifiedBy", assayOrder.PriorityLevelID);
ViewBag.AssayID = new SelectList(db.ProtocolNotebooks, "AssayID", "AssayName", assayOrder.AssayID);
ViewBag.WorkOrderID = new SelectList(db.WorkOrders, "WorkOrderID", "ModifiedBy", assayOrder.WorkOrderID);
return(View(assayOrder));
}
// GET: AssayOrder/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AssayOrder assayOrder = db.AssayOrders.Find(id);
if (assayOrder == null)
{
return(HttpNotFound());
}
return(View(assayOrder));
}
public ActionResult Edit([Bind(Include = "AssayOrderID,WorkOrderID,PriorityLevelID,AssayID,ModifiedBy,ModifiedDate,CreatedBy,CreatedDate,CompoundID")] AssayOrder assayOrder, int?WorkOrderID)
{
AssayOrderWithTestResults assayOrderWithTestResults = new AssayOrderWithTestResults();
if (ModelState.IsValid)
{
db.Entry(assayOrder).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", "WorkOrders", new { id = assayOrder.WorkOrderID }));
}
ViewBag.PriorityLevelID = new SelectList(db.PriorityLevels, "PriorityLevelID", "ModifiedBy", assayOrder.PriorityLevelID);
ViewBag.AssayID = new SelectList(db.ProtocolNotebooks, "AssayID", "AssayName", assayOrder.AssayID);
assayOrderWithTestResults.AssayOrder = assayOrder;
return(View(assayOrderWithTestResults));
}
public ActionResult ClientNewWorkOrder(FormCollection form, int?workorderid,
[Bind(Include = "LTNumber,SequenceCode,CompoundName,Quantity,DateArrived,ReceivedBy,DateDue,Appearance,Weight,MolecularMass,ConfirmationDate,MaxTotalDose,ActualWeight,ModifiedBy,ModifiedDate,CreatedBy,CreatedDate")] Compound compound,
[Bind(Include = "AssayOrderID,WorkOrderID,PriorityLevelID,AssayID,ModifiedBy,ModifiedDate,CreatedBy,CreatedDate,CompoundID")] AssayOrder assayorder)
{
ViewBag.PriorityLevelID = new SelectList(db.PriorityLevels, "PriorityLevelID", "WorkDaysProcessing");
ViewBag.AssayID = new SelectList(db.ProtocolNotebooks, "AssayID", "AssayName");
WorkOrder workOrder = new WorkOrder();
if (workorderid == null || workorderid == 0)
{
workOrder.ClientID = GetClientID();
workOrder.CreatedBy = "Client " + GetClientID();
workOrder.ModifiedBy = "Client " + GetClientID();
workOrder.DateTime = DateTime.Now;
workOrder.CreatedDate = DateTime.Now;
workOrder.ModifiedDate = DateTime.Now;
workOrder.DiscountRate = 0; //calculate discount for customer if it applies here
db.WorkOrders.Add(workOrder);
db.SaveChanges();
}
else
{
workOrder = db.WorkOrders.Find(workorderid);
}
compound.CompoundName = form["CompoundName"];
compound.LTNumber = db.Compounds.Max(t => t.LTNumber) + 1;
compound.SequenceCode = 1;
compound.ModifiedBy = "Client " + GetClientID();
compound.ModifiedDate = DateTime.Now;
compound.CreatedBy = "Client " + GetClientID();
compound.CreatedDate = DateTime.Now;
db.Compounds.Add(compound);
db.SaveChanges();
assayorder.WorkOrderID = workOrder.WorkOrderID;
assayorder.CompoundID = compound.CompoundID;
assayorder.ModifiedBy = "Client " + GetClientID();
assayorder.ModifiedDate = DateTime.Now;
assayorder.CreatedBy = "Client " + GetClientID();
assayorder.CreatedDate = DateTime.Now;
db.AssayOrders.Add(assayorder);
db.SaveChanges();
NewClientOrder newClientOrder = new NewClientOrder();
IEnumerable <AssayOrder> allAssay = db.AssayOrders.ToList();
foreach (AssayOrder item in allAssay)
{
if (item.WorkOrderID == workOrder.WorkOrderID)
{
CompoundAssayOrder myCompoundAssayOrder = new CompoundAssayOrder();
myCompoundAssayOrder.assayOrder = item;
myCompoundAssayOrder.compound = db.Compounds.Find(item.CompoundID);
newClientOrder.compoundAssayOrderList.Add(myCompoundAssayOrder);
}
}
newClientOrder.workOrder = workOrder;
foreach (var item in newClientOrder.compoundAssayOrderList)
{
item.assayOrder.ProtocolNotebook = db.ProtocolNotebooks.Find(item.assayOrder.AssayID);
item.assayOrder.PriorityLevel = db.PriorityLevels.Find(item.assayOrder.PriorityLevelID);
}
return(View("WorkOrderMain", newClientOrder));
}
