protected void ButtonRefresh_Click(object sender, EventArgs e) { try { Student stu = new Student(); int strID = stu.GetStudentOIDByStudentBannerID(lblID.Text.ToString()); //string strID = null; //strID = ViewState["STDOID"].ToString(); populateDropdownList(); string strOID = stu.GetStudentIDByStudentBannerOID(Convert.ToInt32(strID)); Populate(strOID); PopulateSection(ddlAssesment.Text.ToString(), lblID.Text); PopulateSectionNoScore(ddlAssesment.Text.ToString(), lblID.Text); PopulateCourseByStudentID(); PopulateGridIntervention(Convert.ToInt32(ViewState["ROID"])); } catch (Exception ex) { } }
private int Prev() { int i = 0; Student stu = new Student(); //if (lblDate.Text != "") //{ // i = stu.GetPrevStudentOID(Convert.ToDateTime(lblDate.Text.ToString())); //} i = stu.GetStudentOIDByStudentBannerID(lbtnID.Text.ToString()); if (i > 1) { i = i - 1; string strID = stu.GetStudentIDByStudentBannerOID(i); if (strID == "" || strID == null) { i--; for (int j = i; j > 0; j--) { strID = stu.GetStudentIDByStudentBannerOID(j); if (strID != "" && strID != null) { i = j; return i; } } } } else { i = 1; } return i; }
private int Next() { int i = 1; string strID=null ; Student stu = new Student(); //if (lblDate.Text != "") //{ // i = stu.GetNextStudentOID(Convert.ToDateTime(lblDate.Text.ToString())); //} i = stu.GetStudentOIDByStudentBannerID(lbtnID.Text.ToString()); i++; strID = stu.GetStudentIDByStudentBannerOID(i); if (strID == "" || strID == null) { i++; for (int j = i; j < 25000000; j++) { strID = stu.GetStudentIDByStudentBannerOID(j); if (strID != "" && strID != null) { i = j; return i; } } } return i; }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { GenerateCalendar(); GenerateTaskOnCalendar(); Student stu = new Student(); //string strOID = stu.GetFirstStudentID(); int firstRowID = 1; string strOID = stu.GetStudentByRowID(firstRowID); ViewState["RowID"] = firstRowID; int StdOID = stu.GetStudentOIDByStudentBannerID(strOID); //dtStudents = ViewState["StuID"] = StdOID; string fassName = ""; Sections sec = new Sections(); Populate(Convert.ToString(strOID)); populateDropdownList(); fassName = sec.GetFirstAssessmentName(); //PopulateSection(ddlAssesment.Text, Convert.ToInt32(StdOID)); PopulateSection(ddlAssesment.Text, strOID); PopulateSectionNoScore(ddlAssesment.Text, strOID); Initialization(); populateChart(); } }
protected void ddlAssesment_SelectedIndexChanged(object sender, EventArgs e) { try { Student stu = new Student(); //int stdOID = stu.GetStudentOIDByStudentBannerID(lbtnID.Text.ToString()); int stuOID = stu.GetStudentOIDByStudentBannerID(lbtnID.Text.ToString()); string strSectionName = null; strSectionName = ddlAssesment.SelectedItem.ToString(); PopulateSection(strSectionName, lbtnID.Text.ToString()); PopulateSectionNoScore(ddlAssesment.Text.ToString(), lbtnID.Text.ToString()); } catch (Exception ex) { } }
private void PrintIntervention(int POID, int RiskOID, string BannerID,int AOID) { try { Interventions intervention = new Interventions(); intervention = intervention.GetInterventionByOID(POID); if (intervention != null) { Student stdnt = new Student(); int StdOID = stdnt.GetStudentOIDByStudentBannerID(Request.QueryString["soid"]); stdnt = stdnt.GetStudentByOID(StdOID); if (stdnt != null) { string html = ""; Assessment ass = new Assessment(); //Create Html html += "<table width='100%' ><tr><td><img alt='Logo' src='../../images/chippewavtc_logo.jpg' /></td><td style='text-align:center;'><span style='font-size:medium;font-weight:bold;'> Steps to Success: CVTC's commitment to helping YOU succeed!</span><br/><span style='text-align:center;'> Inventory of Student Success: Personalized Success Plan </span></td></tr></table>"; html += "<table width='100%'><tr><td style='width:45%;'>Success Steps For:<br /><b>First Name :</b>" + stdnt.FirstName + " <b>Last Name :</b> " + stdnt.LastName + "</td><td> <div style='background-color: #C0C0C0;float:left;width:20%;'>Program </div><div style='padding-left:10px;border:solid 1px black;width:75%; float:left;'>" + stdnt.MajorProgramEnrollment + "</div></td></tr></table>"; //ass.GetAssessmentByAssessmentOID(AOID); //if (ass != null) //{ //html += "<table width='100%'><tr><td style='width:45%;'><b>Assessment Name : </b><b>" + ass.AssessmentName + "</b></td><td> </td></tr></table>"; //} html += "<table width='100%'><tr><td style='border:solid 1px black;'>Inventory of Student Success results provide comparsions of your attitudes and confidence with other<br /> entering CVTC students in key focus areas that could affect your academic performance and program<br /> persistance: </td></tr></table>"; //Collection<Interventions> interventions = intervention.GetInterventionByStudentOID(intervention.StudentOID); Collection<Interventions> interventions = new Collection<Interventions>(); interventions = intervention.GetInterventionByAssOID(StdOID, RiskOID,AOID); foreach (Interventions inter in interventions) { //Start html += "<table style='width: 100%;'>"; //Get Sectionwise Student Rank StudentRank studentRank = new StudentRank(); // Collection<StudentRank> _list = studentRank.GetStudentRankByOID(stdnt.StudentOID); int AssessmentOID = 0; //Assessment ass = new Assessment(); // AssessmentOID = ass.GetAssessmentOIDByAssessmentName(ddlAssessment.SelectedItem.Text); // Collection<Assessment> assList = new Collection<Assessment>(); //assList = ass.GetAssessmentBySOID(BannerID); ass.GetAssessmentByAssessmentOID(AOID); if (ass != null) { //foreach (Assessment assessment in assList) //{ Collection<StudentRank> _list = studentRank.GetStudentRankBySOIDandAOID(StdOID, ass.AssessmentOID); //if //for (int i = 0; i < 5; i++) foreach (StudentRank stRank in _list) { html += "<tr>"; html += "<td style='border:solid 1px black;background-color:#727272;width:200px;'>" + stRank.SectionName + "</td>"; html += "<td style='border:solid 1px black;width:50px;text-align:center;'>" + stRank.Rank.ToString() + "</td>"; html += "<td style='border:solid 1px black;'>" + stRank.Comment + "</td>"; html += "</tr>"; //break; } break; //} } html += "</table>"; //End } html += "<table style='width: 100%; border:solid 1px black;'> <tr > <td>COMPASS test scores measure your academic readiness for college coursework in four broad areas:</td> </tr> </table>"; html += " <table style='width: 60%; '> <tr><td style='background-color:#727272;width:200px;'>COMPASS Pre-Algebra</td><td style='width:100px; border:solid 1px black;'>" + stdnt.PrealgebraTestScore + "</td><td style='background-color:#727272;width:200px;'>COMPASS Writing</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassWrittingTestScore + "</td></tr> <tr><td style='background-color:#727272;width:200px;'>COMPASS Algebra</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassalgebraTestScore + "</td><td style='background-color:#727272;width:200px;'>COMPASS Reading</td><td style='width:100px; border:solid 1px black;'>" + stdnt.CompassReadingTestScore + "</td></tr> </table>"; html += "<br/>"; int counter = 0; //Collection<Interventions> interventionsList = intervention.GetInterventionByStudentOID(StdOID,RiskOID); foreach (Interventions inter in interventions) { counter++; #region Printing Checkboxes html += "<table style='width: 100%; '>"; html += "<tr><td style='width:60px;font-size:medium;font-weight:bold;'></td><td style='background-color:#727272;width:100px;'> Assessment Name : </td><td>" + inter .AssessmentName + "</td><td></td></tr>"; html += "<tr><td style='width:60px;font-size:medium;font-weight:bold;'>Step " + counter.ToString() + "</td><td style='background-color:#727272;width:100px;'> Plan Target</td><td>" + inter.DomainName + "</td><td></td></tr>"; html += "<tr><td > </td><td style='background-color:#727272;width:100px;'> Intervention</td><td>" + inter.InterventionName + "</td><td></td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:150px;'>CVTC Advocate </td><td>" + inter.UserName + "</td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Action Date </td><td>" + inter.LatestActionDate; html += " Prescribed "; if (inter.Prescribed == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Participating "; if (inter.Participating == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Internal "; if (inter.Internal == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Urgent "; if (inter.Urgent == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Completed "; if (inter.Completed == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += "</td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Contact Date </td><td>" + inter.LatestContact; html += " Email "; if (inter.Email == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Telephone "; if (inter.Telephone == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " In Person "; if (inter.InPerson == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Hand-Off "; if (inter.HandOff == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } html += " Testing "; if (inter.Testing == 1) { html += "<img alt='' src='../../images/tic-pic.png' />"; } else { html += "<img alt='' src='../../images/nonetic-pic.png' />"; } #endregion html += "</td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:150px;'>Comments : </td><td>" + inter.Comment + "</td></tr>"; html += "</table>"; html += "<br /><br />"; //End }//foreach //html += "<script type =\"text/javascript\">"; //html += "printDiv();"; //html += "</script>"; Response.Write(html.ToString()); //print_div1.InnerHtml = html; }//std } } catch (Exception ex) { } }
private int Prev() { int i = 0; Student stu = new Student(); i = stu.GetStudentOIDByStudentBannerID(lblID.Text.ToString()); if (i > 1) { i = i - 1; string strID = stu.GetStudentIDByStudentBannerOID(i); if (strID == "" || strID == null) { i--; for (int j = i; j > 0; j--) { strID = stu.GetStudentIDByStudentBannerOID(j); if (strID != "" && strID != null) { i = j; return i; } } } } else { i = 1; } return i; }
private void PopulateGridIntervention(int RISKOID) { int UserOID = 0; User user = new User(); user = Session["CurrentUser"] as User; if (user != null) { UserOID = user.UserOID; } Interventions inv = null;// new Interventions(); Student stu = new Student(); Collection<Interventions> IntListStd = new Collection<Interventions>(); Collection<Interventions> IntListRisk = new Collection<Interventions>(); int i = stu.GetStudentOIDByStudentBannerID(lblID.Text.ToString()); if (i > 0) { inv = new Interventions(); IntListStd = inv.GetInterventionByStudentOID(i, "1", "10", UserOID); //GridViewIntervention.DataSource = inv.GetInterventionByStudentOID(i, "1", "10"); } if (RISKOID > 0) { inv = new Interventions(); inv = inv.GetInterventionByRiskOID(RISKOID, lblID.Text.ToString(), "1", "10", UserOID); if (inv != null) { IntListStd.Add(inv); } } GridViewIntervention.DataSource = IntListStd; GridViewIntervention.DataBind(); }
private int Next() { int i = 0; string strID = "1"; Student stu = new Student(); i = stu.GetStudentOIDByStudentBannerID(lblID.Text.ToString()); i++; strID = stu.GetStudentIDByStudentBannerOID(i); if (strID == "" || strID == null) { i++; for (int j = i; j < 25000000; j++) { strID = stu.GetStudentIDByStudentBannerOID(j); if (strID != "" && strID != null) { i = j; return i; } } } return i; }
//protected void ddlAssesment_SelectedIndexChanged1(object sender, EventArgs e) //{ //} //protected void ddlAssesment_SelectedIndexChanged2(object sender, EventArgs e) //{ //} protected void lbtnPrev_Click(object sender, EventArgs e) { Session["StudentID"] = lblID.Text.ToString(); lbtnNext.Enabled = true; Student stu = new Student(); //int OID = Prev(); int OID = 0; rowID = Convert.ToInt32(ViewState["RowID"]); rowID--; ViewState["RowID"] = rowID; string strID = stu.GetStudentByRowID_Profile(rowID); OID = stu.GetStudentOIDByRowID_Profile(rowID); //string strID = stu.GetStudentIDByStudentBannerOID(OID); if (strID == "" || strID == null) { lbtnPrev.Enabled = false; } else { Populate(strID); populateDropdownList(); PopulateCourseByStudentID(); //PopulateGridIntervention(); PopulateSectionNoScore(ddlAssesment.Text.ToString(), strID); PopulateSection(ddlAssesment.Text.ToString(), strID); int AOID = new Sections().GetAssessmentOIDByAssessmentName(ddlAssesment.Text.ToString()); Student stu1 = new Student(); int studentOID = stu1.GetStudentOIDByStudentBannerID(strID); if (!string.IsNullOrEmpty(studentOID.ToString())) { this.BindRiskCalculation(AOID, Convert.ToInt32(studentOID)); } if (LabelRisk.Text != "") { PopulateGridIntervention(Convert.ToInt32(ViewState["ROID"])); } else { PopulateGridIntervention(0); } } }
protected void ButtonSubmit_Click(object sender, EventArgs e) { try { if ((string.IsNullOrEmpty(TextBoxLatestAction.Value)) || (string.IsNullOrEmpty(TextBoxLatestContact.Value))) { LabelStatus.Text = "Please Enter Action and Contact Date"; return; } Interventions interventions = new Interventions(); //Changed by Babul 20111103 //int strInterventionOID = interventions.GetInterventionOIDByInterventionName(DropDownListIntervention.SelectedItem.ToString()); int strInterventionOID = 0; if (DropDownListIntervention.SelectedIndex == -1) { strInterventionOID = 1; } else { strInterventionOID = interventions.GetInterventionOIDByInterventionName(DropDownListIntervention.SelectedItem.ToString()); } // interventions.InterventionOID = strInterventionOID; Domain domain=new Domain (); int DomainIOD = domain.GetDomainOIDByDomainName(DropDownListDomain.SelectedItem.ToString()); interventions.DomainOID = DomainIOD; User user = new User(); int UserIOD = user.GetUserOIDByUserName(DropDownListAdvocate.SelectedItem.ToString()); interventions.UserOID = UserIOD; if (ViewState["POID"] == null) { studentid = Session["StudentID"].ToString(); Student student = new Student(); int StudentOID = student.GetStudentOIDByStudentBannerID(studentid); interventions.StudentOID = StudentOID; ViewState["studentID"]=studentid; } else { interventions.StudentOID = Convert.ToInt32(ViewState["studentID"]); } //interventions.LatestActionDate = TextBoxLatestAction.Text.ToString(); //interventions.LatestContact = TextBoxLatestContact.Text.ToString(); interventions.LatestActionDate = TextBoxLatestAction.Value.ToString(); interventions.LatestContact = TextBoxLatestContact.Value.ToString(); interventions.CreatedBy = (Session["CurrentUser"] != null) ? ((User)Session["CurrentUser"]).UserOID : 0; if (CheckBoxListLeft.Items[0].Selected) { interventions.Urgent = 1; } else { interventions.Urgent = 0; } if (CheckBoxListLeft.Items[1].Selected) { interventions.Internal = 1; } else { interventions.Internal = 0; } if (CheckBoxListLeft.Items[2].Selected) { interventions.Prescribed = 1; } else { interventions.Prescribed = 0; } if (CheckBoxListLeft.Items[3].Selected) { interventions.Participating = 1; } else { interventions.Participating = 0; } if (CheckBoxListLeft.Items[4].Selected) { interventions.Completed = 1; } else { interventions.Completed = 0; } if (CheckBoxListRight.Items[0].Selected) { interventions.Email = 1; } else { interventions.Email = 0; } if (CheckBoxListRight.Items[1].Selected) { interventions.Telephone = 1; } else { interventions.Telephone = 0; } if (CheckBoxListRight.Items[2].Selected) { interventions.InPerson = 1; } else { interventions.InPerson = 0; } if (CheckBoxListRight.Items[3].Selected) { interventions.HandOff = 1; } else { interventions.HandOff = 0; } if (CheckBoxTesting.Checked == true) { interventions.Testing = 1; } else { interventions.Testing = 0; } interventions.Comment = TextBoxContactNotes.Text.Trim(); interventions.RiskOID = 0; Assessment assment=new Assessment (); interventions.AssessmentOID = assment.GetAssessmentOIDByAssessmentName(ddlAssessment.SelectedItem.Text); if (ViewState["POID"] == null) { if (interventions.AddInterventions() > 0) { LabelStatus.Text = "Saved Successfully."; } else { LabelStatus.Text = "Save Failed."; } ViewState["POID"] = interventions.PrescriptionOID; } else { interventions.PrescriptionOID=Convert.ToInt32(ViewState["POID"].ToString()); if (interventions.UpdateInterventions()) { LabelStatus.Text = "Update Successfully."; } else { LabelStatus.Text = "Update Failed."; } } //Sending Email For Hand Off try { if (interventions.HandOff == 1) { string toEmail = null; if (ConfigurationManager.AppSettings["productionMode"].ToString() == "OFF") { toEmail = ConfigurationManager.AppSettings["toEmail"].ToString(); } else { //Get Student Email Address By ID studentid = Session["StudentID"].ToString(); Student stu = new Student(); stu = stu.GetStudentByStudentOID(studentid); if (stu != null) { if (stu.EmailAddress != null) { toEmail = stu.EmailAddress; } } //toEmail = ConfigurationManager.AppSettings["toEmail"].ToString(); } #region Handoff Body string html = null ; html += "<table style='width: 100%; '>"; html += "<tr><td colspan='4'> <h3>Handoff Details of " + DropDownListIntervention.SelectedItem.ToString() + " Intervention</h3></td></tr>"; html += "<tr><td > </td><td style='background-color:#727272;width:100px;'> Assessment</td><td>" + ddlAssessment.Text + "</td><td></td></tr>"; html += "<tr><td > </td><td style='background-color:#727272;width:100px;'> Domain</td><td>" + DropDownListDomain.SelectedItem.ToString() + "</td><td></td></tr>"; html += "<tr><td > </td><td style='background-color:#727272;width:100px;'> Intervention</td><td>" + DropDownListIntervention.SelectedItem.ToString() + "</td><td></td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:150px;'>User Name </td><td>" + DropDownListAdvocate.SelectedItem.ToString() + "</td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Action Date </td><td>" + TextBoxLatestAction.Value.ToString(); html += " Prescribed "; if (interventions.Prescribed == 1) { html += "<img alt='yes' src='../../images/tic-pic.png' />"; } else { html += "<img alt='no' src='../../images/nonetic-pic.png' />"; } html += " Participating "; if (interventions.Participating == 1) { html += "<img alt='yes' src='../../images/tic-pic.png' />"; } else { html += "<img alt='no' src='../../images/nonetic-pic.png' />"; } html += " Internal "; if (interventions.Internal == 1) { html += "<img alt='yes' src='../../images/tic-pic.png' />"; } else { html += "<img alt='no' src='../../images/nonetic-pic.png' />"; } html += " Urgent "; if (interventions.Urgent == 1) { html += "<img alt='yes' src='../../images/tic-pic.png' />"; } else { html += "<img alt='no' src='../../images/nonetic-pic.png' />"; } html += " Completed "; if (interventions.Completed == 1) { html += "<img alt='yes' src='../../images/tic-pic.png' />"; } else { html += "<img alt='no' src='../../images/nonetic-pic.png' />"; } html += "</td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Contact Date </td><td>" + TextBoxLatestContact.Value.ToString(); html += " Email "; if (interventions.Email == 1) { html += "<img alt='yes' src='../../images/tic-pic.png' />"; } else { html += "<img alt='no' src='../../images/nonetic-pic.png' />"; } html += " Telephone "; if (interventions.Telephone == 1) { html += "<img alt='yes' src='../../images/tic-pic.png' />"; } else { html += "<img alt='no' src='../../images/nonetic-pic.png' />"; } html += " In Person "; if (interventions.InPerson == 1) { html += "<img alt='yes' src='../../images/tic-pic.png' />"; } else { html += "<img alt='no' src='../../images/nonetic-pic.png' />"; } html += " Hand-Off "; if (interventions.HandOff == 1) { html += "<img alt='yes' src='../../images/tic-pic.png' />"; } else { html += "<img alt='no' src='../../images/nonetic-pic.png' />"; } html += " Testing "; if (interventions.Testing == 1) { html += "<img alt='yes' src='../../images/tic-pic.png' />"; } else { html += "<img alt='no' src='../../images/nonetic-pic.png' />"; } html += "</td></tr>"; html += "<tr><td > </td><td > </td><td style='background-color:#727272; width:100px;'>Comments: </td><td>" + TextBoxContactNotes.Text; html += "</table>"; #endregion if (SendMail(toEmail, "You have got a Handoff", html)) { LabelStatus.Text = "Eamil Sent .. Successfully"; } else { LabelStatus.Text = "Eamil Not Sent .. Please contact with admin "; } } } catch (Exception ae) { LabelStatus.Text = "Eamil Not Sent .. Please contact with admin "; } //End Sending Mail For Hand Off } catch (Exception ex) { } }