/// <summary>
/// Saves a record to the FormaEntrega table.
/// </summary>
public void Insert(FormaEntregaEntidad formaEntrega)
{
ValidationUtility.ValidateArgument("formaEntrega", formaEntrega);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@DescripcionFormaEntrega", formaEntrega.DescripcionFormaEntrega)
};
formaEntrega.IdFormaEntrega = (int)SqlClientUtility.ExecuteScalar(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "FormaEntregaInsert", parameters);
}
/// <summary>
/// Updates a record in the FormaEntrega table.
/// </summary>
public void Update(FormaEntregaEntidad formaEntrega)
{
ValidationUtility.ValidateArgument("formaEntrega", formaEntrega);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdFormaEntrega", formaEntrega.IdFormaEntrega),
new SqlParameter("@DescripcionFormaEntrega", formaEntrega.DescripcionFormaEntrega)
};
SqlClientUtility.ExecuteNonQuery(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "FormaEntregaUpdate", parameters);
}
/// <summary>
/// Selects a single record from the FormaEntrega table.
/// </summary>
public FormaEntregaEntidad Select(int idFormaEntrega)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdFormaEntrega", idFormaEntrega)
};
using (DataTable dt = SqlClientUtility.ExecuteDataTable(SqlClientUtility.connectionStringName, CommandType.StoredProcedure, "FormaEntregaSelect", parameters))
{
FormaEntregaEntidad FormaEntregaEntidad = new FormaEntregaEntidad();
FormaEntregaEntidad = Mapeador.MapearFirst <FormaEntregaEntidad>(dt);
return(FormaEntregaEntidad);
}
}
