public ActionResult CreateTTube([Bind(Include = "TestTubeID,ScheduledDate,Concentration,LT,SequenceCode,AssayID,TestID")] SampleTest test)
{
if (ModelState.IsValid)
{
db.Entry(test).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(test));
}
public ActionResult Create([Bind(Include = "UserID,FirstName,LastName,Phone,Email,Password,RoleID,CompanyID")] User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CompanyID = new SelectList(db.Companies, "CompanyID", "Name", user.CompanyID);
ViewBag.RoleID = new SelectList(db.Roles, "RoleID", "Name", user.RoleID);
return(View(user));
}
public ActionResult CreateTicket([Bind(Include = "PriorityName,OrderID,Comment")] Ticket ticket)
{
if (ModelState.IsValid)
{
ticket.DateSubmitted = DateTime.Now;
ticket.UserID = Convert.ToInt32(Request.Cookies["UserID"].Value);
ticket.TicketID = db.Tickets.Max(p => p.TicketID) + 1;
db.Tickets.Add(ticket);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PriorityName = new SelectList(db.Priorities, "PriorityName", "PriorityName", ticket.PriorityName);
ViewBag.OrderID = new SelectList(db.WorkOrders, "OrderID", "OrderID", ticket.OrderID);
return(View(ticket));
}
public ActionResult CreateAccount([Bind(Include = "UserID,FirstName,LastName,Phone,Email,Password,RoleID,CompanyID")] User user, FormCollection form)
{
if (ModelState.IsValid)
{
// Assign user to their role
user.RoleID = 1;
// Assign PK
user.UserID = db.Users.ToList().Max(x => x.UserID) + 1;
// Determine if company is already in db
List <Company> Companies = db.Companies.ToList();
Boolean CompanyExists = false;
foreach (var Item in Companies)
{
if (Item.Name.Equals(form["CompanyName"].ToString()))
{
user.CompanyID = Item.CompanyID;
CompanyExists = true;
}
}
// Add custoemr to the database if the company exists
if (CompanyExists)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index", "Customer"));
}
else
{
PendedUser = user;
return(RedirectToAction("CreateCompany", new { CompanyName = form["CompanyName"].ToString() }));
}
}
return(View(user));
}
public ActionResult RequestOrder(FormCollection form)
{
/*Weight
* DateDue
* AssayID
* Comments
*/
List <string> sAssays = form["AssayID"].Split(',').ToList();
int iCount = 0;
int iCount1 = 0;
int iCount2 = 0;
int iCount3 = 0;
foreach (var Compound in workOrderCompoundSample.compoundSampleSampleTests)
{
Compound.compoundSample.DateDue = Convert.ToDateTime(form["DateDue"]);
// Clear the Sample tests for each compound to determine the amount of samples tests within each assay
Compound.sampleTests.Clear();
iCount3 = 0;
// Loop for all the assays
for (iCount = 0; iCount < iTest.ElementAt(iCount1); iCount++)
{
Compound.compoundSample.AssayID = sAssays.ElementAt(iCount);
var Tests = db.Database.SqlQuery <AssayTest>("SELECT * FROM AssayTest WHERE AssayID = '" + Compound.compoundSample.AssayID + "'").ToList();
// Loop for all the sample tests within each assay
for (iCount2 = 0; iCount2 < Tests.Count(); iCount2++)
{
Compound.sampleTests.Add(new SampleTest());
Compound.sampleTests.ElementAt(iCount3).LT = workOrderCompoundSample.compound.LT;
Compound.sampleTests.ElementAt(iCount3).SequenceCode = Compound.compoundSample.SequenceCode;
iTestTubeCounter++;
Compound.sampleTests.ElementAt(iCount3).TestTubeID = iTestTubeCounter;
Compound.sampleTests.ElementAt(iCount3).TestID = Tests.ElementAt(iCount2).TestID;
Compound.sampleTests.ElementAt(iCount3).AssayID = Compound.compoundSample.AssayID;
iCount3++;
}
}
iCount1++;
}
workOrderCompoundSample.workOrder.Comments = form["workOrder.Comments"];
// Update database tables
// Update Work Order
db.WorkOrders.Add(workOrderCompoundSample.workOrder);
db.SaveChanges();
// Check if Compound is already in table
var Compounds = db.Compounds.ToList();
Boolean CompoundUpdate = true;
foreach (var Item in Compounds)
{
if (Item.Name == workOrderCompoundSample.compound.Name)
{
CompoundUpdate = false;
}
}
// Updated Compound
if (CompoundUpdate)
{
db.Compounds.Add(workOrderCompoundSample.compound);
db.SaveChanges();
}
// Loop to Update Compound Samples
foreach (var Item in workOrderCompoundSample.compoundSampleSampleTests)
{
db.CompoundSamples.Add(Item.compoundSample);
db.SaveChanges();
// Loop to updated Sample Tests
foreach (var SampleTest in Item.sampleTests)
{
db.SampleTests.Add(SampleTest);
db.SaveChanges();
}
}
return(RedirectToAction("Confirmation", new { Name = user.FirstName }));
}