public ActionResult Add_Price_Quote([Bind(Include = "Order_ID,Customer_ID,Order_Date,Date_Received,Due_Date,Order_Rerun_Date,Order_Complete_Date,Order_Comments,Order_Quote,Summary_Report,Data_Report")] Order order)
{
if (ModelState.IsValid)
{
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
return(View("Added_Price_Quote"));
}
return(View(order));
}
public ActionResult Edit_Customer([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.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult EditWork_Orders([Bind(Include = "Work_Order_ID,Status_ID,Customer_ID,Instructions,Rush,Price_Quote,Discount,Total_Cost")] Work_Orders work_Orders)
{
//work_Orders.Status_ID = 1; //reset status after changes
// work_Orders.Customer_ID = db.Work_Orders.Find(work_Orders.Work_Order_ID).Customer_ID;
if (ModelState.IsValid)
{
db.Entry(work_Orders).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(work_Orders));
}
public ActionResult EditBankInfo([Bind(Include = "EmployeeBankInfoID,BankAccount,RoutingNumber,AccountType,ModifiedBy,ModifiedDate")] EmployeeBankInfo employeeBankInfo)
{
employeeBankInfo.EmployeeID = GetEmployeeID();
if (IsClient())
{
RedirectToAction("Index");
}
if (ModelState.IsValid)
{
db.Entry(employeeBankInfo).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("EmployeeAccount");
}
return View(employeeBankInfo);
}
public ActionResult Edit([Bind(Include = "OrderID, CustID,CustInstructions,SpecialDiscount,Priority,ShipDate")] WorkOrder workOrder)
{
if (ModelState.IsValid)
{
//workOrder.Customer = db.Customers.Find(workOrder.CustID);
//db.Entry(workOrder).State = EntityState.Modified;
//db.Database.ExecuteSqlCommand(
// "Update WorkOrder SET (CustInstructions, SpecialDiscount, Priority, ShipDate) " +
// "values(" + workOrder.CustInstructions + ", " + workOrder.SpecialDiscount + ", " +
// workOrder.Priority + ", " + workOrder.ShipDate + ") " +
// "Where CustID = " + workOrder.CustID + ";");
//db.Database.ExecuteSqlCommand(
// "Update WorkOrder SET CustInstructions = " + workOrder.CustInstructions +
// ", SpecialDiscount = " + workOrder.SpecialDiscount +
// ", Priority = " + workOrder.Priority +
// ", ShipDate = " + workOrder.ShipDate +
// " Where CustID = " + workOrder.CustID +
// " And OrderID = " + workOrder.OrderID + ";");
db.Entry(workOrder).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustID = new SelectList(db.Customers, "CustID", "CustFirstName", workOrder.Customer.CustID);
return(View(workOrder));
}
public ActionResult Edit([Bind(Include = "customerID,firstName,lastName,companyName,streetAddress,city,state,zip,email,phone,discountRate")] Customer customer)
{
if (ModelState.IsValid)
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Edit([Bind(Include = "Customer_Payment_ID,Card_Type,Card_Num,Card_Expiration,Card_CVV")] Customer_Payment customer_Payment)
{
if (ModelState.IsValid)
{
db.Entry(customer_Payment).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", new { id = customer_Payment.Customer_Payment_ID }));
}
return(View(customer_Payment));
}
public ActionResult Edit([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.Entry(compound).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(compound));
}
public ActionResult Edit([Bind(Include = "CompoundId,LT,OrderId,Name,Quantity,Date_Arrived,Received_By,Appearance,Reported_Weight,Molecular_Mass,Max_Tolerated_Dose,Due_Date")] Compound compound)
{
if (ModelState.IsValid)
{
db.Entry(compound).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details/" + compound.CompoundId));
}
return(View(compound));
}
public ActionResult Edit([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.Entry(order).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(order));
}
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 Edit([Bind(Include = "CustID,CustFirstName,CustLastName,CustAddress1,CustAddress2,CustCity,StateID,CustZip,CountryID,CustPhone,CustEmail,PaymentInfo,CustUserName,Comments,Balance")] Customer customer)
{
if (ModelState.IsValid)
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Edit([Bind(Include = "EmployeeID,Name,Address,Phone,Position,Location,StartDate,UserName,Password,ModifiedBy,ModifiedDate,CreatedBy,CreatedDate")] Employee employee)
{
if (ModelState.IsValid)
{
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public ActionResult Edit([Bind(Include = "TestId,TestName,Protocol,TestDurationDays,ConditionalTest,BasePrice,MaterialsCost,WageEstimate,QtyInStock")] Test test)
{
if (ModelState.IsValid)
{
db.Entry(test).State = EntityState.Modified;
db.SaveChanges();
return(Redirect("/Materials"));
}
return(View(test));
}
public ActionResult Edit([Bind(Include = "PaymentInfoID,CardNum,SecCode,NameOnCard,ExpMonth,ExpYear")] PaymentInfo paymentInfo)
{
if (ModelState.IsValid)
{
db.Entry(paymentInfo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(paymentInfo));
}
public ActionResult Edit([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.Entry(work_Orders).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(work_Orders));
}
public ActionResult Edit([Bind(Include = "Database_Number,order,Work_Order_Assay_ID,Work_Order_ID,Assay_Cost,Assay_ID,Date_Due")] SortingworkOrders sortingworkOrders)
{
if (ModelState.IsValid)
{
db.Entry(sortingworkOrders).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sortingworkOrders));
}
public ActionResult Edit([Bind(Include = "KnowledgeBaseId,Title,Author,Date,Contents")] KnowledgeBase knowledgeBase)
{
if (ModelState.IsValid)
{
db.Entry(knowledgeBase).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(knowledgeBase));
}
public ActionResult EditClients([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.Entry(client).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ClientIndex"));
}
return(View(client));
}
public ActionResult Edit([Bind(Include = "Assay_ID,Assay_Abbreviation,Assay_Desc,Assay_Duration,Employee_Cost,Base_Price,Assay_Results")] Assays assays)
{
if (ModelState.IsValid)
{
db.Entry(assays).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(assays));
}
public ActionResult Edit([Bind(Include = "Invoice_ID,Customer_ID,Payment_Due,Early_Payment,Early_Discount,Total_Cost")] Invoice invoice)
{
if (ModelState.IsValid)
{
db.Entry(invoice).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(invoice));
}
public ActionResult Edit([Bind(Include = "Test_Tube_ID,Concentration,Assay_ID,LT_Number")] Test_Tube test_Tube)
{
if (ModelState.IsValid)
{
db.Entry(test_Tube).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(test_Tube));
}
public ActionResult EditTest([Bind(Include = "TestID, LTNumber, SampleID, TestTypeID, EmployeeID, StatusID, WorkOrderID")] CompoundTests compoundTests)
{
if (ModelState.IsValid)
{
db.Entry(compoundTests).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("EditTest"));
}
return(View(compoundTests));
}
public ActionResult Edit([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.Entry(compound_Sample).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(compound_Sample));
}
public ActionResult Edit([Bind(Include = "OrderID,CustomerID,LTNumber,Status,dateArrived,dateDue,custWeight,actualWeight,Quantity")] Work_Order work_Order)
{
if (ModelState.IsValid)
{
db.Entry(work_Order).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(work_Order));
}
public ActionResult Edit([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.Entry(work_Order_Assays).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(work_Order_Assays));
}
public ActionResult Edit([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.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public ActionResult Edit([Bind(Include = "ClientId,Company,Address_1,Address_2,Primary_Contact,Phone_1,Phone_2,Email_1,Email_2,City,State,Country,Zip,Payment_Info")] Client client)
{
if (ModelState.IsValid)
{
db.Entry(client).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details/" + client.ClientId));
}
return(View(client));
}
public ActionResult Edit([Bind(Include = "Customer_ID,Email,Password,First_Name,Last_Name,Street_Address,City,State,Phone,Qualify_Discount,User_Role_ID,Customer_Payment_ID")] Customers customers)
{
if (ModelState.IsValid)
{
db.Entry(customers).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details"));
}
return(View(customers));
}
public ActionResult Edit([Bind(Include = "LTNumber,OrderID,CompName,Volume,VolumeUnitID,DateArrived,ReceivedBy,DateDue,ClientWeight,MolecularMass,ConfID,ActualWeight,ActualWeightID,DoseID")] Compound compound)
{
if (ModelState.IsValid)
{
db.Entry(compound).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(compound));
}
