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