/// <summary> /// update row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true for successfully updated</returns> public bool Update(CCorrelative businessObject) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_correlative_Update"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.AddWithValue("p_cod_type_sample", businessObject.Cod_type_sample); sqlCommand.Parameters["p_cod_type_sample"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_cod_serie", businessObject.Cod_serie); sqlCommand.Parameters["p_cod_serie"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_prefix", businessObject.Prefix); sqlCommand.Parameters["p_prefix"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_correlative", businessObject.Correlative); sqlCommand.Parameters["p_correlative"].NpgsqlDbType = NpgsqlDbType.Integer; sqlCommand.Parameters.AddWithValue("p_mreach15", businessObject.Mreach15); sqlCommand.Parameters["p_mreach15"].NpgsqlDbType = NpgsqlDbType.Boolean; sqlCommand.Parameters.AddWithValue("p_num_digits", businessObject.Num_digits); sqlCommand.Parameters["p_num_digits"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_usernew", businessObject.Usernew); sqlCommand.Parameters["p_usernew"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_datenew", businessObject.Datenew); sqlCommand.Parameters["p_datenew"].NpgsqlDbType = NpgsqlDbType.Date; sqlCommand.Parameters.AddWithValue("p_useredit", businessObject.Useredit); sqlCommand.Parameters["p_useredit"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_dateedit", businessObject.Dateedit); sqlCommand.Parameters["p_dateedit"].NpgsqlDbType = NpgsqlDbType.Date; sqlCommand.Parameters.AddWithValue("p_status", businessObject.Status); sqlCommand.Parameters["p_status"].NpgsqlDbType = NpgsqlDbType.Boolean; MainConnection.Open(); if (Convert.ToInt32(sqlCommand.ExecuteScalar()) > 0) { return(true); } return(false); } catch (Exception ex) { throw new Exception("CCorrelative::Update::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(CCorrelative businessObject, IDataReader dataReader) { businessObject.Cod_type_sample = dataReader.GetString(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Cod_type_sample.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Cod_serie.ToString()))) { businessObject.Cod_serie = dataReader.GetString(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Cod_serie.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Prefix.ToString()))) { businessObject.Prefix = dataReader.GetString(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Prefix.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Correlative.ToString()))) { businessObject.Correlative = dataReader.GetInt32(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Correlative.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Mreach15.ToString()))) { businessObject.Mreach15 = dataReader.GetBoolean(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Mreach15.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Num_digits.ToString()))) { businessObject.Num_digits = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Num_digits.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Usernew.ToString()))) { businessObject.Usernew = dataReader.GetString(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Usernew.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Datenew.ToString()))) { businessObject.Datenew = dataReader.GetDateTime(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Datenew.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Useredit.ToString()))) { businessObject.Useredit = dataReader.GetString(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Useredit.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Dateedit.ToString()))) { businessObject.Dateedit = dataReader.GetDateTime(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Dateedit.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Status.ToString()))) { businessObject.Status = dataReader.GetBoolean(dataReader.GetOrdinal(CCorrelative.CCorrelativeFields.Status.ToString())); } }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of CCorrelative</returns> internal List <CCorrelative> PopulateObjectsFromReader(IDataReader dataReader) { List <CCorrelative> list = new List <CCorrelative>(); while (dataReader.Read()) { CCorrelative businessObject = new CCorrelative(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
protected override bool Grabar_Registro() { CCorrelativeFactory faCorrelative = new CCorrelativeFactory(); CCorrelative oCorrelative = new CCorrelative(); CCorr_modulesFactory faCorr_module = new CCorr_modulesFactory(); CCorr_modules oCorr_module = new CCorr_modules(); bool result = false; try { for (int i = 0; i < gvCorrelativos.RowCount; i++) { //oCorrelative = new CCorrelative(); //oCorrelative.Cod_type_sample = gvCorrelativos.GetRowCellValue(i, gcCorr_cod_type_sample).ToString(); //oCorrelative.Cod_serie = gvCorrelativos.GetRowCellValue(i, gcCorr_cod_serie).ToString(); //oCorrelative.Correlative = Convert.ToInt32(gvCorrelativos.GetRowCellValue(i, gcCorr_correlative)); //oCorrelative.Mreach15 = Convert.ToBoolean(gvCorrelativos.GetRowCellValue(i, gcCorr_mreach15)); //oCorrelative.Num_digits = Convert.ToInt16(gvCorrelativos.GetRowCellValue(i, gcCorr_num_digits)); //oCorrelative.Prefix = gvCorrelativos.GetRowCellValue(i, gcCorr_prefix).ToString(); //if (!(result = faCorrelative.Update(oCorrelative))) // result = faCorrelative.Insert(oCorrelative); //if (!result) // break; oCorrelative = (CCorrelative)gvCorrelativos.GetRow(i); if (!new CCorrelativeFactory().Update(oCorrelative)) { new CCorrelativeFactory().Insert(oCorrelative); } } for (int i = 0; i < gvVarios.RowCount; i++) { oCorr_module = (CCorr_modules)gvVarios.GetRow(i); new CCorr_modulesFactory().Update(oCorr_module); } } catch (Exception ex) { ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message); result = false; } return(result); }
protected override bool Grabar_Registro() { CCorrelativeFactory faCorrelative = new CCorrelativeFactory(); CCorrelative oCorrelative = new CCorrelative(); CCorr_modulesFactory faCorr_module = new CCorr_modulesFactory(); CCorr_modules oCorr_module = new CCorr_modules(); bool result = false; try { for (int i = 0; i < gvCorrelativos.RowCount; i++) { //oCorrelative = new CCorrelative(); //oCorrelative.Cod_type_sample = gvCorrelativos.GetRowCellValue(i, gcCorr_cod_type_sample).ToString(); //oCorrelative.Cod_serie = gvCorrelativos.GetRowCellValue(i, gcCorr_cod_serie).ToString(); //oCorrelative.Correlative = Convert.ToInt32(gvCorrelativos.GetRowCellValue(i, gcCorr_correlative)); //oCorrelative.Mreach15 = Convert.ToBoolean(gvCorrelativos.GetRowCellValue(i, gcCorr_mreach15)); //oCorrelative.Num_digits = Convert.ToInt16(gvCorrelativos.GetRowCellValue(i, gcCorr_num_digits)); //oCorrelative.Prefix = gvCorrelativos.GetRowCellValue(i, gcCorr_prefix).ToString(); //if (!(result = faCorrelative.Update(oCorrelative))) // result = faCorrelative.Insert(oCorrelative); //if (!result) // break; oCorrelative = (CCorrelative)gvCorrelativos.GetRow(i); if (!new CCorrelativeFactory().Update(oCorrelative)) new CCorrelativeFactory().Insert(oCorrelative); } for (int i = 0; i < gvVarios.RowCount; i++) { oCorr_module = (CCorr_modules)gvVarios.GetRow(i); new CCorr_modulesFactory().Update(oCorr_module); } } catch (Exception ex) { ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message); result = false; } return result; }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>CCorrelative business object</returns> public CCorrelative SelectByPrimaryKey(CCorrelativeKeys keys) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_correlative_SelectByPrimaryKey"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new NpgsqlParameter("p_cod_type_sample", NpgsqlDbType.Varchar, 5, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Cod_type_sample)); MainConnection.Open(); NpgsqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { CCorrelative businessObject = new CCorrelative(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch (Exception ex) { throw new Exception("CCorrelative::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public void CallSaveSampleBatchWithRetest(int idtemplate_method, long idrecep_sample, long idrecep_sample_detail, long idrecep_sample_detail_elem, long cod_interno, string str_cod_interno, string user, CCorrelative correlative, int Qaqc_par_prev_batch, long origin_batch) { Correlative = correlative; CBatch_detail_aa_twofold oBatch_detail_aa_twofold = new CBatch_detail_aa_twofold(); oTemplate_method = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(idtemplate_method)); CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method)); CRecep_sample_detail oRecep_sample_detail = new CRecep_sample_detailFactory().GetByPrimaryKey(new CRecep_sample_detailKeys(idrecep_sample_detail)); CDescription_sample oDescription_sample = new CDescription_sampleFactory().GetByPrimaryKey(new CDescription_sampleKeys(oRecep_sample_detail.Cod_des_sample)); if (oTemplate_method_aa != null) { oBatch_detail_aa_twofold.Idtemplate_method = idtemplate_method; oBatch_detail_aa_twofold.Idrecep_sample = idrecep_sample; oBatch_detail_aa_twofold.Idrecep_sample_detail = idrecep_sample_detail; oBatch_detail_aa_twofold.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; oBatch_detail_aa_twofold.Idunit_result = oTemplate_method_aa.Idunit_result; oBatch_detail_aa_twofold.Weight1 = oTemplate_method_aa.Weight; oBatch_detail_aa_twofold.Weight2 = oTemplate_method_aa.Weight; oBatch_detail_aa_twofold.Volumen1 = oTemplate_method_aa.Volumen; oBatch_detail_aa_twofold.Volumen2 = oTemplate_method_aa.Volumen; oBatch_detail_aa_twofold.Dilu2 = oTemplate_method_aa.Dilution2; oBatch_detail_aa_twofold.Dilu3 = oTemplate_method_aa.Dilution3; oBatch_detail_aa_twofold.Flag_dilu2 = false; oBatch_detail_aa_twofold.Flag_dilu3 = false; oBatch_detail_aa_twofold.Cod_des_sample = oRecep_sample_detail.Cod_des_sample; oBatch_detail_aa_twofold.Order_des_sample = oDescription_sample.Priority_order; oBatch_detail_aa_twofold.Flag_mri = 0; oBatch_detail_aa_twofold.Fum = methods.GetFactorConvertionUM(idtemplate_method); oBatch_detail_aa_twofold.Qaqc_blk = 3; oBatch_detail_aa_twofold.Qaqc_par = 3; oBatch_detail_aa_twofold.Qaqc_mr = 3; oBatch_detail_aa_twofold.Qaqc_error = 0; oBatch_detail_aa_twofold.Qaqc_approve = false; oBatch_detail_aa_twofold.Qaqc_review = false; oBatch_detail_aa_twofold.Qaqc_has_retest = 0; oBatch_detail_aa_twofold.Qaqc_tmp_retest = 0; oBatch_detail_aa_twofold.Qaqc_tmp_retest_idmethod = 0; oBatch_detail_aa_twofold.Qaqc_approve_text = ""; oBatch_detail_aa_twofold.Qaqc_review_text = ""; oBatch_detail_aa_twofold.Qaqc_par_prev_batch = Qaqc_par_prev_batch; oBatch_detail_aa_twofold.Cod_interno = cod_interno; oBatch_detail_aa_twofold.Cod_sample = str_cod_interno; control_sample.Idtemplate_method = idtemplate_method; //control_sample.Idrecep_sample = idrecep_sample; //control_sample.Idrecep_sample_detail = idrecep_sample_detail; //control_sample.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; control_sample.Weight1 = oTemplate_method_aa.Weight; control_sample.Weight2 = oTemplate_method_aa.Weight; control_sample.Volumen1 = oTemplate_method_aa.Volumen; control_sample.Volumen2 = oTemplate_method_aa.Volumen; control_sample.Dilu2 = oTemplate_method_aa.Dilution2; control_sample.Dilu3 = oTemplate_method_aa.Dilution3; control_sample.Flag_dilu2 = false; control_sample.Flag_dilu3 = false; control_sample.Flag_mri = 1; control_sample.Fum = methods.GetFactorConvertionUM(idtemplate_method); control_sample.Qaqc_blk = 3; control_sample.Qaqc_par = 3; control_sample.Qaqc_mr = 3; control_sample.Qaqc_error = 0; control_sample.Qaqc_approve = false; control_sample.Qaqc_review = false; control_sample.Qaqc_tmp_retest_idmethod = 0; control_sample.Qaqc_approve_text = ""; control_sample.Qaqc_review_text = ""; Enabled_retest = true; oRetest.Idrecep_sample_detail = idrecep_sample_detail; oRetest.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; oRetest.Origin_batch = origin_batch; oRetest.Useredit1 = user; oRetest.Usernew = user; oRetest.Type_retest = 'R'; oRetest.Status = true; // --- save in batch SaveInBatch(oBatch_detail_aa_twofold, user); } }
// --- insert sample came from retest full batch public void CallSaveFromRetestFullBatch(int idtemplate_method, long idrecep_sample, long idrecep_sample_detail, long idrecep_sample_detail_elem, long cod_interno, string str_cod_interno, string user, CCorrelative correlative, int?previus_parity) { Correlative = correlative; CBatch_detail_aa_twofold oBatch_detail_aa_twofold = new CBatch_detail_aa_twofold(); CTemplate_method oTemplate_method = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(idtemplate_method)); CTemplate_method_aa oTemplate_method_aa = new CTemplate_method_aaFactory().GetByPrimaryKey(new CTemplate_method_aaKeys(idtemplate_method)); CRecep_sample_detail oRecep_sample_detail = new CRecep_sample_detailFactory().GetByPrimaryKey(new CRecep_sample_detailKeys(idrecep_sample_detail)); CDescription_sample oDescription_sample = new CDescription_sampleFactory().GetByPrimaryKey(new CDescription_sampleKeys(oRecep_sample_detail.Cod_des_sample)); oBatch_detail_aa_twofold.Idtemplate_method = idtemplate_method; oBatch_detail_aa_twofold.Idrecep_sample = idrecep_sample; oBatch_detail_aa_twofold.Idrecep_sample_detail = idrecep_sample_detail; oBatch_detail_aa_twofold.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; oBatch_detail_aa_twofold.Idunit_result = oTemplate_method_aa.Idunit_result; oBatch_detail_aa_twofold.Weight1 = oTemplate_method_aa.Weight; oBatch_detail_aa_twofold.Weight2 = oTemplate_method_aa.Weight; oBatch_detail_aa_twofold.Volumen1 = oTemplate_method_aa.Volumen; oBatch_detail_aa_twofold.Volumen2 = oTemplate_method_aa.Volumen; oBatch_detail_aa_twofold.Dilu2 = oTemplate_method_aa.Dilution2; oBatch_detail_aa_twofold.Dilu3 = oTemplate_method_aa.Dilution3; oBatch_detail_aa_twofold.Flag_dilu2 = false; oBatch_detail_aa_twofold.Flag_dilu3 = false; oBatch_detail_aa_twofold.Flag_mri = 0; oBatch_detail_aa_twofold.Fum = methods.GetFactorConvertionUM(idtemplate_method); oBatch_detail_aa_twofold.Qaqc_blk = 3; oBatch_detail_aa_twofold.Qaqc_par = 3; oBatch_detail_aa_twofold.Qaqc_mr = 3; oBatch_detail_aa_twofold.Qaqc_error = 0; oBatch_detail_aa_twofold.Qaqc_approve = false; oBatch_detail_aa_twofold.Qaqc_review = false; oBatch_detail_aa_twofold.Qaqc_has_retest = 0; oBatch_detail_aa_twofold.Qaqc_tmp_retest = 0; oBatch_detail_aa_twofold.Qaqc_tmp_retest_idmethod = 0; oBatch_detail_aa_twofold.Qaqc_approve_text = ""; oBatch_detail_aa_twofold.Qaqc_review_text = ""; oBatch_detail_aa_twofold.Qaqc_par_prev_batch = previus_parity; oBatch_detail_aa_twofold.Cod_interno = cod_interno; oBatch_detail_aa_twofold.Cod_sample = str_cod_interno; oBatch_detail_aa_twofold.Cod_des_sample = oRecep_sample_detail.Cod_des_sample; oBatch_detail_aa_twofold.Order_des_sample = oDescription_sample.Priority_order; // --- control sample control_sample.Idtemplate_method = idtemplate_method; //control_sample.Idrecep_sample = idrecep_sample; //control_sample.Idrecep_sample_detail = idrecep_sample_detail; //control_sample.Idrecep_sample_detail_elem = idrecep_sample_detail_elem; control_sample.Weight1 = oTemplate_method_aa.Weight; control_sample.Weight2 = oTemplate_method_aa.Weight; control_sample.Volumen1 = oTemplate_method_aa.Volumen; control_sample.Volumen2 = oTemplate_method_aa.Volumen; control_sample.Dilu2 = oTemplate_method_aa.Dilution2; control_sample.Dilu3 = oTemplate_method_aa.Dilution3; control_sample.Flag_dilu2 = false; control_sample.Flag_dilu3 = false; control_sample.Flag_mri = 1; control_sample.Fum = methods.GetFactorConvertionUM(idtemplate_method); control_sample.Qaqc_blk = 3; control_sample.Qaqc_par = 3; control_sample.Qaqc_mr = 3; control_sample.Qaqc_error = 0; control_sample.Qaqc_approve = false; control_sample.Qaqc_review = false; control_sample.Qaqc_tmp_retest_idmethod = 0; control_sample.Qaqc_approve_text = ""; control_sample.Qaqc_review_text = ""; SaveInBatch(oBatch_detail_aa_twofold, user); }