public bool AddEnrollment(wpEnroll enroll) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ccode", enroll.ClassCode), new SqlParameter("@snum", enroll.StudentNum), new SqlParameter("@grade", enroll.EnrollGrade) }; return(dbHelper.ExecuteNonQuery("[uspAddEnrollment]", System.Data.CommandType.StoredProcedure, parameters)); }
public List <wpEnroll> GetEnrollList() { List <wpEnroll> enrollList = null; using (DataTable table = dbHelper.ExecuteSelectCommand("[uspGetEnroll]", System.Data.CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { enrollList = new List <wpEnroll>(); foreach (DataRow row in table.Rows) { wpEnroll myEnroll = new wpEnroll(); myEnroll.ClassCode = row["CLASS_CODE"].ToString(); myEnroll.StudentNum = Convert.ToInt32(row["STU_NUM"]); myEnroll.EnrollGrade = row["ENROLL_GRADE"].ToString(); enrollList.Add(myEnroll); } } return(enrollList); } }
public bool AddEnrollment(wpEnroll enroll) { return(eAccess.AddEnrollment(enroll)); }