/// <summary>
/// Saves a record to the Carrera table.
/// </summary>
public void Insert(Carrera carrera)
{
ValidationUtility.ValidateArgument("carrera", carrera);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Nombre", carrera.Nombre)
};
carrera.IdCarrera = (int) SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "CarreraInsert", parameters);
SqlConnection.ClearAllPools();
}
/// <summary>
/// Creates a new instance of the Carrera class and populates it with data from the specified SqlDataReader.
/// </summary>
private Carrera MapDataReader(SqlDataReader dataReader)
{
Carrera carrera = new Carrera();
carrera.IdCarrera = dataReader.GetInt32("IdCarrera", 0);
carrera.Nombre = dataReader.GetString("Nombre", null);
return carrera;
}
/// <summary>
/// Updates a record in the Carrera table.
/// </summary>
public void Update(Carrera carrera)
{
ValidationUtility.ValidateArgument("carrera", carrera);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@IdCarrera", carrera.IdCarrera),
new SqlParameter("@Nombre", carrera.Nombre)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "CarreraUpdate", parameters);
SqlConnection.ClearAllPools();
}