public ActionResult UpdateDriver([FromBody] UpdateDriverResults results)
{
using RDATContext context = new RDATContext();
// Check for Drug Update
//if (results != null && results.Drug_TestingLogID != 0)
//{
// TestingLog _drugResults = context.TestingLogs.Where(tl => tl.Id == results.Drug_TestingLogID).FirstOrDefault();
// _drugResults.ResultsDate = results.Drug_Results_Date;
// _drugResults.Reported_Results = results.Drug_Reported_Result;
// context.Update(_drugResults);
// context.SaveChanges();
//}
// Check for Alcohol
//if (results != null && results.Alcohol_TestingLogID != 0)
//{
// TestingLog _alcoholResults = context.TestingLogs.Where(tl => tl.Id == results.Alcohol_TestingLogID).FirstOrDefault();
// _alcoholResults.ResultsDate = results.Alcohol_Results_Date;
// _alcoholResults.Reported_Results = results.Alcohol_Reported_Result;
// context.Update(_alcoholResults);
// context.SaveChanges();
//}
if (results == null)
{
// Send "false"
return(Json(new { success = false, responseText = "The attached file is not supported." }));
}
else
{
// Send "Success"
return(Json(new { success = true, responseText = "Your message successfuly sent!" }));
}
}
public UpdateDriverResults GetDriver(int id)
{
var thisID = id;
using RDATContext context = new RDATContext();
UpdateDriverResults _driverResults = new UpdateDriverResults();
Driver _driver = context.Drivers.Where(c => c.Id == id).FirstOrDefault();
int _batchId = context.Batches.OrderByDescending(b => b.Id).FirstOrDefault().Id;
// Get TestingLog
// TODO: Create List of Alcohol Dates - There can be multiples
List <TestingLog> _logDrug = context.TestingLogs.Where(l => l.Driver_Id == id && l.Test_Type == "Drug" && l.ResultsDate == null).ToList();
// TODO: Create List of Alcohol Dates - There can be multiples
List <TestingLog> _logAlcohol = context.TestingLogs.Where(l => l.Driver_Id == id && l.Test_Type == "Alcohol" && l.ResultsDate == null).ToList();
// Set Values
_driverResults.Driver_Id = _driver.Id;
_driverResults.Driver_Name = _driver.DriverName;
_driverResults.Company_Name = context.Companys.Where(c => c.Id == _driver.Company_id).FirstOrDefault().Name;
_driverResults.Driver_UniqueID = _driver.UniqueId.ToString();
// Do we have results
_driverResults.Alcohol_Show = _logAlcohol.Count > 0 ? true : false;
_driverResults.Drug_Show = _logDrug.Count > 0 ? true : false;
// Alcohol Test
if (_logAlcohol.Count > 0)
{
List <AlcoholResult> results = new List <AlcoholResult>();
foreach (TestingLog tl in _logAlcohol)
{
AlcoholResult alcoholResult = new AlcoholResult();
alcoholResult.Alcohol_TestingLogID = tl.Id;
alcoholResult.Alcohol_Test_Date = tl.TestDate;
alcoholResult.Alcohol_Specimen_Id = tl.Specimen_Id;
alcoholResult.Alcohol_Results_Date = tl.ResultsDate;
alcoholResult.Alcohol_Reported_Result = tl.Reported_Results;
alcoholResult.BatchID = tl.Batch_Id;
results.Add(alcoholResult);
}
_driverResults.AlcoholResults = results;
}
// Drug Test
if (_logDrug.Count > 0)
{
List <DrugResult> dresults = new List <DrugResult>();
foreach (TestingLog tl in _logDrug)
{
DrugResult drugResult = new DrugResult();
drugResult.Drug_TestingLogID = tl.Id;
drugResult.Drug_Test_Date = tl.TestDate;
drugResult.Drug_Specimen_Id = tl.Specimen_Id;
drugResult.Drug_Results_Date = tl.ResultsDate;
drugResult.Drug_Reported_Result = tl.Reported_Results;
drugResult.BatchID = tl.Batch_Id;
dresults.Add(drugResult);
}
_driverResults.DrugResults = dresults;
}
return(_driverResults);
}
