protected override void Recuperar_Registro() { CMr oMr = new CMr(); CMrFactory faMr = new CMrFactory(); if ((oMr = faMr.GetByPrimaryKey(new CMrKeys(IDMr))) != null) { tbLot.Text = oMr.Lot; cbTypeMr.EditValue = Convert.ToChar(oMr.Type_mr); cbDescription.EditValue = oMr.Type_material; cbManufacturer.EditValue = oMr.Manufaturer; cbCertifier.EditValue = oMr.Certifier; cbStatus.EditValue = oMr.Status_mr; deBegin.DateTime = Convert.ToDateTime(oMr.Fbegin_validity); deEnd.DateTime = Convert.ToDateTime(oMr.Fend_validity); CMr_detail oMr_detail = new CMr_detail(); CMr_detailFactory faMr_detail = new CMr_detailFactory(); BindingList <CMr_detail> lstMr_detail = new BindingList <CMr_detail>(new LimsProject.BusinessLayer.Modules.ModMaterialReference().SelectByMr(oMr.Idmr)); gcMaterialReference.DataSource = lstMr_detail; CMr_jarFactory faMr_jar = new CMr_jarFactory(); CMr_jar oMr_jar = new CMr_jar(); BindingList <CMr_jar> lstMr_jar = new BindingList <CMr_jar>(new LimsProject.BusinessLayer.Modules.ModMaterialReference().GetJarByMr(IDMr)); gcOpenCloseJar.DataSource = lstMr_jar; } }
private void cbCod_method_ProcessNewValue(object sender, DevExpress.XtraEditors.Controls.ProcessNewValueEventArgs e) { DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit Edit; Edit = ((DevExpress.XtraEditors.LookUpEdit)sender).Properties; if (e.DisplayValue == null || Edit.NullText.Equals(e.DisplayValue) || string.Empty.Equals(e.DisplayValue)) { return; } List <CMr> lstMr = (List <CMr>)cbCodMR.Properties.DataSource; CMr oMr = new CMr(); oMr.Cod_mr = e.DisplayValue.ToString(); oMr.Idmr = -100; lstMr.Add(oMr); cbCodMR.Properties.DataSource = lstMr; // --- referencia material detail CMr_detail oMr_detail = new CMr_detail(); CMr_detailFactory faMr_detail = new CMr_detailFactory(); BindingList <CMr_detail> lstMr_detail = new BindingList <CMr_detail>(new LimsProject.BusinessLayer.Modules.ModMaterialReference().SelectByMr(0)); gcMaterialReference.DataSource = lstMr_detail; // --- jar detail CMr_jarFactory faMr_jar = new CMr_jarFactory(); CMr_jar oMr_jar = new CMr_jar(); BindingList <CMr_jar> lstMr_jar = new BindingList <CMr_jar>(new LimsProject.BusinessLayer.Modules.ModMaterialReference().GetJarByMr(0)); gcOpenCloseJar.DataSource = lstMr_jar; e.Handled = true; }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of CMr</returns> internal List <CMr> PopulateObjectsFromReader(IDataReader dataReader) { List <CMr> list = new List <CMr>(); while (dataReader.Read()) { CMr businessObject = new CMr(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>CMr business object</returns> public CMr SelectByPrimaryKey(CMrKeys keys) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_mr_SelectByPrimaryKey"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new NpgsqlParameter("p_idmr", NpgsqlDbType.Smallint, 2, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idmr)); MainConnection.Open(); NpgsqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { CMr businessObject = new CMr(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch (Exception ex) { throw new Exception("CMr::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
protected override bool Grabar_Registro() { bool result = false; try { CMrFactory faMr = new CMrFactory(); CMr oMr = new CMr(); oMr.Cod_mr = cbCodMR.Text; oMr.Idmr = IDMr; oMr.Lot = tbLot.Text; oMr.Type_material = Convert.ToChar(cbDescription.EditValue); oMr.Type_mr = Convert.ToChar(cbTypeMr.EditValue); oMr.Status_mr = Convert.ToBoolean(cbStatus.EditValue); oMr.Type_material = Convert.ToChar(cbDescription.EditValue); oMr.Manufaturer = Convert.ToInt16(cbManufacturer.EditValue); oMr.Certifier = Convert.ToInt16(cbCertifier.EditValue); oMr.Fbegin_validity = deBegin.DateTime; oMr.Fend_validity = deEnd.DateTime; if (!(result = faMr.Update(oMr))) result = faMr.Insert(oMr); if (result) { IDMr = oMr.Idmr; // --- detail elements CMr_detailFactory faMr_detail = new CMr_detailFactory(); CMr_detail oMr_detail = new CMr_detail(); for (int i = 0; i < gvMaterialReference.RowCount; i++) { oMr_detail = (CMr_detail)gvMaterialReference.GetRow(i); oMr_detail.Idmr = IDMr; if (!faMr_detail.Update(oMr_detail)) faMr_detail.Insert(oMr_detail); } // --- detail jars CMr_jarFactory faMr_jar = new CMr_jarFactory(); CMr_jar oMr_jar = new CMr_jar(); for (int i = 0; i < gvOpenCloseJar.RowCount; i++) { oMr_jar = (CMr_jar)gvOpenCloseJar.GetRow(i); oMr_jar.Idmr = IDMr; if (!faMr_jar.Update(oMr_jar)) faMr_jar.Insert(oMr_jar); } } } catch (Exception ex) { result = false; ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message); } return result; }
private void cbCod_method_ProcessNewValue(object sender, DevExpress.XtraEditors.Controls.ProcessNewValueEventArgs e) { DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit Edit; Edit = ((DevExpress.XtraEditors.LookUpEdit)sender).Properties; if (e.DisplayValue == null || Edit.NullText.Equals(e.DisplayValue) || string.Empty.Equals(e.DisplayValue)) { return; } List<CMr> lstMr = (List<CMr>)cbCodMR.Properties.DataSource; CMr oMr = new CMr(); oMr.Cod_mr = e.DisplayValue.ToString(); oMr.Idmr = -100; lstMr.Add(oMr); cbCodMR.Properties.DataSource = lstMr; // --- referencia material detail CMr_detail oMr_detail = new CMr_detail(); CMr_detailFactory faMr_detail = new CMr_detailFactory(); BindingList<CMr_detail> lstMr_detail = new BindingList<CMr_detail>(new LimsProject.BusinessLayer.Modules.ModMaterialReference().SelectByMr(0)); gcMaterialReference.DataSource = lstMr_detail; // --- jar detail CMr_jarFactory faMr_jar = new CMr_jarFactory(); CMr_jar oMr_jar = new CMr_jar(); BindingList<CMr_jar> lstMr_jar = new BindingList<CMr_jar>(new LimsProject.BusinessLayer.Modules.ModMaterialReference().GetJarByMr(0)); gcOpenCloseJar.DataSource = lstMr_jar; e.Handled = true; }
protected override void Recuperar_Registro() { CMr oMr = new CMr(); CMrFactory faMr = new CMrFactory(); if ((oMr = faMr.GetByPrimaryKey(new CMrKeys(IDMr))) != null) { tbLot.Text = oMr.Lot; cbTypeMr.EditValue = Convert.ToChar(oMr.Type_mr); cbDescription.EditValue = oMr.Type_material; cbManufacturer.EditValue = oMr.Manufaturer; cbCertifier.EditValue = oMr.Certifier; cbStatus.EditValue = oMr.Status_mr; deBegin.DateTime = Convert.ToDateTime(oMr.Fbegin_validity); deEnd.DateTime = Convert.ToDateTime(oMr.Fend_validity); CMr_detail oMr_detail = new CMr_detail(); CMr_detailFactory faMr_detail = new CMr_detailFactory(); BindingList<CMr_detail> lstMr_detail = new BindingList<CMr_detail>(new LimsProject.BusinessLayer.Modules.ModMaterialReference().SelectByMr(oMr.Idmr)); gcMaterialReference.DataSource = lstMr_detail; CMr_jarFactory faMr_jar = new CMr_jarFactory(); CMr_jar oMr_jar = new CMr_jar(); BindingList<CMr_jar> lstMr_jar = new BindingList<CMr_jar>(new LimsProject.BusinessLayer.Modules.ModMaterialReference().GetJarByMr(IDMr)); gcOpenCloseJar.DataSource = lstMr_jar; } }
protected override bool Grabar_Registro() { bool result = false; try { CMrFactory faMr = new CMrFactory(); CMr oMr = new CMr(); oMr.Cod_mr = cbCodMR.Text; oMr.Idmr = IDMr; oMr.Lot = tbLot.Text; oMr.Type_material = Convert.ToChar(cbDescription.EditValue); oMr.Type_mr = Convert.ToChar(cbTypeMr.EditValue); oMr.Status_mr = Convert.ToBoolean(cbStatus.EditValue); oMr.Type_material = Convert.ToChar(cbDescription.EditValue); oMr.Manufaturer = Convert.ToInt16(cbManufacturer.EditValue); oMr.Certifier = Convert.ToInt16(cbCertifier.EditValue); oMr.Fbegin_validity = deBegin.DateTime; oMr.Fend_validity = deEnd.DateTime; if (!(result = faMr.Update(oMr))) { result = faMr.Insert(oMr); } if (result) { IDMr = oMr.Idmr; // --- detail elements CMr_detailFactory faMr_detail = new CMr_detailFactory(); CMr_detail oMr_detail = new CMr_detail(); for (int i = 0; i < gvMaterialReference.RowCount; i++) { oMr_detail = (CMr_detail)gvMaterialReference.GetRow(i); oMr_detail.Idmr = IDMr; if (!faMr_detail.Update(oMr_detail)) { faMr_detail.Insert(oMr_detail); } } // --- detail jars CMr_jarFactory faMr_jar = new CMr_jarFactory(); CMr_jar oMr_jar = new CMr_jar(); for (int i = 0; i < gvOpenCloseJar.RowCount; i++) { oMr_jar = (CMr_jar)gvOpenCloseJar.GetRow(i); oMr_jar.Idmr = IDMr; if (!faMr_jar.Update(oMr_jar)) { faMr_jar.Insert(oMr_jar); } } } } catch (Exception ex) { result = false; ComunForm.Send_message(this.Text, TypeMsg.error, ex.Message); } 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(CMr businessObject, IDataReader dataReader) { businessObject.Idmr = (short)dataReader.GetInt16(dataReader.GetOrdinal(CMr.CMrFields.Idmr.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Cod_mr.ToString()))) { businessObject.Cod_mr = dataReader.GetString(dataReader.GetOrdinal(CMr.CMrFields.Cod_mr.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Lot.ToString()))) { businessObject.Lot = dataReader.GetString(dataReader.GetOrdinal(CMr.CMrFields.Lot.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Type_mr.ToString()))) { businessObject.Type_mr = dataReader.GetChar(dataReader.GetOrdinal(CMr.CMrFields.Type_mr.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Type_material.ToString()))) { businessObject.Type_material = dataReader.GetChar(dataReader.GetOrdinal(CMr.CMrFields.Type_material.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Status_mr.ToString()))) { businessObject.Status_mr = dataReader.GetBoolean(dataReader.GetOrdinal(CMr.CMrFields.Status_mr.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Manufaturer.ToString()))) { businessObject.Manufaturer = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CMr.CMrFields.Manufaturer.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Certifier.ToString()))) { businessObject.Certifier = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CMr.CMrFields.Certifier.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Fbegin_validity.ToString()))) { businessObject.Fbegin_validity = dataReader.GetDateTime(dataReader.GetOrdinal(CMr.CMrFields.Fbegin_validity.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Fend_validity.ToString()))) { businessObject.Fend_validity = dataReader.GetDateTime(dataReader.GetOrdinal(CMr.CMrFields.Fend_validity.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Usernew.ToString()))) { businessObject.Usernew = dataReader.GetString(dataReader.GetOrdinal(CMr.CMrFields.Usernew.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Datenew.ToString()))) { businessObject.Datenew = dataReader.GetDateTime(dataReader.GetOrdinal(CMr.CMrFields.Datenew.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Useredit.ToString()))) { businessObject.Useredit = dataReader.GetString(dataReader.GetOrdinal(CMr.CMrFields.Useredit.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Dateedit.ToString()))) { businessObject.Dateedit = dataReader.GetDateTime(dataReader.GetOrdinal(CMr.CMrFields.Dateedit.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Status.ToString()))) { businessObject.Status = dataReader.GetBoolean(dataReader.GetOrdinal(CMr.CMrFields.Status.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMr.CMrFields.Solid.ToString()))) { businessObject.Solid = dataReader.GetBoolean(dataReader.GetOrdinal(CMr.CMrFields.Solid.ToString())); } }
/// <summary> /// insert new row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true of successfully insert</returns> public bool Insert(CMr businessObject) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_mr_Insert"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.AddWithValue("p_idmr", businessObject.Idmr); sqlCommand.Parameters["p_idmr"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters["p_idmr"].Direction = ParameterDirection.InputOutput; sqlCommand.Parameters.AddWithValue("p_cod_mr", businessObject.Cod_mr); sqlCommand.Parameters["p_cod_mr"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_lot", businessObject.Lot); sqlCommand.Parameters["p_lot"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_type_mr", businessObject.Type_mr); sqlCommand.Parameters["p_type_mr"].NpgsqlDbType = NpgsqlDbType.Char; sqlCommand.Parameters.AddWithValue("p_type_material", businessObject.Type_material); sqlCommand.Parameters["p_type_material"].NpgsqlDbType = NpgsqlDbType.Char; sqlCommand.Parameters.AddWithValue("p_status_mr", businessObject.Status_mr); sqlCommand.Parameters["p_status_mr"].NpgsqlDbType = NpgsqlDbType.Boolean; sqlCommand.Parameters.AddWithValue("p_manufaturer", businessObject.Manufaturer); sqlCommand.Parameters["p_manufaturer"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_certifier", businessObject.Certifier); sqlCommand.Parameters["p_certifier"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_fbegin_validity", businessObject.Fbegin_validity); sqlCommand.Parameters["p_fbegin_validity"].NpgsqlDbType = NpgsqlDbType.Date; sqlCommand.Parameters.AddWithValue("p_fend_validity", businessObject.Fend_validity); sqlCommand.Parameters["p_fend_validity"].NpgsqlDbType = NpgsqlDbType.Date; 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; sqlCommand.Parameters.AddWithValue("p_solid", businessObject.Solid); sqlCommand.Parameters["p_solid"].NpgsqlDbType = NpgsqlDbType.Boolean; MainConnection.Open(); sqlCommand.ExecuteNonQuery(); businessObject.Idmr = Convert.ToInt16(sqlCommand.Parameters["p_idmr"].Value); return(true); } catch (Exception ex) { throw new Exception("CMr::Insert::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }