protected void btnStudentOnTranscript_Click(object sender, EventArgs e) { com.maplewood.www.StAc_StuOnTrans objMW = new com.maplewood.www.StAc_StuOnTrans(); objMW = Integration.GetStudentOnTranscript("689351", ""); grdStudentOnTranscript.DataSource = objMW.Student_OnTranscript_Details; grdStudentOnTranscript.DataBind(); SqlBulkCopy oBulk = new SqlBulkCopy(strCareerdbImportLocal); oBulk.DestinationTableName = "MWStudentOnTranscript"; oBulk.WriteToServer(objMW.Student_OnTranscript_Details); oBulk.Close(); }
protected void btnDownloadOnTranscript_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(); 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 Course History //-------------------------- com.maplewood.www.StAc_StuOnTrans objMWHistory = new com.maplewood.www.StAc_StuOnTrans(); objMWHistory = Integration.GetStudentOnTranscript(dr["cpSchoolCode"].ToString(), ""); Response.Write("History Courses: " + objMWHistory.Student_OnTranscript_Details.Count.ToString() + "<br/>"); SqlBulkCopy oBulkHistory = new SqlBulkCopy(strCareerdbImportLocal); oBulkHistory.BulkCopyTimeout = 120000; oBulkHistory.DestinationTableName = "MWStudentOnTranscript"; oBulkHistory.WriteToServer(objMWHistory.Student_OnTranscript_Details); oBulkHistory.Close(); //-------------------------- } }
protected void btnStudentTranscript_Click(object sender, EventArgs e) { com.maplewood.www.mwWebSrvStAc Integration = new com.maplewood.www.mwWebSrvStAc(); Integration.Url = strWebServiceURL; Integration.Timeout = 60000000; lblResultText.Text = btnStudentTranscript.Text.ToString(); //Loop thru selected Schools foreach (ListItem itm in chkSchools.Items) { if (itm.Selected) { dtmTimeBefore = DateTime.Now; com.maplewood.www.StAc_StuOnTrans objMWTranscript = new com.maplewood.www.StAc_StuOnTrans(); objMWTranscript = Integration.GetStudentOnTranscript(itm.Value.ToString(), ""); dtmTimeAfter = DateTime.Now; timDuration = (TimeSpan)dtmTimeAfter.Subtract(dtmTimeBefore); dtmTimeBefore = DateTime.Now; if (objMWTranscript.Student_OnTranscript_Details.Count > 0) { strResults.Append(timDuration.Minutes.ToString() + ":" + timDuration.Seconds.ToString() + " - " + objMWTranscript.Student_OnTranscript_Details.Count.ToString() + " : " + itm.Value.ToString() + ":" + itm.Text.ToString() + " - "); } SqlBulkCopy oBulkHistory = new SqlBulkCopy(strCareerdbImportLocal); oBulkHistory.BulkCopyTimeout = 120000; oBulkHistory.DestinationTableName = "MWStudentOnTranscript"; oBulkHistory.WriteToServer(objMWTranscript.Student_OnTranscript_Details); oBulkHistory.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(); }