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