private void GetRequestResponse(IAsyncResult result) { try { Result = ((ISampleService)result.AsyncState).EndGetOOS(result); }catch (Exception ex) { Error = ex; }finally { service.Close(); service = null; } // Execute Last Caliburn.Micro.Execute.OnUIThread(() => Completed(this, new ResultCompletionEventArgs())); }
public IAsyncResult BeginSaveOos(Oos oos, Identification identification, AsyncCallback callback, object state) { logger.Log(LogLevel.Trace, AppLib.GetCaller(logger)); identification.UserId = AppLib.VerifyToken(identification.Token); if (identification.UserId <= 0) { throw new FaultException<ServiceFault>(new ServiceFault("Invalid Authentication", "Authorization"), new FaultReason("Unauthorized")); } var task = Task<int>.Factory.StartNew(process => DoSaveOos(oos, identification), state); return task.ContinueWith(res => callback(task)); }
public int DoSaveOos(Oos oos, Identification identification) { logger.Log(LogLevel.Trace, AppLib.GetCaller(logger)); //Validate Oos Object if (!oos.ValidateModel()) throw new FaultException<ServiceFault>(new ServiceFault(oos.CurrentErrors), new FaultReason(SysVars.InvalidFormat)); // Save Oos using (SampleDAO dao = new SampleDAO()) { return dao.SaveOOS(oos, identification); } }
public Oos GetOosData(string token, object recordId) { Oos result = new Oos(); User user = new User(); int userId = 0; this.Token = token; if (AppLib.DesignMode) { return new Oos(); } else { try { using (SystemDAO systemDao = new SystemDAO()) { userId = systemDao.GetToken(new Guid(this.Token)); } if (userId > 0) { using (UserDAO userDao = new UserDAO()) { user = userDao.GetUser(userId); } using (SampleDAO ordersDao = new SampleDAO()) { result = ordersDao.GetOOS(Convert.ToInt32(recordId), new Identification() { Token = new Guid(this.Token), UserId = (int)user.UserId }); } } } catch (Exception) { throw; } } return result; }
public int SaveOrderSampleTestOos(ref MsSqlPersistence dbConnection, ref SqlCommand dbCommand, Oos oos, Identification identification) { try { int returnValue = 0; string sql = string.Empty; dbCommand.Parameters.Clear(); if (oos.IsDirty) { sql = string.Empty; if (oos.OosId.IsNull() || oos.OosId <= 0) { sql = @" INSERT INTO orders_samples_tests_timepoints_oos ([parentid] ,[status] ,[is_sample_prep_acceptable] ,[is_raw_data_acceptable] ,[is_standard_acceptable] ,[is_method_acceptable] ,[is_parameters_acceptable] ,[is_trends_acceptable] ,[is_analyst_acceptable] ,[is_retest] ,[primary_cause] ,[client_contact_id] ,[client_contact_phone_id] ,[is_client_notified] ,[is_testing_complete] ,[review_comment] ,[conclusion_comment] ,[investigator_id] ,[investigation_date] ,[approved_by] ,[approved_date] ,[created_by] ) VALUES (@ParentId ,@Status ,@IsSamplePrepAcceptable ,@IsRawDataAcceptable ,@IsStandardAcceptable ,@IsMethodAcceptable ,@IsParametersAcceptable ,@IsTrendsAcceptable ,@IsAnalystAcceptable ,@IsRetest ,@PrimaryCause ,@ClientContactId ,@ClientContactPhoneId ,@IsClientNotified ,@IsTestingComplete ,@ReviewComment ,@ConclusionComment ,@InvestigatorId ,@InvestigationDate ,@ApprovedBy ,@ApprovedDate ,@CreatedBy ); SELECT id FROM orders_samples_tests_timepoints_oos WHERE (id = SCOPE_IDENTITY()); "; dbCommand.Parameters.Add("@ParentId", System.Data.SqlDbType.Int).Value = oos.SampleTestId; dbCommand.Parameters.Add("@CreatedBy", System.Data.SqlDbType.Int).Value = identification.UserId; } else { sql = @" UPDATE orders_samples_tests_timepoints_oos SET status = @Status ,is_sample_prep_acceptable = @IsSamplePrepAcceptable ,is_raw_data_acceptable = @IsRawDataAcceptable ,is_standard_acceptable = @IsStandardAcceptable ,is_method_acceptable = @IsMethodAcceptable ,is_parameters_acceptable = @IsParametersAcceptable ,is_trends_acceptable = @IsTrendsAcceptable ,is_analyst_acceptable = @IsAnalystAcceptable ,is_retest = @IsRetest ,primary_cause = @PrimaryCause ,client_contact_id = @ClientContactId ,client_contact_phone_id = @ClientContactPhoneId ,is_client_notified = @IsClientNotified ,is_testing_complete = @IsTestingComplete ,review_comment = @ReviewComment ,conclusion_comment = @ConclusionComment ,investigator_id = @InvestigatorId ,investigation_date = @InvestigationDate ,approved_by = @ApprovedBy ,approved_date = @ApprovedDate ,modified_by = @ModifiedBy WHERE id = @ID; "; dbCommand.Parameters.Add("@ID", System.Data.SqlDbType.Int).Value = oos.OosId; dbCommand.Parameters.Add("@ModifiedBy", System.Data.SqlDbType.Int).Value = identification.UserId; } dbCommand.CommandText = sql; /*dbCommand.Parameters.Add("@Status", System.Data.SqlDbType.Int).Value = (int)oos.Status; dbCommand.Parameters.Add("@IsSamplePrepAcceptable", System.Data.SqlDbType.Bit).Value = oos.PreparationYN; dbCommand.Parameters.Add("@IsRawDataAcceptable", System.Data.SqlDbType.Bit).Value = oos.RawDataYN; dbCommand.Parameters.Add("@IsStandardAcceptable", System.Data.SqlDbType.Bit).Value = oos.StandardsReagentsYN; dbCommand.Parameters.Add("@IsMethodAcceptable", System.Data.SqlDbType.Bit).Value = oos.MethodologyYN; dbCommand.Parameters.Add("@IsParametersAcceptable", System.Data.SqlDbType.Bit).Value = oos.InstrumentParametersYN; dbCommand.Parameters.Add("@IsTrendsAcceptable", System.Data.SqlDbType.Bit).Value = oos.TrendsYN; dbCommand.Parameters.Add("@IsAnalystAcceptable", System.Data.SqlDbType.Bit).Value = oos.AnalystYN; dbCommand.Parameters.Add("@IsRetest", System.Data.SqlDbType.Bit).Value = oos.IsRetest; dbCommand.Parameters.Add("@PrimaryCause", System.Data.SqlDbType.VarChar, 50).Value = oos.PrimaryCause ?? string.Empty; dbCommand.Parameters.Add("@ClientContactId", System.Data.SqlDbType.Int).Value = oos.ClientContactEmailYN ?? 0; dbCommand.Parameters.Add("@ClientContactPhoneId", System.Data.SqlDbType.Int).Value = oos.ClientContactPhoneYN ?? 0; dbCommand.Parameters.Add("@IsClientNotified", System.Data.SqlDbType.Bit).Value = oos.IsClientNotified; dbCommand.Parameters.Add("@IsTestingComplete", System.Data.SqlDbType.Bit).Value = oos.IsTestingComplete; dbCommand.Parameters.Add("@ReviewComment", System.Data.SqlDbType.NVarChar, -1).Value = oos.AdditionalObservations ?? string.Empty; dbCommand.Parameters.Add("@ConclusionComment", System.Data.SqlDbType.NVarChar, -1).Value = oos.Conclusion ?? string.Empty; dbCommand.Parameters.Add("@InvestigatorId", System.Data.SqlDbType.Int).Value = oos.InvestigatorId ?? 0; dbCommand.Parameters.Add("@InvestigationDate", System.Data.SqlDbType.DateTime).Value = oos.InvestigationDate.HasValue ? oos.InvestigationDate.Value : SqlDateTime.Null; dbCommand.Parameters.Add("@ApprovedBy", System.Data.SqlDbType.Int).Value = oos.ApprovedBy ?? 0; dbCommand.Parameters.Add("@ApprovedDate", System.Data.SqlDbType.DateTime).Value = oos.ApprovedDate.HasValue ? oos.ApprovedDate.Value : SqlDateTime.Null; */ if (oos.OosId.IsNotNull() && oos.OosId > 0) returnValue += dbConnection.ExecuteCommand(dbCommand); else returnValue = (int)dbConnection.ExecuteScalar(dbCommand); // Create Timepoint Entry if IsRetest // Calculate SampleTest Status if (oos.SampleTestId.IsNotNull()) this.OrderSampleTestsSetStatus(ref dbConnection, ref dbCommand, (int)oos.SampleTestId, identification); // Release Lock using (SystemDAO systemDao = new SystemDAO()) { //systemDao.ReleaseLock(ref dbConnection, ref dbCommand, (int)ModelNamesEnum.Order, oos.OrderId.ToString(), identification.Token); } } return returnValue; } catch { throw; } }
private SmartCollection<Oos> GetOOSs(bool showAll, ref MsSqlPersistence dbConnection, ref SqlCommand dbCommand, Identification identification) { try { SmartCollection<Oos> resultList = new SmartCollection<Oos>(); using (DbConnection = new MsSqlPersistence(DbConnectionSettings)) { if (DbConnection.IsConnected()) { using (DbCommand) { DbCommand.CommandType = CommandType.StoredProcedure; DbCommand.CommandText = "uspGetOOSs"; DbCommand.Parameters.Clear(); dbCommand.Parameters.Add("@IncludeAll", System.Data.SqlDbType.Bit).Value = showAll; DataTable returnDT = DbConnection.ExecuteQuery(DbCommand); foreach (DataRow row in returnDT.Rows) { Oos result = new Oos(); result.OosId = Convert.ToInt32(row["OOSID"]); if (row["ARLNumber"] != DBNull.Value) result.ARLNumber = (int)row["ARLNumber"]; if (row["SampleTestId"] != DBNull.Value) result.SampleTestId = (int)row["SampleTestId"]; result.ClientName = row["ClientName"].ToString(); result.Status = row["status"] != DBNull.Value ? (SampleTestStatus)row["status"] : SampleTestStatus.UnderInvestigation; result.TestName = row["TestName"].ToString(); result.AnalyteName = row["AnalyteName"].ToString(); result.PriorityName = row["PriorityName"].ToString(); if (row["DueDate"] != DBNull.Value) result.DueDate = (DateTime)row["DueDate"]; result.DepartmentName = row["DepartmentName"].ToString(); if (row["TimepointStudyYN"] != DBNull.Value) result.TimepointStudyYN = (bool)row["TimepointStudyYN"]; if (row["NextTimepoint"] != DBNull.Value) result.NextTimepoint = (DateTime)row["NextTimepoint"]; result.ModifiedUser = row["ModifiedUser"] != DBNull.Value ? row["ModifiedUser"].ToString() : null; result.CreatedUser = row["CreatedUser"] != DBNull.Value ? row["CreatedUser"].ToString() : null; result.CreatedDate = row["CreatedDate"] != DBNull.Value ? (DateTime)row["CreatedDate"] : new DateTime(); result.CreatedBy = row["CreatedBy"] != DBNull.Value ? (int)row["CreatedBy"] : new Int32(); result.ModifiedDate = row["ModifiedDate"] != DBNull.Value ? (DateTime)row["ModifiedDate"] : new DateTime(); result.ModifiedBy = row["ModifiedBy"] != DBNull.Value ? (int)row["ModifiedBy"] : new Int32(); // result.Results = resultList.Add(result); } returnDT = null; } } else { throw new Exception("Unable to Connect"); } } return resultList; } catch { throw; } }
public int SaveOrderSampleTestOos(Oos oos, Identification identification) { try { using (DbConnection = new MsSqlPersistence(DbConnectionSettings, true)) { if (DbConnection.IsConnected()) { using (DbCommand) { return this.SaveOrderSampleTestOos(ref dbConnection, ref dbCommand, oos, identification); } } else { throw new Exception("Unable to Connect"); } } } catch { throw; } }
public int SaveOOS(Oos Oos, Identification identification) { try { int returnValue = 0; if (Oos.IsDirty) { /* SystemDAO.SaveChangeAudit<SampleTest>(ref dbConnection, ref dbCommand, GetSampleTest(ref dbConnection, ref dbCommand, sampleTest.Pk ?? 0, identification), sampleTest, ModuleNames.Samples, sample.Pk, identification.UserId); */ DbCommand.Parameters.Clear(); DbCommand.CommandType = CommandType.StoredProcedure; DbCommand.CommandText = "uspUpdateOOS"; DbCommand.Parameters.Add("@OOSId", System.Data.SqlDbType.Int).Value = Oos.OosId; if (Oos.PreparationYN.IsNotNull()) DbCommand.Parameters.Add("@PreparationYN", System.Data.SqlDbType.Bit).Value = (bool)Oos.PreparationYN; if (Oos.RawDataYN != null) DbCommand.Parameters.Add("@RawDataYN", System.Data.SqlDbType.Bit).Value = (bool)Oos.RawDataYN; if (Oos.StandardsReagentsYN.IsNotNull()) DbCommand.Parameters.Add("@StandardsReagentsYN", System.Data.SqlDbType.Bit).Value = (bool)Oos.StandardsReagentsYN; if (Oos.MethodologyYN.IsNotNull()) DbCommand.Parameters.Add("@MethodologyYN", System.Data.SqlDbType.Bit).Value = (bool)Oos.MethodologyYN; if (Oos.InstrumentParametersYN.IsNotNull()) DbCommand.Parameters.Add("@InstrumentParametersYN", System.Data.SqlDbType.Bit).Value = (bool)Oos.InstrumentParametersYN; if (Oos.TrendsYN.IsNotNull()) DbCommand.Parameters.Add("@TrendsYN", System.Data.SqlDbType.Bit).Value = (bool)Oos.TrendsYN; if (Oos.AnalystYN.IsNotNull()) DbCommand.Parameters.Add("@AnalystYN", System.Data.SqlDbType.Bit).Value = (bool)Oos.AnalystYN; if (Oos.ClientContactEmailYN.IsNotNull()) DbCommand.Parameters.Add("@ClientContactEmailYN", System.Data.SqlDbType.Bit).Value = (bool)Oos.ClientContactEmailYN; if (Oos.ClientContactPhoneYN.IsNotNull()) DbCommand.Parameters.Add("@ClientContactPhoneYN", System.Data.SqlDbType.Bit).Value = (bool)Oos.ClientContactPhoneYN; if (Oos.ClientContactName.IsNotNull()) DbCommand.Parameters.Add("@ClientContactName", System.Data.SqlDbType.NVarChar, 100).Value = Oos.ClientContactName; if (Oos.ClientContactDate.IsNotNull()) DbCommand.Parameters.Add("@ClientContactDate", System.Data.SqlDbType.NVarChar, 100).Value = Oos.ClientContactDate; if (Oos.AdditionalObservations.IsNotNull()) DbCommand.Parameters.Add("@AdditionalObservations", System.Data.SqlDbType.NVarChar, 4000).Value = Oos.AdditionalObservations; if (Oos.Conclusion.IsNotNull()) DbCommand.Parameters.Add("@Conclusion", System.Data.SqlDbType.NVarChar, 4000).Value = Oos.Conclusion; if (Oos.PrimaryCause.IsNotNull()) DbCommand.Parameters.Add("@PrimaryCause", System.Data.SqlDbType.NVarChar, 100).Value = Oos.PrimaryCause; if (Oos.ResultInvalidatedYN.IsNotNull()) DbCommand.Parameters.Add("@ResultInvalidatedYN", System.Data.SqlDbType.Bit).Value = (bool)Oos.ResultInvalidatedYN; DbCommand.Parameters.Add("@ModifiedDate", System.Data.SqlDbType.DateTime).Value = DateTime.Now; DbCommand.Parameters.Add("@ModifiedBy", System.Data.SqlDbType.Int).Value = identification.UserId; // returnValue = Primary Key Id DbConnection.ExecuteCommand(DbCommand); // Save OOS Results SaveOOSResults(Oos.Results, identification); } //Return Total Number of Updated Records or Last Primary ID return returnValue; } catch { throw; } }
public SmartCollection<Oos> GetOrdersSampleTestsOoss(int orderid, Identification identification) { try { SmartCollection<Oos> resultList = new SmartCollection<Oos>(); using (DbConnection = new MsSqlPersistence(DbConnectionSettings)) { if (DbConnection.IsConnected()) { using (DbCommand) { string sql = @" SELECT Oos.id, Oos.parentid, Oos.status, Oos.is_sample_prep_acceptable, Oos.is_raw_data_acceptable, Oos.is_standard_acceptable, Oos.is_method_acceptable, Oos.is_parameters_acceptable, Oos.is_trends_acceptable, Oos.is_analyst_acceptable, Oos.is_retest, Oos.primary_cause, Oos.client_contact_id, Oos.client_contact_phone_id, Oos.is_client_notified,Oos.is_testing_complete, Oos.review_comment, Oos.conclusion_comment, Oos.investigator_id, Oos.investigation_date, Oos.approved_by, Oos.approved_date, Oos.created_by, Oos.created_date, Oos.modified_by, Oos.modified_date, Test.lab_number,Test.id AS SampleTestId, TimepointResult.result_date, (users.firstname + ' ' + users.lastname) as modifieduser, (users4.firstname + ' ' + users4.lastname) as ApprovedUser, (users2.firstname + ' ' + users2.lastname) as createduser, (users3.firstname + ' ' + users3.lastname) as InvestigationUser FROM Orders INNER JOIN orders_samples_tests AS Test ON Test.parentid = Orders.Id INNER JOIN orders_samples_tests_timepoints AS Timepoint ON Timepoint.parentid = Test.id INNER JOIN orders_samples_tests_timepoints_results AS TimepointResult ON TimepointResult.parentid = Timepoint.id INNER JOIN orders_samples_tests_timepoints_oos AS Oos ON Oos.parentid = Timepoint.id LEFT JOIN [User] as users ON Oos.modified_by = users.UserID LEFT JOIN [User] as users2 ON Oos.created_by = users2.UserID. LEFT JOIN [User] as users3 ON Oos.investigator_id = users3.UserID LEFT JOIN [User] as users4 ON Oos.approved_by = users4.UserID WHERE Orders.id = @OrderId ORDER BY Oos.id Desc "; DbCommand.CommandText = sql; DbCommand.Parameters.Add("@OrderId", System.Data.SqlDbType.Int).Value = orderid; DataTable returnDT = DbConnection.ExecuteQuery(DbCommand); foreach (DataRow row in returnDT.Rows) { Oos result = new Oos(); result.OosId = Convert.ToInt32(row["Id"]); /*result.ParentId = row["parentid"] != DBNull.Value ? (int)row["parentid"] : 0; result.Status = row["status"] != DBNull.Value ? (EnumOosStatus)row["status"] : EnumOosStatus.Open; result.PreparationYN = row["is_sample_prep_acceptable"] != DBNull.Value ? Convert.ToBoolean(row["is_sample_prep_acceptable"]) : false; result.RawDataYN = row["is_raw_data_acceptable"] != DBNull.Value ? Convert.ToBoolean(row["is_raw_data_acceptable"]) : false; result.StandardsReagentsYN = row["is_standard_acceptable"] != DBNull.Value ? Convert.ToBoolean(row["is_standard_acceptable"]) : false; result.MethodologyYN = row["is_method_acceptable"] != DBNull.Value ? Convert.ToBoolean(row["is_method_acceptable"]) : false; result.InstrumentParametersYN = row["is_parameters_acceptable"] != DBNull.Value ? Convert.ToBoolean(row["is_parameters_acceptable"]) : false; result.TrendsYN = row["is_trends_acceptable"] != DBNull.Value ? Convert.ToBoolean(row["is_trends_acceptable"]) : false; result.AnalystYN = row["is_analyst_acceptable"] != DBNull.Value ? Convert.ToBoolean(row["is_analyst_acceptable"]) : false; result.IsRetest = row["is_retest"] != DBNull.Value ? Convert.ToBoolean(row["is_retest"]) : false; result.PrimaryCause = row["primary_cause"].ToString(); result.ClientContactEmailYN = row["client_contact_id"] != DBNull.Value ? (int)row["client_contact_id"] : 0; result.ClientContactPhoneYN = row["client_contact_phone_id"] != DBNull.Value ? (int)row["client_contact_phone_id"] : 0; result.IsClientNotified = row["is_client_notified"] != DBNull.Value ? Convert.ToBoolean(row["is_client_notified"]) : false; result.IsTestingComplete = row["is_testing_complete"] != DBNull.Value ? Convert.ToBoolean(row["is_testing_complete"]) : false; result.AdditionalObservations = row["review_comment"].ToString(); result.Conclusion = row["conclusion_comment"].ToString(); result.InvestigatorId = row["investigator_id"] != DBNull.Value ? (int)row["investigator_id"] : 0; result.InvestigationDate = row["investigation_date"] != DBNull.Value ? (DateTime?)row["investigation_date"] : null; result.ApprovedBy = row["approved_by"] != DBNull.Value ? (int?)row["approved_by"] : null; result.ApprovedDate = row["approved_date"] != DBNull.Value ? (DateTime?)row["approved_date"] : null; result.ARLNumber = row["lab_number"] != DBNull.Value ? (int)row["lab_number"] : 0; result.SampleTestId = row["SampleTestId"] != DBNull.Value ? (int)row["SampleTestId"] : 0; result.ApprovedUser = row["ApprovedUser"].ToString(); result.InvestigationUser = row["InvestigationUser"].ToString(); result.CreatedUser = row["createduser"].ToString(); result.CreatedBy = row["created_by"] != DBNull.Value ? (int?)row["created_by"] : null; result.CreatedDate = row["created_date"] != DBNull.Value ? (DateTime?)row["created_date"] : null; result.ModifiedBy = row["modified_by"] != DBNull.Value ? (int?)row["modified_by"] : null; result.ModifiedUser = row["modifieduser"].ToString(); result.ModifiedDate = row["modified_date"] != DBNull.Value ? (DateTime?)row["modified_date"] : null; result.TimePoints = this.GetSampleTestOosTimePoints(ref dbConnection, ref dbCommand, (int)row["id"]); */ //result.TimePoints = this.GetSampleTestTimePoint(ref dbConnection, ref dbCommand, (int)row["parentid"], Convert.ToDateTime(row["result_date"])); resultList.Add(result); } returnDT = null; } } else { throw new Exception("Unable to Connect"); } } return resultList; } catch { throw; } }
public Oos GetOOS(int OOSId, Identification identification) { try { Oos result = new Oos(); using (DbConnection = new MsSqlPersistence(DbConnectionSettings)) { if (DbConnection.IsConnected()) { using (DbCommand) { DbCommand.CommandType = CommandType.StoredProcedure; DbCommand.CommandText = "uspGetOOS"; DbCommand.Parameters.Add("@OOSId", System.Data.SqlDbType.Int).Value = OOSId; DataTable returnDT = DbConnection.ExecuteQuery(DbCommand); if (returnDT.Rows.Count >= 1) { DataRow row = returnDT.Rows[0]; result.OosId = Convert.ToInt32(row["OOSID"]); if (row["ARLNumber"] != DBNull.Value) result.ARLNumber = (int)row["ARLNumber"]; if (row["SampleTestId"] != DBNull.Value) result.SampleTestId = (int)row["SampleTestId"]; result.ClientName = row["ClientName"].ToString(); result.LabelDescription = row["LabelDescription"].ToString(); result.LotNumber = row["LotNumber"].ToString(); result.Analyst = row["AnalystName"].ToString(); if (row["TestedDate"] != DBNull.Value) result.TestedDate = (DateTime)row["TestedDate"]; result.Status = row["Status"] != DBNull.Value ? (SampleTestStatus)row["Status"] : SampleTestStatus.UnderInvestigation; result.TestName = row["TestName"].ToString(); result.AnalyteName = row["AnalyteName"].ToString(); result.PriorityName = row["PriorityName"].ToString(); if (row["DueDate"] != DBNull.Value) result.DueDate = (DateTime)row["DueDate"]; result.DepartmentName = row["DepartmentName"].ToString(); if (row["TimepointStudyYN"] != DBNull.Value) result.TimepointStudyYN = (bool)row["TimepointStudyYN"]; if (row["NextTimepoint"] != DBNull.Value) result.NextTimepoint = (DateTime)row["NextTimepoint"]; if (row["PreparationYN"] != DBNull.Value) result.PreparationYN = (bool)row["PreparationYN"]; if (row["RawDataYN"] != DBNull.Value) result.RawDataYN = (bool)row["RawDataYN"]; if (row["StandardsReagentsYN"] != DBNull.Value) result.StandardsReagentsYN = (bool)row["StandardsReagentsYN"]; if (row["MethodologyYN"] != DBNull.Value) result.MethodologyYN = (bool)row["MethodologyYN"]; if (row["InstrumentParametersYN"] != DBNull.Value) result.InstrumentParametersYN = (bool)row["InstrumentParametersYN"]; if (row["TrendsYN"] != DBNull.Value) result.TrendsYN = (bool)row["TrendsYN"]; if (row["AnalystYN"] != DBNull.Value) result.AnalystYN = (bool)row["AnalystYN"]; if (row["ClientContactEmailYN"] != DBNull.Value) result.ClientContactEmailYN = (bool)row["ClientContactEmailYN"]; if (row["ClientContactPhoneYN"] != DBNull.Value) result.ClientContactPhoneYN = (bool)row["ClientContactPhoneYN"]; if (row["ClientContactName"] != DBNull.Value) result.ClientContactName = row["ClientContactName"].ToString(); if (row["ClientContactDate"] != DBNull.Value) result.ClientContactDate = (DateTime)row["ClientContactDate"]; if (row["AdditionalObservationDiscussion"] != DBNull.Value) result.AdditionalObservations = row["AdditionalObservationDiscussion"].ToString(); if (row["Conclusion"] != DBNull.Value) result.Conclusion = row["Conclusion"].ToString(); if (row["PrimaryCause"] != DBNull.Value) result.PrimaryCause = row["PrimaryCause"].ToString(); if (row["ResultInvalidatedYN"] != DBNull.Value) result.ResultInvalidatedYN = (bool)row["ResultInvalidatedYN"]; else result.ResultInvalidatedYN = false; result.ModifiedUser = row["ModifiedUser"] != DBNull.Value ? row["ModifiedUser"].ToString() : null; result.CreatedUser = row["CreatedUser"] != DBNull.Value ? row["CreatedUser"].ToString() : null; result.CreatedDate = row["CreatedDate"] != DBNull.Value ? (DateTime)row["CreatedDate"] : new DateTime(); result.CreatedBy = row["CreatedBy"] != DBNull.Value ? (int)row["CreatedBy"] : new Int32(); result.ModifiedDate = row["ModifiedDate"] != DBNull.Value ? (DateTime)row["ModifiedDate"] : new DateTime(); result.ModifiedBy = row["ModifiedBy"] != DBNull.Value ? (int)row["ModifiedBy"] : new Int32(); result.Results = this.GetResultsForSampleTest((int)result.SampleTestId, identification); } returnDT = null; } } else { throw new Exception("Unable to Connect"); } } return result; } catch { throw; } }
public SaveOosRequest(Oos oos) { this.oos = oos; }