public ActionResult DeleteConfirmed(int id) { TestTube testTube = db.TestTubes.Find(id); db.TestTubes.Remove(testTube); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "TestTubeID,SampleID,TestTubeNo,TechID,TestID,TotalMaterialCost,QuantResult,QualResult,Pass_Fail,TotalCost")] TestTube testTube) { if (ModelState.IsValid) { db.Entry(testTube).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SampleID = new SelectList(db.Samples, "SampleID", "SampleName", testTube.SampleID); ViewBag.TestID = new SelectList(db.Tests, "TestID", "TestName", testTube.TestID); return(View(testTube)); }
// GET: TestTubes/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TestTube testTube = db.TestTubes.Find(id); if (testTube == null) { return(HttpNotFound()); } return(View(testTube)); }
// GET: TestTubes/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TestTube testTube = db.TestTubes.Find(id); if (testTube == null) { return(HttpNotFound()); } ViewBag.SampleID = new SelectList(db.Samples, "SampleID", "SampleName", testTube.SampleID); ViewBag.TestID = new SelectList(db.Tests, "TestID", "TestName", testTube.TestID); return(View(testTube)); }
public async System.Threading.Tasks.Task <ActionResult> SubmitOrder(int workorderid) { ViewBag.PriorityLevelID = new SelectList(db.PriorityLevels, "PriorityLevelID", "WorkDaysProcessing"); ViewBag.AssayID = new SelectList(db.ProtocolNotebooks, "AssayID", "AssayName"); WorkOrder workOrder = db.WorkOrders.Find(workorderid); 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; IEnumerable <Test> TestList = db.Tests.ToList(); foreach (var item in newClientOrder.compoundAssayOrderList) { item.assayOrder.ProtocolNotebook = db.ProtocolNotebooks.Find(item.assayOrder.AssayID); item.assayOrder.PriorityLevel = db.PriorityLevels.Find(item.assayOrder.PriorityLevelID); foreach (var test in TestList) { if (test.AssayID == item.assayOrder.AssayID) { TestResult newresult = new TestResult(); newresult.AssayOrderID = item.assayOrder.AssayOrderID; newresult.CompoundID = item.compound.CompoundID; newresult.TestID = test.TestID; newresult.CreatedBy = "Client " + GetClientID(); newresult.CreatedDate = DateTime.Now; newresult.ModifedBy = "Client " + GetClientID(); newresult.ModifiedDate = DateTime.Now; newresult.StatusID = 1; //set status to Work Order Received newresult.StatusUpdatedDate = DateTime.Now; TestTube mytube = new TestTube(); mytube.CompoundID = item.compound.CompoundID; mytube.CreatedBy = "System"; mytube.CreatedDate = DateTime.Now; db.TestTubes.Add(mytube); newresult.TestTubeID = mytube.TestTubeID; db.TestResults.Add(newresult); db.SaveChanges(); } } } //Function to send email var body = "<h2>Order Confirmed</h2>" + "<p>Order Date:" + newClientOrder.workOrder.DateTime + "</p>" + "<br />"; Dictionary <int, NorthWestLabs.Models.Compound> LTNumberList = new Dictionary <int, NorthWestLabs.Models.Compound>(); foreach (NorthWestLabs.Models.CompoundAssayOrder item in newClientOrder.compoundAssayOrderList) { if (!LTNumberList.ContainsKey(item.compound.LTNumber)) { LTNumberList.Add(item.compound.LTNumber, item.compound); } } foreach (var LtNumber in LTNumberList) { //<!--Display of compound and assay details--> body += "<h3>Compound" + LtNumber.Key + " | " + LtNumber.Value.CompoundName + "</h3>" + "<table class='table'>" + "<tr>" + "<th>Assay Name</th>" + "<th>LTNumber</th>" + "</tr>"; foreach (NorthWestLabs.Models.CompoundAssayOrder item in newClientOrder.compoundAssayOrderList) { if (item.assayOrder.Compound.LTNumber == LtNumber.Key) { body += "<tr>" + "<td>" + item.assayOrder.ProtocolNotebook.AssayName + "</td>" + "<td>" + LtNumber.Key + "-" + item.compound.SequenceCode + "</td>" + "</tr>"; } } body += "</table>"; } var message = new MailMessage(); message.To.Add(new MailAddress(db.Clients.Find(GetClientID()).Email)); // replace with valid value message.From = new MailAddress("*****@*****.**", "Northwest Labs"); // replace with valid value message.Subject = "Northwest Labs - Order Confirmation"; message.Body = string.Format(body); message.IsBodyHtml = true; //message.Attachments() add attachments using (var smtp = new SmtpClient()) { var credential = new NetworkCredential { UserName = "******", // replace with valid value Password = "******" // replace with valid value }; smtp.Credentials = credential; smtp.Host = "smtp.gmail.com"; smtp.Port = 587; smtp.EnableSsl = true; await smtp.SendMailAsync(message); } return(View(newClientOrder)); }