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); }