public void RetestBatch() { try { CBatchFactory faBatch = new CBatchFactory(); CBatch oBatch = faBatch.GetByPrimaryKey(new CBatchKeys(Idbatch)); // --- check parity for (int i = 0; i < ListSamples.Count; i++) { CBatch_detail_aa_twofold row = ListSamples[i]; CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory(); if (Convert.ToInt32(row.Flag_mri) == 0) { // --- approved samples with additional retest mark row.Qaqc_has_retest = 1; faBatch_detail_aa_twofold.Update(row); // --- save retest string cod_type_sample = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(Convert.ToInt32(row.Idtemplate_method))).Cod_type_sample; CCorrelative oCorrelative = new CCorrelativeFactory().GetByPrimaryKey(new CCorrelativeKeys(cod_type_sample)); CBatchManager oBatchManager = new CBatchManager(); oBatchManager.CallSaveFromRetestFullBatch( Convert.ToInt32(row.Idtemplate_method), Convert.ToInt64(row.Idrecep_sample), Convert.ToInt64(row.Idrecep_sample_detail), Convert.ToInt64(row.Idrecep_sample_detail_elem), Convert.ToInt64(row.Cod_interno), row.Cod_sample, Comun.GetUser(), oCorrelative, row.Qaqc_par); // --- register as finished trace process CProcess_Sample_Manage.Finalize_process(Convert.ToInt64(row.Idrecep_sample_detail_elem), LimsProcess.PROCESS_IN_READING, LimsProcess.PROCESS_APPROVE_SAMPLES); } } // --- modify the batch status, put in other process CProcess oProcess = new CProcessFactory().GetByPrimaryKey(new CProcessKeys(LimsProcess.PROCESS_APPROVE_SAMPLES)); oBatch.Status_process = Convert.ToChar(LimsProcess.Status_Process.Waiting); oBatch.Cod_module = oProcess.Cod_module; oBatch.Cod_area = oProcess.Cod_area; oBatch.Cod_process = LimsProcess.PROCESS_APPROVE_SAMPLES; oBatch.User_approve_tray = Comun.GetUser(); oBatch.Date_approve_tray = Comun.GetDate(); faBatch.Update(oBatch); // --- register as finished trace batch Cprocess_Batch_Manage.Finalize_process(Idbatch, LimsProcess.PROCESS_IN_READING, LimsProcess.PROCESS_APPROVE_SAMPLES); } catch (Exception ex) { Comun.Save_log(ex.InnerException.ToString()); throw new Exception("pivot data::approve::Error occured.", ex); } }
private void InsertBatch(LinkedListNode <CBatch> node, CBatch_detail_aa_twofold sample) { if (node != null) { if (node.Next == null) { CBatch batch = node.Value; List <CBatch_detail_aa_twofold> lst_tmp_samples = new List <CBatch_detail_aa_twofold>(); // --- seleccionar la lista de muestras del batch CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory(); List <CBatch_detail_aa_twofold> lst_samples = new List <CBatch_detail_aa_twofold>( faBatch_detail_aa_twofold.GetAll() .Where(c => c.Idbatch == batch.Idbatch)) .OrderBy(c => c.Cod_interno).ToList(); // --- asignar nuevo idbatch a la muestra entrante sample.Idbatch = batch.Idbatch; faBatch_detail_aa_twofold.Update(sample); } else if (node.Next != null) { CBatch batch = node.Value; List <CBatch_detail_aa_twofold> lst_tmp_samples = new List <CBatch_detail_aa_twofold>(); // --- seleccionar la lista de muestras del batch CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory(); List <CBatch_detail_aa_twofold> lst_samples = new List <CBatch_detail_aa_twofold>( faBatch_detail_aa_twofold.GetAll() .Where(c => c.Idbatch == batch.Idbatch)) .OrderBy(c => c.Cod_interno).ToList(); // --- asignar nuevo idbatch a la muestra entrante sample.Idbatch = batch.Idbatch; faBatch_detail_aa_twofold.Update(sample); // --- calcular el índice de la muestra a insertar int i = lst_samples.Count - 1; if (lst_samples[i].Flag_mri == 1) { i = i - 1; } CBatch_detail_aa_twofold sample_out = lst_samples[i]; // --- quitar la dirección del batch de la muestra saliente sample_out.Idbatch = null; faBatch_detail_aa_twofold.Update(sample_out); InsertBatch(node.Next, sample_out); } } }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of CBatch</returns> internal List <CBatch> PopulateObjectsFromReader(IDataReader dataReader) { List <CBatch> list = new List <CBatch>(); while (dataReader.Read()) { CBatch businessObject = new CBatch(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>CBatch business object</returns> public CBatch SelectByPrimaryKey(CBatchKeys keys) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_batch_SelectByPrimaryKey"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new NpgsqlParameter("p_idbatch", NpgsqlDbType.Bigint, 8, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idbatch)); MainConnection.Open(); NpgsqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { CBatch businessObject = new CBatch(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch (Exception ex) { throw new Exception("CBatch::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public void ApplyQaqcMrBlk(CBatch_detail_aa_twofold current_row) { int flag_mri = Convert.ToInt32(current_row.Flag_mri); // only work with rows that are reference material if (flag_mri == 1) { long idbatch = Convert.ToInt64(pivot[0].Idbatch); CBatchFactory faBatch = new CBatchFactory(); CBatch oBatch = faBatch.GetByPrimaryKey(new CBatchKeys(idbatch)); GetSd(); // recuperate the blk decimal value_blk = Convert.ToDecimal(current_row.Reading1); // blk if (current_row.Reading1 != null) { if (value_blk <= Max_value_blk) { current_row.Qaqc_blk = 1; // --- correcto oBatch.Flag_correct_lrb = true; oBatch.Lrb_measured = Convert.ToDecimal(Lrb_measured); } if (value_blk > Max_value_blk) { current_row.Qaqc_blk = 2; // --- error en el blanco oBatch.Flag_correct_lrb = false; oBatch.Lrb_measured = Convert.ToDecimal(Lrb_measured); } } // mri if (current_row.Reading2 != null) { // ley mri +- repetibilidad*2 <= ley conocida + reproducibilidad decimal min = Law_fixed - Factor_reproducibility; decimal max = Law_fixed + Factor_reproducibility; decimal law_mr = Convert.ToDecimal(current_row.Law2); decimal value = law_mr; if (value >= min && value <= max) { current_row.Qaqc_mr = 1; // correcto oBatch.Flag_correct_mri = true; oBatch.Mri_measured = Convert.ToDecimal(Mri_measured); } if (value < min || value > max) { current_row.Qaqc_mr = 2; // error en el mri oBatch.Flag_correct_mri = false; oBatch.Mri_measured = Convert.ToDecimal(Mri_measured); } } faBatch.Update(oBatch); } else { // no es mri current_row.Qaqc_blk = 3; current_row.Qaqc_mr = 3; } }
public void Review() { try { CBatchFactory faBatch = new CBatchFactory(); CBatch oBatch = faBatch.GetByPrimaryKey(new CBatchKeys(Idbatch)); // --- save trace CRecep_sample_detail_elemFactory faRecep_sample_detail_elem = new CRecep_sample_detail_elemFactory(); for (int i = 0; i < ListSamples.Count; i++) { CBatch_detail_aa_twofold current_row = ListSamples[i]; int status_result = Convert.ToInt32(current_row.Qaqc_status_result); if (Convert.ToInt32(current_row.Flag_mri) == 0) { // --- set how accepted sample // Espera = 0, // Incorrecto = 1, // Plausible = 2, // Aceptado = 3, // IncorrectoPlausible = 4, // Espera reensayos = 5 // --- save only the accept samples long Idrecep_sample_detail_elem = Convert.ToInt64(current_row.Idrecep_sample_detail_elem); if (Convert.ToBoolean(oBatch.Flag_correct_mri) && Convert.ToBoolean(oBatch.Flag_correct_lrb)) { if (status_result == Convert.ToInt32(Comun.Status_result.Plausible)) { current_row.Qaqc_status_result = Convert.ToInt16(Comun.Status_result.Aceptado); } Qaqc oQaqc = new Qaqc(); if (!oQaqc.IsRetest(Idrecep_sample_detail_elem, Idbatch)) { // --- save final element law if (current_row.Qaqc_status_result == Convert.ToInt16(Comun.Status_result.Aceptado)) { CRecep_sample_detail_elem oRecep_sample_detail_elem = faRecep_sample_detail_elem.GetByPrimaryKey(new CRecep_sample_detail_elemKeys(Idrecep_sample_detail_elem)); oRecep_sample_detail_elem.Result_analysis = current_row.Result_analysis; oRecep_sample_detail_elem.Str_result_analysis = current_row.Str_result_analysis.ToString(); oRecep_sample_detail_elem.With_result = true; if (current_row.Str_result_analysis == null) { oRecep_sample_detail_elem.With_result = false; } faRecep_sample_detail_elem.Update(oRecep_sample_detail_elem); } CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory(); faBatch_detail_aa_twofold.Update(current_row); } else// --- es un reensayo { if (!oQaqc.ExistsResultPendingSel(Idrecep_sample_detail_elem, Idbatch)) { // --- si no está pendiente de seleccionar entre varios análisis // --- save final element law if (current_row.Qaqc_status_result == Convert.ToInt16(Comun.Status_result.Aceptado)) { CRecep_sample_detail_elem oRecep_sample_detail_elem = faRecep_sample_detail_elem.GetByPrimaryKey(new CRecep_sample_detail_elemKeys(Idrecep_sample_detail_elem)); oRecep_sample_detail_elem.Result_analysis = current_row.Result_analysis; oRecep_sample_detail_elem.Str_result_analysis = current_row.Str_result_analysis.ToString(); oRecep_sample_detail_elem.With_result = true; if (current_row.Str_result_analysis == null) { oRecep_sample_detail_elem.With_result = false; } faRecep_sample_detail_elem.Update(oRecep_sample_detail_elem); } CBatch_detail_aa_twofoldFactory faBatch_detail_aa_twofold = new CBatch_detail_aa_twofoldFactory(); faBatch_detail_aa_twofold.Update(current_row); } } // --- save retest if (current_row.Qaqc_tmp_retest == 1) { string cod_type_sample = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(Convert.ToInt32(current_row.Idtemplate_method))).Cod_type_sample; CCorrelative oCorrelative = new CCorrelativeFactory().GetByPrimaryKey(new CCorrelativeKeys(cod_type_sample)); CBatchManager oBatchManager = new CBatchManager(); oBatchManager.CallSaveSampleBatchWithRetest( Convert.ToInt32(current_row.Idtemplate_method), Convert.ToInt64(current_row.Idrecep_sample), Convert.ToInt64(current_row.Idrecep_sample_detail), Convert.ToInt64(current_row.Idrecep_sample_detail_elem), Convert.ToInt64(current_row.Cod_interno), current_row.Cod_sample, Comun.GetUser(), oCorrelative, Convert.ToInt32(current_row.Qaqc_par), Idbatch); } // --- register as finished trace process CProcess_Sample_Manage.Finalize_process(Idrecep_sample_detail_elem, LimsProcess.PROCESS_APPROVE_SAMPLES, LimsProcess.PROCESS_ACCEPT_RESULTS); } else { // --- the samples pertain to batch with full batch retest CProcess_Sample_Manage.Finalize_process(Idrecep_sample_detail_elem, LimsProcess.PROCESS_APPROVE_SAMPLES, LimsProcess.PROCESS_ACCEPT_RESULTS); } } } // --- modify the batch status, put in other process CProcess oProcess = new CProcessFactory().GetByPrimaryKey(new CProcessKeys(LimsProcess.PROCESS_ACCEPT_RESULTS)); oBatch.Status_process = Convert.ToChar(LimsProcess.Status_Process.Waiting); oBatch.Cod_module = oProcess.Cod_module; oBatch.Cod_area = oProcess.Cod_area; oBatch.Cod_process = LimsProcess.PROCESS_ACCEPT_RESULTS; oBatch.User_review_tray = Comun.GetUser(); oBatch.Date_review_tray = Comun.GetDate(); faBatch.Update(oBatch); // --- register as finished trace batch Cprocess_Batch_Manage.Finalize_process(Idbatch, LimsProcess.PROCESS_APPROVE_SAMPLES, LimsProcess.PROCESS_ACCEPT_RESULTS); } catch (Exception ex) { Comun.Save_log(ex.InnerException.ToString()); throw new Exception("pivot data::approve::Error occured.", ex); } }
public long?GetBatchAvailable(int p_idtemplate_method, bool p_flag_new, string p_user, long p_idbatch_origin) { #region codigo anterior ///TODO /* * CREATE OR REPLACE FUNCTION public.sp_GetBatchAvailable(p_idtemplate_method int4, p_flag_new boolean, p_user varchar, p_idbatch_origin bigint) * returns int4 * AS $$ * Declare v_NullIdBatch bigint; * Declare v_idbatch bigint; * declare v_name_batch varchar(30); * declare v_num_tray bigint; * declare v_status_batch bpchar; * declare v_mri_value numeric(10,6); * declare v_cod_module varchar; * declare v_cod_process varchar; * declare v_cod_area varchar; * declare v_status_process char(1); * declare v_NullIdTraceBatch bigint; * declare v_date_out timestamp; * declare v_trace_prev bigint; * declare v_trace_next bigint; * declare v_observation varchar; * declare v_user varchar; * declare v_date_in timestamp; * BEGIN * -- get the current batch of template method * * v_NullIdBatch = 0; * v_num_tray = COALESCE((SELECT MAX(num_tray) * FROM batch * ), 0)+1; * * v_idbatch = 0; * v_cod_module = 'M002'; * v_cod_process = 'P013'; * v_cod_area = 'A004'; * v_status_process = 'W'; * v_date_out = null; * v_trace_prev = null; * v_trace_next = null; * v_observation = null; * v_user = null; * v_date_in = current_timestamp; * * -- * SELECT INTO v_idbatch COALESCE(A.idbatch, 0) * FROM (SELECT DISTINCT t1.idbatch, t2.idrecep_sample_detail, * t2.idtemplate_method, t3.limit_samples * FROM batch t1 * INNER JOIN batch_detail_aa_twofold t2 on t1.idbatch = t2.idbatch * INNER JOIN template_method t3 on t1.idtemplate_method = t3.idtemplate_method * WHERE t1.cod_process = v_cod_process * AND t1.idtemplate_method = p_idtemplate_method * AND t1.idbatch <> p_idbatch_origin * AND t1.status_process = v_status_process) A * GROUP BY A.idbatch, A.limit_samples * HAVING count(*) < A.limit_samples; * * -- get one name for the batch * SELECT INTO v_name_batch, v_mri_value t3.abbreviation, t2.nominal_value * FROM template_method_aa t1 * INNER JOIN mr_detail t2 * ON t1.idmr_detail = t2.idmr_detail * AND t1.idtemplate_method = p_idtemplate_method * INNER JOIN template_method t3 * ON t1.idtemplate_method = t3.idtemplate_method * WHERE t1.idtemplate_method = p_idtemplate_method; * * IF (p_flag_new = true) THEN * -- create a new batch * v_idbatch = (SELECT public.sp_batch_Insert(v_NullIdBatch,v_name_batch,v_num_tray,p_idtemplate_method,v_cod_module,v_cod_process,v_cod_area,v_status_process,true,v_mri_value, '', v_date_out, p_user, false)); * * -- save trace * -- antes de insertar, si es ultima muestra y contiene mri no insertar * * PERFORM public.sp_trace_batch_insert(v_NullIdTraceBatch, v_cod_module, v_cod_process, v_cod_area, v_idbatch, v_date_in, v_date_out, v_status_process, v_trace_prev, v_trace_next, v_observation, p_user, v_date_in, v_user, v_date_in, true); * ELSE * -- create new batch, if not exists batch in wait * IF (v_idbatch = 0 or v_idbatch is null) * THEN * -- create a new batch * v_idbatch = (SELECT public.sp_batch_Insert(v_NullIdBatch, v_name_batch, v_num_tray, p_idtemplate_method, v_cod_module, v_cod_process, v_cod_area, v_status_process, true, v_mri_value, '', v_date_out, p_user, false)); * * -- save trace * PERFORM public.sp_trace_batch_insert(v_NullIdTraceBatch, v_cod_module, v_cod_process, v_cod_area, v_idbatch, v_date_in, v_date_out, v_status_process, v_trace_prev, v_trace_next, v_observation, p_user, v_date_in, v_user, v_date_in, true); * END IF; * END IF; * return v_idbatch; * * END;*/ #endregion var query = (from m in new CBatchFactory() .GetAll() .Where(x => x.Idbatch != p_idbatch_origin && x.Idtemplate_method == p_idtemplate_method && x.Status_process == 'W') from n in new CBatch_detail_aa_twofoldFactory().GetAll().Where(x => x.Idbatch == m.Idbatch) from p in new CTemplate_methodFactory().GetAll().Where(x => x.Idtemplate_method == m.Idtemplate_method) from q in new CTemplate_method_aaFactory().GetAll().Where(x => x.Idtemplate_method == m.Idtemplate_method) select new { m.Idbatch, n.Idrecep_sample_detail, n.Idtemplate_method, q.Limit_samples }).ToList(); var query2 = (from m in query group m by new { m.Idbatch, m.Limit_samples } into grp where grp.Count() < grp.Key.Limit_samples select new { Idbatch = grp.Key == null ? 0 : grp.Key.Idbatch }).ToList(); var query3 = (from m in new CTemplate_method_aaFactory().GetAll().Where(x => x.Idtemplate_method == p_idtemplate_method) join n in new CMr_detailFactory().GetAll() on m.Idmr_detail equals n.Idmr_detail join p in new CTemplate_methodFactory().GetAll() on m.Idtemplate_method equals p.Idtemplate_method select new { name_batch = p.Abbreviation, mri_value = n.Nominal_value }).ToList(); string name_batch = query3.FirstOrDefault().name_batch; decimal?mri_value = query3.FirstOrDefault().mri_value; long? num_tray = new CBatchFactory().GetAll().Max(x => x.Num_tray) == null ? 0 : 1; long?idbatch = null; if (p_flag_new) { //save batch CBatch batch = new CBatch() { Num_tray = num_tray, Idtemplate_method = p_idtemplate_method, Cod_module = "M002", Cod_process = "P013", Cod_area = "A004", Status_process = 'W', Status = true, Mri_value = mri_value, Description = "", Date_creation_tray = null, User_creation_tray = p_user, Has_sample_control = true }; new CBatchFactory().Insert(batch); idbatch = batch.Idbatch; //save trace CTrace_batch trace_batch = new CTrace_batch() { Cod_module = "M002", Cod_process = "P013", Cod_area = "A004", Idbatch = batch.Idbatch, Date_in = DateTime.Now, Status_process = 'W', Usernew = p_user, Useredit = p_user, Status = true }; } else { if (idbatch == null || idbatch == 0) { CBatch batch = new CBatch() { Name_batch = name_batch, Num_tray = num_tray, Idtemplate_method = p_idtemplate_method, Cod_module = "M002", Cod_process = "P013", Cod_area = "A004", Status_process = 'W', Status = true, Mri_value = mri_value, Description = "", Date_creation_tray = null, User_creation_tray = p_user, Has_sample_control = false }; new CBatchFactory().Insert(batch); idbatch = batch.Idbatch; //save trace CTrace_batch trace_batch = new CTrace_batch() { Cod_module = "M002", Cod_process = "P013", Cod_area = "A004", Idbatch = batch.Idbatch, Date_in = DateTime.Now, Status_process = 'W', Usernew = p_user, Useredit = p_user, Status = true }; } } return(idbatch); }
/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(CBatch businessObject, IDataReader dataReader) { businessObject.Idbatch = dataReader.GetInt64(dataReader.GetOrdinal(CBatch.CBatchFields.Idbatch.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Name_batch.ToString()))) { businessObject.Name_batch = dataReader.GetString(dataReader.GetOrdinal(CBatch.CBatchFields.Name_batch.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Num_tray.ToString()))) { businessObject.Num_tray = dataReader.GetInt64(dataReader.GetOrdinal(CBatch.CBatchFields.Num_tray.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Idtemplate_method.ToString()))) { businessObject.Idtemplate_method = dataReader.GetInt32(dataReader.GetOrdinal(CBatch.CBatchFields.Idtemplate_method.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Cod_module.ToString()))) { businessObject.Cod_module = dataReader.GetString(dataReader.GetOrdinal(CBatch.CBatchFields.Cod_module.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Cod_process.ToString()))) { businessObject.Cod_process = dataReader.GetString(dataReader.GetOrdinal(CBatch.CBatchFields.Cod_process.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Cod_area.ToString()))) { businessObject.Cod_area = dataReader.GetString(dataReader.GetOrdinal(CBatch.CBatchFields.Cod_area.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Status_process.ToString()))) { businessObject.Status_process = dataReader.GetChar(dataReader.GetOrdinal(CBatch.CBatchFields.Status_process.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Status.ToString()))) { businessObject.Status = dataReader.GetBoolean(dataReader.GetOrdinal(CBatch.CBatchFields.Status.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Mri_value.ToString()))) { businessObject.Mri_value = dataReader.GetDecimal(dataReader.GetOrdinal(CBatch.CBatchFields.Mri_value.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Description.ToString()))) { businessObject.Description = dataReader.GetString(dataReader.GetOrdinal(CBatch.CBatchFields.Description.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Date_creation_tray.ToString()))) { businessObject.Date_creation_tray = dataReader.GetDateTime(dataReader.GetOrdinal(CBatch.CBatchFields.Date_creation_tray.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.User_creation_tray.ToString()))) { businessObject.User_creation_tray = dataReader.GetString(dataReader.GetOrdinal(CBatch.CBatchFields.User_creation_tray.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Has_sample_control.ToString()))) { businessObject.Has_sample_control = dataReader.GetBoolean(dataReader.GetOrdinal(CBatch.CBatchFields.Has_sample_control.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Absorvance.ToString()))) { businessObject.Absorvance = dataReader.GetDecimal(dataReader.GetOrdinal(CBatch.CBatchFields.Absorvance.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Std_verification.ToString()))) { businessObject.Std_verification = dataReader.GetDecimal(dataReader.GetOrdinal(CBatch.CBatchFields.Std_verification.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Flag_abs_std.ToString()))) { businessObject.Flag_abs_std = dataReader.GetBoolean(dataReader.GetOrdinal(CBatch.CBatchFields.Flag_abs_std.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Mri_measured.ToString()))) { businessObject.Mri_measured = dataReader.GetDecimal(dataReader.GetOrdinal(CBatch.CBatchFields.Mri_measured.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Lrb_measured.ToString()))) { businessObject.Lrb_measured = dataReader.GetDecimal(dataReader.GetOrdinal(CBatch.CBatchFields.Lrb_measured.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Flag_correct_abs.ToString()))) { businessObject.Flag_correct_abs = dataReader.GetBoolean(dataReader.GetOrdinal(CBatch.CBatchFields.Flag_correct_abs.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Flag_correct_std.ToString()))) { businessObject.Flag_correct_std = dataReader.GetBoolean(dataReader.GetOrdinal(CBatch.CBatchFields.Flag_correct_std.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Flag_correct_mri.ToString()))) { businessObject.Flag_correct_mri = dataReader.GetBoolean(dataReader.GetOrdinal(CBatch.CBatchFields.Flag_correct_mri.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Flag_correct_lrb.ToString()))) { businessObject.Flag_correct_lrb = dataReader.GetBoolean(dataReader.GetOrdinal(CBatch.CBatchFields.Flag_correct_lrb.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.User_close_tray.ToString()))) { businessObject.User_close_tray = dataReader.GetString(dataReader.GetOrdinal(CBatch.CBatchFields.User_close_tray.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Date_close_tray.ToString()))) { businessObject.Date_close_tray = dataReader.GetDateTime(dataReader.GetOrdinal(CBatch.CBatchFields.Date_close_tray.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.User_approve_tray.ToString()))) { businessObject.User_approve_tray = dataReader.GetString(dataReader.GetOrdinal(CBatch.CBatchFields.User_approve_tray.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Date_approve_tray.ToString()))) { businessObject.Date_approve_tray = dataReader.GetDateTime(dataReader.GetOrdinal(CBatch.CBatchFields.Date_approve_tray.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.User_review_tray.ToString()))) { businessObject.User_review_tray = dataReader.GetString(dataReader.GetOrdinal(CBatch.CBatchFields.User_review_tray.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CBatch.CBatchFields.Date_review_tray.ToString()))) { businessObject.Date_review_tray = dataReader.GetDateTime(dataReader.GetOrdinal(CBatch.CBatchFields.Date_review_tray.ToString())); } }
/// <summary> /// insert new row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true of successfully insert</returns> public bool Insert(CBatch businessObject) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_batch_Insert"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.AddWithValue("p_idbatch", businessObject.Idbatch); sqlCommand.Parameters["p_idbatch"].NpgsqlDbType = NpgsqlDbType.Bigint; sqlCommand.Parameters["p_idbatch"].Direction = ParameterDirection.InputOutput; sqlCommand.Parameters.AddWithValue("p_name_batch", businessObject.Name_batch); sqlCommand.Parameters["p_name_batch"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_num_tray", businessObject.Num_tray); sqlCommand.Parameters["p_num_tray"].NpgsqlDbType = NpgsqlDbType.Bigint; sqlCommand.Parameters.AddWithValue("p_idtemplate_method", businessObject.Idtemplate_method); sqlCommand.Parameters["p_idtemplate_method"].NpgsqlDbType = NpgsqlDbType.Integer; sqlCommand.Parameters.AddWithValue("p_cod_module", businessObject.Cod_module); sqlCommand.Parameters["p_cod_module"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_cod_process", businessObject.Cod_process); sqlCommand.Parameters["p_cod_process"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_cod_area", businessObject.Cod_area); sqlCommand.Parameters["p_cod_area"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_status_process", businessObject.Status_process); sqlCommand.Parameters["p_status_process"].NpgsqlDbType = NpgsqlDbType.Char; sqlCommand.Parameters.AddWithValue("p_status", businessObject.Status); sqlCommand.Parameters["p_status"].NpgsqlDbType = NpgsqlDbType.Boolean; sqlCommand.Parameters.AddWithValue("p_mri_value", businessObject.Mri_value); sqlCommand.Parameters["p_mri_value"].NpgsqlDbType = NpgsqlDbType.Numeric; sqlCommand.Parameters.AddWithValue("p_description", businessObject.Description); sqlCommand.Parameters["p_description"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_date_creation_tray", businessObject.Date_creation_tray); sqlCommand.Parameters["p_date_creation_tray"].NpgsqlDbType = NpgsqlDbType.Timestamp; sqlCommand.Parameters.AddWithValue("p_user_creation_tray", businessObject.User_creation_tray); sqlCommand.Parameters["p_user_creation_tray"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_has_sample_control", businessObject.Has_sample_control); sqlCommand.Parameters["p_has_sample_control"].NpgsqlDbType = NpgsqlDbType.Boolean; sqlCommand.Parameters.AddWithValue("p_absorvance", businessObject.Absorvance); sqlCommand.Parameters["p_absorvance"].NpgsqlDbType = NpgsqlDbType.Numeric; sqlCommand.Parameters.AddWithValue("p_std_verification", businessObject.Std_verification); sqlCommand.Parameters["p_std_verification"].NpgsqlDbType = NpgsqlDbType.Numeric; sqlCommand.Parameters.AddWithValue("p_flag_abs_std", businessObject.Flag_abs_std); sqlCommand.Parameters["p_flag_abs_std"].NpgsqlDbType = NpgsqlDbType.Boolean; sqlCommand.Parameters.AddWithValue("p_mri_measured", businessObject.Mri_measured); sqlCommand.Parameters["p_mri_measured"].NpgsqlDbType = NpgsqlDbType.Numeric; sqlCommand.Parameters.AddWithValue("p_lrb_measured", businessObject.Lrb_measured); sqlCommand.Parameters["p_lrb_measured"].NpgsqlDbType = NpgsqlDbType.Numeric; sqlCommand.Parameters.AddWithValue("p_flag_correct_abs", businessObject.Flag_correct_abs); sqlCommand.Parameters["p_flag_correct_abs"].NpgsqlDbType = NpgsqlDbType.Boolean; sqlCommand.Parameters.AddWithValue("p_flag_correct_std", businessObject.Flag_correct_std); sqlCommand.Parameters["p_flag_correct_std"].NpgsqlDbType = NpgsqlDbType.Boolean; sqlCommand.Parameters.AddWithValue("p_flag_correct_mri", businessObject.Flag_correct_mri); sqlCommand.Parameters["p_flag_correct_mri"].NpgsqlDbType = NpgsqlDbType.Boolean; sqlCommand.Parameters.AddWithValue("p_flag_correct_lrb", businessObject.Flag_correct_lrb); sqlCommand.Parameters["p_flag_correct_lrb"].NpgsqlDbType = NpgsqlDbType.Boolean; sqlCommand.Parameters.AddWithValue("p_user_close_tray", businessObject.User_close_tray); sqlCommand.Parameters["p_user_close_tray"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_date_close_tray", businessObject.Date_close_tray); sqlCommand.Parameters["p_date_close_tray"].NpgsqlDbType = NpgsqlDbType.Timestamp; sqlCommand.Parameters.AddWithValue("p_user_approve_tray", businessObject.User_approve_tray); sqlCommand.Parameters["p_user_approve_tray"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_date_approve_tray", businessObject.Date_approve_tray); sqlCommand.Parameters["p_date_approve_tray"].NpgsqlDbType = NpgsqlDbType.Timestamp; sqlCommand.Parameters.AddWithValue("p_user_review_tray", businessObject.User_review_tray); sqlCommand.Parameters["p_user_review_tray"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_date_review_tray", businessObject.Date_review_tray); sqlCommand.Parameters["p_date_review_tray"].NpgsqlDbType = NpgsqlDbType.Timestamp; MainConnection.Open(); sqlCommand.ExecuteNonQuery(); businessObject.Idbatch = Convert.ToInt64(sqlCommand.Parameters["p_idbatch"].Value); return(true); } catch (Exception ex) { throw new Exception("CBatch::Insert::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }