/// <summary>
/// This function is used to display the photograph .
/// </summary>
private void showPhotograph()
{
oStudent = new clsStudent(UniID, YearID, StudentID, true);
DataTable dt = new DataTable();
if (oCDNKeys != null)
{
objCDN = new clsCDN(oCDNKeys.PhotoSignKey);
sPathExists = !string.IsNullOrEmpty(Convert.ToString(oStudent.PhotoPath)) ? "Y" : "N";
ImgPhoto.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(oStudent.PhotoPath), sPathExists, "P");
ImgPhoto.Visible = true;
}
//if (oStudent.PhotoPath != null)
//{
// ImgPhoto.ImageUrl = dtRow["Download_Path"].ToString() + oStudent.PhotoPath;//"..\\PhotoSignTemp.ashx?QS_Student_ID=" + StudentID + "&img=Photo&Year=" + YearID;
// ImgPhoto.Visible = true;
// DivNoPhoto.Visible = false;
//}
//else
//{
// DivNoPhoto.Visible = true;
// ImgPhoto.Visible = false;
//}
}
/// <summary>
/// Rendering profile details
/// </summary>
/// <param name="studDs"></param>
private void RenderTable(DataSet studDs)
{
#region "Reset Tables"
ResetTable(TBLSummery);
#endregion
#region Summary
//
//Add columns to table Summary
//
TableCell oTD = null;
foreach (DataRow Row in studDs.Tables[0].Rows)
{
foreach (DataColumn Field in studDs.Tables[0].Columns)
{
switch (Field.ColumnName)
{
case "PRN":
oTD = new TableCell();
oTD.CssClass = "clOn";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TBLSummery.Rows[0].Cells.Add(oTD);
break;
case "Student_Name":
oTD = new TableCell();
oTD.CssClass = "clOn";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TBLSummery.Rows[1].Cells.Add(oTD);
break;
case "Photosign":
oTD = new TableCell();
oTD.CssClass = "clOn";
oTD.VerticalAlign = VerticalAlign.Middle;
System.Web.UI.WebControls.Image oPhoto = new System.Web.UI.WebControls.Image();
oPhoto.ID = "imgPhoto" + Row["Student_ID"].ToString();
System.Web.UI.WebControls.Image oSign = new System.Web.UI.WebControls.Image();
oSign.ID = "imgSign" + Row["Student_ID"].ToString();
//Modified as per Req 102312
if (oCDNKeys != null)
{
objCDN = new clsCDN(oCDNKeys.PhotoSignKey);
sPathExists = !string.IsNullOrEmpty(Convert.ToString(Row["PhotoPath"])) ? "Y" : "N";
oPhoto.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(Row["PhotoPath"]), sPathExists, "P");
sPathExists = !string.IsNullOrEmpty(Convert.ToString(Row["SignPath"])) ? "Y" : "N";
oSign.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(Row["SignPath"]), sPathExists, "S");
}
oPhoto.CssClass = "cssImage";
//oSign.ImageUrl = dtRow["Download_Path"].ToString() + Row["SignPath"].ToString();//"PhotoSignHandler.ashx?img=Sign&UniID=" + Convert.ToString(Row["pk_Uni_ID"]) + "&StudentID=" + Convert.ToString(Row["pk_Student_ID"]) + "&YearID=" + Convert.ToString(Row["pk_Year"]);
oSign.CssClass = "cssImage";
oTD.Controls.Add(oPhoto);
oTD.Controls.Add(oSign);
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TBLSummery.Rows[2].Cells.Add(oTD);
break;
default: break;
}
}
}
#endregion
#region Course
if (studDs.Tables[1] != null && studDs.Tables[1].Rows.Count > 0)
{
RptCourse.DataSource = studDs.Tables[1];
RptCourse.DataBind();
divCourseProfile.Visible = true;
divCourse.Visible = true;
hid_Term_Count.Value = studDs.Tables[1].Rows.Count.ToString();
}
else
{
divCourseProfile.Visible = false;
divCourse.Visible = false;
}
#endregion
}
public void FetchStudentDetails1(int pk_Uni_ID, int pk_Year, int pk_Student_ID)
{
try
{
ds = clsEligibilityDBAccess.Elg_AdvSearch_StudentEligibilityDetails(pk_Uni_ID, pk_Year, pk_Student_ID, hidRef_InstReg_Uni_ID.Value, hidRef_InstReg_Institute_ID.Value, hidRef_InstReg_Year.Value, hidRef_Student_ID.Value, hidPRN.Value);
divTblElgFormdetails.Style.Remove("display");
divTblElgFormdetails.Style.Add("display", "none");
if (ds.Tables[0].Rows.Count > 0)
{
Regex objNotNaturalPattern = new Regex("^([0-9]){16}$");
if (!objNotNaturalPattern.IsMatch(ds.Tables[0].Rows[0]["PRN"].ToString()))
{
lblPermRegNo.Text = "Not Generated";
}
else
{
lblPermRegNo.Text = ds.Tables[0].Rows[0]["PRN"].ToString();
}
lblAlumni.Text = ds.Tables[0].Rows[0]["Alumini_Flag"].ToString();
lblNameAsMarksheet.Text = ds.Tables[0].Rows[0]["Name_QualExamMarkSheet"].ToString();
lblNameOfStudent.Text = ds.Tables[0].Rows[0]["Last_Name"].ToString() + " " + ds.Tables[0].Rows[0]["First_Name"].ToString() + " " + ds.Tables[0].Rows[0]["Middle_Name"].ToString();
lblMothersMaidenName.Text = ds.Tables[0].Rows[0]["Mother_Last_Name"].ToString() + " " + ds.Tables[0].Rows[0]["Mother_First_Name"].ToString() + " " + ds.Tables[0].Rows[0]["Mother_Middle_Name"].ToString();
lblFathersName.Text = ds.Tables[0].Rows[0]["Father_Last_Name"].ToString() + " " + ds.Tables[0].Rows[0]["Father_First_Name"].ToString() + " " + ds.Tables[0].Rows[0]["Father_Middle_Name"].ToString();
if (ds.Tables[0].Rows[0]["Changed_Name_Flag"].ToString() == "1")
{
lblPreviousName.Text = ds.Tables[0].Rows[0]["Prev_Last_Name"].ToString() + " " + ds.Tables[0].Rows[0]["Prev_First_Name"].ToString() + " " + ds.Tables[0].Rows[0]["Prev_Middle_Name"].ToString();
}
lblGender.Text = ds.Tables[0].Rows[0]["Gender_Desc"].ToString();
lblDOB.Text = ds.Tables[0].Rows[0]["DOB"].ToString(); //Gender,Date_of_Birth,Changed_Name_Reason
lblNationality.Text = ds.Tables[0].Rows[0]["Nationality"].ToString();
}
if (ds.Tables[1].Rows.Count > 0)
{
lblDomicileState.Text = ds.Tables[1].Rows[0]["Domicile_of_State"].ToString();
lblResvCategory.Text = ds.Tables[1].Rows[0]["Category"].ToString();
if (ds.Tables[1].Rows[0]["Category_Flag"].ToString() == "1")
{
if (ds.Tables[1].Rows[0]["ResvCategory"].ToString() != "")
{
lblResvCategory.Text += " (" + ds.Tables[1].Rows[0]["ResvCategory"].ToString();
if (ds.Tables[1].Rows[0]["SubCaste"].ToString() != "")
{
lblResvCategory.Text += " - " + ds.Tables[1].Rows[0]["SubCaste"].ToString();
}
lblResvCategory.Text += ")";
}
}
if (ds.Tables[1].Rows[0]["Physically_Challenged_Flag"].ToString() == "1")
{
lblPhyChlngd.Text = ds.Tables[1].Rows[0]["PhysicallyChallenged"].ToString();
}
else
{
lblPhyChlngd.Text = " -";
}
lblGuardianincome.Text = "Rs. " + ds.Tables[1].Rows[0]["Guardian_Annual_Income"].ToString();
lblGuardianOccupation.Text = ds.Tables[1].Rows[0]["GuardOccupation"].ToString();
}
if (ds.Tables[2].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[2].Rows.Count; i++)
{
lblSocResv.Text += ds.Tables[2].Rows[i]["SocialReservation_Description"].ToString();
if (i < (ds.Tables[2].Rows.Count - 1))
{
lblSocResv.Text += ", ";
}
}
}
if (ds.Tables[3].Rows.Count > 0)
{
DGQualification1.DataSource = ds.Tables[3];
DGQualification1.DataBind();
}
if (ds.Tables[4].Rows.Count > 0)
{
DGSubmittedDocs1.DataSource = ds.Tables[4];
DGSubmittedDocs1.DataBind();
}
/*IF there are any Matching Records
* if(ds.Tables[5].Rows.Count>0)
* {
*
* divMatchingRecords.Style.Add("display","block");
* //lblEligibilityFormNo.Text=ds.Tables[5].Rows[0]["ElgFormNo"].ToString() ;
* DGMatchgCourseDetails.DataSource=ds.Tables[5];
* DGMatchgCourseDetails.DataBind();
* }
* else
* {
*
* divMatchingRecords.Style.Add("display","none");
* }
* if ((hidPRN.Value == null) || (hidPRN.Value == ""))
* {*/
if (ds.Tables[5].Rows.Count > 0)
{
lblInstName.Text = ds.Tables[5].Rows[0]["RefInstName"].ToString();
lblElgReason.Text = FormatReason(ds.Tables[5].Rows[0]["Reason"].ToString());
lblElgStatus.Text = FormatReason(ds.Tables[5].Rows[0]["EligibilityStatus"].ToString());
lblEligibilityFormNo.Text = ds.Tables[5].Rows[0]["ElgFormNo"].ToString();
TblAdmission.Style.Remove("display");
TblAdmission.Style.Add("display", "block");
divTblElgFormdetails.Style.Remove("display");
divTblElgFormdetails.Style.Add("display", "block");
lblAdmissionDate.Text = ds.Tables[5].Rows[0]["Admission_Date"].ToString();
lblAppFormNo.Text = ds.Tables[5].Rows[0]["Admission_Form_No"].ToString();
lblCourse.Text = ds.Tables[5].Rows[0]["Course"].ToString();
}
/*}
* else
* if ((hidPRN.Value != null) && (hidPRN.Value != ""))
* {
* TblAdmission.Style.Remove("display");
* TblAdmission.Style.Add("display", "none");
* divTblElgFormdetails.Style.Remove("display");
* divTblElgFormdetails.Style.Add("display", "none");
* lblGridName.Text = "Course Eligibility Status";
* }*/
hidDocCnt.Value = ds.Tables[4].Rows.Count.ToString();
//Image1.ImageUrl = "ELGV2_ViewStatus__3.aspx?img=PR&sStudentDetails=" + hidpkYear.Value + "-" + hidpkStudentID.Value;
//Image1.Visible = true;
//Image2.ImageUrl = "ELGV2_ViewStatus__3.aspx?img=SR&sStudentDetails=" + hidpkYear.Value + "-" + hidpkStudentID.Value;
//Image2.Visible = true;
ds = elgDBAccess.Reg_Fetch_Student_Photograph(Convert.ToInt32(Classes.clsGetSettings.UniversityID.ToString()), Convert.ToInt32(hidpkYear.Value), Convert.ToInt32(hidpkStudentID.Value));
if (ds.Tables[0].Rows.Count > 0)
{
//Modified as per Req 102312
if (oCDNKeys != null)
{
objCDN = new clsCDN(oCDNKeys.PhotoSignKey);
sPathExists = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["PhotoPath"])) ? "Y" : "N";
Image1.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(ds.Tables[0].Rows[0]["PhotoPath"]), sPathExists, "P");
Image1.Width = objCDN.PhotoWidth;
Image1.Height = objCDN.PhotoHeight;
sPathExists = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["SignPath"])) ? "Y" : "N";
Image2.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(ds.Tables[0].Rows[0]["SignPath"]), sPathExists, "S");
Image2.Width = objCDN.ImageWidth;
Image2.Height = objCDN.ImageHeight;
}
}
lblStudName.Text = "<br><b> for student <i>" + lblNameOfStudent.Text + "</i> for " + lblCr.Text + " " + ds.Tables[5].Rows[0]["Course"].ToString() + "</b>";
/*divStudentDetails.Style.Add("Display","block");
* For Proper Display Message of Eligibility Decision
*
* lblGridName.Text ="Candidate "+ds.Tables[2].Rows[0]["First_Name"].ToString() +"'s Matching Other Course Details ";
* if(ds.Tables[0].Rows.Count > 0)
* lblPageHead.Text += "<font color='black'> of <i>"+lblNameOfStudent.Text+"</i> for Course "+ds.Tables[0].Rows[0]["CoursePart"].ToString()+"</font>";*/
}
catch (Exception ex)
{
Response.Write(ex.Message);
throw new Exception(ex.Message);
}
ds.Dispose();
}
public void FetchStudentDetails()
{
string ElgFormNo = hidElgFormNo.Value.ToString();
//string[] RefIDarr = new string[4];
RefIDarr = ElgFormNo.Split('-'); //Year = RefIDarr[0], UniID = RefIDarr[1], InstID = RefIDarr[2], StudID = RefIDarr[3]
try
{
//ds=clsEligibilityDBAccess.REG_Get_Eligibilitystatusdetails(Convert.ToInt32(hidUniID.Value),Convert.ToInt32(hidpkYear.Value),Convert.ToInt32(hidpkStudentID.Value),hidPRN.Value);//Convert.ToInt32(RefIDarr[0].ToString()),Convert.ToInt32(RefIDarr[2].ToString()),Convert.ToInt32(RefIDarr[1].ToString()),Convert.ToInt32(RefIDarr[3].ToString()),hidPRN.Value);
ds = clsEligibilityDBAccess.REG_Get_Eligibilitystatusdetails(Convert.ToInt32(Classes.clsGetSettings.UniversityID.ToString()), Convert.ToInt32(hidpkYear.Value), Convert.ToInt32(hidpkStudentID.Value), Convert.ToInt32(RefIDarr[0].ToString()), Convert.ToInt32(RefIDarr[1].ToString()), Convert.ToInt32(RefIDarr[2].ToString()), Convert.ToInt32(RefIDarr[3].ToString()), Convert.ToInt32(hidpkFacID.Value), Convert.ToInt32(hidpkCrID.Value), Convert.ToInt32(hidpkMoLrnID.Value), Convert.ToInt32(hidpkPtrnID.Value), Convert.ToInt32(hidpkBrnID.Value), Convert.ToInt32(hidpkCrPrDetailsID.Value));
/* if (ds.Tables[0].Rows.Count > 0)
* {
* lblPapers.Text = "<table id='Tbl2' cellSpacing='0' cellPadding='3' width='100%' border='1px'>";
* int j = 0;
* for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
* {
* if (j == 0)
* lblPapers.Text += "<tr class='rfont'>";
* lblPapers.Text += "<td>" + ds.Tables[1].Rows[i]["PaperCode"].ToString() + "</td>";
* lblPapers.Text += "<td>" + ds.Tables[1].Rows[i]["PaperName"].ToString() + "</td>";
++j;
* if (j == 3)
* {
* lblPapers.Text += "</tr>";
* j = 0;
* }
*
* }
*
* lblPapers.Text += "</table>";
* }*/
if (ds.Tables[1].Rows.Count > 0)
{
Regex objNotNaturalPattern = new Regex("^([0-9]){16}$");
if (!objNotNaturalPattern.IsMatch(ds.Tables[1].Rows[0]["PRN"].ToString()))
{
lblPermRegNo.Text = "Not Generated";
}
else
{
lblPermRegNo.Text = ds.Tables[1].Rows[0]["PRN"].ToString();
}
//lblPermRegNo.Text=ds.Tables[1].Rows[0]["PRN"].ToString();
lblAlumni.Text = ds.Tables[1].Rows[0]["Alumini_Flag"].ToString();
lblNameAsMarksheet.Text = ds.Tables[1].Rows[0]["Name_QualExamMarkSheet"].ToString();
lblNameOfStudent.Text = ds.Tables[1].Rows[0]["Last_Name"].ToString() + " " + ds.Tables[1].Rows[0]["First_Name"].ToString() + " " + ds.Tables[1].Rows[0]["Middle_Name"].ToString();
lblMothersMaidenName.Text = ds.Tables[1].Rows[0]["Mother_Last_Name"].ToString() + " " + ds.Tables[1].Rows[0]["Mother_First_Name"].ToString() + " " + ds.Tables[1].Rows[0]["Mother_Middle_Name"].ToString();
lblFathersName.Text = ds.Tables[1].Rows[0]["Father_Last_Name"].ToString() + " " + ds.Tables[1].Rows[0]["Father_First_Name"].ToString() + " " + ds.Tables[1].Rows[0]["Father_Middle_Name"].ToString();
if (ds.Tables[1].Rows[0]["Changed_Name_Flag"].ToString() == "1")
{
lblPreviousName.Text = ds.Tables[1].Rows[0]["Prev_Last_Name"].ToString() + " " + ds.Tables[1].Rows[0]["Prev_First_Name"].ToString() + " " + ds.Tables[1].Rows[0]["Prev_Middle_Name"].ToString();
}
lblGender.Text = ds.Tables[1].Rows[0]["Gender_Desc"].ToString();
lblDOB.Text = ds.Tables[1].Rows[0]["DOB"].ToString();
lblNationality.Text = ds.Tables[1].Rows[0]["Nationality"].ToString();
lblStudName.Text = "<br><b> for student <i>" + lblNameOfStudent.Text + "</i> for " + lblCr.Text + " " + ds.Tables[0].Rows[0]["Course"].ToString() + "</b>";
}
if (ds.Tables[2].Rows.Count > 0)
{
lblDomicileState.Text = ds.Tables[2].Rows[0]["Domicile_of_State"].ToString();
lblResvCategory.Text = ds.Tables[2].Rows[0]["Category"].ToString();
if (ds.Tables[2].Rows[0]["Category_Flag"].ToString() == "1")
{
if (ds.Tables[2].Rows[0]["ResvCategory"].ToString() != "")
{
lblResvCategory.Text += " (" + ds.Tables[2].Rows[0]["ResvCategory"].ToString();
if (ds.Tables[2].Rows[0]["SubCaste"].ToString() != "")
{
lblResvCategory.Text += " - " + ds.Tables[2].Rows[0]["SubCaste"].ToString();
}
lblResvCategory.Text += ")";
}
}
if (ds.Tables[2].Rows[0]["Physically_Challenged_Flag"].ToString() == "1")
{
lblPhyChlngd.Text = ds.Tables[2].Rows[0]["PhysicallyChallenged"].ToString();
}
else
{
lblPhyChlngd.Text = " -";
}
lblGuardianincome.Text = "Rs. " + ds.Tables[2].Rows[0]["Guardian_Annual_Income"].ToString();
lblGuardianOccupation.Text = ds.Tables[2].Rows[0]["GuardOccupation"].ToString();
}
if (ds.Tables[5].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[5].Rows.Count; i++)
{
lblSocResv.Text += ds.Tables[5].Rows[i]["SocialReservation_Description"].ToString();
if (i < (ds.Tables[5].Rows.Count - 1))
{
lblSocResv.Text += ", ";
}
}
}
if (ds.Tables[3].Rows.Count > 0)
{
DGQualification1.DataSource = ds.Tables[3];
DGQualification1.DataBind();
}
if (ds.Tables[4].Rows.Count > 0)
{
DGSubmittedDocs1.DataSource = ds.Tables[4];
DGSubmittedDocs1.DataBind();
}
/*IF there are any Matching Records This functionality is commented to supress
* the logic of duplicate erecord checking
* if(ds.Tables[5].Rows.Count>0)
* {
*
* divMatchingRecords.Style.Add("display","block");
* //lblEligibilityFormNo.Text=ds.Tables[5].Rows[0]["ElgFormNo"].ToString() ;
* DGMatchgCourseDetails.DataSource=ds.Tables[5];
* DGMatchgCourseDetails.DataBind();
* }
* else
* {
*
* divMatchingRecords.Style.Add("display","none");
* }
*
* if((hidPRN.Value==null)||(hidPRN.Value==""))
* {*/
if (ds.Tables[0].Rows.Count > 0)
{
lblInstName.Text = ds.Tables[0].Rows[0]["RefInstName"].ToString();
lblElgReason.Text = FormatReason(ds.Tables[0].Rows[0]["Reason"].ToString());
lblElgStatus.Text = ds.Tables[0].Rows[0]["EligibilityStatus"].ToString();
lblEligibilityFormNo.Text = ds.Tables[0].Rows[0]["ElgFormNo"].ToString();
TblAdmission.Style.Remove("display");
TblAdmission.Style.Add("display", "block");
divTblElgFormdetails.Style.Remove("display");
divTblElgFormdetails.Style.Add("display", "block");
lblAdmissionDate.Text = ds.Tables[0].Rows[0]["Admission_Date"].ToString();
lblAppFormNo.Text = ds.Tables[0].Rows[0]["Admission_Form_No"].ToString();
lblCourse.Text = ds.Tables[0].Rows[0]["Course"].ToString();
}
/*}
* else
* if((hidPRN.Value!=null) && (hidPRN.Value!=""))
* {
* TblAdmission.Style.Remove("display");
* TblAdmission.Style.Add("display","none");
* divTblElgFormdetails.Style.Remove("display");
* divTblElgFormdetails.Style.Add("display","none");
* lblGridName.Text="Course Eligibility Status";
* }*/
//hidDocCnt.Value = ds.Tables[5].Rows.Count.ToString();
//Image1.ImageUrl = dtRow["Download_Path"].ToString() + ds.Tables[1].Rows[0]["PhotoPath"].ToString();//"ELGV2_ViewStatus__3.aspx?img=PR&sStudentDetails=" + hidpkYear.Value + "-" + hidpkStudentID.Value;
Image1.Visible = true;
//Image2.ImageUrl = dtRow["Download_Path"].ToString() + ds.Tables[1].Rows[0]["SignPath"].ToString();//"ELGV2_ViewStatus__3.aspx?img=SR&sStudentDetails=" + hidpkYear.Value + "-" + hidpkStudentID.Value;
Image2.Visible = true;
if (oCDNKeys != null)
{
objCDN = new clsCDN(oCDNKeys.PhotoSignKey);
sPathExists = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[1].Rows[0]["PhotoPath"])) ? "Y" : "N";
Image1.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(ds.Tables[1].Rows[0]["PhotoPath"]), sPathExists, "P");
sPathExists = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[1].Rows[0]["SignPath"])) ? "Y" : "N";
Image2.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(ds.Tables[1].Rows[0]["SignPath"]), sPathExists, "S");
}
/*divStudentDetails.Style.Add("Display","block");
* For Proper Display Message of Eligibility Decision
*
* lblGridName.Text ="Candidate "+ds.Tables[2].Rows[0]["First_Name"].ToString() +"'s Matching Other Course Details ";
* if(ds.Tables[0].Rows.Count > 0)
* lblPageHead.Text += "<font color='black'> of <i>"+lblNameOfStudent.Text+"</i> for Course "+ds.Tables[0].Rows[0]["CoursePart"].ToString()+"</font>";*/
}
catch (Exception ex)
{
// Response.Write(ex.Message);
throw ex;
}
finally
{
ds.Dispose();
}
}
public void DisplayContactDetails()
{
string PRN;
DataSet ds = new DataSet();
DataTable tempDT = new DataTable();
oStudent = new clsRegStudent(Classes.clsGetSettings.UniversityID.ToString(), hid_pk_Year.Value, hid_pk_Student_ID.Value.ToString());
Session["StudentObj"] = oStudent;
ds = clsRegStudent.Fetch_StudentReRegistraionCourseDetails(pUID, pYr, pStudID);
if (ds.Tables[0].Rows.Count > 0)
{
clsCDN objCDN = new clsCDN();
DataRow dtRow = objCDN.GetCDNKeys(clsDUConfigurations.Instance.CDNKeys.PhotoSignKey);
if (!string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["PhotoPath"])))
{
Image1.ImageUrl = dtRow["Download_Path"].ToString() + ds.Tables[0].Rows[0]["PhotoPath"].ToString(); //"ViewRequestStatus__2.aspx?PStudentID=" + pUID + "-" + pYr + "-" + pStudID;
}
else
{
Image1.ImageUrl = dtRow["Download_Path"].ToString() + "NoPhoto.JPG";
}
if (!string.IsNullOrEmpty(Convert.ToString(ds.Tables[0].Rows[0]["SignPath"])))
{
Image2.ImageUrl = dtRow["Download_Path"].ToString() + ds.Tables[0].Rows[0]["SignPath"].ToString(); //"ViewRequestStatus__2.aspx?SStudentID=" + pUID + "-" + pYr + "-" + pStudID;
}
else
{
Image2.ImageUrl = dtRow["Download_Path"].ToString() + "NoSign.JPG";
}
PRN = ds.Tables[0].Rows[0]["PRN_Number"].ToString();
if ((PRN == "") || (PRN == null) || ((PRN == " ")))
{
PRN = "Not Generated";
lblPRN.Text = PRN;
}
else
{
lblPRN.Text = ds.Tables[0].Rows[0]["PRN_Number"].ToString();
}
//lblCourse.Text = ds.Tables[1].Rows[1]["CrDesc"].ToString();
//lblCollege.Text = ds.Tables[1].Rows[1]["InstName"].ToString();
if (ds.Tables[1].Rows.Count > 0)
{
DGCourseInstitute1.DataSource = ds.Tables[1];
DGCourseInstitute1.DataBind();
DGCourseInstitute1.Visible = true;
}
else
{
//Err_Qualification.Visible = true;
DGCourseInstitute1.Visible = false;
btnMercyAllow.Enabled = false;
}
DGCourseInstitute1.Dispose();
}
lblNameOfStudent.Text = oStudent.Last_Name + " " + oStudent.First_Name + " " + oStudent.Middle_Name;
lblNameOnMarksheet.Text = oStudent.Name_QualExamMarkSheet;
lblFathersName.Text = oStudent.Father_Last_Name + " " + oStudent.Father_First_Name + " " + oStudent.Father_Middle_Name;
lblMothersMaidenName.Text = oStudent.Mother_Last_Name + " " + oStudent.Mother_First_Name + " " + oStudent.Mother_Middle_Name;
if (oStudent.Gender == "1")
{
lblGender.Text = "Male";
}
else if (oStudent.Gender == "2")
{
lblGender.Text = "Female";
}
lblDOB.Text = oStudent.DOB;
}
protected void gvStudentCountLinks_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("cmdGenerateXML"))
{
oRegionalStudyCenter = new clsRegionalStudyCenter();
string PhotoSignXml = string.Empty;
GridView gv = (GridView)sender;
int index = Convert.ToInt32(e.CommandArgument);
string LowerLimit = gv.DataKeys[index]["Text"].ToString().Split('-')[0];
string UpperLimit = gv.DataKeys[index]["Text"].ToString().Split('-')[1];
int RowIndex = index + 1;
string sFileName = hidUniID.Value + "_" + hidAcademicYearID.Value + "_" +
hidCrName.Value + "_" + hidMoLrnName.Value + "_" + hidPtrnName.Value + "_" + hidBrnName.Value + "_" +
hidCrPrName.Value + "_" + hidCrPrChName.Value + "_" + RowIndex.ToString();
char[] charNotAllowed = { '/', '\\', '*', '?', '"', '<', '>', '|', ':' };
for (int icharCount = 0; icharCount < charNotAllowed.Length; icharCount++)
{
sFileName = sFileName.Replace(charNotAllowed[icharCount], '_');
}
sFileName = sFileName.Replace(" ", string.Empty);
string sDestination = Server.MapPath(".\\TempDirectory\\");
PhotoSignXml = oRegionalStudyCenter.ListStudentPhotoSignXML(hidAcademicYearID.Value, hidUniID.Value,
hidFacID.Value, hidCrID.Value, hidMoLrnID.Value,
hidPtrnID.Value, hidBrnID.Value, hidCrPrDetailsID.Value,
hidCrPrChID.Value, LowerLimit, UpperLimit, hidExamEventID.Value);
//************************************ CDN related changes ******************************
clsCDN objCDN = new clsCDN();
string BusinessUnitId, PIdDC, Relative_Path, Upload_Path;
string DownloadZipServicePath;
//DataTable oDtCDNConf = cdnConf.GetCDNKeys();
if (oCDNKeys != null)
{
DataRow dtRow = objCDN.GetCDNKeys(oCDNKeys.PhotoSignKey);
if (dtRow != null)
{
BusinessUnitId = Convert.ToString(dtRow["BusinessUnitId"]);
PIdDC = Convert.ToString(dtRow["PIdDC"]);
Relative_Path = Convert.ToString(dtRow["Relative_Path"]);
Upload_Path = Convert.ToString(dtRow["Upload_Path"]); //+ "uploadBase64AndGetId";
DownloadZipServicePath = Upload_Path + "downloadZipFile";
StringBuilder CDNKeys = new StringBuilder("<CDNXML><CDNKeys>");
CDNKeys.Append("<BusinessUnitId>");
CDNKeys.Append(BusinessUnitId);
CDNKeys.Append("</BusinessUnitId>");
CDNKeys.Append("<PIdDC>");
CDNKeys.Append(PIdDC);
CDNKeys.Append("</PIdDC>");
CDNKeys.Append("<Relative_Path>");
CDNKeys.Append(Relative_Path);
CDNKeys.Append("</Relative_Path>");
CDNKeys.Append("<DownloadZipServicePath>");
CDNKeys.Append(DownloadZipServicePath);
CDNKeys.Append("</DownloadZipServicePath>");
CDNKeys.Append("</CDNKeys>");
// BusinessUnitId, PIdDC, Relative_Path, DownloadZipServicePath
PhotoSignXml = CDNKeys.ToString() + PhotoSignXml + "</CDNXML>";
}
}
//***************************************************************************************
if (!Directory.Exists(sDestination))
{
Directory.CreateDirectory(sDestination);
}
string outputFile = sDestination + sFileName + ".zip";
string inputFile = sDestination + sFileName + ".xml";
string sPassword = "******";
DeleteZipFiles(sDestination, sFileName);
try
{
UTF8Encoding encoding = new UTF8Encoding();
Byte[] byteArray = encoding.GetBytes(PhotoSignXml);
oFileStream = new FileStream(inputFile, FileMode.Create, FileAccess.Write);
oFileStream.Write(byteArray, 0, byteArray.Length);
oFileStream.Close();
oFastZip.CreateZip(inputFile, outputFile, sPassword);
}
catch (Exception ex)
{
lblErrorMsg.Text = ex.Message.ToString();
}
}
}
/// <summary>
/// Rendering profile details
/// </summary>
/// <param name="studDt"></param>
private void RenderTable(DataTable studDt)
{
#region "Reset Tables"
ResetTable(TBLSummery);
ResetTable(TblPersonalInfo);
ResetTable(TblQual);
ResetTable(TblSocRes);
ResetTable(TblCourse);
ResetTable(TblCollege);
ResetTable(TblAction);
#endregion
#region Summary
//
//Add columns to table Summary
//
TableCell oTD = null;
foreach (DataRow Row in studDt.Rows)
{
foreach (DataColumn Field in studDt.Columns)
{
switch (Field.ColumnName)
{
case "PRN":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TBLSummery.Rows[0].Cells.Add(oTD);
break;
//case "Eligibility Form No":
// oTD = new TableCell();
// oTD.CssClass = "clOff";
// oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
// oTD.Attributes.Add("id", Row["Student_ID"].ToString());
// TBLSummery.Rows[1].Cells.Add(oTD);
// break;
case "Student_Name":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TBLSummery.Rows[1].Cells.Add(oTD);
break;
case "Photosign":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.VerticalAlign = VerticalAlign.Middle;
System.Web.UI.WebControls.Image oPhoto = new System.Web.UI.WebControls.Image();
oPhoto.ID = "imgPhoto" + Row["Student_ID"].ToString();
System.Web.UI.WebControls.Image oSign = new System.Web.UI.WebControls.Image();
oSign.ID = "imgSign" + Row["Student_ID"].ToString();
//oSign.ImageUrl = dtRow["Download_Path"].ToString() + Row["SignPath"].ToString();//"PhotoSignHandler.ashx?img=Sign&UniID=" + Convert.ToString(Row["pk_Uni_ID"]) + "&StudentID=" + Convert.ToString(Row["pk_Student_ID"]) + "&YearID=" + Convert.ToString(Row["pk_Year"]);
if (oCDNKeys != null)
{
objCDN = new clsCDN(oCDNKeys.PhotoSignKey);
sPathExists = !string.IsNullOrEmpty(Convert.ToString(Row["PhotoPath"])) ? "Y" : "N";
oPhoto.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(Row["PhotoPath"]), sPathExists, "P");
sPathExists = !string.IsNullOrEmpty(Convert.ToString(Row["SignPath"])) ? "Y" : "N";
oSign.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(Row["SignPath"]), sPathExists, "S");
}
oSign.CssClass = "cssImage";
oTD.Controls.Add(oPhoto);
oTD.Controls.Add(oSign);
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TBLSummery.Rows[2].Cells.Add(oTD);
break;
//case "College Name":
// oTD = new TableCell();
// oTD.CssClass = "clOff";
// oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
// oTD.Attributes.Add("id", Row["Student_ID"].ToString());
// TBLSummery.Rows[4].Cells.Add(oTD);
// break;
}
}
}
#endregion
#region Personal Information
//
//Add columns to table Personal Information
//
oTD = null;
foreach (DataRow Row in studDt.Rows)
{
foreach (DataColumn Field in studDt.Columns)
{
switch (Field.ColumnName)
{
case "Student_Name":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[0].Cells.Add(oTD);
break;
case "Mother_Name":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[1].Cells.Add(oTD);
break;
case "Father_Name":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[2].Cells.Add(oTD);
break;
case "Printed_statement":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[3].Cells.Add(oTD);
break;
case "Name_in_Vernacular_language":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[4].Cells.Add(oTD);
break;
case "Marital_Status":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[5].Cells.Add(oTD);
break;
case "Gender":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[6].Cells.Add(oTD);
break;
case "Date_of_Birth":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[7].Cells.Add(oTD);
break;
case "Place_of_Birth":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[8].Cells.Add(oTD);
break;
case "Blood_Group":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[9].Cells.Add(oTD);
break;
case "Religion":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[10].Cells.Add(oTD);
break;
case "Previous_Name":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[11].Cells.Add(oTD);
break;
case "Reason_for_Changing_Name":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[12].Cells.Add(oTD);
break;
case "Country_of_Citizenship":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[13].Cells.Add(oTD);
break;
case "Location_Category":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[14].Cells.Add(oTD);
break;
case "Correspondence_Address":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[15].Cells.Add(oTD);
break;
case "Correspondence_Tahsil":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[16].Cells.Add(oTD);
break;
case "Correspondence_District":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[17].Cells.Add(oTD);
break;
case "Correspondence_State":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[18].Cells.Add(oTD);
break;
case "Correspondence_Country":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[19].Cells.Add(oTD);
break;
case "Permanent_Address":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[20].Cells.Add(oTD);
break;
case "Permanent_Tahsil":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[21].Cells.Add(oTD);
break;
case "Permanent_District":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[22].Cells.Add(oTD);
break;
case "Permanent_State":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[23].Cells.Add(oTD);
break;
case "Permanent_Country":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[24].Cells.Add(oTD);
break;
case "Area_STD_Phone1":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[25].Cells.Add(oTD);
break;
case "Area_STD_Phone2":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[26].Cells.Add(oTD);
break;
case "Mobile_Number":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[27].Cells.Add(oTD);
break;
case "Email_ID":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblPersonalInfo.Rows[28].Cells.Add(oTD);
break;
}
}
}
//divPerInfo.Controls.Add(TblPersonalInfo);
#endregion
#region Qualifications
//
//Add columns to table Qualifications
//
oTD = null;
foreach (DataRow Row in studDt.Rows)
{
foreach (DataColumn Field in studDt.Columns)
{
switch (Field.ColumnName)
{
case "10th_Board_Type":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblQual.Rows[0].Cells.Add(oTD);
break;
case "10th_Board_State":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblQual.Rows[1].Cells.Add(oTD);
break;
case "10th_Board":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblQual.Rows[2].Cells.Add(oTD);
break;
case "10th_Passing_Certificate":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblQual.Rows[3].Cells.Add(oTD);
break;
case "10th_Examination_Seat_Number":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblQual.Rows[4].Cells.Add(oTD);
break;
case "12th_Board_Type":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblQual.Rows[5].Cells.Add(oTD);
break;
case "12th_Board_State":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblQual.Rows[6].Cells.Add(oTD);
break;
case "12th_Board":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblQual.Rows[7].Cells.Add(oTD);
break;
case "12th_Passing_Certificate":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblQual.Rows[8].Cells.Add(oTD);
break;
case "12th_Examination_Seat_Number":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblQual.Rows[9].Cells.Add(oTD);
break;
}
}
}
//divQual.Controls.Add(TblQual);
#endregion
#region Social Reservation
//
//Add columns to table Social Reservation
//
oTD = null;
foreach (DataRow Row in studDt.Rows)
{
foreach (DataColumn Field in studDt.Columns)
{
switch (Field.ColumnName)
{
case "Social_Reservations":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblSocRes.Rows[0].Cells.Add(oTD);
break;
case "Domicile_of_State":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblSocRes.Rows[1].Cells.Add(oTD);
break;
case "Category":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblSocRes.Rows[2].Cells.Add(oTD);
break;
case "Reserved_Category":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblSocRes.Rows[3].Cells.Add(oTD);
break;
case "Caste":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblSocRes.Rows[4].Cells.Add(oTD);
break;
case "Admitted_Under_Category":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblSocRes.Rows[5].Cells.Add(oTD);
break;
case "Physically_Challenged":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblSocRes.Rows[6].Cells.Add(oTD);
break;
case "Annual_Income_of_Guardian":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblSocRes.Rows[7].Cells.Add(oTD);
break;
case "Occupation_of_Guardian":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblSocRes.Rows[8].Cells.Add(oTD);
break;
}
}
}
//divSocRes.Controls.Add(TblSocRes);
#endregion
#region Course Profile
//
//Add columns to table Course
//
oTD = null;
foreach (DataRow Row in studDt.Rows)
{
foreach (DataColumn Field in studDt.Columns)
{
switch (Field.ColumnName)
{
case "Course":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Attributes.Add("style", "padding:0px;");
string[] ArrStudID = Row["Student_ID"].ToString().Split('-');
CourseProfile objCourseProfile = (CourseProfile)LoadControl("CourseProfile.ascx");
objCourseProfile.UniID = ArrStudID[0];
objCourseProfile.Year = ArrStudID[1];
objCourseProfile.StudentID = ArrStudID[2];
oTD.Controls.Add(objCourseProfile);
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblCourse.Rows[0].Cells.Add(oTD);
break;
}
}
}
#endregion
#region College Profile
//
//Add columns to table College
//
oTD = null;
foreach (DataRow Row in studDt.Rows)
{
foreach (DataColumn Field in studDt.Columns)
{
switch (Field.ColumnName)
{
case "College":
oTD = new TableCell();
oTD.CssClass = "clOff";
oTD.Attributes.Add("style", "padding:0px;");
string[] ArrStudID = Row["Student_ID"].ToString().Split('-');
CollegeProfile objCollegeProfile = (CollegeProfile)LoadControl("CollegeProfile.ascx");
objCollegeProfile.UniID = ArrStudID[0];
objCollegeProfile.Year = ArrStudID[1];
objCollegeProfile.StudentID = ArrStudID[2];
oTD.Controls.Add(objCollegeProfile);
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TblCollege.Rows[0].Cells.Add(oTD);
break;
}
}
}
#endregion
#region Action
//
//Add columns to table Action
//
oTD = null;
foreach (DataRow Row in studDt.Rows)
{
foreach (DataColumn Field in studDt.Columns)
{
switch (Field.ColumnName)
{
case "Delete_Duplicate":
oTD = new TableCell();
oTD.CssClass = "clOff";
btDel = new Button();
btDel.CssClass = "profileBut";
btDel.Text = "Delete Profile";
btDel.ID = "Del-" + Row["Student_ID"].ToString();
btDel.Click += new EventHandler(btDel_Click);
btDel.Attributes.Add("onclick", "javascript:return ValidateDelete(this);");
oTD.Controls.Add(btDel);
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
oTD.HorizontalAlign = HorizontalAlign.Center;
oTD.VerticalAlign = VerticalAlign.Middle;
TblAction.Rows[0].Cells.Add(oTD);
break;
}
}
}
#endregion
}
/// <summary>
/// Rendering profile details
/// </summary>
/// <param name="studDt"></param>
private void RenderTable(DataTable studDt)
{
#region "Reset Table"
for (int it = 0; it < TBLSummery.Rows.Count; it++)
{
int iCellCount = TBLSummery.Rows[it].Cells.Count;
for (int i = iCellCount - 1; i >= 1; i--)
{
TBLSummery.Rows[it].Cells.RemoveAt(i);
}
}
#endregion
#region Summary
//
//Add columns to table Summary
//
TableCell oTD = null;
oTD = new TableCell();
oTD.CssClass = "clOn";
oTD.Text = "<div></div>";
oTD.Attributes.Add("id", "divNote");
TBLSummery.Rows[0].Cells.Add(oTD);
oTD = new TableCell();
oTD.CssClass = "clOn";
oTD.Text = "<div></div>";
oTD.Attributes.Add("id", "divNote");
TBLSummery.Rows[0].Cells.Add(oTD);
foreach (DataRow Row in studDt.Rows)
{
foreach (DataColumn Field in studDt.Columns)
{
switch (Field.ColumnName)
{
case "PRN":
oTD = new TableCell();
oTD.CssClass = "clOn";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TBLSummery.Rows[1].Cells.Add(oTD);
break;
//case "Eligibility Form No":
// oTD = new TableCell();
// oTD.CssClass = "clOn";
// oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
// oTD.Attributes.Add("id", Row["Student_ID"].ToString());
// TBLSummery.Rows[1].Cells.Add(oTD);
// break;
case "Student_Name":
oTD = new TableCell();
oTD.CssClass = "clOn";
oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TBLSummery.Rows[2].Cells.Add(oTD);
break;
case "Photosign":
oTD = new TableCell();
oTD.CssClass = "clOn";
oTD.VerticalAlign = VerticalAlign.Middle;
System.Web.UI.WebControls.Image oPhoto = new System.Web.UI.WebControls.Image();
oPhoto.ID = "imgPhoto" + Row["Student_ID"].ToString();
// oPhoto.ImageUrl = "PhotoSignHandler.ashx?img=Photo&UniID=" + Convert.ToString(Row["pk_Uni_ID"]) + "&StudentID=" + Convert.ToString(Row["pk_Student_ID"]) + "&YearID=" + Convert.ToString(Row["pk_Year"]);
oPhoto.CssClass = "cssImage";
System.Web.UI.WebControls.Image oSign = new System.Web.UI.WebControls.Image();
oSign.ID = "imgSign" + Row["Student_ID"].ToString();
//oSign.ImageUrl = "PhotoSignHandler.ashx?img=Sign&UniID=" + Convert.ToString(Row["pk_Uni_ID"]) + "&StudentID=" + Convert.ToString(Row["pk_Student_ID"]) + "&YearID=" + Convert.ToString(Row["pk_Year"]);
if (oCDNKeys != null)
{
objCDN = new clsCDN(oCDNKeys.PhotoSignKey);
sPathExists = !string.IsNullOrEmpty(Convert.ToString(Row["PhotoPath"])) ? "Y" : "N";
oPhoto.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(Row["PhotoPath"]), sPathExists, "P");
sPathExists = !string.IsNullOrEmpty(Convert.ToString(Row["SignPath"])) ? "Y" : "N";
oSign.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(Row["SignPath"]), sPathExists, "S");
}
oSign.CssClass = "cssImage";
oTD.Controls.Add(oPhoto);
oTD.Controls.Add(oSign);
oTD.Attributes.Add("id", Row["Student_ID"].ToString());
TBLSummery.Rows[3].Cells.Add(oTD);
break;
//case "College Name":
// oTD = new TableCell();
// oTD.CssClass = "clOn";
// oTD.Text = "<div>" + Convert.ToString(Row[Field.ColumnName]) + "</div>";
// oTD.Attributes.Add("id", Row["Student_ID"].ToString());
// TBLSummery.Rows[4].Cells.Add(oTD);
// break;
}
}
}
#endregion
}
public void FetchStudentDetails()
{
DataSet ds = new DataSet();
string[] RefIDarr = new string[4];
RefIDarr = ElgFormNo.Split('-');
try
{
ds = elgDBAccess.IA_Fetch_Student_Details_BulkInsert(hidUniID.Value, hidpkStudentID.Value, hidpkYear.Value, Classes.clsGetSettings.UniversityID.ToString(), RefIDarr[1], RefIDarr[2], RefIDarr[3], hidFacID.Value, hidCrID.Value, hidMoLrnID.Value, hidPtrnID.Value, hidBrnID.Value, hidCrPrID.Value);
if (ds.Tables[2].Rows.Count > 0)
{
lblNameAsMarksheet.Text = ds.Tables[2].Rows[0]["Name_QualExamMarkSheet"].ToString();
lblNameOfStudent.Text = ds.Tables[2].Rows[0]["Last_Name"].ToString() + " " + ds.Tables[2].Rows[0]["First_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Middle_Name"].ToString();
lblMothersMaidenName.Text = ds.Tables[2].Rows[0]["Mother_Last_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Mother_First_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Mother_Middle_Name"].ToString();
lblFathersName.Text = ds.Tables[2].Rows[0]["Father_Last_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Father_First_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Father_Middle_Name"].ToString();
if (ds.Tables[2].Rows[0]["Changed_Name_Flag"].ToString() == "1")
{
lblPreviousName.Text = ds.Tables[2].Rows[0]["Prev_Last_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Prev_First_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Prev_Middle_Name"].ToString();
}
lblGender.Text = ds.Tables[2].Rows[0]["Gender_Desc"].ToString();
lblDOB.Text = ds.Tables[2].Rows[0]["DOB"].ToString(); //Gender,Date_of_Birth,Changed_Name_Reason
lblNationality.Text = ds.Tables[2].Rows[0]["Nationality"].ToString();
}
if (ds.Tables[3].Rows.Count > 0)
{
lblDomicileState.Text = ds.Tables[3].Rows[0]["Domicile_of_State"].ToString();
lblResvCategory.Text = ds.Tables[3].Rows[0]["Category"].ToString();
if (ds.Tables[3].Rows[0]["Category_Flag"].ToString() == "1")
{
if (ds.Tables[3].Rows[0]["ResvCategory"].ToString() != "")
{
lblResvCategory.Text += " (" + ds.Tables[3].Rows[0]["ResvCategory"].ToString();
if (ds.Tables[3].Rows[0]["SubCaste"].ToString() != "")
{
lblResvCategory.Text += " - " + ds.Tables[3].Rows[0]["SubCaste"].ToString();
}
lblResvCategory.Text += ")";
}
}
if (ds.Tables[3].Rows[0]["Physically_Challenged_Flag"].ToString() == "1")
{
lblPhyChlngd.Text = ds.Tables[3].Rows[0]["PhysicallyChallenged"].ToString();
}
else
{
lblPhyChlngd.Text = " -";
}
lblAdmittedCategory.Text = ds.Tables[3].Rows[0]["AdmittedCategory"].ToString();
lblGuardianincome.Text = "Rs. " + ds.Tables[3].Rows[0]["Guardian_Annual_Income"].ToString();
lblGuardianOccupation.Text = ds.Tables[3].Rows[0]["GuardOccupation"].ToString();
}
if (ds.Tables[4].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[4].Rows.Count; i++)
{
lblSocResv.Text += ds.Tables[4].Rows[i]["SocialReservation_Description"].ToString();
if (i < (ds.Tables[4].Rows.Count - 1))
{
lblSocResv.Text += ", ";
}
}
}
if (ds.Tables[5].Rows.Count > 0)
{
DGQualification1.DataSource = ds.Tables[5];
DGQualification1.DataBind();
}
if (ds.Tables[6].Rows.Count > 0)
{
DGSubmittedDocs1.DataSource = ds.Tables[6];
DGSubmittedDocs1.DataBind();
}
else
{
lblDoctext.Text = "No documents submitted.";
lblDoctext.Visible = true;
}
if (ds.Tables[0].Rows.Count > 0)
{
lblInstName.Text = ds.Tables[0].Rows[0]["RefInstName"].ToString();
lblEligibilityFormNo.Text = hidElgFormNo.Value;
TblAdmission.Style.Remove("display");
TblAdmission.Style.Add("display", "block");
divTblElgFormdetails.Style.Remove("display");
divTblElgFormdetails.Style.Add("display", "block");
lblAdmissionDate.Text = ds.Tables[0].Rows[0]["Admission_Date"].ToString();
lblAppFormNo.Text = ds.Tables[0].Rows[0]["Admission_Form_No"].ToString();
lblCourse.Text = ds.Tables[0].Rows[0]["Course"].ToString();// +"-" + ds.Tables[0].Rows[0]["CrPrAbbr"].ToString();
}
//Modified as per Req 102312 By Deepak Omar
//Image1.ImageUrl = dtRow["Download_Path"].ToString() + ds.Tables[2].Rows[0]["PhotoPath"].ToString();//"ELGV2_BulkProcess__3.aspx?img=PR&sStudentDetails=" + hidpkYear.Value + "-" + hidpkStudentID.Value;
Image1.Visible = true;
//Image2.ImageUrl = dtRow["Download_Path"].ToString() + ds.Tables[2].Rows[0]["SignPath"].ToString();//"ELGV2_BulkProcess__3.aspx?img=SR&sStudentDetails=" + hidpkYear.Value + "-" + hidpkStudentID.Value;
Image2.Visible = true;
if (oCDNKeys != null)
{
objCDN = new clsCDN(oCDNKeys.PhotoSignKey);
sPathExists = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[2].Rows[0]["PhotoPath"])) ? "Y" : "N";
Image1.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(ds.Tables[2].Rows[0]["PhotoPath"]), sPathExists, "P");
sPathExists = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[2].Rows[0]["SignPath"])) ? "Y" : "N";
Image2.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(ds.Tables[2].Rows[0]["SignPath"]), sPathExists, "S");
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
throw new Exception(ex.Message);
}
ds.Dispose();
}
public void FetchStudentDetails()
{
// Session["ElgFormNo"] = null;
// Session["pk_Year"] = null;
// Session["pk_Student_ID"]=null;
// Session["pk_CrMoLrnPtrn_ID"]=null;
lblEligibilityFormNo.Text = hidElgFormNo.Value.ToString();
//lblEligibilityFormNo.Text = Session["ElgFormNo"].ToString();
//string ElgFormNo = Session["ElgFormNo"].ToString();
string ElgFormNo = hidElgFormNo.Value.ToString();
RefIDarr = ElgFormNo.Split('-'); // UniID = RefIDarr[0], InstID = RefIDarr[1],Year = RefIDarr[2], StudID = RefIDarr[3]
try
{
//ds=clsEligibilityDBAccess.Fetch_REG_Pending_Student_Details(Convert.ToInt32(ConfigurationSettings.AppSettings["UniversityID"].ToString()),Convert.ToInt32(Session["pk_Year"].ToString()),Convert.ToInt32(Session["pk_Student_ID"].ToString()),Convert.ToInt32(RefIDarr[1].ToString()),Convert.ToInt32(RefIDarr[0].ToString()),Convert.ToInt32(RefIDarr[2].ToString()),Convert.ToInt32(RefIDarr[3].ToString()),Convert.ToInt32(Session["pk_CrMoLrnPtrn_ID"].ToString()));
ds = clsEligibilityDBAccess.Fetch_REG_Pending_Student_Details(Convert.ToInt32(Classes.clsGetSettings.UniversityID.ToString()), Convert.ToInt32(hidpkYear.Value), Convert.ToInt32(hidpkStudentID.Value), Convert.ToInt32(RefIDarr[0].ToString()), Convert.ToInt32(RefIDarr[1].ToString()), Convert.ToInt32(RefIDarr[2].ToString()), Convert.ToInt32(RefIDarr[3].ToString()), Convert.ToInt32(hidpkFacID.Value), Convert.ToInt32(hidpkCrID.Value), Convert.ToInt32(hidpkMoLrnID.Value), Convert.ToInt32(hidpkPtrnID.Value), Convert.ToInt32(hidpkCrPrDetailsID.Value), Convert.ToInt32(hidpkBrnID.Value));
//ds=clsEligibilityDBAccess.Fetch_REG_Pending_Student_Details(179,1996,100,179,1996,1,1,1);
if (ds.Tables[0].Rows.Count > 0)
{
lblInstName.Text = ds.Tables[0].Rows[0]["RefInstName"].ToString();
lblPendingReason.Text = FormatReason(ds.Tables[0].Rows[0]["PendingReason"].ToString());
lblAdmissionDate.Text = ds.Tables[0].Rows[0]["Admission_Date"].ToString();
lblAppFormNo.Text = ds.Tables[0].Rows[0]["Admission_Form_No"].ToString();
//lblCourse.Text=ds.Tables[0].Rows[0]["Course"].ToString()+" ("+ds.Tables[0].Rows[0]["CoursePart"].ToString()+")";
//lblFaculty.Text = ds.Tables[0].Rows[0]["Faculty"].ToString();
lblCourse.Text = ds.Tables[0].Rows[0]["Course"].ToString(); //+ "-" + ds.Tables[0].Rows[0]["CrPrAbbr"].ToString();
hidElgFlag.Value = ds.Tables[0].Rows[0]["Eligibility"].ToString();
hidSMSCrAbbr.Value = ds.Tables[0].Rows[0]["CrAbbr"].ToString();
hidAcademicYr.Value = ds.Tables[0].Rows[0]["Year"].ToString();
if (hidSMSCrAbbr.Value.Length > 9)
{
hidSMSCrAbbr.Value = hidSMSCrAbbr.Value.Substring(0, 8);
}
}
if (ds.Tables[1].Rows.Count > 0)
{
lblPapers.Text = "<table cellSpacing='0' cellPadding='3' width='100%' align='center' style='BORDER-TOP: silver 1px solid; BORDER-LEFT: silver 1px solid;'>"; //border='1px'
int j = 0;
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
if (j == 0)
{
lblPapers.Text += "<tr>"; //class='rfont'
}
lblPapers.Text += "<td style='BORDER-RIGHT: silver 1px solid; BORDER-BOTTOM: silver 1px solid'>" + ds.Tables[1].Rows[i]["PaperCode"].ToString() + "</td>";
lblPapers.Text += "<td style='BORDER-RIGHT: silver 1px solid; BORDER-BOTTOM: silver 1px solid'>" + ds.Tables[1].Rows[i]["PaperName"].ToString() + "</td>";
++j;
if (j == 3)
{
lblPapers.Text += "</tr>";
j = 0;
}
}
lblPapers.Text += "</table>";
}
if (ds.Tables[2].Rows.Count > 0)
{
lblPermRegNo.Text = ds.Tables[2].Rows[0]["PRN"].ToString();
if (lblPermRegNo.Text == "" || lblPermRegNo.Text == null)
{
lblPermRegNo.Text = "Not Generated";
}
lblAlumni.Text = ds.Tables[2].Rows[0]["Alumini_Flag"].ToString();
lblNameOfStudent.Text = ds.Tables[2].Rows[0]["Last_Name"].ToString() + " " + ds.Tables[2].Rows[0]["First_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Middle_Name"].ToString();
lblNameAsMarksheet.Text = ds.Tables[2].Rows[0]["Name_QualExamMarkSheet"].ToString();
lblMothersMaidenName.Text = ds.Tables[2].Rows[0]["Mother_Last_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Mother_First_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Mother_Middle_Name"].ToString();
lblFathersName.Text = ds.Tables[2].Rows[0]["Father_Last_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Father_First_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Father_Middle_Name"].ToString();
hidSMSFirstName.Value = ds.Tables[2].Rows[0]["First_Name"].ToString();
if (hidSMSFirstName.Value.Length > 15)
{
hidSMSFirstName.Value = hidSMSFirstName.Value.Substring(0, 14);
}
if (ds.Tables[2].Rows[0]["Changed_Name_Flag"].ToString() == "1")
{
lblPreviousName.Text = ds.Tables[2].Rows[0]["Prev_Last_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Prev_First_Name"].ToString() + " " + ds.Tables[2].Rows[0]["Prev_Middle_Name"].ToString();
}
lblGender.Text = ds.Tables[2].Rows[0]["Gender_Desc"].ToString();
lblDOB.Text = ds.Tables[2].Rows[0]["DOB"].ToString(); //Gender,Date_of_Birth,Changed_Name_Reason
lblNationality.Text = ds.Tables[2].Rows[0]["Nationality"].ToString();
hidSMSMobileNumber.Value = ds.Tables[2].Rows[0]["Mobile_Number"].ToString();
hidUniAbbrv.Value = ds.Tables[2].Rows[0]["UniAbbr"].ToString().ToUpper();
}
if (ds.Tables[3].Rows.Count > 0)
{
lblDomicileState.Text = ds.Tables[3].Rows[0]["Domicile_of_State"].ToString();
lblResvCategory.Text = ds.Tables[3].Rows[0]["Category"].ToString();
if (ds.Tables[3].Rows[0]["Category_Flag"].ToString() == "1")
{
if (ds.Tables[3].Rows[0]["ResvCategory"].ToString() != "")
{
lblResvCategory.Text += " (" + ds.Tables[3].Rows[0]["ResvCategory"].ToString();
if (ds.Tables[3].Rows[0]["SubCaste"].ToString() != "")
{
lblResvCategory.Text += " - " + ds.Tables[3].Rows[0]["SubCaste"].ToString();
}
lblResvCategory.Text += ")";
}
}
if (ds.Tables[3].Rows[0]["Physically_Challenged_Flag"].ToString() == "1")
{
lblPhyChlngd.Text = ds.Tables[3].Rows[0]["PhysicallyChallenged"].ToString();
}
else
{
lblPhyChlngd.Text = " -";
}
lblAdmittedCategory.Text = ds.Tables[3].Rows[0]["AdmittedCategory"].ToString();
lblGuardianincome.Text = "Rs. " + ds.Tables[3].Rows[0]["Guardian_Annual_Income"].ToString();
lblGuardianOccupation.Text = ds.Tables[3].Rows[0]["GuardOccupation"].ToString();
}
if (ds.Tables[4].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[4].Rows.Count; i++)
{
lblSocResv.Text += ds.Tables[4].Rows[i]["SocialReservation_Description"].ToString();
if (i < (ds.Tables[4].Rows.Count - 1))
{
lblSocResv.Text += ", ";
}
}
}
if (ds.Tables[5].Rows.Count > 0)
{
DGQualification1.DataSource = ds.Tables[5];
DGQualification1.DataBind();
}
if (ds.Tables[6].Rows.Count > 0)
{
DGSubmittedDocs1.DataSource = ds.Tables[6];
DGSubmittedDocs1.DataBind();
}
//IF there are any Matching Records
//Commented By deepti on 10/09/2007 to supress the functionality of
//displaying match records for different Courses and Institutes for given student
/*
* HTML code to show matching records,removed from aspx page as it was giving error when commented
* <div id="divMatchingRecords" style="DISPLAY: block" runat="server"><br>
* <asp:label id="lblGridName" runat="server" Width="100%" CssClass="GridHeadingM" Height="18px"> Eligiblility Pending Student's Other Course(s) Details</asp:label><asp:datagrid id="DGMatchgCourseDetails" runat="server" Width="100%" BorderColor="#336699" BorderWidth="1px"
* AutoGenerateColumns="False" PageSize="5" BorderStyle="Solid">
* <ItemStyle CssClass="GridData2"></ItemStyle>
* <HeaderStyle Font-Bold="True" HorizontalAlign="Center" BorderWidth="1px" ForeColor="White" BorderStyle="Solid"
* BorderColor="White" CssClass="GridHeading"></HeaderStyle>
* <Columns>
* <asp:BoundColumn ReadOnly="True" HeaderText="Sr. No."></asp:BoundColumn>
* <asp:BoundColumn DataField="Course" HeaderText="Course"></asp:BoundColumn>
* <asp:BoundColumn DataField="InstituteName" HeaderText="Institute Name"></asp:BoundColumn>
* <asp:BoundColumn DataField="EligibilityStatus" HeaderText="Eligibility Status"></asp:BoundColumn>
* <asp:BoundColumn DataField="CourseStatus" HeaderText="Course Status"></asp:BoundColumn>
* </Columns>
* <PagerStyle Mode="NumericPages"></PagerStyle>
* </asp:datagrid>
* </div>
*/
/*if(ds.Tables[7].Rows.Count>0)
* {
*
* divMatchingRecords.Style.Add("display","block");
* DGMatchgCourseDetails.DataSource=ds.Tables[7];
* DGMatchgCourseDetails.DataBind();
* }
* else
* {
*
* divMatchingRecords.Style.Add("display","none");
* }*/
hidDocCnt.Value = ds.Tables[6].Rows.Count.ToString();
//Image1.ImageUrl = dtRow["Download_Path"].ToString() + ds.Tables[2].Rows[0]["PhotoPath"].ToString();//"ELGV2_ResolvePending__3.aspx?img=PR&sStudentDetails=" + hidpkYear.Value + "-" + hidpkStudentID.Value;
Image1.Visible = true;
Image2.Visible = true;
if (oCDNKeys != null)
{
objCDN = new clsCDN(oCDNKeys.PhotoSignKey);
sPathExists = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[2].Rows[0]["PhotoPath"])) ? "Y" : "N";
Image1.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(ds.Tables[2].Rows[0]["PhotoPath"]), sPathExists, "P");
sPathExists = !string.IsNullOrEmpty(Convert.ToString(ds.Tables[2].Rows[0]["SignPath"])) ? "Y" : "N";
Image2.ImageUrl = objCDN.PhotoSignDisplay(Convert.ToString(ds.Tables[2].Rows[0]["SignPath"]), sPathExists, "S");
}
divStudentDetails.Style.Add("Display", "block");
//For Proper Display Message of Eligibility Decision
if (hidElgFlag.Value == "1")
{
lblProfileHeading.Text = "Candidate " + ds.Tables[2].Rows[0]["First_Name"].ToString() + " is Marked Eligible for the " + lblCr.Text + " : " + ds.Tables[0].Rows[0]["CrPrAbbr"].ToString();
divPendingReason.Visible = false;
divReason.Attributes.Add("style", "display:none");
}
else if (hidElgFlag.Value == "2")
{
lblProfileHeading.Text = "Candidate " + ds.Tables[2].Rows[0]["First_Name"].ToString() + " is Marked Not-Eligible for the " + lblCr.Text + " : " + ds.Tables[0].Rows[0]["CrPrAbbr"].ToString();
lblEligibilityReason.Text = "Not-Eligible due to following reason(s)";
divPendingReason.Visible = true;
rbDefaulter.Checked = true;
divReason.Attributes.Add("style", "display:inline");
divOldReason.Attributes.Add("style", "display:inline");
//tbReason.Text = ds.Tables[0].Rows[0]["PendingReason"].ToString();
tbOldReason.Text = FormatReason(ds.Tables[0].Rows[0]["PendingReason"].ToString()).Replace("<br/>", Environment.NewLine);;
}
else if (hidElgFlag.Value == "3")
{
lblProfileHeading.Text = "Candidate " + ds.Tables[2].Rows[0]["First_Name"].ToString() + " is Marked Pending for the " + lblCr.Text + " : " + ds.Tables[0].Rows[0]["CrPrAbbr"].ToString();
lblEligibilityReason.Text = "Eligibility Kept Pending due to following reason(s)";
divPendingReason.Visible = true;
rbPending.Checked = true;
divReason.Attributes.Add("style", "display:inline");
divOldReason.Attributes.Add("style", "display:inline");
//tbReason.Text = ds.Tables[0].Rows[0]["PendingReason"].ToString();
tbOldReason.Text = FormatReason(ds.Tables[0].Rows[0]["PendingReason"].ToString()).Replace("<br/>", Environment.NewLine);;
}
//lblGridName.Text ="Candidate "+ds.Tables[2].Rows[0]["First_Name"].ToString() +"'s Matching Other Course Details ";
if (ds.Tables[0].Rows.Count > 0)
{
hidUniID.Value = Classes.clsGetSettings.UniversityID.ToString();
}
lblPageHead.Text = "Resolve Pending Eligibility";
lblSubHeader.Text = " for " + InstRep.InstituteName(hidUniID.Value, hidInstID.Value);
lblStudName.Text = "<br><b> for student <i>" + lblNameOfStudent.Text + "</i> for " + lblCr.Text + " " + ds.Tables[0].Rows[0]["CrPrAbbr"].ToString() + "</b>";
}
catch (Exception ex)
{
throw (ex);
}
finally
{
ds.Dispose();
}
}
