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 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 Page_Load(object sender, EventArgs e) { #region InitializeForm Server.ScriptTimeout = 3600; //1 hr GetSystemSchoolInfo(); if (strSystemNameID == "") strSystemNameID = CPSystemSchoolInfo["SystemNameID"].ToString(); Header1.strSearchFormName = "SearchResults.aspx?SystemNameID=" + strSystemNameID + "&"; Header1.strPageTitle = "School System Management"; #endregion //Get SystemNameId and Web Service URL strSystemNameID = CPSystemSchoolInfo["SystemNameID"].ToString(); DataTable dtb = DataAccess.GetDataTable("select top 1 WebServiceURL, left(ImportScript, 20) as BoardCode from CP_SystemName where SystemNameId = " + strSystemNameID); if (dtb.Rows.Count > 0) { strWebServiceURL = dtb.Rows[0]["WebServiceURL"].ToString(); strBoardCode = dtb.Rows[0]["BoardCode"].ToString(); txtDetails.Text = strBoardCode + "\r\n" + strWebServiceURL; } if (!Page.IsPostBack) { //Load Schools list in dropdown strSQL = String.Format(@"select CPSChoolCode, CPSChoolCode + ' - ' + InstitutionName as InstitutionName from UserInfo ui INNER JOIN cp_School s ON ui.SchoolID = s.SchoolID WHERE CoursePlanner > 0 and CPSchoolCode is not null and CPSystemNameId = {0} ORDER BY SchoolType Desc, InstitutionName", strSystemNameID); DataTable dtbSchools = DataAccess.GetDataTable(strSQL); chkSchools.DataSource = dtbSchools; chkSchools.DataBind(); foreach (ListItem itm in chkSchools.Items) { itm.Selected = true; } strSQL = String.Format(@"SELECT DISTINCT School_Code, InstitutionName FROM UserInfo ui INNER JOIN careerdbImport..MWExport e ON ui.CPSchoolCode = e.School_Code WHERE CoursePlanner > 0 and CPSchoolCode is not null and CPSystemNameId = {0} ORDER BY InstitutionName", strSystemNameID); DataTable dtbSch = DataAccess.GetDataTable(strSQL); ddlSchoolCode.DataSource = dtbSch; ddlSchoolCode.DataBind(); } //Response.Write(DateTime.Now); com.maplewood.www.mwWebSrvStAc Integration = new com.maplewood.www.mwWebSrvStAc(); Integration.Url = strWebServiceURL; txtDetails.Text += "\r\n" + Integration.GetVersion(); }
protected void btnUpGetStudentChoices_Click(object sender, EventArgs e) { com.maplewood.www.mwWebSrvStAc Integration = new com.maplewood.www.mwWebSrvStAc(); Integration.Url = strWebServiceURL; Integration.Timeout = 60000000; lblResultText.Text = btnUpGetStudentChoices.Text.ToString(); //Loop thru selected Schools foreach (ListItem itm in chkSchools.Items) { if (itm.Selected) { strSQL = "DELETE FROM MWStudentChoices WHERE Board_Code = " + CP.SQLClean(strBoardCode) + " AND School_Code = " + CP.SQLClean(itm.Value.ToString()); //Response.Write(strSQL); SqlConnection oConn = new SqlConnection(strCareerdbImportLocal); oConn.Open(); SqlDataAdapter oDA = new SqlDataAdapter(strSQL, oConn); DataTable dtb = new DataTable(); oDA.Fill(dtb); oConn.Close(); com.maplewood.www.StAc_StuChoice objMW = new com.maplewood.www.StAc_StuChoice(); objMW = Integration.GetStudentChoices(itm.Value.ToString(), ""); if (objMW.HasErrors) { Response.Write("<br />" + objMW.Errors.Rows.Count.ToString()); Response.Write(objMW.Errors[0].Error_Details.ToString()); } if (objMW.Student_Choice_Details.Count > 0) { strResults.Append(objMW.Student_Choice_Details.Count.ToString() + " : " + itm.Value.ToString() + ":" + itm.Text.ToString() + "\r\n"); strResults.Append("--------------------------------------" + "\r\n"); } SqlBulkCopy oBulk = new SqlBulkCopy(strCareerdbImportLocal); oBulk.BulkCopyTimeout = 120000; oBulk.DestinationTableName = "MWStudentChoices"; oBulk.WriteToServer(objMW.Student_Choice_Details); oBulk.Close(); //-------------------------- } } txtResults.Text = strResults.ToString(); }
protected void btnUpExportToMaplewood_Click(object sender, EventArgs e) { lblResultText.Text = btnUpExportToMaplewood.Text.ToString(); txtResults.Text = ""; SqlConnection oConn = new SqlConnection(strCareerdbImportLocal); oConn.Open(); //Get parts of CC student choices based on ExportPart strSQL = String.Format(@"SELECT board_code, school_code, course_code, student_code, choice_type, choice_type_title FROM MWExport WHERE board_code = {0} AND school_code = {1} AND ExportPart = {2} order by board_code, school_code, student_code, choice_type, CourseDateAdded" , CP.SQLClean(strBoardCode), CP.SQLClean(ddlSchoolCode.SelectedValue.ToString()) , ddlExportPart.SelectedValue.ToString()); SqlDataAdapter oDA = new SqlDataAdapter(strSQL, oConn); DataTable dtb = new DataTable(); oDA.Fill(dtb); //Maplewood code to store all choices and then pass everythign together com.maplewood.www.StAc_StuChoice stuChoice = new com.maplewood.www.StAc_StuChoice(); int iCounter = 0; foreach (DataRow dr in dtb.Rows) { stuChoice.Student_Choices.AddStudent_ChoicesRow(iCounter); stuChoice.Student_Choice_Details.AddStudent_Choice_DetailsRow(dr["board_code"].ToString(), dr["school_code"].ToString(), dr["course_code"].ToString(), dr["student_code"].ToString(), dr["choice_type"].ToString(), dr["choice_type_title"].ToString(), stuChoice.Student_Choices[iCounter]); iCounter += 1; } //Call Update student choices and get errors com.maplewood.www.mwWebSrvStAc Integration = new com.maplewood.www.mwWebSrvStAc(); Integration.Url = strWebServiceURL; Integration.Timeout = 60000000; dtmTimeBefore = DateTime.Now; com.maplewood.www.StAc_StuChoiceUpdate stuResults; stuResults = Integration.UpdateStuChoices(ddlSchoolCode.SelectedValue.ToString(), "Y", "N", stuChoice); DataTable dtbErrors = stuResults.UpdateError; dtmTimeAfter = DateTime.Now; timDuration = (TimeSpan)dtmTimeAfter.Subtract(dtmTimeBefore); foreach (DataRow dr in dtbErrors.Rows) { if (dr["Message"].ToString() != "Student already has choice selected.") { strSQL = "INSERT INTO MWUploadErrors(SystemNameId, SchoolCode, StudentId, CourseCode, ErrorMessage)"; strSQL += "VALUES(" + strSystemNameID + ", '" + dr["school_code"].ToString() + "','"; strSQL += dr["student_code"].ToString() + "','" + dr["course_code"].ToString() + "',"; strSQL += CP.SQLClean(dr["Message"].ToString()) + ")"; SqlCommand oCmd = new SqlCommand(strSQL, oConn); oCmd.ExecuteNonQuery(); } } //Display Transfer Result. if (stuResults.UpdateError.Rows.Count > 0) txtResults.Text += "Success (Y/N) 1:" + stuResults.UpdateError.Rows[0][0] + " - " + stuResults.UpdateError.Rows[0][1] + "\n"; else txtResults.Text += "Success (Y/N) 2:" + stuResults.StuChoiceUpdate.Rows[0][0] + " - " + stuResults.StuChoiceUpdate.Rows[0][1] + "\n"; txtResults.Text += " - " + timDuration.Minutes.ToString() + ":" + timDuration.Seconds.ToString() + "\r\n"; oConn.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(); }
protected void btnSchool_Click(object sender, EventArgs e) { com.maplewood.www.mwWebSrvStAc Integration = new com.maplewood.www.mwWebSrvStAc(); Integration.Url = strWebServiceURL; Integration.Timeout = 360000; //Response.Write(Integration.GetVersion()); com.maplewood.www.StAc_School School = new com.maplewood.www.StAc_School(); School = Integration.GetSchools(""); foreach (DataRow drow in School.School_Details.Rows) { strResults.Append(drow["board_code"].ToString() + ", " + drow["school_code"].ToString() + ", " + drow["school_name"].ToString() + ", " + drow["street_address"].ToString() + ", " + drow["City"].ToString() + "\r\n"); } txtResults.Text = strResults.ToString(); }
protected void btnScheduledCourses_Click(object sender, EventArgs e) { com.maplewood.www.mwWebSrvStAc Integration = new com.maplewood.www.mwWebSrvStAc(); Integration.Url = strWebServiceURL; Integration.Timeout = 60000000; lblResultText.Text = btnCourses.Text.ToString(); foreach (ListItem itm in chkSchools.Items) { if (itm.Selected) { //Student Courses in Progress //-------------------------- dtmTimeBefore = DateTime.Now; com.maplewood.www.StAc_Course objMWCourses = new com.maplewood.www.StAc_Course(); objMWCourses = Integration.GetCoursesSched(itm.Value.ToString()); dtmTimeAfter = DateTime.Now; timDuration = (TimeSpan)dtmTimeAfter.Subtract(dtmTimeBefore); dtmTimeBefore = DateTime.Now; if (objMWCourses.Course_Details.Count > 0) { strResults.Append(timDuration.Minutes.ToString() + ":" + timDuration.Seconds.ToString() + " - " + objMWCourses.Course_Details.Count.ToString() + " : " + itm.Value.ToString() + ":" + itm.Text.ToString() + " - "); } SqlBulkCopy oBulkInProgress = new SqlBulkCopy(strCareerdbImportLocal); oBulkInProgress.DestinationTableName = "MWCourses"; oBulkInProgress.WriteToServer(objMWCourses.Course_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(); }