public ActionResult DeleteConfirmed(int id) { Compound_Receipts compound_Receipts = db.Compound_Receipts.Find(id); db.Compound_Receipts.Remove(compound_Receipts); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Compound_Receipt_ID,LT,Compound_Sequence_Code,Compound_Name,Quantity,Date_Arrived,Received_By,Date_Due,Appearance,Indicated_Weight,Molecular_Mass,Actual_Weight,MTD,Confirmation_Date,Confirmation_Time,Work_Order_ID,Test_Results")] Compound_Receipts compound_Receipts) { if (ModelState.IsValid) { db.Entry(compound_Receipts).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(compound_Receipts)); }
public ActionResult SendReceipt(int id) { IEnumerable <Customers> receipt = db.Database.SqlQuery <Customers>("select distinct Customers.Customer_ID, customers.First_Name, Customers.Last_Name, customers.Street_Address, Customers.City, customers.State, Customers.Phone, Customers.Email, customers.Qualify_Discount, Customers.Password, customers.User_Role_ID " + "FROM Customers " + "inner join Work_Orders on " + "Work_Orders.Customer_ID = Customers.Customer_ID " + "inner join Compound_Receipts on " + "Work_Orders.Work_Order_ID = Compound_Receipts.Work_Order_ID " + "where Work_Orders.Work_Order_ID = " + id); Compound_Receipts compound_Receipts = db.Compound_Receipts.Find(id); Customers cust = db.Customers.FirstOrDefault(p => p.Email == User.Identity.Name); List <Customers> listReceipt = receipt.ToList(); Customers firstReceipt = listReceipt.First(); var senderEmail = new MailAddress("*****@*****.**", "Northwest Labs"); var receiverEmail = new MailAddress(firstReceipt.Email, "Receiver"); var password = "******"; var body = "Recipe ID: " + compound_Receipts.Compound_Receipt_ID + "\n" + "Lab Tests Number: " + compound_Receipts.LT + "\n" + "Compound sequence code: " + compound_Receipts.Compound_Sequence_Code + "\n" + "Compound Name: " + compound_Receipts.Compound_Name + "\n" + "Quantity: " + compound_Receipts.Quantity + "\n" + "Date Arived: " + compound_Receipts.Date_Arrived + "\n" + "Received By: " + compound_Receipts.Received_By + "\n" + "Date Due: " + compound_Receipts.Date_Due + "\n" + "Appearance: " + compound_Receipts.Appearance + "\n" + "Indicated Weight: " + compound_Receipts.Indicated_Weight + "\n" + "Molecular Mass: " + compound_Receipts.Molecular_Mass + "\n" + "Actual Weight: " + compound_Receipts.Actual_Weight + "\n" + "Maximum Tolerated Dose: " + compound_Receipts.MTD + "\n" + "Confirmation Date: " + compound_Receipts.Confirmation_Date + "\n" + "Work Order ID: " + compound_Receipts.Work_Order_ID + "\n" + "Test Results: " + compound_Receipts.Test_Results; var smtp = new SmtpClient { Host = "smtp.gmail.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new NetworkCredential(senderEmail.Address, password) }; using (var mess = new MailMessage(senderEmail, receiverEmail) { Subject = "From Northwest Labs Singapore", Body = "Our email if you have any questions: " + senderEmail.Address + "\n" + "Message: " + body }) { smtp.Send(mess); } return(RedirectToAction("Index", "Home")); }
// GET: Compound_Receipts/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Compound_Receipts compound_Receipts = db.Compound_Receipts.Find(id); if (compound_Receipts == null) { return(HttpNotFound()); } return(View(compound_Receipts)); }
public ActionResult Create([Bind(Include = "LT,Compound_Sequence_Code,Compound_Name,Quantity,Date_Arrived,Received_By,Date_Due,Appearance,Indicated_Weight,Molecular_Mass,Actual_Weight,MTD,Confirmation_Date,Confirmation_Time,Work_Order_ID,Test_Results")] Compound_Receipts compound_Receipts) { if (ModelState.IsValid) { db.Compound_Receipts.Add(compound_Receipts); db.SaveChanges(); if (db.Work_Orders.Find(compound_Receipts.Work_Order_ID) != null) { if (compound_Receipts.Date_Arrived != null) { IEnumerable <Customers> receipt = db.Database.SqlQuery <Customers>("select distinct Customers.Customer_ID, customers.First_Name, Customers.Last_Name, customers.Street_Address, Customers.City, customers.State, Customers.Phone, Customers.Email, customers.Qualify_Discount, Customers.Password, customers.User_Role_ID " + "FROM Customers " + "inner join Work_Orders on " + "Work_Orders.Customer_ID = Customers.Customer_ID " + "inner join Compound_Receipts on " + "Work_Orders.Work_Order_ID = Compound_Receipts.Work_Order_ID " + "where Work_Orders.Work_Order_ID = " + compound_Receipts.Work_Order_ID); Customers cust = db.Customers.FirstOrDefault(p => p.Email == User.Identity.Name); List <Customers> listReceipt = receipt.ToList(); Customers firstReceipt = listReceipt.First(); var senderEmail = new MailAddress("*****@*****.**", "Northwest Labs"); var receiverEmail = new MailAddress(firstReceipt.Email, "Receiver"); var password = "******"; var body = "Your Order has been received in Singapore on date: " + compound_Receipts.Date_Arrived + ". We will begin working on the tests as soon as possible."; var smtp = new SmtpClient { Host = "smtp.gmail.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new NetworkCredential(senderEmail.Address, password) }; using (var mess = new MailMessage(senderEmail, receiverEmail) { Subject = "From Northwest Labs Singapore", Body = "Our email if you have any questions: " + senderEmail.Address + "\n" + "Message: " + body }) { smtp.Send(mess); } {// stuff to change date of due for stuff if (compound_Receipts.Date_Due != null) { IEnumerable <SortingworkOrders> date = db.SortingWorkOrders .Where(o => o.Work_Order_ID == compound_Receipts.Work_Order_ID); List <SortingworkOrders> newDate = date.ToList(); foreach (SortingworkOrders ordere in newDate) { ordere.Date_Due = compound_Receipts.Date_Due; // db.SortingWorkOrders.FirstOrDefault(p => p.Database_Number == lastOne.Database_Number).Date_Due = compound_Receipts.Date_Due; db.SaveChanges(); } } } } } return(RedirectToAction("Index")); } ViewBag.error = "ERROR: Make sure your work order id is correct."; return(View(compound_Receipts)); }