public static void SaveCompaniaAerea(ref CompaniaAereaDTO companiaAerea)
{
SqlCommand command;
if (companiaAerea.IsNew)
{
command = GetDbSprocCommand("usp_CompaniaAerea_Insert");
command.Parameters.Add(CreateOutputParameter("@idCompaniaAerea", SqlDbType.Int));
}
else
{
command = GetDbSprocCommand("usp_CompaniaAerea_Update");
command.Parameters.Add(CreateParameter("@idCompaniaAerea", companiaAerea.idCompaniaAereaDTO));
}
command.Parameters.Add(CreateParameter("@nombre", companiaAerea.nombreDTO, 50));
command.Parameters.Add(CreateParameter("@telefono", companiaAerea.telefonoDTO, 13));
command.Parameters.Add(CreateParameter("@paginaWeb", companiaAerea.paginaWebDTO, 50));
// Run the command.
command.Connection.Open();
command.ExecuteNonQuery();
command.Connection.Close();
// If this is a new record, let's set the ID so the object
// will have it.
if (companiaAerea.IsNew)
{
companiaAerea.idCompaniaAereaDTO = (int)command.Parameters["@idCompaniaAerea"].Value;
}
}
internal override DTOBase PopulateDTO(SqlDataReader reader)
{
CompaniaAereaDTO companiaAereaDTO = new CompaniaAereaDTO();
//idCompaniaAerea
if (!reader.IsDBNull(Ord_idCompaniaAerea))
{
companiaAereaDTO.idCompaniaAereaDTO = reader.GetInt32(Ord_idCompaniaAerea);
}
//nombre
if (!reader.IsDBNull(Ord_nombre))
{
companiaAereaDTO.nombreDTO = reader.GetString(Ord_nombre);
}
//telefono
if (!reader.IsDBNull(Ord_telefono))
{
companiaAereaDTO.telefonoDTO = reader.GetString(Ord_telefono);
}
//paginaWeb
if (!reader.IsDBNull(Ord_paginaWeb))
{
companiaAereaDTO.paginaWebDTO = reader.GetString(Ord_paginaWeb);
}
return(companiaAereaDTO);
}
