protected void btnDownloadClasses_Click(object sender, EventArgs e)
{
com.maplewood.www.mwWebSrvStAc Integration = new com.maplewood.www.mwWebSrvStAc();
Integration.Url = GetWebServiceURL();
Integration.Timeout = 360000;
//Loop thru Sudbury Schools
string strSQL = "SELECT cpSchoolCode, SchoolId, InstitutionName FROM UserInfo WHERE cpSystemNameId = " + GetSystemNameId() + " order by institutionType, schoolid";
DataTable dtb = DataAccess.GetDataTable(strSQL);
foreach (DataRow dr in dtb.Rows)
{
Response.Write("--------------------------------------<br/>");
Response.Write(dr["cpSchoolCode"].ToString() + ":" + dr["InstitutionName"].ToString() + "<br/>");
Response.Write("--------------------------------------<br/>");
//Student Courses in Progress
//--------------------------
com.maplewood.www.StAc_StuClass objMWProgress = new com.maplewood.www.StAc_StuClass();
objMWProgress = Integration.GetStudentClasses(dr["cpSchoolCode"].ToString(), "");
Response.Write("In Progress Courses: " + objMWProgress.Student_Class_Details.Count.ToString() + "<br/>");
SqlBulkCopy oBulkInProgress = new SqlBulkCopy(strCareerdbImportLocal);
oBulkInProgress.DestinationTableName = "MWStudentClasses";
oBulkInProgress.WriteToServer(objMWProgress.Student_Class_Details);
oBulkInProgress.Close();
//--------------------------
}
}
protected void btnStudentClasses_Click(object sender, EventArgs e)
{
com.maplewood.www.StAc_StuClass objMW = new com.maplewood.www.StAc_StuClass();
objMW = Integration.GetStudentClasses("689351", "");
grdStudentClasses.DataSource = objMW.Student_Class_Details;
grdStudentClasses.DataBind();
//SqlBulkCopy oBulk = new SqlBulkCopy("Data Source=192.168.11.16,1433;Network Library=DBMSSOCN;Initial Catalog=careerdbImport;User ID=ccwebadmin;Password=crm5au1g");
//oBulk.DestinationTableName = "MWStudentClasses";
//oBulk.WriteToServer(objMW.Student_Class_Details);
//oBulk.Close();
}
protected void btnStudentClasses_Click(object sender, EventArgs e)
{
com.maplewood.www.mwWebSrvStAc Integration = new com.maplewood.www.mwWebSrvStAc();
Integration.Url = strWebServiceURL;
Integration.Timeout = 60000000;
lblResultText.Text = btnStudentClasses.Text.ToString();
//Loop thru selected Schools
foreach (ListItem itm in chkSchools.Items)
{
if (itm.Selected)
{
//Student Courses in Progress
//--------------------------
dtmTimeBefore = DateTime.Now;
com.maplewood.www.StAc_StuClass objMWClasses = new com.maplewood.www.StAc_StuClass();
objMWClasses = Integration.GetStudentClasses(itm.Value.ToString(), "");
dtmTimeAfter = DateTime.Now;
timDuration = (TimeSpan)dtmTimeAfter.Subtract(dtmTimeBefore);
dtmTimeBefore = DateTime.Now;
if (objMWClasses.Student_Class_Details.Count > 0)
{
strResults.Append(timDuration.Minutes.ToString() + ":" + timDuration.Seconds.ToString() + " - " +
objMWClasses.Student_Class_Details.Count.ToString() + " : " + itm.Value.ToString() + ":" + itm.Text.ToString() + " - ");
}
SqlBulkCopy oBulkInProgress = new SqlBulkCopy(strCareerdbImportLocal);
oBulkInProgress.DestinationTableName = "MWStudentClasses";
oBulkInProgress.WriteToServer(objMWClasses.Student_Class_Details);
oBulkInProgress.Close();
dtmTimeAfter = DateTime.Now;
timDuration = (TimeSpan)dtmTimeAfter.Subtract(dtmTimeBefore);
strResults.Append(" - " + timDuration.Minutes.ToString() + ":" + timDuration.Seconds.ToString() + "\r\n");
strResults.Append("--------------------------------------\r\n");
//--------------------------
}
}
txtResults.Text = strResults.ToString();
}
