private System.Web.UI.WebControls.Table Create_Rec_Table(MirrorCLS myMirror)
{
System.Web.UI.WebControls.Table MyTable = new System.Web.UI.WebControls.Table();
try
{
myList.Add(myMirror);
//First Row
MyTable.Width = Unit.Percentage(100);
MyTable.BorderWidth = 1;
MyTable.GridLines = GridLines.Horizontal;
TableRow tr = new TableRow();
TableCell td = new TableCell();
//Fifth
tr.CssClass = "th";
td.ColumnSpan = 4;
td.Text = "Student Mirror";
tr.Cells.Add(td);
MyTable.Rows.Add(tr);
tr = new TableRow();
td = new TableCell();
td.ColumnSpan = 4;
string sPath = "";
string sTable = "<table align='left' border='1' >";
sTable += "<tr>";
int iMax = 0;
string sDegree = myMirror.SDegree;
string sMajor = myMirror.SMajor;
//Get the count of general courses
iMax = LibraryMOD.GetMajorGeneralIndex(sDegree, sMajor);
for (int i = 0; i < iMax; i++)
{
sPath = "Images/Majors/GIF/" + myMirror.Mirror[i].sCourse + ".gif";
sTable += "<td><img alt='' src='" + sPath + "' /></td>";
}
sTable += "</tr>";
sTable += "<tr>";
for (int i = 0; i < iMax; i++)
{
if (myMirror.Mirror[i].isRecommended)
{
sTable += "<td style='font-family: Arial, Helvetica, sans-serif; font-size: small; color: #000000; text-align: center; vertical-align: top; background-color: #F2B702'>" + myMirror.Mirror[i].sGrade + "</td>";
}
else
{
sTable += "<td style='font-family: Arial, Helvetica, sans-serif; font-size: small; color: #000000; text-align: center; vertical-align: top'>" + myMirror.Mirror[i].sGrade + "</td>";
}
}
sTable += "</tr>";
sTable += "</table>";
Literal Lt = new Literal();
Lt.Text = sTable;
td.Controls.Add(Lt);
tr.Cells.Add(td);
MyTable.Rows.Add(tr);
tr = new TableRow();
td = new TableCell();
td.ColumnSpan = 4;
int iCourses = 0;
iCourses = myMirror.Mirror.Length;
sPath = "";
sTable = "<table align='left' border='1' >";
sTable += "<tr>";
for (int i = iMax; i < iCourses; i++)
{
sPath = "Images/Majors/GIF/" + myMirror.Mirror[i].sCourse + ".gif";
sTable += "<td><img alt='' src='" + sPath + "' /></td>";
}
sTable += "</tr>";
sTable += "<tr>";
for (int i = iMax; i < iCourses; i++)
{
if (myMirror.Mirror[i].isRecommended)
{
sTable += "<td style='font-family: Arial, Helvetica, sans-serif; font-size: small; color: #000000; text-align: center; vertical-align: top; background-color: #F2B702'>" + myMirror.Mirror[i].sGrade + "</td>";
}
else
{
sTable += "<td style='font-family: Arial, Helvetica, sans-serif; font-size: small; color: #000000; text-align: center; vertical-align: top'>" + myMirror.Mirror[i].sGrade + "</td>";
}
}
sTable += "</tr>";
sTable += "</table>";
Lt = new Literal();
Lt.Text = sTable;
td.Controls.Add(Lt);
tr.Cells.Add(td);
MyTable.Rows.Add(tr);
//Majoe Electives & Free Electives
MirrorDAL myMirrorDAL = new MirrorDAL();
tr = new TableRow();
td = new TableCell();
td.ColumnSpan = 4;
string MElective = myMirrorDAL.GetMajorElectiveCourses(myMirror.StudentNumber, Campus);
string FElective = myMirrorDAL.GetFreeElectiveCourses(myMirror.StudentNumber, Campus);
if (MElective.Length > 0 || FElective.Length > 0)
{
tr = new TableRow();
td = new TableCell();
td.ColumnSpan = 4;
}
td.Text = "";
if (MElective.Length > 0)
{
td.Text += "Major Electives: " + "[ " + MElective + " ]";
}
if (FElective.Length > 0)
{
if (MElective.Length > 0)
{
td.Text += " --- ";
}
td.Text += "Free Electives [" + FElective + " ]";
}
if (MElective.Length > 0 || FElective.Length > 0)
{
tr.Cells.Add(td);
MyTable.Rows.Add(tr);
}
//Recommended
tr = new TableRow();
td = new TableCell();
tr.CssClass = "th";
td.ColumnSpan = 4;
td.Text = "Recommended Courses";
tr.Cells.Add(td);
MyTable.Rows.Add(tr);
int iCompletedHours = LibraryMOD.GetCompletedHours(sNo, Campus);
//Tr=new TableRow();
for (int i = 0; i < myMirror.Recommended.Count; i++)
{
if ((iCompletedHours < 99 && myMirror.Recommended[i].sCourse.Contains("415") && myMirror.Recommended[i].sCourse != "RTV415") || (iCompletedHours < 99 && myMirror.Recommended[i].sCourse.Contains("419")))
{
//dont add Internship & graduation project in completed hours less than 99 credit hours
}
else
{
tr = new TableRow();
if (myMirror.Recommended[i].isOver)
{
tr.CssClass = "R_Critical";
}
else
{
if (i % 2 == 0)
{
tr.CssClass = "R_NormalWhite";
}
else
{
tr.CssClass = "R_NormalGray";
}
}
td = new TableCell();
td.Text = (i + 1).ToString();
td.HorizontalAlign = HorizontalAlign.Center;
tr.Cells.Add(td);
td = new TableCell();
td.Text = myMirror.Recommended[i].sCourse;
td.HorizontalAlign = HorizontalAlign.Center;
tr.Cells.Add(td);
td = new TableCell();
td.ColumnSpan = 2;
td.Text = myMirror.Recommended[i].sDesc;
td.HorizontalAlign = HorizontalAlign.Left;
tr.Cells.Add(td);
MyTable.Rows.Add(tr);
}
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(MyTable);
}
private void Export()
{
ReportDocument myReport = new ReportDocument();
List <Programs_Advisors> myAdvisors = new List <Programs_Advisors>();
Programs_AdvisorsDAL myAdvisorsDAL = new Programs_AdvisorsDAL();
RecommendationDAL myRecommendationDAL = new RecommendationDAL();
try
{
MirrorCLS myMirror = new MirrorCLS();
MirrorDAL myMirrorDAL = new MirrorDAL();
myMirror = myList[0];
DataSet rptDS = new DataSet();
rptDS = myRecommendationDAL.Prepare_RecommendationReport(myMirror);
string reportPath = Server.MapPath("Reports/Recommended_Report3.rpt");
myReport.Load(reportPath);
myReport.SetDataSource(rptDS);
TextObject txt;
int iCount = myMirror.Mirror.Length;
if (iCount > 60)
{
iCount = 60;
}
for (int i = 0; i < 60; i++)
{
txt = (TextObject)myReport.ReportDefinition.ReportObjects["h" + (i + 1).ToString()];
txt.Text = "";
txt.Color = Color.White;
txt.Color = Color.White;
txt.Border.BorderColor = Color.White;
txt.Border.BackgroundColor = Color.White;
txt = (TextObject)myReport.ReportDefinition.ReportObjects["g" + (i + 1).ToString()];
txt.Text = "";
txt.Color = Color.White;
txt.Border.BorderColor = Color.White;
txt.Border.BackgroundColor = Color.White;
}
for (int i = 0; i < iCount; i++)
{
txt = (TextObject)myReport.ReportDefinition.ReportObjects["h" + (i + 1).ToString()];
txt.Text = myMirror.Mirror[i].sCourse;
switch (myMirror.Mirror[i].iClass)
{
case 9: //MEelect
txt.Text = myMirror.Mirror[i].sCourse + "*";
break;
case 11: //CEelect
txt.Text = myMirror.Mirror[i].sCourse + "#";
break;
}
txt.Color = Color.Black;
txt.Border.BorderColor = Color.Black;
txt.Border.BackgroundColor = Color.Silver;
txt = (TextObject)myReport.ReportDefinition.ReportObjects["g" + (i + 1).ToString()];
txt.Text = myMirror.Mirror[i].sGrade;
txt.Color = Color.Black;
txt.Border.BorderColor = Color.Black;
txt.Border.BackgroundColor = Color.White;
}
txt = (TextObject)myReport.ReportDefinition.ReportObjects["Major_txt"];
txt.Text = myMirror.Major;
//Previous Semester
Campus = (InitializeModule.EnumCampus)Session["CurrentCampus"];
txt = (TextObject)myReport.ReportDefinition.ReportObjects["txtregisteredCourseInPrevSem"];
if (iRegSem == 4)
{
int iRegCoursesPrevSem = 0;
iRegCoursesPrevSem = LibraryMOD.GetRegCoursesPrevSem(myMirror.StudentNumber, iRegYear, iRegSem, Campus);
txt.Text = "Previous Semester Courses : " + iRegCoursesPrevSem.ToString();
}
else
{
txt.Text = "";
txt.Width = 0;
}
txt = (TextObject)myReport.ReportDefinition.ReportObjects["cgpa_txt"];
if (myMirror.CGPA != 101)
{
txt.Text = string.Format("{0:f}", myMirror.CGPA);
}
txt = (TextObject)myReport.ReportDefinition.ReportObjects["esl_txt"];
txt.Text = myMirror.Advisor;
txt = (TextObject)myReport.ReportDefinition.ReportObjects["eng_txt"];
txt.Text = myMirror.ENG;
txt = (TextObject)myReport.ReportDefinition.ReportObjects["score_txt"];
txt.Text = string.Format("{0:f}", myMirror.Score);
txt = (TextObject)myReport.ReportDefinition.ReportObjects["Major_Free_Elective_txt"];
string MElective = myMirrorDAL.GetMajorElectiveCourses(myMirror.StudentNumber, Campus);
string FElective = myMirrorDAL.GetFreeElectiveCourses(myMirror.StudentNumber, Campus);
txt.Text = "";
if (MElective.Length > 0)
{
txt.Text += "Major Electives: " + "[ " + MElective + " ]";
}
if (FElective.Length > 0)
{
if (MElective.Length > 0)
{
txt.Text += " --- ";
}
txt.Text += "Free Electives [" + FElective + " ]";
}
txt = (TextObject)myReport.ReportDefinition.ReportObjects["Session_txt"];
txt.Text = myMirror.Period;
txt = (TextObject)myReport.ReportDefinition.ReportObjects["Term_txt"];
string sTerm = LibraryMOD.GetTermDesc(iRegYear, iRegSem);
txt.Text = sTerm;
txt = (TextObject)myReport.ReportDefinition.ReportObjects["Advisor_txt"];
txt.Text = LibraryMOD.GetAdvisorEmail(myMirror.Advisor);
txt = (TextObject)myReport.ReportDefinition.ReportObjects["txtTitle"];
txt.Text = myMirror.StudentNumber.Replace(".", "") + " - " + myMirror.Name;
txt = (TextObject)myReport.ReportDefinition.ReportObjects["UserTXT"];
string sUserName = Session["CurrentUserName"].ToString();
txt.Text = sUserName;
//coordinator_txt
//advisors_txt
string sCoordinator = "";
string sAdvisors = "";
string sMajor = "";
List <Applications> myStudent = new List <Applications>();
ApplicationsDAL myApplicationsDAL = new ApplicationsDAL();
myStudent = myApplicationsDAL.GetList(Campus, " lngStudentNumber='" + myMirror.StudentNumber + "'", false);
if (myStudent.Count > 0)
{
sMajor = myStudent[0].strSpecialization;
}
myStudent.Clear();
myAdvisors = myAdvisorsDAL.GetPrograms_Advisors(Campus, sMajor);
for (int i = 0; i < myAdvisors.Count; i++)
{
if (myAdvisors[i].byteCategory == 1)
{
sCoordinator += LibraryMOD.GetAdvisorEmail(myAdvisors[i].SAdvisor);
}
else
{
sAdvisors += LibraryMOD.GetAdvisorEmail(myAdvisors[i].SAdvisor) + ",";
}
}
txt = (TextObject)myReport.ReportDefinition.ReportObjects["coordinator_txt"];
txt.Text = sCoordinator;
txt = (TextObject)myReport.ReportDefinition.ReportObjects["advisors_txt"];
txt.Text = sAdvisors;
myReport.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Page.Response, true, "ECTReport");
}
catch (Exception exp)
{
Console.WriteLine("{0} Exception caught.", exp);
}
finally
{
myAdvisors.Clear();
myReport.Close();
myReport.Dispose();
}
}