private Entities GetList(SqlDataReader reader)
{
Entities entities = new Entities();
MajorCourse majorCourse;
while (reader.Read())
{
majorCourse = new MajorCourse();
majorCourse.MajorCourseId = reader.GetInt32(0);
majorCourse.MajorId = reader.GetInt32(1);
majorCourse.CourseId = reader.GetInt32(2);
entities.Add(majorCourse);
}
return(entities);
}
public Entity Add(Entity entity)
{
MajorCourse majorCourse = entity as MajorCourse;
string sql = "insert into MajorCourse(MajorId,CourseId)values(@MajorId,@CourseId);select @MajorCourseId = @@Identity";
SqlParameter prmMajorId = new SqlParameter("@MajorId", SqlDbType.Int)
{
Value = majorCourse.MajorId
};
SqlParameter prmCourseId = new SqlParameter("@CourseId", SqlDbType.Int)
{
Value = majorCourse.CourseId
};
SqlParameter prmMajorCourseId = new SqlParameter("@MajorCourseId", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
ExecuteNoQuery(sql, prmMajorId, prmCourseId, prmMajorCourseId);
majorCourse.MajorCourseId = (int)prmMajorCourseId.Value;
return(majorCourse);
}
