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)
{
}
}
