/// <summary> /// insert new row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true of successfully insert</returns> public bool Insert(CConvert_unit_measurement businessObject) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_convert_unit_measurement_Insert"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.AddWithValue("p_idconvert", businessObject.Idconvert); sqlCommand.Parameters["p_idconvert"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters["p_idconvert"].Direction = ParameterDirection.InputOutput; sqlCommand.Parameters.AddWithValue("p_den_unit1", businessObject.Den_unit1); sqlCommand.Parameters["p_den_unit1"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_den_unit2", businessObject.Den_unit2); sqlCommand.Parameters["p_den_unit2"].NpgsqlDbType = NpgsqlDbType.Varchar; sqlCommand.Parameters.AddWithValue("p_idunit1", businessObject.Idunit1); sqlCommand.Parameters["p_idunit1"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_idunit2", businessObject.Idunit2); sqlCommand.Parameters["p_idunit2"].NpgsqlDbType = NpgsqlDbType.Smallint; sqlCommand.Parameters.AddWithValue("p_factor", businessObject.Factor); sqlCommand.Parameters["p_factor"].NpgsqlDbType = NpgsqlDbType.Numeric; 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(); sqlCommand.ExecuteNonQuery(); businessObject.Idconvert = Convert.ToInt16(sqlCommand.Parameters["p_idconvert"].Value); return(true); } catch (Exception ex) { throw new Exception("CConvert_unit_measurement::Insert::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(CConvert_unit_measurement businessObject, IDataReader dataReader) { businessObject.Idconvert = (short)dataReader.GetInt16(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Idconvert.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Den_unit1.ToString()))) { businessObject.Den_unit1 = dataReader.GetString(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Den_unit1.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Den_unit2.ToString()))) { businessObject.Den_unit2 = dataReader.GetString(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Den_unit2.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Idunit1.ToString()))) { businessObject.Idunit1 = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Idunit1.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Idunit2.ToString()))) { businessObject.Idunit2 = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Idunit2.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Factor.ToString()))) { businessObject.Factor = dataReader.GetDecimal(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Factor.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Usernew.ToString()))) { businessObject.Usernew = dataReader.GetString(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Usernew.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Datenew.ToString()))) { businessObject.Datenew = dataReader.GetDateTime(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Datenew.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Useredit.ToString()))) { businessObject.Useredit = dataReader.GetString(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Useredit.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Dateedit.ToString()))) { businessObject.Dateedit = dataReader.GetDateTime(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Dateedit.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Status.ToString()))) { businessObject.Status = dataReader.GetBoolean(dataReader.GetOrdinal(CConvert_unit_measurement.CConvert_unit_measurementFields.Status.ToString())); } }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of CConvert_unit_measurement</returns> internal List <CConvert_unit_measurement> PopulateObjectsFromReader(IDataReader dataReader) { List <CConvert_unit_measurement> list = new List <CConvert_unit_measurement>(); while (dataReader.Read()) { CConvert_unit_measurement businessObject = new CConvert_unit_measurement(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
protected override bool Grabar_Registro() { CConvert_unit_measurementFactory faConvert_unit_measurement = new CConvert_unit_measurementFactory(); CConvert_unit_measurement oConvert_unit_measurement = new CConvert_unit_measurement(); for(int i = 0; i < gvConvertionUM.RowCount; i++) { oConvert_unit_measurement.Idconvert = Convert.ToInt16(gvConvertionUM.GetRowCellValue(i, gcUmc_idconvert)); oConvert_unit_measurement.Idunit1 = Convert.ToInt16(gvConvertionUM.GetRowCellValue(i, gcUmc_idunit1)); oConvert_unit_measurement.Idunit2 = Convert.ToInt16(gvConvertionUM.GetRowCellValue(i, gcUmc_idunit2)); oConvert_unit_measurement.Den_unit1 = gvConvertionUM.GetRowCellValue(i, gcUmc_den_unit1).ToString(); oConvert_unit_measurement.Den_unit2 = gvConvertionUM.GetRowCellValue(i, gcUmc_den_unit2).ToString(); oConvert_unit_measurement.Factor = Convert.ToDecimal( gvConvertionUM.GetRowCellValue(i, gcUmc_factor)); if (!faConvert_unit_measurement.Update(oConvert_unit_measurement)) faConvert_unit_measurement.Insert(oConvert_unit_measurement); } return true; }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>CConvert_unit_measurement business object</returns> public CConvert_unit_measurement SelectByPrimaryKey(CConvert_unit_measurementKeys keys) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_convert_unit_measurement_SelectByPrimaryKey"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new NpgsqlParameter("p_idconvert", NpgsqlDbType.Smallint, 2, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idconvert)); MainConnection.Open(); NpgsqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { CConvert_unit_measurement businessObject = new CConvert_unit_measurement(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch (Exception ex) { throw new Exception("CConvert_unit_measurement::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
protected override bool Grabar_Registro() { CConvert_unit_measurementFactory faConvert_unit_measurement = new CConvert_unit_measurementFactory(); CConvert_unit_measurement oConvert_unit_measurement = new CConvert_unit_measurement(); for (int i = 0; i < gvConvertionUM.RowCount; i++) { oConvert_unit_measurement.Idconvert = Convert.ToInt16(gvConvertionUM.GetRowCellValue(i, gcUmc_idconvert)); oConvert_unit_measurement.Idunit1 = Convert.ToInt16(gvConvertionUM.GetRowCellValue(i, gcUmc_idunit1)); oConvert_unit_measurement.Idunit2 = Convert.ToInt16(gvConvertionUM.GetRowCellValue(i, gcUmc_idunit2)); oConvert_unit_measurement.Den_unit1 = gvConvertionUM.GetRowCellValue(i, gcUmc_den_unit1).ToString(); oConvert_unit_measurement.Den_unit2 = gvConvertionUM.GetRowCellValue(i, gcUmc_den_unit2).ToString(); oConvert_unit_measurement.Factor = Convert.ToDecimal(gvConvertionUM.GetRowCellValue(i, gcUmc_factor)); if (!faConvert_unit_measurement.Update(oConvert_unit_measurement)) { faConvert_unit_measurement.Insert(oConvert_unit_measurement); } } return(true); }