/// <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);
}
