public void filldocuments()
{
submitteddocs.Tables.Add("submitteddocs");
submitteddocs.Tables["submitteddocs"].Columns.Add("DocCert_Desc");
submitteddocs.Tables["submitteddocs"].Columns.Add("pk_DocCert_ID");
submitteddocs.Tables["submitteddocs"].Columns.Add("ReceivedByUniversity");
DataRow dr = submitteddocs.Tables["submitteddocs"].NewRow();
dr["DocCert_Desc"] = "SSC Certificate";
dr["pk_DocCert_ID"] = "11";
dr["ReceivedByUniversity"] = "Recvd (valid)";
submitteddocs.Tables["submitteddocs"].Rows.Add(dr);
dr = submitteddocs.Tables["submitteddocs"].NewRow();
dr["DocCert_Desc"] = "HSC Certificate";
dr["pk_DocCert_ID"] = "12";
dr["ReceivedByUniversity"] = "Not Recvd";
submitteddocs.Tables["submitteddocs"].Rows.Add(dr);
DGSubmittedDocs.DataSource = submitteddocs;
DGSubmittedDocs.DataBind();
}
public void FetchStudentDetails()
{
trChangedName.Style.Add("display", "none");
//lblEligibilityFormNo.Text = Session["ElgFormNo"].ToString();
lblEligibilityFormNo.Text = hidElgFormNo.Value;
//string ElgFormNo = Session["ElgFormNo"].ToString();
string ElgFormNo = hidElgFormNo.Value;
string[] arr = new string[4];
arr = ElgFormNo.Split('-'); //UniID = arr[0], InstID = arr[1], Year = arr[2], StudID = arr[3]
ds = new DataSet();
try
{
ds = elgDBAccess.IA_Fetch_Student_Details(arr[2], UniversityPortal.clsGetSettings.UniversityID.ToString(), arr[1], arr[3]);
if (ds.Tables[0].Rows.Count > 0)
{
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() + "(" + ds.Tables[0].Rows[0]["Faculty"].ToString() + ")";
//lblFaculty.Text = ds.Tables[0].Rows[0]["Faculty"].ToString();
lblInstName.Text = ds.Tables[0].Rows[0]["InstName"].ToString();
hidCrMoLrnPtrnID.Value = ds.Tables[0].Rows[0]["pk_CrMoLrnPtrn_ID"].ToString();
}
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)
{
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();
//Giving Title
lblStudName.Text = "<br><b> for student " + " <i>" + lblNameOfStudent.Text + "</i>" + " for Course " + ds.Tables[0].Rows[0]["CoursePart"].ToString() + "</b>";
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();
trChangedName.Style.Add("display", "block");
}
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 = " -";
}
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)
{
DGQualification.DataSource = ds.Tables[5];
DGQualification.DataBind();
}
if (ds.Tables[6].Rows.Count > 0)
{
DGSubmittedDocs.DataSource = ds.Tables[6];
DGSubmittedDocs.DataBind();
}
else
{
lblDoctext.Text = "NO documents submitted.";
lblDoctext.Visible = true;
}
//if (ds.Tables[7].Rows.Count > 0)
//{
// DGMatchingRecords.DataSource = ds.Tables[7];
// DGMatchingRecords.DataBind();
// divMatchingRecords.Style.Add("display", "block");
//}
hidMatchingRecCount.Value = ds.Tables[7].Rows.Count.ToString();
hidDocCnt.Value = ds.Tables[6].Rows.Count.ToString();
Image1.ImageUrl = "PhotoAndSignTemp.aspx?img=PI&sElgFormNo=" + hidElgFormNo.Value;
Image1.Visible = true;
Image2.ImageUrl = "PhotoAndSignTemp.aspx?img=SI&sElgFormNo=" + hidElgFormNo.Value;
Image2.Visible = true;
divStudentDetails.Style.Add("Display", "block");
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
ds.Dispose();
}
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, 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();
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)
{
DGQualification.DataSource = ds.Tables[3];
DGQualification.DataBind();
}
if (ds.Tables[4].Rows.Count > 0)
{
DGSubmittedDocs.DataSource = ds.Tables[4];
DGSubmittedDocs.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[6].Rows.Count > 0)
{
lblInstName.Text = ds.Tables[6].Rows[0]["RefInstName"].ToString();
lblElgReason.Text = ds.Tables[6].Rows[0]["Reason"].ToString();
lblElgStatus.Text = ds.Tables[6].Rows[0]["EligibilityStatus"].ToString();
lblEligibilityFormNo.Text = ds.Tables[6].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[6].Rows[0]["Admission_Date"].ToString();
lblAppFormNo.Text = ds.Tables[6].Rows[0]["Admission_Form_No"].ToString();
//lblCourse.Text=ds.Tables[6].Rows[0]["Course"].ToString()+" ("+ds.Tables[6].Rows[0]["CoursePart"].ToString()+")";
//lblFaculty.Text = ds.Tables[6].Rows[0]["Faculty"].ToString();
//lblCourse.Text=ds.Tables[6].Rows[0]["Course"].ToString()+"-"+ds.Tables[6].Rows[0]["CoursePart"].ToString()+"("+ds.Tables[6].Rows[0]["Faculty"].ToString()+")";
lblCourse.Text = ds.Tables[6].Rows[0]["Course"].ToString() + "(" + ds.Tables[6].Rows[0]["Faculty"].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 = "PhotoAndSignTemp.aspx?img=PR&sElgFormNo=" + hidElgFormNo.Value;
Image1.Visible = true;
Image2.ImageUrl = "PhotoAndSignTemp.aspx?img=SR&sElgFormNo=" + hidElgFormNo.Value;
Image2.Visible = true;
lblStudName.Text = "<br><b> for student <i>" + lblNameOfStudent.Text + "</i> for Course " + ds.Tables[6].Rows[0]["CoursePart"].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)
// lblTitle.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[] 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), 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(179,2006,55,179,2000,4,73,null);
// 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[0].Rows.Count > 0)
{
lblPermRegNo.Text = ds.Tables[0].Rows[0]["PRN"].ToString();
lblAlumni.Text = ds.Tables[0].Rows[0]["Alumini_Flag"].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();
lblStudName.Text = "<br><b> for student <i>" + lblNameOfStudent.Text + "</i> for Course " + ds.Tables[6].Rows[0]["CoursePart"].ToString() + "</b>";
}
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)
{
DGQualification.DataSource = ds.Tables[3];
DGQualification.DataBind();
}
if (ds.Tables[4].Rows.Count > 0)
{
DGSubmittedDocs.DataSource = ds.Tables[4];
DGSubmittedDocs.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[6].Rows.Count > 0)
{
lblInstName.Text = ds.Tables[6].Rows[0]["RefInstName"].ToString();
lblElgReason.Text = ds.Tables[6].Rows[0]["Reason"].ToString();
lblElgStatus.Text = ds.Tables[6].Rows[0]["EligibilityStatus"].ToString();
lblEligibilityFormNo.Text = ds.Tables[6].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[6].Rows[0]["Admission_Date"].ToString();
lblAppFormNo.Text = ds.Tables[6].Rows[0]["Admission_Form_No"].ToString();
//lblCourse.Text=ds.Tables[6].Rows[0]["Course"].ToString()+" ("+ds.Tables[6].Rows[0]["CoursePart"].ToString()+")";
//lblFaculty.Text = ds.Tables[6].Rows[0]["Faculty"].ToString();
//lblCourse.Text=ds.Tables[6].Rows[0]["Course"].ToString()+"-"+ds.Tables[6].Rows[0]["CoursePart"].ToString()+"("+ds.Tables[6].Rows[0]["Faculty"].ToString()+")";
lblCourse.Text = ds.Tables[6].Rows[0]["Course"].ToString() + "(" + ds.Tables[6].Rows[0]["Faculty"].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 = "PhotoAndSignTemp.aspx?img=PR&sElgFormNo=" + hidElgFormNo.Value;
Image1.Visible = true;
Image2.ImageUrl = "PhotoAndSignTemp.aspx?img=SR&sElgFormNo=" + hidElgFormNo.Value;
Image2.Visible = true;
//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)
// lblTitle.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()
{
// 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(UniversityPortal.clsGetSettings.UniversityID.ToString()), Convert.ToInt32(hidpkYear.Value), Convert.ToInt32(hidpkStudentID.Value), Convert.ToInt32(RefIDarr[0].ToString()), Convert.ToInt32(RefIDarr[2].ToString()), Convert.ToInt32(RefIDarr[1].ToString()), Convert.ToInt32(RefIDarr[3].ToString()), Convert.ToInt32(hidCrMoLrnPtrnID.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 = ds.Tables[0].Rows[0][5].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]["CoursePart"].ToString() + "(" + ds.Tables[0].Rows[0]["Faculty"].ToString() + ")";
hidElgFlag.Value = ds.Tables[0].Rows[0]["Eligibility"].ToString();
}
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();
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 = " -";
}
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)
{
DGQualification.DataSource = ds.Tables[5];
DGQualification.DataBind();
}
if (ds.Tables[6].Rows.Count > 0)
{
DGSubmittedDocs.DataSource = ds.Tables[6];
DGSubmittedDocs.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 = "PhotoAndSignTemp.aspx?img=PR&sElgFormNo=" + hidElgFormNo.Value;
Image1.Visible = true;
Image2.ImageUrl = "PhotoAndSignTemp.aspx?img=SR&sElgFormNo=" + hidElgFormNo.Value;
Image2.Visible = true;
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 Course : " + ds.Tables[0].Rows[0]["CoursePart"].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 Course : " + ds.Tables[0].Rows[0]["CoursePart"].ToString();
lblEligibilityReason.Text = "Not-Eligible due to following reason(s)";
divPendingReason.Visible = true;
rbDefaulter.Checked = true;
divReason.Attributes.Add("style", "display:inline");
tbReason.Text = ds.Tables[0].Rows[0][5].ToString();
btnSubmit.Enabled = true;
btnCancel.Enabled = true;
}
else if (hidElgFlag.Value == "3")
{
lblProfileHeading.Text = "Candidate " + ds.Tables[2].Rows[0]["First_Name"].ToString() + " is Marked Pending for the Course : " + ds.Tables[0].Rows[0]["CoursePart"].ToString();
lblEligibilityReason.Text = "Eligibility Kept Pending due to following reason(s)";
divPendingReason.Visible = true;
rbPending.Checked = true;
divReason.Attributes.Add("style", "display:inline");
tbReason.Text = ds.Tables[0].Rows[0][5].ToString();
btnSubmit.Enabled = true;
btnCancel.Enabled = true;
}
//lblGridName.Text ="Candidate "+ds.Tables[2].Rows[0]["First_Name"].ToString() +"'s Matching Other Course Details ";
if (ds.Tables[0].Rows.Count > 0)
{
lblStudName.Text = "<br><b> for student <i>" + lblNameOfStudent.Text + "</i> for Course " + ds.Tables[0].Rows[0]["CoursePart"].ToString() + "</b>";
}
}
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 = clsEligibilityDBAccess.REG_Get_Eligibilitystatusdetails(Convert.ToInt32(hidUniID.Value), Convert.ToInt32(hidpkYear.Value), Convert.ToInt32(hidpkStudentID.Value), Convert.ToInt32(RefIDarr[0].ToString()), Convert.ToInt32(RefIDarr[2].ToString()), Convert.ToInt32(RefIDarr[1].ToString()), Convert.ToInt32(RefIDarr[3].ToString()), hidPRN.Value);
ds = elgDBAccess.IA_Fetch_Student_Details(RefIDarr[2], UniversityPortal.clsGetSettings.UniversityID.ToString(), RefIDarr[1], RefIDarr[3]);
if (ds.Tables[2].Rows.Count > 0)
{
//lblPermRegNo.Text = ds.Tables[0].Rows[0]["PRN"].ToString();
//lblAlumni.Text = ds.Tables[0].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();
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 = " -";
}
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)
{
DGQualification.DataSource = ds.Tables[5];
DGQualification.DataBind();
}
if (ds.Tables[6].Rows.Count > 0)
{
DGSubmittedDocs.DataSource = ds.Tables[6];
DGSubmittedDocs.DataBind();
}
if (ds.Tables[0].Rows.Count > 0)
{
lblInstName.Text = ds.Tables[0].Rows[0]["InstName"].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]["CoursePart"].ToString() + "(" + ds.Tables[0].Rows[0]["Faculty"].ToString() + ")";
hidCrMoLrnPtrnID.Value = ds.Tables[0].Rows[0]["pk_CrMoLrnPtrn_ID"].ToString();
}
// hidDocCnt.Value = ds.Tables[4].Rows.Count.ToString();
Image1.ImageUrl = "PhotoAndSignTemp.aspx?img=PI&sElgFormNo=" + hidElgFormNo.Value;
Image1.Visible = true;
Image2.ImageUrl = "PhotoAndSignTemp.aspx?img=SI&sElgFormNo=" + hidElgFormNo.Value;
Image2.Visible = true;
}
catch (Exception ex)
{
Response.Write(ex.Message);
throw new Exception(ex.Message);
}
ds.Dispose();
}
