// --- obtener la ultima version de la cotización public BindingList <PriceMethodHistory> GetPriceMethodHistory(CPrice_version price_version, int?idtemplate_method) { var query = (from m in new CPrice_version_detailFactory().GetAll() join n in new CPrice_versionFactory().GetAll() on m.Idprice_version equals n.Idprice_version select m).ToList(); List <PriceMethodHistory> lst = (from m in new CPrice_version_detailFactory().GetAll() join n in new CPrice_versionFactory().GetAll() on m.Idprice_version equals n.Idprice_version into tmp1 from o in tmp1 join p in new CPriceFactory().GetAll() on o.Idprice equals p.Idprice where o.Idcompany == price_version.Idcompany && m.Idtemplate_method == idtemplate_method && o.Idprice_version != price_version.Idprice_version && o.Date_creation < price_version.Date_creation select new PriceMethodHistory { Name = "History", Idprice_version = m.Idprice_version, Cod_price = p.Cod_price, Num_version = o.Num_version, Date_creation = o.Date_creation, Amount_item = m.Amount_item, Unit_price = m.Unit_price }).OrderByDescending(c => c.Cod_price).ToList(); return(new BindingList <PriceMethodHistory>(lst)); }
/// <summary> /// update row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true for successfully updated</returns> public bool Update(CPrice_version businessObject) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_price_version_Update"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.AddWithValue("p_idprice_version", businessObject.Idprice_version); sqlCommand.Parameters["p_idprice_version"].NpgsqlDbType = NpgsqlDbType.Integer; sqlCommand.Parameters.AddWithValue("p_idprice", businessObject.Idprice); sqlCommand.Parameters["p_idprice"].NpgsqlDbType = NpgsqlDbType.Integer; sqlCommand.Parameters.AddWithValue("p_idrecep_sample", businessObject.Idrecep_sample); sqlCommand.Parameters["p_idrecep_sample"].NpgsqlDbType = NpgsqlDbType.Bigint; sqlCommand.Parameters.AddWithValue("p_num_version", businessObject.Num_version); sqlCommand.Parameters["p_num_version"].NpgsqlDbType = NpgsqlDbType.Integer; sqlCommand.Parameters.AddWithValue("p_cod_type_sample", businessObject.Cod_type_sample); sqlCommand.Parameters["p_cod_type_sample"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_idcompany", businessObject.Idcompany); sqlCommand.Parameters["p_idcompany"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_attention", businessObject.Attention); sqlCommand.Parameters["p_attention"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_iduser", businessObject.Iduser); sqlCommand.Parameters["p_iduser"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_num_days_post", businessObject.Num_days_post); sqlCommand.Parameters["p_num_days_post"].NpgsqlDbType = NpgsqlDbType.Integer; sqlCommand.Parameters.AddWithValue("p_date_creation", businessObject.Date_creation); sqlCommand.Parameters["p_date_creation"].NpgsqlDbType = NpgsqlDbType.Timestamp; sqlCommand.Parameters.AddWithValue("p_user_creation", businessObject.User_creation); sqlCommand.Parameters["p_user_creation"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_num_days_valid", businessObject.Num_days_valid); sqlCommand.Parameters["p_num_days_valid"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_status_price", businessObject.Status_price); sqlCommand.Parameters["p_status_price"].NpgsqlDbType = NpgsqlDbType.Integer; sqlCommand.Parameters.AddWithValue("p_observation", businessObject.Observation); sqlCommand.Parameters["p_observation"].NpgsqlDbType = NpgsqlDbType.Varchar; MainConnection.Open(); if (Convert.ToInt32(sqlCommand.ExecuteScalar()) > 0) { return(true); } return(false); } catch (Exception ex) { throw new Exception("CPrice_version::Update::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public List <Anexos> GetLstAnexos(CPrice_version price_version) { if (price_version == null) { List <Anexos> lst = new List <Anexos>(); return(lst); } else { var query = new CPrice_attachFactory() .GetAll() .Where(c => c.Idprice == price_version.Idprice ).ToList(); List <Anexos> query2 = (from m in query from n in new CPrice_versionFactory().GetAll().Where(c => c.Idprice == m.Idprice && c.Idprice_version == m.Idprice_version).DefaultIfEmpty() where n.Num_version <= price_version.Num_version select new Anexos { Filename = m.Name_document, Idprice = m.Idprice, Idprice_version = m.Idprice_version, Num_version = n.Num_version, Source_filename = "" }).ToList(); return(query2); } }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of CPrice_version</returns> internal List <CPrice_version> PopulateObjectsFromReader(IDataReader dataReader) { List <CPrice_version> list = new List <CPrice_version>(); while (dataReader.Read()) { CPrice_version businessObject = new CPrice_version(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
public FormPrice(CPrice_version pPrice_version, LoadData pLoadData) { InitializeComponent(); Init(); oPrice_version = pPrice_version; loadData = pLoadData; if (pPrice_version != null) { oPrice = new CPriceFactory().GetByPrimaryKey(new CPriceKeys(Convert.ToInt32(oPrice_version.Idprice))); } Recuperar_Registro(); ShowStatusControl(); }
protected override void Limpiar_Campos() { oPrice = null; oPrice_version = null; LstPrice_version_detail = null; totalAmount = 0; cbTypeSample.EditValue = null; cbCompany.EditValue = null; deDateCreation.DateTime = Comun.GetDate(); tbNumDaysValid.Value = new CSettings().GetNumDaysPriceDefault(); tbClientDomicile.Text = ""; tbClientPhone.Text = ""; tbClientRuc.Text = ""; tabHead.Text = "Datos"; tbCodPrice.Text = ""; tbNumVersion.Text = ""; ckDispatchCurier.Checked = false; ckDispatchFax.Checked = false; ckDispatchPerson.Checked = false; ckDispatchTransport.Checked = false; ckSaveHistoryEnd.Checked = false; ckSaveHistoryIni.Checked = false; tbObservation.Text = ""; tbSubTotalAmount.Value = 0; tbTotalAmount.Value = 0; tbTotalIgv.Value = 0; gcPrice.DataSource = new BindingList <PriceMethod>(new ModPrice().GetPriceMethod(null)); gcContact.DataSource = null; richTextIni.RichTextBox.Clear(); richTextEnd.RichTextBox.Clear(); gcAnexos.DataSource = new BindingList <Anexos>(new ModPrice().GetLstAnexos(null)); previewControl1.Clear(); loadData = LoadData.Nothing; ShowStatusControl(); }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>CPrice_version business object</returns> public CPrice_version SelectByPrimaryKey(CPrice_versionKeys keys) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_price_version_SelectByPrimaryKey"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new NpgsqlParameter("p_idprice_version", NpgsqlDbType.Integer, 4, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idprice_version)); MainConnection.Open(); NpgsqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { CPrice_version businessObject = new CPrice_version(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch (Exception ex) { throw new Exception("CPrice_version::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public void Save(CPrice price, CPrice_version price_version) { foreach (CItemCopy item in this) { //copiar item if (ComunForm.CopyAndSaveFile(item.Source_file, item.Destiny_directory, item.Filename)) { CPrice_attach price_attach = new CPrice_attach(); price_attach.Idprice = price_version.Idprice; price_attach.Idprice_version = price_version.Idprice_version; price_attach.Name_document = item.Filename; //guardar adjunto if (!new CPrice_attachFactory().Update(price_attach)) { new CPrice_attachFactory().Insert(price_attach); } } } }
public List <PriceMethod> GetPriceMethod(CPrice_version price_version) { if (price_version == null) { List <PriceMethod> lstPriceMethod = new List <PriceMethod>(); return(lstPriceMethod); } else { List <CPrice_version_detail> lst = (from m in new CPrice_version_detailFactory().GetAll() where m.Idprice_version == price_version.Idprice_version select m).ToList(); List <PriceMethod> lstPriceMethod = new List <PriceMethod>(); foreach (CPrice_version_detail item in lst) { lstPriceMethod.Add(new PriceMethod(item, GetPriceMethodHistory(price_version, item.Idtemplate_method))); } return(lstPriceMethod); } }
private void ucToolButtons_onFind() { // --- FormMasterSearch fmBusqueda = new FormMasterSearch(); UcFilterPrice filter = new UcFilterPrice(); filter.onSearch += delegate(ModMasterSearch.KeyFilterPrice key) { fmBusqueda.BindGrid(new ModMasterSearch().GetPrices(key)); }; fmBusqueda.BindGrid(filter, filter.Size, new ModMasterSearch().GetPrices(filter.keyDefault)); fmBusqueda.ShowDialog(); Dictionary <string, string> keys = fmBusqueda.getKeyValues(); if (keys != null) { Limpiar_Campos(); loadData = LoadData.MasterSearchPrice; /// recuperar cotización seleccionada oPrice_version = new CPrice_versionFactory() .GetByPrimaryKey(new CPrice_versionKeys(Convert.ToInt32(keys["Idprice_version"]))); oPrice = new CPriceFactory() .GetByPrimaryKey(new CPriceKeys(Convert.ToInt32(oPrice_version.Idprice))); Recuperar_Registro(); ShowStatusControl(); } }
private void btAdd_Click(object sender, EventArgs e) { if (cbCompany.EditValue != null && cbMethodAdd.EditValue != null) { BindingList <PriceMethod> lst = gcPrice.DataSource as BindingList <PriceMethod>; List <PriceMethod> myLstPriceMethod = lst.ToList(); // agregar un método a la lista int idtemplate_method = Convert.ToInt32(cbMethodAdd.EditValue); CTemplate_method oTemplate_method = new CTemplate_methodFactory().GetByPrimaryKey(new CTemplate_methodKeys(idtemplate_method)); CPrice_version price_version = new CPrice_version(); price_version.Idprice_version = 0; price_version.Idcompany = Convert.ToInt16(cbCompany.EditValue); price_version.Date_creation = Comun.GetDate(); CPrice_version_detail price_version_detail = new CPrice_version_detail(); price_version_detail.Num_item = myLstPriceMethod.Count + 1; price_version_detail.Amount_item = 1; price_version_detail.Idtemplate_method = idtemplate_method; price_version_detail.Unit_price = oTemplate_method.Cost_method; price_version_detail.Sale_price = oTemplate_method.Cost_method * price_version_detail.Amount_item; myLstPriceMethod.Add( new PriceMethod(price_version_detail, new ModPrice().GetPriceMethodHistory(price_version, price_version_detail.Idtemplate_method))); gcPrice.DataSource = new BindingList <PriceMethod>(myLstPriceMethod); gvPrice.LayoutChanged(); cbMethodAdd.EditValue = null; SumTotals(); ShowPreviewReport(); } }
protected override bool Grabar_Registro() { // --- 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); } } bool result_price = false; if (oPrice == null) { oPrice = new CPrice(); } CPriceFactory faPrice = new CPriceFactory(); if (!(loadData == LoadData.FromPrice_ToNewVersion)) { oPrice.Cod_price = new ModCorrelatives().GetCorrelative(Comun.Correlative.Price); } // --- person if (ckDispatchPerson.Checked) { oPrice.Dispatch_person = 1; } else { oPrice.Dispatch_person = 0; } // --- curier if (ckDispatchCurier.Checked) { oPrice.Dispatch_curier = 1; } else { oPrice.Dispatch_curier = 0; } // --- transport if (ckDispatchTransport.Checked) { oPrice.Dispatch_transport = 1; } else { oPrice.Dispatch_transport = 0; } // --- fax if (ckDispatchFax.Checked) { oPrice.Dispatch_fax = 1; } else { oPrice.Dispatch_fax = 0; } if (!(result_price = faPrice.Update(oPrice))) { result_price = faPrice.Insert(oPrice); } // --- save contacts CPerson oContact = new CPerson(); CPersonFactory faPerson = new CPersonFactory(); CPrice_company_person oPrice_company_person = new CPrice_company_person(); CPrice_company_personFactory faPrice_company_person = new CPrice_company_personFactory(); // --- delete all if (result_price) { oPrice_version = new CPrice_version(); CPrice_versionFactory faPrice_version = new CPrice_versionFactory(); oPrice_version.Idprice = oPrice.Idprice; oPrice_version.Idcompany = null; if (cbCompany.EditValue != null) { oPrice_version.Idcompany = Convert.ToInt16(cbCompany.EditValue); } oPrice_version.Cod_type_sample = cbTypeSample.EditValue.ToString(); oPrice_version.Num_version = new ModPrice().GetNextNumVersion(oPrice.Idprice); oPrice_version.Date_creation = deDateCreation.DateTime; oPrice_version.Num_days_valid = Convert.ToInt16(tbNumDaysValid.Value); oPrice_version.Observation = tbObservation.Text; oPrice_version.Iduser = Comun.User_system.Iduser; oPrice_version.Status_price = 1; bool result_price_version = false; if (!(result_price_version = faPrice_version.Update(oPrice_version))) { result_price_version = faPrice_version.Insert(oPrice_version); } if (result_price_version) { //guardar párrafos iniciales CMemo_price oMemoPrice; CMemo_priceFactory faMemo_price = new CMemo_priceFactory(); //guardando el parrafo inicial oMemoPrice = new CMemo_price(); oMemoPrice.Idprice_version = oPrice_version.Idprice_version; oMemoPrice.Paragraph = richTextIni.RichTextBox.Rtf; oMemoPrice.Memo_type = 1; faMemo_price.Insert(oMemoPrice); //guardando el parrafo final oMemoPrice = new CMemo_price(); oMemoPrice.Idprice_version = oPrice_version.Idprice_version; oMemoPrice.Paragraph = richTextEnd.RichTextBox.Rtf; oMemoPrice.Memo_type = 2; faMemo_price.Insert(oMemoPrice); if (ckSaveHistoryIni.Checked) { CMemo_template oMemo_template = new CMemo_template(); CMemo_templateFactory faMemo_template = new CMemo_templateFactory(); oMemo_template.Paragraph = richTextIni.RichTextBox.Text; oMemo_template.Paragraph_rtf = richTextIni.RichTextBox.Rtf.ToString(); oMemo_template.Memo_type = 1; faMemo_template.Insert(oMemo_template); } //guardar párrafos finales if (ckSaveHistoryEnd.Checked) { CMemo_template oMemo_template = new CMemo_template(); CMemo_templateFactory faMemo_template = new CMemo_templateFactory(); oMemo_template.Paragraph_rtf = richTextEnd.RichTextBox.Rtf; oMemo_template.Paragraph = richTextEnd.RichTextBox.Text.ToString(); oMemo_template.Memo_type = 2; faMemo_template.Insert(oMemo_template); } } if (result_price) { CCompany_person oCompany_person = new CCompany_person(); CCompany_personFactory faCompany_person = new CCompany_personFactory(); 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) { oPrice_company_person = new CPrice_company_person(); oPrice_company_person.Idprice_company_person = 0; oPrice_company_person.Idcompany = oCompany.Idcompany; oPrice_company_person.Idprice = oPrice.Idprice; oPrice_company_person.Idperson = oContact.Idperson; oPrice_company_person.Idprice_version = oPrice_version.Idprice_version; oPrice_company_person.Person_type = Convert.ToInt16(gvContact.GetRowCellValue(i, gcCon_Person_type)); if (!faPrice_company_person.Update(oPrice_company_person)) { faPrice_company_person.Insert(oPrice_company_person); } } // --- save history company person if (!faCompany_person.GetAll().Exists(c => c.Idcompany == oCompany.Idcompany && c.Idperson == oContact.Idperson)) { oCompany_person = new CCompany_person(); oCompany_person.Idcompany = oCompany.Idcompany; oCompany_person.Idperson = oContact.Idperson; if (!faCompany_person.Update(oCompany_person)) { faCompany_person.Insert(oCompany_person); } } } } if (result_price_version) { // guardar detalle CPrice_version_detail oPrice_version_detail = new CPrice_version_detail(); CPrice_version_detailFactory faPrice_version_detail = new CPrice_version_detailFactory(); for (int i = 0; i < gvPrice.RowCount; i++) { oPrice_version_detail = new CPrice_version_detail(); oPrice_version_detail.Idprice_version = oPrice_version.Idprice_version; oPrice_version_detail.Idtemplate_method = Convert.ToInt32(gvPrice.GetRowCellValue(i, gcolItem_Idtemplate_method)); oPrice_version_detail.Num_item = Convert.ToInt32(gvPrice.GetRowCellValue(i, gcolItem_Num_item)); oPrice_version_detail.Amount_item = Convert.ToInt32(gvPrice.GetRowCellValue(i, gcolItem_Amount_item)); oPrice_version_detail.Sale_price = Convert.ToDecimal(gvPrice.GetRowCellValue(i, gcolItem_Sale_price)); oPrice_version_detail.Unit_price = Convert.ToDecimal(gvPrice.GetRowCellValue(i, gcolItem_Unit_price)); if (!faPrice_version_detail.Update(oPrice_version_detail)) { faPrice_version_detail.Insert(oPrice_version_detail); } } } if (result_price_version) { if (gvAnexos.RowCount > 0) { // guardar adjuntos ListCopy lstCopySave = new ListCopy(); List <Anexos> lstAnexos = (gcAnexos.DataSource as BindingList <Anexos>).ToList(); if (lstAnexos != null && lstAnexos.Count > 0) { foreach (Anexos item in lstAnexos) { if (item.Source_filename.Trim().Length > 0) { string destiny_directory = oSettings.GetPathAttachPrice(); lstCopySave.Add( new CItemCopy() { Filename = item.Filename, Source_file = item.Source_filename, Destiny_directory = destiny_directory }); } } lstCopySave.Save(oPrice, oPrice_version); } } } } return(true); }
public CRecep_sample getRecep_sample(CPrice_version p_price_version) { return(new CRecep_sampleFactory() .GetByPrimaryKey(new CRecep_sampleKeys(Convert.ToInt64(p_price_version.Idrecep_sample)))); }
public DataTable GetDTPrice_version_detail(CPrice_version price_version) { return(ToDataTable <PriceMethod>(GetPriceMethod(price_version))); }
protected override void Limpiar_Campos() { txIdrecep_sample.Text = ""; IDCompany = 0; cbCompany.EditValue = null; tbClientRuc.Text = ""; tbClientDomicile.Text = ""; tbClientPhone.Text = ""; ckDispatchPerson.Checked = false; ckDispatchCurier.Checked = false; ckDispatchTransport.Checked = false; ckDispatchFax.Checked = false; tbSubTotalAmount.Text = ""; tbTotalIgv.Text = ""; tbTotalAmount.Text = ""; totalAmount = 0; tbAmortization.Text = ""; tbResidue.Text = ""; deReception.DateTime = DateTime.Now; deHourReception.EditValue = DateTime.Now; deResult.Text = ""; deHourResult.Text = ""; tbCod_recep_sample.Text = ""; deHourResult.Time = DateTime.Now; tbNumDays.Value = 0; deResult.EditValue = null; deHourResult.EditValue = null; tpRightReports.PageVisible = false; tpRightAttach.PageVisible = false; tpRightProgram.PageVisible = false; lstItemsSelAttach.Clear(); lstItemsSelReport.Clear(); lstItemsSelProgram.Clear(); InitDatatable(); InitDataControls(); gcContact.DataSource = null; gcReport.DataSource = null; gcAttachFile.DataSource = null; gcProgram.DataSource = null; ClearElemColumns(); ucSignReception.Clear(); oRecep_sample = null; oPrice = null; oPrice_version = null; }
/// <summary> /// inicializa un nuevo registro de recepción desde una cotización /// </summary> /// <param name="pPrice_version"></param> public FormReception(CPrice_version pPrice_version, LoadData generic) { InitializeComponent(); loadData = generic; Init(); Recuperar_Registro(); ChangeStatusControls(); statusRegReception = StatusRegRecep.reg_recep_saved; }
void OpenFormMasterSearch(typeModule tm) { if (tm == typeModule.RegisterReception) { ///attributes short? p_year = null; short? p_idcompany = null; DateTime? p_date_begin = null; DateTime? p_date_end = null; FormMasterSearch fmBusqueda = new FormMasterSearch(); fmBusqueda.BindGrid(new ModMasterSearch().GetRegReception(p_year, p_idcompany, p_date_begin, p_date_end)); fmBusqueda.ShowDialog(); Dictionary<string, string> keys = fmBusqueda.getKeyValues(); if (keys != null) { ///get recep sample oRecep_sample = faRecep_sample.GetByPrimaryKey(new CRecep_sampleKeys(Convert.ToInt64(keys["Idrecep_sample"]))); oPrice_version = faPrice_version.GetByPrimaryKey(new CPrice_versionKeys(Convert.ToInt32(keys["Idprice_version"]))); Limpiar_Campos(); Recuperar_Registro(); thePanelTab1.SelectedIndex = 0; statusRegReception = StatusRegRecep.reg_recep_saved; } } }
/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(CPrice_version businessObject, IDataReader dataReader) { businessObject.Idprice_version = dataReader.GetInt32(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Idprice_version.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Idprice.ToString()))) { businessObject.Idprice = dataReader.GetInt32(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Idprice.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Idrecep_sample.ToString()))) { businessObject.Idrecep_sample = dataReader.GetInt64(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Idrecep_sample.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Num_version.ToString()))) { businessObject.Num_version = dataReader.GetInt32(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Num_version.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Cod_type_sample.ToString()))) { businessObject.Cod_type_sample = dataReader.GetString(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Cod_type_sample.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Idcompany.ToString()))) { businessObject.Idcompany = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Idcompany.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Attention.ToString()))) { businessObject.Attention = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Attention.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Iduser.ToString()))) { businessObject.Iduser = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Iduser.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Num_days_post.ToString()))) { businessObject.Num_days_post = dataReader.GetInt32(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Num_days_post.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Date_creation.ToString()))) { businessObject.Date_creation = dataReader.GetDateTime(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Date_creation.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.User_creation.ToString()))) { businessObject.User_creation = dataReader.GetString(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.User_creation.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Num_days_valid.ToString()))) { businessObject.Num_days_valid = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Num_days_valid.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Status_price.ToString()))) { businessObject.Status_price = dataReader.GetInt32(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Status_price.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Observation.ToString()))) { businessObject.Observation = dataReader.GetString(dataReader.GetOrdinal(CPrice_version.CPrice_versionFields.Observation.ToString())); } }