private void gvPrepSample_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
// colorear las filas completadas
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
if (rgStatusComplete.SelectedIndex == 0)//pendiente (1)
{
if (
(rgPreparationSamples.SelectedIndex == 0 && oPrep_sample.Final_weight_gross == 1) ||
(rgPreparationSamples.SelectedIndex == 1 && oPrep_sample.Final_moisture == 1) ||
(rgPreparationSamples.SelectedIndex == 2 && oPrep_sample.Final_reject == 1) ||
(rgPreparationSamples.SelectedIndex == 3 && oPrep_sample.Final_sample_prepared == 1)
)
{
e.Appearance.BackColor = colorComplete;
}
else
{
e.Appearance.BackColor = Color.White;
}
}
else //Completado (2)
{
e.Appearance.BackColor = Color.NavajoWhite;
}
e.Appearance.ForeColor = Color.Black;
}
public void SetComplete(CPrep_samples prep_samples)
{
switch (Convert.ToInt32(rgPreparationSamples.EditValue))
{
case 1://recepsample
if (prep_samples.Weight_gross != null)
prep_samples.Final_weight_gross = 1;
break;
case 2://humedad
if (prep_samples.Percent_moisture != null)
prep_samples.Final_moisture = 1;
break;
case 3://salidaMuestreria
if (Convert.ToBoolean(prep_samples.Output_flag_sample) && Convert.ToBoolean(prep_samples.Output_flag_cs)
&& Convert.ToBoolean(prep_samples.Output_flag_re))
prep_samples.Final_sample_prepared = 1;
break;
case 4://pesarrechazos
if (prep_samples.Weight_gross_reject != null)
prep_samples.Final_reject = 1;
break;
case 5://almacen
break;
}
}
/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of CPrep_samples</returns>
internal List <CPrep_samples> PopulateObjectsFromReader(IDataReader dataReader)
{
List <CPrep_samples> list = new List <CPrep_samples>();
while (dataReader.Read())
{
CPrep_samples businessObject = new CPrep_samples();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
/// <summary>
/// Select by primary key
/// </summary>
/// <param name="keys">primary keys</param>
/// <returns>CPrep_samples business object</returns>
public CPrep_samples SelectByPrimaryKey(CPrep_samplesKeys keys)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_prep_samples_SelectByPrimaryKey";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new NpgsqlParameter("p_idrecep_sample_detail", NpgsqlDbType.Bigint, 8, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idrecep_sample_detail));
MainConnection.Open();
NpgsqlDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
CPrep_samples businessObject = new CPrep_samples();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("CPrep_samples::SelectByPrimaryKey::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
public void SetComplete(CPrep_samples prep_samples)
{
switch (Convert.ToInt32(rgPreparationSamples.EditValue))
{
case 1: //recepsample
if (prep_samples.Weight_gross != null)
{
prep_samples.Final_weight_gross = 1;
}
break;
case 2: //humedad
if (prep_samples.Percent_moisture != null)
{
prep_samples.Final_moisture = 1;
}
break;
case 3: //salidaMuestreria
if (Convert.ToBoolean(prep_samples.Output_flag_sample) && Convert.ToBoolean(prep_samples.Output_flag_cs) &&
Convert.ToBoolean(prep_samples.Output_flag_re))
{
prep_samples.Final_sample_prepared = 1;
}
break;
case 4: //pesarrechazos
if (prep_samples.Weight_gross_reject != null)
{
prep_samples.Final_reject = 1;
}
break;
case 5: //almacen
break;
}
}
private void gvPrepSample_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (e.Column == gcol_Weight_gross)
{
// actualizar fecha entrada y usuario
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
oPrep_sample.Weight_gross_date = Comun.GetDate();
oPrep_sample.Weight_gross_user = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Weight_moisture)
{
// actualizar fecha de peso húmedo y usuario
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
if (oPrep_sample.Weight_moisture != null && oPrep_sample.Weight_dry != null &&
oPrep_sample.Weight_dry > 0 && oPrep_sample.Weight_moisture > 0)
{
oPrep_sample.Percent_moisture = Math.Round(Convert.ToDecimal((oPrep_sample.Weight_moisture - oPrep_sample.Weight_dry) / oPrep_sample.Weight_moisture), 2);
}
oPrep_sample.Weight_moisture_date = Comun.GetDate();
oPrep_sample.Weight_moisture_user = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Weight_dry)
{
// actualizar fecha de peso seco y usuario y calcular la humedad
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
if (oPrep_sample.Weight_moisture != null && oPrep_sample.Weight_dry != null &&
oPrep_sample.Weight_dry > 0 && oPrep_sample.Weight_moisture > 0)
{
oPrep_sample.Percent_moisture = Math.Round(Convert.ToDecimal((oPrep_sample.Weight_moisture - oPrep_sample.Weight_dry) / oPrep_sample.Weight_moisture), 2);
oPrep_sample.Weight_dry_date = Comun.GetDate();
oPrep_sample.Weight_dry_user = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
}
else if (e.Column == gcol_Weight_gross_reject)
{
// actualizar fecha de rechazo y usuario
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
oPrep_sample.Weight_gross_reject_date = Comun.GetDate();
oPrep_sample.Weight_gross_reject_user = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Moisture_reject)
{
// actualizar fecha, usuario de humedad
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
oPrep_sample.Moisture_reject_date = Comun.GetDate();
oPrep_sample.Moisture_reject_user = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Output_flag_sample)
{
// actualizar fecha, usuario en salida de muestra
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
oPrep_sample.Output_date_sample = Comun.GetDate();
oPrep_sample.Output_user_sample = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Output_flag_cs)
{
// actualizar fecha, usuario en salida de contramuestra
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
oPrep_sample.Output_date_cs = Comun.GetDate();
oPrep_sample.Output_user_cs = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Output_flag_re)
{
// actualizar fecha, usuario en salida de contramuestra
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
oPrep_sample.Output_date_re = Comun.GetDate();
oPrep_sample.Output_user_re = Comun.GetUser();
SetComplete(oPrep_sample);
new CPrep_samplesFactory().Update(oPrep_sample);
}
else if (e.Column == gcol_Observation1 || e.Column == gcol_Observation2)
{
CPrep_samples oPrep_sample = gvPrepSample.GetRow(e.RowHandle) as CPrep_samples;
new CPrep_samplesFactory().Update(oPrep_sample);
}
}
bool SaveRegisterReception()
{
bool result = false;
object obj = deHourReception.EditValue;
try
{
#region save head
if (oRecep_sample == null)
oRecep_sample = new CRecep_sample();
else
{
if (loadData == LoadData.FromRR_ToExtendRR)
oRecep_sample.Idrecep_sample = 0;
}
CPersonFactory faPerson = new CPersonFactory();
Reception oReception = new BusinessLayer.Modules.Reception();
// --- save company
bool result_company = false;
CCompany oCompany = new CCompany();
if (cbCompany.EditValue != null)
{
CCorr_modulesFactory faCorr_modules = new CCorr_modulesFactory();
CCompanyFactory faCompany = new CCompanyFactory();
oCompany.Idcompany = Convert.ToInt16(cbCompany.EditValue);
//oCompany.Cod_company = faCorr_modules.GetCorrModule(Comun.Formulario.fmEmpresa.ToString());
oCompany.Ruc = tbClientRuc.Text;
oCompany.Business_name = cbCompany.Text;
oCompany.Domicile = tbClientDomicile.Text;
oCompany.Type_company = 'C'; // --- client
oCompany.Phone_client = tbClientPhone.Text;
if (!(result_company = faCompany.Update(oCompany)))
result_company = faCompany.Insert(oCompany);
}
// --- save head
if (!result_company)
{
ComunForm.Send_message(this.Text, TypeMsg.error, "Error al guardar cliente, no se pudo completar la operación.");
return false;
}
bool result_recep_sample = false;
oReception.GetNewCodReception();
oRecep_sample.Cod_recep_sample = oReception.GetFormatCodReception();
oRecep_sample.Idcompany = oCompany.Idcompany;
oRecep_sample.Date_reception = deReception.DateTime;
DateTime Hour_reception = Convert.ToDateTime(deHourReception.EditValue);
oRecep_sample.Date_reception = new DateTime(
deReception.DateTime.Year, deReception.DateTime.Month, deReception.DateTime.Day,
Hour_reception.Hour, Hour_reception.Minute, Hour_reception.Second);
DateTime Hour_result = Convert.ToDateTime(deHourResult.EditValue);
oRecep_sample.Date_result = new DateTime(
deResult.DateTime.Year, deResult.DateTime.Month, deResult.DateTime.Day,
Hour_result.Hour, Hour_result.Minute, Hour_result.Second);
oRecep_sample.Cod_type_sample = cbTypeSample.EditValue.ToString();
oRecep_sample.Total_amount = Convert.ToDecimal(tbSubTotalAmount.Text);
oRecep_sample.Total_igv = Convert.ToDecimal(tbTotalIgv.Text);
oRecep_sample.Total_amount_igv = Convert.ToDecimal(tbTotalAmount.Text);
oRecep_sample.Amortization = Convert.ToDecimal(tbAmortization.Text);
oRecep_sample.Flag_isprice = false;
//oRecep_sample.Discount = ckDiscount.Checked == true ? tbDiscount.Value : 0;
if (oRecep_sample.Idrecep_sample == 0)
{
oRecep_sample.Usernew = Comun.GetUser();
oRecep_sample.Datenew = Comun.GetDate();
}
oRecep_sample.Useredit = Comun.GetUser();
oRecep_sample.Dateedit = Comun.GetDate();
if (!(result_recep_sample = faRecep_sample.Update(oRecep_sample)))
result_recep_sample = faRecep_sample.Insert(oRecep_sample);
if (!result_recep_sample)
{
ComunForm.Send_message(this.Text, TypeMsg.error, "Error al guardar datos en recepción, no se pudo completar la operación.");
return false;
}
#endregion
#region update price
if (result_recep_sample && oPrice_version != null && oPrice_version.Idprice_version > 0)
{
oPrice_version.Status_price = 4;
faPrice_version.Update(oPrice_version);
}
#endregion
#region save detail
// --- contacts and detail
if (result_recep_sample)
{
// --- save contacts
CPerson oContact = new CPerson();
CRecep_company_person oRecep_company_person = new CRecep_company_person();
CRecep_company_personFactory faRecep_company_person = new CRecep_company_personFactory();
// --- delete all
tbCod_recep_sample.Text = oReception.GetFormatCodReception();
oReception.SetDisabledContact(oRecep_sample.Idrecep_sample);
for (int i = 0; i < gvContact.RowCount; i++)
{
oContact.Idperson = Convert.ToInt16(gvContact.GetRowCellValue(i, gcCon_Idperson));
oContact.Phone = gvContact.GetRowCellValue(i, gcCon_Phone).ToString();
oContact.Cellphone = gvContact.GetRowCellValue(i, gcCon_Cellphone).ToString();
oContact.Mail = gvContact.GetRowCellValue(i, gcCon_Mail).ToString();
oContact.Allname = gvContact.GetRowCellValue(i, gcCon_Allname).ToString();
bool result_contact = false;
if (!(result_contact = faPerson.Update(oContact)))
result_contact = faPerson.Insert(oContact);
if (result_contact)
{
oRecep_company_person = new CRecep_company_person();
oRecep_company_person.Idrecep_company_person = 0;
oRecep_company_person.Idcompany = oCompany.Idcompany;
oRecep_company_person.Idrecep_sample = oRecep_sample.Idrecep_sample;
oRecep_company_person.Idperson = oContact.Idperson;
oRecep_company_person.Person_type = Convert.ToInt16(gvContact.GetRowCellValue(i, gcCon_Person_type));
oRecep_company_person.Enabled_show = true;
if (!faRecep_company_person.Update(oRecep_company_person))
faRecep_company_person.Insert(oRecep_company_person);
}
}
// --- save dispatch
CRecep_sample_dispatchFactory faRecep_sample_dispatch = new CRecep_sample_dispatchFactory();
CRecep_sample_dispatch oRecep_sample_dispatch = new CRecep_sample_dispatch();
oRecep_sample_dispatch.Idrecep_sample = oRecep_sample.Idrecep_sample;
// --- person
if (ckDispatchPerson.Checked)
oRecep_sample_dispatch.Dispatch_person = 1;
else
oRecep_sample_dispatch.Dispatch_person = 0;
// --- curier
if (ckDispatchCurier.Checked)
oRecep_sample_dispatch.Dispatch_curier = 1;
else
oRecep_sample_dispatch.Dispatch_curier = 0;
// --- transport
if (ckDispatchTransport.Checked)
oRecep_sample_dispatch.Dispatch_transport = 1;
else
oRecep_sample_dispatch.Dispatch_transport = 0;
// --- fax
if (ckDispatchFax.Checked)
oRecep_sample_dispatch.Dispatch_fax = 1;
else
oRecep_sample_dispatch.Dispatch_fax = 0;
// --- save
if (!faRecep_sample_dispatch.Update(oRecep_sample_dispatch))
faRecep_sample_dispatch.Insert(oRecep_sample_dispatch);
// ---------------------------------------------------------------------------
// --- save detail -----------------------------------------------------------
// ---------------------------------------------------------------------------
CRecep_sample_detail oRecep_sample_detail = new CRecep_sample_detail();
CRecep_sample_detailFactory faRecep_sample_detail = new CRecep_sample_detailFactory();
CRecep_elem oRecep_elem = new CRecep_elem();
CRecep_elemFactory faRecep_elem = new CRecep_elemFactory();
CRecep_sample_detail_elem oRecep_sample_detail_elem = new CRecep_sample_detail_elem();
CRecep_sample_detail_elemFactory faRecep_sample_detail_elem = new CRecep_sample_detail_elemFactory();
CCorrelative oCorrelative = new CCorrelativeFactory().GetByPrimaryKey(new CCorrelativeKeys(oRecep_sample.Cod_type_sample));
if (oRecep_sample.Idrecep_sample > 0)
{
int i = 0;
while (i < gvReception.RowCount)
{
oRecep_sample_detail = new CRecep_sample_detail();
oRecep_sample_detail.Idrecep_sample = oRecep_sample.Idrecep_sample;
//if (gvReception.GetRowCellValue(i, gcRec_idrecep_sample_detail) != DBNull.Value)
//oRecep_sample_detail.Idrecep_sample_detail = Convert.ToInt64(gvReception.GetRowCellValue(i, gcRec_idrecep_sample_detail));
oRecep_sample_detail.Idrecep_sample_detail = 0;
oRecep_sample_detail.Order_sample = Convert.ToInt16(gvReception.GetRowCellValue(i, gcRec_OrderSample));
oRecep_sample_detail.Name_sample = gvReception.GetRowCellValue(i, gcRec_NameSample).ToString();
oRecep_sample_detail.Procedence = gvReception.GetRowCellValue(i, gcRec_Procedence).ToString();
oRecep_sample_detail.Cod_des_sample = gvReception.GetRowCellValue(i, gcRec_Description).ToString();
oRecep_sample_detail.Cod_type_sample = gvReception.GetRowCellValue(i, gcRec_Type_Sample).ToString();
oRecep_sample_detail.Cod_sample = gvReception.GetRowCellValue(i, gcRec_Code).ToString();
oRecep_sample_detail.Amount_weight = Convert.ToDecimal(gvReception.GetRowCellValue(i, gcRec_CantKg));
oRecep_sample_detail.Cost_sample = Convert.ToDecimal(gvReception.GetRowCellValue(i, gcRec_Cost));
oRecep_sample_detail.Flag_envelope_sealed = Convert.ToBoolean(gvReception.GetRowCellValue(i, gcRec_Flag_envelope_sealed));
oRecep_sample_detail.Flag_reject = Convert.ToBoolean(gvReception.GetRowCellValue(i, gcRec_Reject));
oRecep_sample_detail.Flag_counter_sample = Convert.ToInt16(gvReception.GetRowCellValue(i, gcRec_Counter_Sample));
oRecep_sample_detail.Analisys_time = Convert.ToInt16(gvReception.GetRowCellValue(i, gcRec_Days));
bool result_detail_elem = false;
bool result_recep_sample_detail = false;
if (!(result_recep_sample_detail = faRecep_sample_detail.Update(oRecep_sample_detail)))
result_recep_sample_detail = faRecep_sample_detail.Insert(oRecep_sample_detail);
if (result_recep_sample_detail)
{
if (FlagRegRecepCopy)
{
oRecep_sample_detail.Cod_interno = Convert.ToInt64(gvReception.GetRowCellValue(i, gcRec_Cod_interno));
oRecep_sample_detail.Cod_sample = gvReception.GetRowCellValue(i, gcRec_Code).ToString();
oRecep_sample_detail.Flag_control_sample = false;
}
else
{
// assign correlative code
long Cod_interno = oReception.GetNewCodInternoSample(gvReception.GetRowCellValue(i, gcRec_Type_Sample).ToString());
string Format_cod_interno = oReception.GetFormatCodInternoSample(gvReception.GetRowCellValue(i, gcRec_Type_Sample).ToString());
oRecep_sample_detail.Cod_interno = Cod_interno;
oRecep_sample_detail.Cod_sample = Format_cod_interno;
oRecep_sample_detail.Flag_control_sample = false;
}
faRecep_sample_detail.Update(oRecep_sample_detail);
#region save element cell repetition
CRecep_sample_detail oRecep_sample_aux = faRecep_sample_detail.GetByPrimaryKey(new CRecep_sample_detailKeys(oRecep_sample_detail.Idrecep_sample_detail));
CSettings oSettings = new CSettings();
bool HasHumidityAnalysis = false;
bool Has60GradesElement = false;
// --- retrieve code sample and assign
if (!Convert.ToBoolean(oRecep_sample_detail.Flag_control_sample))
gvReception.SetRowCellValue(i, gcRec_Code, oRecep_sample_aux.Cod_sample);
// --- save element cell
foreach (KeyValuePair<DevExpress.XtraGrid.Columns.GridColumn, bool> kvp in DicShowColumns)
{
if (kvp.Value)
{
bool value_check = Convert.ToBoolean(gvReception.GetRowCellValue(i, kvp.Key));
bool flag_control_sample = Convert.ToBoolean(oRecep_sample_detail.Flag_control_sample);
if ((!flag_control_sample && value_check)
|| flag_control_sample)
{
oRecep_sample_detail_elem = new CRecep_sample_detail_elem();
CTagInfoMethod tagMethod = (CTagInfoMethod)kvp.Key.Tag;
oRecep_sample_detail_elem.Idelement = tagMethod.IDElement;
oRecep_sample_detail_elem.Idrecep_sample = oRecep_sample.Idrecep_sample;
oRecep_sample_detail_elem.Idrecep_sample_detail = oRecep_sample_detail.Idrecep_sample_detail;
oRecep_sample_detail_elem.Idtemplate_method = tagMethod.IDTemplate_method;
oRecep_sample_detail_elem.Idcompany = oRecep_sample.Idcompany;
oRecep_sample_detail_elem.Idunit = tagMethod.IDMeasurement_Unit;
oRecep_sample_detail_elem.Cost_method = tagMethod.Cost_Method;
if (!(result_detail_elem = faRecep_sample_detail_elem.Update(oRecep_sample_detail_elem)))
result_detail_elem = faRecep_sample_detail_elem.Insert(oRecep_sample_detail_elem);
if (result_detail_elem)
{
// crear bandejas
CBatchManager oBatchManager = new CBatchManager();
oBatchManager.CallSaveSampleBatch(
Convert.ToInt32(oRecep_sample_detail_elem.Idtemplate_method),
Convert.ToInt64(oRecep_sample_detail_elem.Idrecep_sample),
Convert.ToInt64(oRecep_sample_detail_elem.Idrecep_sample_detail),
oRecep_sample_detail_elem.Idrecep_sample_detail_elem,
Convert.ToInt64(oRecep_sample_detail.Cod_interno),
oRecep_sample_detail.Cod_sample,
Comun.GetUser(),
oCorrelative);
// enviar a preparación de muestras
}
//verificar si tiene análisis por humedad
if (oSettings.GetIdHumidityAnalysis().Contains(tagMethod.IDElement.ToString()))
HasHumidityAnalysis = true;
//verificar si tiene que elementos para ser analizados a 60°
if (oSettings.GetIDElements60Grades().Contains(tagMethod.IDElement.ToString()))
Has60GradesElement = true;
}
}
}
#endregion
#region save sample preparation
CPrep_samples oPrep_samples = new CPrep_samples();
oPrep_samples.Idrecep_sample_detail = oRecep_sample_detail.Idrecep_sample_detail;
oPrep_samples.Flag_counter_sample = oRecep_sample_detail.Flag_counter_sample;
oPrep_samples.Flag_reject = oRecep_sample_detail.Flag_reject;
oPrep_samples.Flag_humidity_analysis = HasHumidityAnalysis;
oPrep_samples.Flag_60celsius = Has60GradesElement;
oPrep_samples.Date_creation = Comun.GetDate();
oPrep_samples.Moisture_reject = false;
oPrep_samples.Final_moisture = 0;
oPrep_samples.Final_reject = 0;
oPrep_samples.Final_sample_prepared = 0;
oPrep_samples.Final_weight_gross = 0;
oPrep_samples.Output_flag_sample = false;
oPrep_samples.Output_flag_cs = false;
oPrep_samples.Output_flag_re = false;
CPrep_samplesFactory faPrep_samples = new CPrep_samplesFactory();
if (!faPrep_samples.Update(oPrep_samples))
faPrep_samples.Insert(oPrep_samples);
#endregion
}
if (!Convert.ToBoolean(oRecep_sample_detail.Flag_control_sample))
i++;
}
}
#region save tag infor method
// --- save tag info method (mr or blk)
foreach (KeyValuePair<DevExpress.XtraGrid.Columns.GridColumn, bool> kvp in DicShowColumns)
{
if (kvp.Value)
{
CTagInfoMethod tagMethod = (CTagInfoMethod)kvp.Key.Tag;
oRecep_elem = new CRecep_elem();
oRecep_elem.Idelement = tagMethod.IDElement;
oRecep_elem.Idrecep_sample = oRecep_sample.Idrecep_sample;
oRecep_elem.Idtemplate_method = tagMethod.IDTemplate_method;
oRecep_elem.Name_unit = tagMethod.Name_Measurement_Unit;
oRecep_elem.Idunit = tagMethod.IDMeasurement_Unit;
oRecep_elem.Percent_repetition = tagMethod.Percent_repetition;
if (!faRecep_elem.Update(oRecep_elem))
faRecep_elem.Insert(oRecep_elem);
}
}
#endregion
}
#endregion
result = true;
}
catch (Exception ex)
{
Comun.Save_log(ex.Message);
if (ex.InnerException != null)
Comun.Save_log(ex.InnerException.ToString());
return false;
}
return result;
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(CPrep_samples businessObject, IDataReader dataReader)
{
businessObject.Idrecep_sample_detail = dataReader.GetInt64(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Idrecep_sample_detail.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Flag_humidity_analysis.ToString())))
{
businessObject.Flag_humidity_analysis = dataReader.GetBoolean(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Flag_humidity_analysis.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Flag_reject.ToString())))
{
businessObject.Flag_reject = dataReader.GetBoolean(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Flag_reject.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Flag_counter_sample.ToString())))
{
businessObject.Flag_counter_sample = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Flag_counter_sample.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Flag_60celsius.ToString())))
{
businessObject.Flag_60celsius = dataReader.GetBoolean(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Flag_60celsius.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Date_creation.ToString())))
{
businessObject.Date_creation = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Date_creation.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Input_sample_date.ToString())))
{
businessObject.Input_sample_date = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Input_sample_date.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Input_sample_user.ToString())))
{
businessObject.Input_sample_user = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Input_sample_user.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_gross.ToString())))
{
businessObject.Weight_gross = dataReader.GetDecimal(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_gross.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_gross_date.ToString())))
{
businessObject.Weight_gross_date = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_gross_date.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_gross_user.ToString())))
{
businessObject.Weight_gross_user = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_gross_user.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_moisture.ToString())))
{
businessObject.Weight_moisture = dataReader.GetDecimal(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_moisture.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_moisture_date.ToString())))
{
businessObject.Weight_moisture_date = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_moisture_date.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_moisture_user.ToString())))
{
businessObject.Weight_moisture_user = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_moisture_user.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_dry.ToString())))
{
businessObject.Weight_dry = dataReader.GetDecimal(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_dry.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_dry_date.ToString())))
{
businessObject.Weight_dry_date = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_dry_date.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_dry_user.ToString())))
{
businessObject.Weight_dry_user = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_dry_user.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Percent_moisture.ToString())))
{
businessObject.Percent_moisture = dataReader.GetDecimal(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Percent_moisture.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Moisture_reject.ToString())))
{
businessObject.Moisture_reject = dataReader.GetBoolean(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Moisture_reject.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Moisture_reject_date.ToString())))
{
businessObject.Moisture_reject_date = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Moisture_reject_date.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Moisture_reject_user.ToString())))
{
businessObject.Moisture_reject_user = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Moisture_reject_user.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_gross_reject.ToString())))
{
businessObject.Weight_gross_reject = dataReader.GetDecimal(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_gross_reject.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_gross_reject_date.ToString())))
{
businessObject.Weight_gross_reject_date = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_gross_reject_date.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_gross_reject_user.ToString())))
{
businessObject.Weight_gross_reject_user = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Weight_gross_reject_user.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_flag_sample.ToString())))
{
businessObject.Output_flag_sample = dataReader.GetBoolean(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_flag_sample.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_flag_cs.ToString())))
{
businessObject.Output_flag_cs = dataReader.GetBoolean(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_flag_cs.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_flag_re.ToString())))
{
businessObject.Output_flag_re = dataReader.GetBoolean(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_flag_re.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_date_sample.ToString())))
{
businessObject.Output_date_sample = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_date_sample.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_user_sample.ToString())))
{
businessObject.Output_user_sample = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_user_sample.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_date_cs.ToString())))
{
businessObject.Output_date_cs = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_date_cs.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_user_cs.ToString())))
{
businessObject.Output_user_cs = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_user_cs.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_date_re.ToString())))
{
businessObject.Output_date_re = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_date_re.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_user_re.ToString())))
{
businessObject.Output_user_re = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Output_user_re.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Observation1.ToString())))
{
businessObject.Observation1 = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Observation1.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_input_date_cs.ToString())))
{
businessObject.Store_input_date_cs = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_input_date_cs.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_input_user_cs.ToString())))
{
businessObject.Store_input_user_cs = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_input_user_cs.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_input_date_re.ToString())))
{
businessObject.Store_input_date_re = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_input_date_re.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_input_user_re.ToString())))
{
businessObject.Store_input_user_re = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_input_user_re.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_output_date_cs.ToString())))
{
businessObject.Store_output_date_cs = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_output_date_cs.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_output_user_cs.ToString())))
{
businessObject.Store_output_user_cs = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_output_user_cs.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_output_date_re.ToString())))
{
businessObject.Store_output_date_re = dataReader.GetDateTime(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_output_date_re.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_output_user_re.ToString())))
{
businessObject.Store_output_user_re = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Store_output_user_re.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Observation2.ToString())))
{
businessObject.Observation2 = dataReader.GetString(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Observation2.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Final_weight_gross.ToString())))
{
businessObject.Final_weight_gross = dataReader.GetInt32(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Final_weight_gross.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Final_moisture.ToString())))
{
businessObject.Final_moisture = dataReader.GetInt32(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Final_moisture.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Final_reject.ToString())))
{
businessObject.Final_reject = dataReader.GetInt32(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Final_reject.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Final_sample_prepared.ToString())))
{
businessObject.Final_sample_prepared = dataReader.GetInt32(dataReader.GetOrdinal(CPrep_samples.CPrep_samplesFields.Final_sample_prepared.ToString()));
}
}
/// <summary>
/// insert new row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true of successfully insert</returns>
public bool Insert(CPrep_samples businessObject)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_prep_samples_Insert";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.AddWithValue("p_idrecep_sample_detail", businessObject.Idrecep_sample_detail);
sqlCommand.Parameters["p_idrecep_sample_detail"].NpgsqlDbType = NpgsqlDbType.Bigint;
sqlCommand.Parameters.AddWithValue("p_flag_humidity_analysis", businessObject.Flag_humidity_analysis);
sqlCommand.Parameters["p_flag_humidity_analysis"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_flag_reject", businessObject.Flag_reject);
sqlCommand.Parameters["p_flag_reject"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_flag_counter_sample", businessObject.Flag_counter_sample);
sqlCommand.Parameters["p_flag_counter_sample"].NpgsqlDbType = NpgsqlDbType.Smallint;
sqlCommand.Parameters.AddWithValue("p_flag_60celsius", businessObject.Flag_60celsius);
sqlCommand.Parameters["p_flag_60celsius"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_date_creation", businessObject.Date_creation);
sqlCommand.Parameters["p_date_creation"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_input_sample_date", businessObject.Input_sample_date);
sqlCommand.Parameters["p_input_sample_date"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_input_sample_user", businessObject.Input_sample_user);
sqlCommand.Parameters["p_input_sample_user"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_weight_gross", businessObject.Weight_gross);
sqlCommand.Parameters["p_weight_gross"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_weight_gross_date", businessObject.Weight_gross_date);
sqlCommand.Parameters["p_weight_gross_date"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_weight_gross_user", businessObject.Weight_gross_user);
sqlCommand.Parameters["p_weight_gross_user"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_weight_moisture", businessObject.Weight_moisture);
sqlCommand.Parameters["p_weight_moisture"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_weight_moisture_date", businessObject.Weight_moisture_date);
sqlCommand.Parameters["p_weight_moisture_date"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_weight_moisture_user", businessObject.Weight_moisture_user);
sqlCommand.Parameters["p_weight_moisture_user"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_weight_dry", businessObject.Weight_dry);
sqlCommand.Parameters["p_weight_dry"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_weight_dry_date", businessObject.Weight_dry_date);
sqlCommand.Parameters["p_weight_dry_date"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_weight_dry_user", businessObject.Weight_dry_user);
sqlCommand.Parameters["p_weight_dry_user"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_percent_moisture", businessObject.Percent_moisture);
sqlCommand.Parameters["p_percent_moisture"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_moisture_reject", businessObject.Moisture_reject);
sqlCommand.Parameters["p_moisture_reject"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_moisture_reject_date", businessObject.Moisture_reject_date);
sqlCommand.Parameters["p_moisture_reject_date"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_moisture_reject_user", businessObject.Moisture_reject_user);
sqlCommand.Parameters["p_moisture_reject_user"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_weight_gross_reject", businessObject.Weight_gross_reject);
sqlCommand.Parameters["p_weight_gross_reject"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_weight_gross_reject_date", businessObject.Weight_gross_reject_date);
sqlCommand.Parameters["p_weight_gross_reject_date"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_weight_gross_reject_user", businessObject.Weight_gross_reject_user);
sqlCommand.Parameters["p_weight_gross_reject_user"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_output_flag_sample", businessObject.Output_flag_sample);
sqlCommand.Parameters["p_output_flag_sample"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_output_flag_cs", businessObject.Output_flag_cs);
sqlCommand.Parameters["p_output_flag_cs"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_output_flag_re", businessObject.Output_flag_re);
sqlCommand.Parameters["p_output_flag_re"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_output_date_sample", businessObject.Output_date_sample);
sqlCommand.Parameters["p_output_date_sample"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_output_user_sample", businessObject.Output_user_sample);
sqlCommand.Parameters["p_output_user_sample"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_output_date_cs", businessObject.Output_date_cs);
sqlCommand.Parameters["p_output_date_cs"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_output_user_cs", businessObject.Output_user_cs);
sqlCommand.Parameters["p_output_user_cs"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_output_date_re", businessObject.Output_date_re);
sqlCommand.Parameters["p_output_date_re"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_output_user_re", businessObject.Output_user_re);
sqlCommand.Parameters["p_output_user_re"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_observation1", businessObject.Observation1);
sqlCommand.Parameters["p_observation1"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_store_input_date_cs", businessObject.Store_input_date_cs);
sqlCommand.Parameters["p_store_input_date_cs"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_store_input_user_cs", businessObject.Store_input_user_cs);
sqlCommand.Parameters["p_store_input_user_cs"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_store_input_date_re", businessObject.Store_input_date_re);
sqlCommand.Parameters["p_store_input_date_re"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_store_input_user_re", businessObject.Store_input_user_re);
sqlCommand.Parameters["p_store_input_user_re"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_store_output_date_cs", businessObject.Store_output_date_cs);
sqlCommand.Parameters["p_store_output_date_cs"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_store_output_user_cs", businessObject.Store_output_user_cs);
sqlCommand.Parameters["p_store_output_user_cs"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_store_output_date_re", businessObject.Store_output_date_re);
sqlCommand.Parameters["p_store_output_date_re"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_store_output_user_re", businessObject.Store_output_user_re);
sqlCommand.Parameters["p_store_output_user_re"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_observation2", businessObject.Observation2);
sqlCommand.Parameters["p_observation2"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_final_weight_gross", businessObject.Final_weight_gross);
sqlCommand.Parameters["p_final_weight_gross"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_final_moisture", businessObject.Final_moisture);
sqlCommand.Parameters["p_final_moisture"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_final_reject", businessObject.Final_reject);
sqlCommand.Parameters["p_final_reject"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_final_sample_prepared", businessObject.Final_sample_prepared);
sqlCommand.Parameters["p_final_sample_prepared"].NpgsqlDbType = NpgsqlDbType.Integer;
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
throw new Exception("CPrep_samples::Insert::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
