public ActionResult RequestOrderNumber()
{
user = db.Users.Find(Int32.Parse(Request.Cookies["UserID"].Value));
iTestTubeCounter = db.SampleTests.Max(x => x.TestTubeID);
workOrderCompoundSample = new WorkOrderCompoundSample();
workOrderCompoundSample.workOrder = new WorkOrder();
workOrderCompoundSample.compound = new Compound();
workOrderCompoundSample.workOrder.Discount = 0;
workOrderCompoundSample.workOrder.CompanyID = user.CompanyID.Value;
workOrderCompoundSample.workOrder.OrderID = db.WorkOrders.ToList().Max(x => x.OrderID) + 1;
//Create compound and assign the number
workOrderCompoundSample.compound.LT = db.Compounds.ToList().Max(x => x.LT) + 1;
List <SelectListItem> items = new List <SelectListItem>();
items.Add(new SelectListItem {
Text = "1", Value = "1", Selected = true
});
items.Add(new SelectListItem {
Text = "2", Value = "2"
});
items.Add(new SelectListItem {
Text = "3", Value = "3"
});
items.Add(new SelectListItem {
Text = "4", Value = "4"
});
items.Add(new SelectListItem {
Text = "5", Value = "5"
});
items.Add(new SelectListItem {
Text = "6", Value = "6"
});
items.Add(new SelectListItem {
Text = "7", Value = "7"
});
items.Add(new SelectListItem {
Text = "8", Value = "8"
});
items.Add(new SelectListItem {
Text = "9", Value = "9"
});
ViewBag.CompoundCount = items;
return(View("RequestOrderNumber"));
}
public ActionResult ViewOrder(int?OrderID)
{
WorkOrderCompoundSample workOrderCompoundSample = new WorkOrderCompoundSample();
// Find work order
workOrderCompoundSample.workOrder = db.WorkOrders.Find(OrderID);
workOrderCompoundSample.compoundSampleSampleTests = new List <CompoundSampleSampleTest>();
// Find the compund samples with that work order
List <CompoundSample> dbCompoundSamples = db.Database.SqlQuery <CompoundSample>("SELECT * FROM CompoundSample WHERE OrderID = " + OrderID).ToList();
int iCount = 0;
int iCount1 = 0;
int iTestCount = 0;
foreach (var CompoundSample in dbCompoundSamples)
{
workOrderCompoundSample.compoundSampleSampleTests.Add(new CompoundSampleSampleTest());
workOrderCompoundSample.compoundSampleSampleTests.ElementAt(iCount).compoundSample = CompoundSample;
// Find all the sample tests within the compounds of the work order
List <SampleTest> dbSampleTests = db.Database.SqlQuery <SampleTest>("SELECT * FROM SampleTest WHERE LT = '" +
dbCompoundSamples.ElementAt(iCount).LT + "' AND SequenceCode =" +
dbCompoundSamples.ElementAt(iCount).SequenceCode).ToList();
workOrderCompoundSample.compoundSampleSampleTests.ElementAt(iCount).sampleTests = new List <SampleTest>();
for (iCount1 = 0; iCount1 < dbSampleTests.Count(); iCount1++)
{
workOrderCompoundSample.compoundSampleSampleTests.ElementAt(iCount).sampleTests.Add(dbSampleTests.ElementAt(iCount1));
iTestCount++;
}
iCount++;
}
List <Compound> Compounds = db.Database.SqlQuery <Compound>("SELECT * FROM Compound WHERE LT = '" + workOrderCompoundSample.compoundSampleSampleTests.ElementAt(0).compoundSample.LT + "'").ToList();
workOrderCompoundSample.compound = Compounds.ElementAt(0);
ViewBag.Name = db.Users.Find(Convert.ToInt32(Request.Cookies["UserID"].Value)).FirstName;
ViewBag.CompanyName = db.Companies.Find(workOrderCompoundSample.workOrder.CompanyID).Name;
ViewBag.TotalTest = iTestCount;
return(View(workOrderCompoundSample));
}
