public ActionResult NewQuote(int?QuoteID, [Bind(Include = "QuoteID,AssayID")] QuoteItem quoteItem) { QuoteEstimate MyQuote = new QuoteEstimate(); if (QuoteID == null || QuoteID == 0) { MyQuote.ClientID = GetClientID(); MyQuote.CreatedBy = "Client " + GetClientID(); MyQuote.CreatedDate = DateTime.Now; MyQuote.ModifiedBy = "Client " + GetClientID(); MyQuote.ModifiedDate = DateTime.Now; MyQuote.QuoteDate = DateTime.Now; db.QuoteEstimates.Add(MyQuote); db.SaveChanges(); } else { MyQuote.QuoteID = (int)QuoteID; } QuoteItem MyItem = new QuoteItem(); MyItem.QuoteID = MyQuote.QuoteID; MyItem.AssayID = quoteItem.AssayID; MyItem.CreatedBy = "Client " + GetClientID(); MyItem.CreatedDate = DateTime.Now; MyItem.ModifiedBy = "Client " + GetClientID(); MyItem.ModifiedDate = DateTime.Now; MyItem.Cost = 0; IEnumerable <Test> testList = db.Tests.ToList(); foreach (Test test in testList) { if (test.AssayID == MyItem.AssayID) { MyItem.Cost += (test.BasePrice + (test.Hours * 40)); } } db.QuoteItems.Add(MyItem); db.SaveChanges(); IEnumerable <QuoteItem> items = db.QuoteItems.ToList(); MyQuote.QuoteItems = new List <QuoteItem>(); foreach (QuoteItem item in items) { if (item.QuoteID == MyQuote.QuoteID) { item.ProtocolNotebook = db.ProtocolNotebooks.Find(item.AssayID); MyQuote.QuoteItems.Add(item); } } ViewBag.AssayID = new SelectList(db.ProtocolNotebooks, "AssayID", "AssayName", quoteItem.AssayID); QuoteEstimateWithItemTemplate myModel = new QuoteEstimateWithItemTemplate(); myModel.Quote = MyQuote; return(View(myModel)); }
public ActionResult NewQuote() { ViewBag.AssayID = new SelectList(db.ProtocolNotebooks, "AssayID", "AssayName"); QuoteEstimateWithItemTemplate myModel = new QuoteEstimateWithItemTemplate(); myModel.Quote = new QuoteEstimate(); myModel.Quote.QuoteID = 0; return(View(myModel)); }