public void getCourse() { //connect to db objConn.Open(); //set up and run the sql objCmd = new SqlCommand("SELECT * FROM Courses WHERE CourseID = " + CourseID.ToString(), objConn); //execute the sql and store the results in an sqldatareader to send back to the caller SqlDataReader objRdr; objRdr = objCmd.ExecuteReader(); //loop through the columns and fill the properties of the User object while (objRdr.Read()) { StudentName = objRdr.GetString(1); CourseName = objRdr.GetString(0); CourseTime = objRdr.GetString(2); //address = objRdr.GetString(2); } objRdr.Close(); objCmd.Dispose(); objConn.Close(); }
public void deleteUsers() { //connect to db objConn.Open(); //set up and run the sql objCmd = new SqlCommand("DELETE FROM Courses WHERE CourseID = " + CourseID.ToString(), objConn); objCmd.ExecuteNonQuery(); //clean up objCmd.Dispose(); objConn.Close(); }
protected override void Fill() { lblMessage.Visible = false; FillCourses(); if (CourseID > 0) { trSlideHeader.Visible = true; ddlCourse.SelectedIndex = -1; ddlCourse.Items.FindByValue(CourseID.ToString()).Selected = true; if (IsTrngAdmin || TrngCourseAdmin.IsAdmin(CourseID, CurrentUser.ID)) { trSlideHeader.Visible = true; GetSlides(CourseID); } else { lblMessage.Visible = true; trSlideHeader.Visible = false; lblMessage.Text = "<br> You must be a course administrator for the selected course to modify."; } } }
protected override void Fill() { ddlOrgGroup.Enabled = false; tdCourseCompletions.Visible = false; tdCourseSummary.Visible = false; FillCourses(); FillOrgGroups(); if (CourseID > 0) { ddlOrgGroup.Enabled = true; tdLookup.Visible = true; tdItem.Visible = false; ddlCourse.SelectedIndex = -1; ddlCourse.Items.FindByValue(CourseID.ToString()).Selected = true; tdCourseCompletions.Visible = true; tdCourseSummary.Visible = true; if (OrgGroupID == 0) { ddlOrgGroup.SelectedIndex = 0; GetCourseMetrics(CourseID); GetCourseSummary(CourseID); } else { ddlOrgGroup.SelectedIndex = -1; ddlOrgGroup.Items.FindByValue(OrgGroupID.ToString()).Selected = true; GetCourseMetrics(CourseID, OrgGroupID); GetCourseSummary(CourseID, OrgGroupID); } if (UserID > 0) { LookupUser(); } } }
public string[] ListCourses() { var rad = new string[] { CourseID.ToString(), HP.ToString(), Name }; return(rad); }
public void saveUsers() { //connect to db objConn.Open(); //set up and run the sql if (CourseID == 0) { objCmd = new SqlCommand("INSERT INTO Courses (StudentName, CourseName, CourseTime) VALUES ('" + StudentName + "', '" + CourseName + "', '" + CourseTime + "')", objConn); } else { objCmd = new SqlCommand("UPDATE Courses SET CompanyName = '" + StudentName + "','" + CourseName + "', '" + CourseTime + "' WHERE CourseD = " + CourseID.ToString(), objConn); } objCmd.ExecuteNonQuery(); //clean up objCmd.Dispose(); objConn.Close(); }
public override string ToString() { return(CourseID.ToString() + " " + TeeID.ToString()); }