public ActionResult add2Test(int?id) { count += 1; ViewBag.ID = id; Assays assays = db.Assays.Find(id); Work_Order_Assays theTest = new Work_Order_Assays(); theTest.Work_Order_ID = workOrderId; theTest.Assay_ID = assays.Assay_ID; theTest.Assay_Cost = assays.Base_Price + assays.Employee_Cost * assays.Assay_Duration; db.Work_Order_Assays.Add(theTest); db.SaveChanges(); SortingworkOrders sortDB = new SortingworkOrders(); sortDB.Assay_Cost = theTest.Assay_Cost; sortDB.Assay_ID = theTest.Assay_ID; sortDB.Work_Order_ID = workOrderId; sortDB.Date_Due = Convert.ToDateTime("01/01/1901"); // get from query from thingy sortDB.order = count; sortDB.Work_Order_Assay_ID = theTest.Work_Order_Assay_ID; db.SortingWorkOrders.Add(sortDB); db.SaveChanges(); return(RedirectToAction("Index", new { id = workOrderId })); }
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 CreateCompound([Bind(Include = "LTNumber, CompoundName,Quantity,DateArrived,EmployeeID,DateDue,Appearance, Weight, MolecularMass, MTD")] Compound compound) { if (ModelState.IsValid) { db.Compounds.Add(compound); db.SaveChanges(); return(RedirectToAction("WorkList")); } return(View(compound)); }
// GET: Work_Orders public ActionResult Index() { Customers cust = db.Customers.FirstOrDefault(p => p.Email == User.Identity.Name); if (cust != null) { ViewBag.Statuses = ""; lstWork_Orders = db.Work_Orders .Where(o => o.Customer_ID == cust.Customer_ID) .ToList(); foreach (Work_Orders order in lstWork_Orders) { IEnumerable <Work_Order_Assays> assays = db.Database.SqlQuery <Work_Order_Assays>("select Work_Order_Assay_ID, Work_Order_Assays.Work_Order_ID,Work_Order_Assays.Assay_Cost,Work_Order_Assays.Assay_ID,Work_Order_Assays.Assay_Results " + "from Work_Order_Assays " + "Where Work_order_Assays.Work_Order_ID = " + order.Work_Order_ID); List <Work_Order_Assays> myList = assays.ToList(); double totalPrice = 0; foreach (Work_Order_Assays thing in myList) { totalPrice += thing.Assay_Cost; } if (order.Rush) { totalPrice = totalPrice * 1.15; } if (order.Discount) { totalPrice = totalPrice - totalPrice * .15; } order.Price_Quote = totalPrice; if (order.Conditional_Tests) { totalPrice = totalPrice + totalPrice * .5; } order.Total_Cost = totalPrice; Status myStatus = db.Statuses.FirstOrDefault(o => o.Status_ID == order.Status_ID); string sStatus = myStatus.Status_Desc; ViewBag.Statuses = ViewBag.Statuses + sStatus + ","; db.Work_Orders.Find(order.Work_Order_ID).Total_Cost = totalPrice; db.Work_Orders.Find(order.Work_Order_ID).Price_Quote = order.Price_Quote; db.SaveChanges(); } return(View(lstWork_Orders)); } else { return(View()); } }
public ActionResult Create([Bind(Include = "Customer_ID,Customer_Last_Name,Customer_First_Name,Customer_Address_1,Customer_Address_2,Customer_City,Customer_State,Customer_Zipcode,Customer_Home_Phone,Customer_Cell_Phone,Customer_Email,Customer_Password,Customer_Payment_Info,Customer_Discount,Customer_Balance")] Customer customer) { if (ModelState.IsValid) { db.Customer.Add(customer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }
public ActionResult Create([Bind(Include = "Test_Tube_ID,Concentration,Assay_ID,LT_Number")] Test_Tube test_Tube) { if (ModelState.IsValid) { db.Test_Tube.Add(test_Tube); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(test_Tube)); }
public ActionResult Create([Bind(Include = "Compound_Sample_ID,LT_Number,Compound_Sequence_Code,Compound_Name,Employee_ID,Appearance,Weight,Weight_Unit,Molecular_Mass,MTD,MTD_Units,Test_Date_Time,Pass_Fail,Quantitative_Data,Qualitative_Data")] Compound_Sample compound_Sample) { if (ModelState.IsValid) { db.Compound_Sample.Add(compound_Sample); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(compound_Sample)); }
public ActionResult Create([Bind(Include = "EmployeeWageInfoID,EmployeeID,LastIncreaseDate,LastIncreaseAmount,CurrentWage,WageType,DirectDeposit,ModifiedBy,ModifiedDate,CreatedBy,CreatedDate")] EmployeeWageInfo employeeWageInfo) { if (ModelState.IsValid) { db.EmployeeWageInfoes.Add(employeeWageInfo); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employeeWageInfo)); }
public ActionResult Create([Bind(Include = "Assay_ID,Assay_Abbreviation,Assay_Desc,Assay_Duration,Employee_Cost,Base_Price,Assay_Results")] Assays assays) { if (ModelState.IsValid) { db.Assays.Add(assays); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(assays)); }
public ActionResult Create([Bind(Include = "Customer_Payment_ID,Card_Type,Card_Num,Card_Expiration,Card_CVV")] Customer_Payment customer_Payment) { if (ModelState.IsValid) { db.Customer_Payments.Add(customer_Payment); db.SaveChanges(); return(RedirectToAction("Home", "Customers", new { area = "" })); } return(View(customer_Payment)); }
public ActionResult Create([Bind(Include = "KnowledgeBaseId,Title,Author,Date,Contents")] KnowledgeBase knowledgeBase) { if (ModelState.IsValid) { db.knowledgeBases.Add(knowledgeBase); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(knowledgeBase)); }
public ActionResult Create([Bind(Include = "PaymentInfoID,CardNum,SecCode,NameOnCard,ExpMonth,ExpYear")] PaymentInfo paymentInfo) { if (ModelState.IsValid) { db.PaymentInfo.Add(paymentInfo); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(paymentInfo)); }
public ActionResult Create([Bind(Include = "TestId,TestName,Protocol,TestDurationDays,ConditionalTest,BasePrice,MaterialsCost,WageEstimate,QtyInStock")] Test test) { if (ModelState.IsValid) { db.Tests.Add(test); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(test)); }
public ActionResult Create([Bind(Include = "Database_Number,order,Work_Order_Assay_ID,Work_Order_ID,Assay_Cost,Assay_ID,Date_Due")] SortingworkOrders sortingworkOrders) { if (ModelState.IsValid) { db.SortingWorkOrders.Add(sortingworkOrders); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sortingworkOrders)); }
public ActionResult Create([Bind(Include = "Work_Order_ID,Status_ID,Customer_ID,Instructions,Rush,Conditional_Tests,Price_Quote,Discount,Total_Cost")] Work_Orders work_Orders) { if (ModelState.IsValid) { db.Work_Orders.Add(work_Orders); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(work_Orders)); }
public ActionResult Create([Bind(Include = "CompoundID,LTNumber,SequenceCode,CompoundName,Quantity,DateArrived,ReceivedBy,DateDue,Appearance,Weight,MolecularMass,ConfirmationDate,MaxTotalDose,ActualWeight,ModifiedBy,ModifiedDate,CreatedBy,CreatedDate")] Compound compound) { if (ModelState.IsValid) { db.Compounds.Add(compound); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(compound)); }
public ActionResult Create([Bind(Include = "Customer_ID,First_Name,Last_Name,Street_Address,City,State,Phone,Email,Qualify_Discount,Password,User_Role_ID")] Customers customers) { if (ModelState.IsValid) { db.Customers.Add(customers); db.SaveChanges(); return(RedirectToAction("Index", "Customers")); } return(View(customers)); }
public ActionResult Create([Bind(Include = "AssayID,assayDescription")] Assay assay) { if (ModelState.IsValid) { db.Assays.Add(assay); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(assay)); }
public ActionResult Create([Bind(Include = "Employee_ID,Location_ID,Access_Level,Employee_First_Name,Employee_Last_Name,Employee_Email,Employee_Password,Employee_Position")] Employee employee) { if (ModelState.IsValid) { db.Employee.Add(employee); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }
public ActionResult Create([Bind(Include = "Invoice_ID,Customer_ID,Payment_Due,Early_Payment,Early_Discount,Total_Cost")] Invoice invoice) { if (ModelState.IsValid) { db.Invoice.Add(invoice); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(invoice)); }
public ActionResult Create([Bind(Include = "LTNumber,OrderID,CompName,Volume,VolumeUnitID,DateArrived,ReceivedBy,DateDue,ClientWeight,MolecularMass,ConfID,ActualWeight,ActualWeightID,DoseID")] Compound compound) { if (ModelState.IsValid) { db.Compounds.Add(compound); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(compound)); }
public ActionResult Create([Bind(Include = "OrderID,CustomerID,LTNumber,Status,dateArrived,dateDue,custWeight,actualWeight,Quantity")] Work_Order work_Order) { if (ModelState.IsValid) { db.Work_Order.Add(work_Order); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(work_Order)); }
public ActionResult Create([Bind(Include = "ClientID,CompanyName,ContactFirstName,ContactLastName,Address1,Address2,City,State,Country,Zip,Phone,Email,Username,PasswordHash,ModifiedBy,ModifiedDate,CreatedBy,CreatedDate")] Client client) { if (ModelState.IsValid) { db.Clients.Add(client); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(client)); }
public ActionResult Create([Bind(Include = "TestID,testName,estimatedDays,baseCost")] Test test) { if (ModelState.IsValid) { db.Tests.Add(test); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(test)); }
public ActionResult Create([Bind(Include = "EmployeeID,Name,Address,Phone,Position,Location,StartDate,UserName,Password,ModifiedBy,ModifiedDate,CreatedBy,CreatedDate")] Employee employee) { if (ModelState.IsValid) { db.Employees.Add(employee); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }
public ActionResult Create([Bind(Include = "Material_ID,Material_Name,Material_Quantity,Quantity_Unit,Material_Cost,Min_On_Hand")] Material material) { if (ModelState.IsValid) { db.Material.Add(material); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(material)); }
public ActionResult Create([Bind(Include = "Order_ID,Customer_ID,Order_Date,Date_Received,Due_Date,Order_Rerun_Date,Order_Complete_Date,Order_Comments,Summary_Report,Data_Report")] Order order) { if (ModelState.IsValid) { db.Order.Add(order); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(order)); }
public ActionResult Edit([Bind(Include = "Id,CompoundId,StatusId,StatusDate")] CompoundStatus compoundStatus) { if (ModelState.IsValid) { db.Entry(compoundStatus).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.StatusId = new SelectList(db.Statuses, "StatusId", "StatusName", compoundStatus.StatusId); return(View(compoundStatus)); }
public ActionResult Create([Bind(Include = "Work_Order_Assay_ID,Work_Order_ID,Assay_Cost,Assay_ID,Assay_results")] Work_Order_Assays work_Order_Assays) { if (ModelState.IsValid) { db.Work_Order_Assays.Add(work_Order_Assays); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(work_Order_Assays)); }
public ActionResult Create([Bind(Include = "CustID,CustFirstName,CustLastName,CustAddress1,CustAddress2,CustCity,StateID,CustZip,CountryID,CustPhone,CustEmail,PaymentInfo,CustUserName,Comments,Balance")] Customer customer) { if (ModelState.IsValid) { db.Customers.Add(customer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }