/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of CMethods_multi</returns>
internal List <CMethods_multi> PopulateObjectsFromReader(IDataReader dataReader)
{
List <CMethods_multi> list = new List <CMethods_multi>();
while (dataReader.Read())
{
CMethods_multi businessObject = new CMethods_multi();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
/// <summary>
/// Select by primary key
/// </summary>
/// <param name="keys">primary keys</param>
/// <returns>CMethods_multi business object</returns>
public CMethods_multi SelectByPrimaryKey(CMethods_multiKeys keys)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_methods_multi_SelectByPrimaryKey";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new NpgsqlParameter("p_id", NpgsqlDbType.Integer, 4, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Id));
MainConnection.Open();
NpgsqlDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
CMethods_multi businessObject = new CMethods_multi();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("CMethods_multi::SelectByPrimaryKey::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(CMethods_multi businessObject, IDataReader dataReader)
{
businessObject.Id = dataReader.GetInt32(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Id.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Elemento_longitud.ToString())))
{
businessObject.Elemento_longitud = dataReader.GetString(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Elemento_longitud.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Elemento.ToString())))
{
businessObject.Elemento = dataReader.GetString(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Elemento.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Prioridad.ToString())))
{
businessObject.Prioridad = dataReader.GetInt32(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Prioridad.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Longitud.ToString())))
{
businessObject.Longitud = dataReader.GetDecimal(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Longitud.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Idl.ToString())))
{
businessObject.Idl = dataReader.GetDecimal(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Idl.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Mdl.ToString())))
{
businessObject.Mdl = dataReader.GetDecimal(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Mdl.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Linealidad.ToString())))
{
businessObject.Linealidad = dataReader.GetDecimal(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Linealidad.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Num_decimal.ToString())))
{
businessObject.Num_decimal = dataReader.GetDecimal(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Num_decimal.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Std1.ToString())))
{
businessObject.Std1 = dataReader.GetDecimal(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Std1.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Std2.ToString())))
{
businessObject.Std2 = dataReader.GetDecimal(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Std2.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Ipc.ToString())))
{
businessObject.Ipc = dataReader.GetDecimal(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Ipc.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Lfb.ToString())))
{
businessObject.Lfb = dataReader.GetDecimal(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Lfb.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Lfm.ToString())))
{
businessObject.Lfm = dataReader.GetDecimal(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Lfm.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Limite_inferior_md.ToString())))
{
businessObject.Limite_inferior_md = dataReader.GetDecimal(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Limite_inferior_md.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Limite_inferior_mt.ToString())))
{
businessObject.Limite_inferior_mt = dataReader.GetDecimal(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Limite_inferior_mt.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Limite_superior.ToString())))
{
businessObject.Limite_superior = dataReader.GetDecimal(dataReader.GetOrdinal(CMethods_multi.CMethods_multiFields.Limite_superior.ToString()));
}
}
/// <summary>
/// insert new row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true of successfully insert</returns>
public bool Insert(CMethods_multi businessObject)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_methods_multi_Insert";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.AddWithValue("p_id", businessObject.Id);
sqlCommand.Parameters["p_id"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters["p_id"].Direction = ParameterDirection.InputOutput;
sqlCommand.Parameters.AddWithValue("p_elemento_longitud", businessObject.Elemento_longitud);
sqlCommand.Parameters["p_elemento_longitud"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_elemento", businessObject.Elemento);
sqlCommand.Parameters["p_elemento"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_prioridad", businessObject.Prioridad);
sqlCommand.Parameters["p_prioridad"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_longitud", businessObject.Longitud);
sqlCommand.Parameters["p_longitud"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_idl", businessObject.Idl);
sqlCommand.Parameters["p_idl"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_mdl", businessObject.Mdl);
sqlCommand.Parameters["p_mdl"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_linealidad", businessObject.Linealidad);
sqlCommand.Parameters["p_linealidad"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_num_decimal", businessObject.Num_decimal);
sqlCommand.Parameters["p_num_decimal"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_std1", businessObject.Std1);
sqlCommand.Parameters["p_std1"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_std2", businessObject.Std2);
sqlCommand.Parameters["p_std2"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_ipc", businessObject.Ipc);
sqlCommand.Parameters["p_ipc"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_lfb", businessObject.Lfb);
sqlCommand.Parameters["p_lfb"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_lfm", businessObject.Lfm);
sqlCommand.Parameters["p_lfm"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_limite_inferior_md", businessObject.Limite_inferior_md);
sqlCommand.Parameters["p_limite_inferior_md"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_limite_inferior_mt", businessObject.Limite_inferior_mt);
sqlCommand.Parameters["p_limite_inferior_mt"].NpgsqlDbType = NpgsqlDbType.Numeric;
sqlCommand.Parameters.AddWithValue("p_limite_superior", businessObject.Limite_superior);
sqlCommand.Parameters["p_limite_superior"].NpgsqlDbType = NpgsqlDbType.Numeric;
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
businessObject.Id = Convert.ToInt32(sqlCommand.Parameters["p_id"].Value);
return(true);
}
catch (Exception ex)
{
throw new Exception("CMethods_multi::Insert::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
