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