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