public void UpdateDrugSeal(string userId, bool COCA, bool BARB, bool LSD, bool METH, bool MTQL, bool PCP, bool KET, bool BUPRE, bool CAT, bool PPZ, bool NPS, string updatedBy) { string NRIC = new DAL_User().GetUserByUserId(userId).Data.NRIC; var localRepo = _localUnitOfWork.GetRepository <DrugResult>(); DateTime today = DateTime.Today; DrugResult drug = _localUnitOfWork.DataContext.DrugResults.FirstOrDefault(d => d.NRIC.Equals(NRIC) && DbFunctions.TruncateTime(d.UploadedDate) == today); if (drug != null) { drug.COCA = COCA; drug.BARB = BARB; drug.LSD = LSD; drug.METH = METH; drug.MTQL = MTQL; drug.PCP = PCP; drug.KET = KET; drug.BUPRE = BUPRE; drug.CAT = CAT; drug.PPZ = PPZ; drug.NPS = NPS; drug.IsSealed = true; drug.SealedOrDiscardedBy = updatedBy; drug.SealedOrDiscardedDate = DateTime.Now; localRepo.Update(drug); _localUnitOfWork.Save(); } }
public string GetResultUTByNRIC(string NRIC, DateTime date) { date = date.Date; DrugResult drug = _localUnitOfWork.DataContext.DrugResults.FirstOrDefault(d => d.NRIC.Equals(NRIC) && DbFunctions.TruncateTime(d.UploadedDate) == date); if (drug == null) { return(string.Empty); } else { if ( (drug.AMPH.HasValue && drug.AMPH.Value) || (drug.BENZ.HasValue && drug.BENZ.Value) || (drug.OPI.HasValue && drug.OPI.Value) || (drug.THC.HasValue && drug.THC.Value) ) { return(EnumUTResult.POS); } else { return(EnumUTResult.NEG); } } //if (EnumAppConfig.IsLocal) //{ //} //else //{ // DrugResult drug = _centralizedUnitOfWork.DataContext.DrugResults.FirstOrDefault(d => d.NRIC.Equals(NRIC)); // if (drug == null) // return EnumUTResult.NEG; // else // { // if (drug.AMPH.Value || drug.BARB.Value || drug.BENZ.Value || drug.BUPRE.Value || drug.CAT.Value || drug.COCA.Value || drug.KET.Value || drug.LSD.Value // || drug.METH.Value || drug.MTQL.Value || drug.NPS.Value || drug.OPI.Value || drug.PCP.Value || drug.PPZ.Value || drug.THC.Value) // { // return EnumUTResult.POS; // } // else // { // return EnumUTResult.NEG; // } // } //} }
public string GetDrugTypeByNRIC(string NRIC) { if (EnumAppConfig.IsLocal) { System.Text.StringBuilder result = new System.Text.StringBuilder(); DrugResult drug = _localUnitOfWork.DataContext.DrugResults.FirstOrDefault(d => d.NRIC.Equals(NRIC)); if (drug == null) { result.Append("NA-"); } else { if (drug.AMPH == true) { result.Append("AMPH-"); } if (drug.BENZ == true) { result.Append("BENZ-"); } if (drug.OPI == true) { result.Append("OPI-"); } if (drug.THC == true) { result.Append("THC-"); } if (drug.COCA == true) { result.Append("COCA-"); } if (drug.BARB == true) { result.Append("BARB-"); } if (drug.LSD == true) { result.Append("LSD-"); } if (drug.METH == true) { result.Append("METH-"); } if (drug.MTQL == true) { result.Append("MTQL-"); } if (drug.PCP == true) { result.Append("PCP-"); } if (drug.KET == true) { result.Append("KET-"); } if (drug.BUPRE == true) { result.Append("BUPRE-"); } if (drug.CAT == true) { result.Append("CAT-"); } if (drug.PPZ == true) { result.Append("PPZ-"); } if (drug.NPS == true) { result.Append("NPS-"); } if (string.IsNullOrEmpty(result.ToString())) { result.Append("NA-"); } } return(result.ToString().Remove(result.ToString().Length - 1)); } else { System.Text.StringBuilder result = new System.Text.StringBuilder(); DrugResult drug = _centralizedUnitOfWork.DataContext.DrugResults.FirstOrDefault(d => d.NRIC.Equals(NRIC)); if (drug == null) { result.Append("NA-"); } else { if (drug.AMPH == true) { result.Append("AMPH-"); } if (drug.BENZ == true) { result.Append("BENZ-"); } if (drug.OPI == true) { result.Append("OPI-"); } if (drug.THC == true) { result.Append("THC-"); } if (drug.COCA == true) { result.Append("COCA-"); } if (drug.BARB == true) { result.Append("BARB-"); } if (drug.LSD == true) { result.Append("LSD-"); } if (drug.METH == true) { result.Append("METH-"); } if (drug.MTQL == true) { result.Append("MTQL-"); } if (drug.PCP == true) { result.Append("PCP-"); } if (drug.KET == true) { result.Append("KET-"); } if (drug.BUPRE == true) { result.Append("BUPRE-"); } if (drug.CAT == true) { result.Append("CAT-"); } if (drug.PPZ == true) { result.Append("PPZ-"); } if (drug.NPS == true) { result.Append("NPS-"); } if (string.IsNullOrEmpty(result.ToString())) { result.Append("NA-"); } } return(result.ToString().Remove(result.ToString().Length - 1)); } }
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); }