public ActionResult SelectAssays(FormCollection form) { String LTNumber = form["LTNumber"]; int key = Int32.Parse(LTNumber); String CustID = form["CustID"]; String SalesAgentName = form["SalesAgentName"]; Compound c = db.Compounds.Find(key); List <AssayName> assayList = new List <AssayName>(); assayList = db.AssayNames.ToList(); ViewBag.assayList = assayList; PreWorkOrderViewModel viewModel = new PreWorkOrderViewModel(); if (CustID != "") { viewModel.CustID = Convert.ToInt32(CustID); } viewModel.CompoundName = c.CompoundName; viewModel.SalesAgentName = SalesAgentName; viewModel.LTNumber = key; return(View(viewModel)); }
public ActionResult Quote([Bind(Include = "CompoundName,CustID,LTNumber,SalesAgentName,BiochemicalPharmacology,DiscoveryScreen,ImmunoScreen,ProfilingScreen,PharmaScreen,CustomScreen")] PreWorkOrderViewModel viewModel) { //List<Assay> assayList = new List<Assay>(); //assayList = new List<Assay>(); //assayList = db.Assays.ToList(); //List<Assay> completedRequiredAssays = new List<Assay>(); //List<int> selectedAssayIDs = new List<int>(); //if (viewModel.BiochemicalPharmacology) //{ // selectedAssayIDs.Add(1); //} //if (viewModel.BiochemicalPharmacology) //{ // selectedAssayIDs.Add(2); //} //if (viewModel.DiscoveryScreen) //{ // selectedAssayIDs.Add(3); //} //if (viewModel.ImmunoScreen) //{ // selectedAssayIDs.Add(4); //} //if (viewModel.PharmaScreen) //{ // selectedAssayIDs.Add(5); //} //if (viewModel.CustomScreen) //{ // selectedAssayIDs.Add(6); //} //// to be added in the calculation for price quote, the assay needs to contain an int AssayNameID, LTNumber and needs to be required //foreach (Assay a in assayList) //{ // if (a.IsRequired == true && a.LTNumber == viewModel.LTNumber && selectedAssayIDs.Contains(a.AssayID)) // { // completedRequiredAssays.Add(a); // } //} //List<int> numberOfAssaysInCombo = new List<int>(); //List<decimal> runningCostOfAssaysInCombo = new List<decimal>(); //List<decimal> averages = new List<decimal>(); //if (completedRequiredAssays.Count == 0) //{ // ViewBag.Price = "Unable to find a quote. Insufficient data in database."; //} //else //{ // for (int i = 0; i < selectedAssayIDs.Count; i++) // { // // average each LT/AssayNameID combo // numberOfAssaysInCombo[i] = 0; // foreach (Assay a in completedRequiredAssays) // { // if (a.AssayNameID == selectedAssayIDs[i]) // { // numberOfAssaysInCombo[i]++; // runningCostOfAssaysInCombo[i] += a.Cost; // } // } // averages[i] = runningCostOfAssaysInCombo[i] / numberOfAssaysInCombo[i]; // } // // sum all values in averages // decimal quotedPrice = 0; // foreach (decimal avg in averages) // { // quotedPrice += avg; // } // ViewBag.quotedPrice = quotedPrice; //} ViewBag.quotedPrice = "[Quoted Price]"; return(View(viewModel)); }