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