protected void DisplayEligibilityDetails()
{
Hashtable oHt = new Hashtable();
oHt["UniID"] = hidUniID.Value;
oHt["FacID"] = hidFacID.Value;
oHt["CrID"] = hidCrID.Value;
oHt["MoLrnID"] = hidMoLrnID.Value;
oHt["PtrnID"] = hidPtrnID.Value;
oHt["BrnID"] = Convert.ToString(Session["ElgBranchID"]);
oHt["CrPrDetailsID"] = Convert.ToString(Session["Elgpk_CrPr_Details_ID"]);
oHt["CrPrChID"] = Convert.ToString(Session["Elgpk_CrPrCh_ID"]);
oHt["AcademicYearID"] = Convert.ToString(Session["Elgpk_AcademicYear_ID"]);
DataTable oDtGridView = CreateDataTable();
try
{
DataTable Dt;
oCollegeAdmissionReports = new clsCollegeAdmissionReports();
Dt = oCollegeAdmissionReports.ListStudentDetailsWithPaperChangeAdvSearch(oHt);
if (Dt != null && Dt.Rows.Count > 0)
{
CreateTableForGridViewAndReport(oDtGridView, Dt);
Session["StudentDetailsWithPprChange"] = oDtGridView;
if (oDtGridView.Rows.Count > 0 && oDtGridView != null)
{
DGEligibility1.DataSource = oDtGridView;
tblDGEligibility.Style.Add("display", "block");
DGEligibility1.DataBind();
lblnorecordfound.Visible = false;
}
else
{
tblDGEligibility.Style.Add("display", "none");
Session.Remove("StudentDetailsWithPprChange");
lblnorecordfound.Visible = true;
}
}
else
{
tblDGEligibility.Style.Add("display", "none");
lblnorecordfound.Visible = true;
Session.Remove("StudentDetailsWithPprChange");
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void DisplayEligibilityDetails()
{
string selectedCriteria = "";
if (user.UserTypeCode != "2")
{
hidInstID.Value = string.Empty;
hidCollName.Value = string.Empty;
}
string collName = string.Empty;
for (int i = 0; i < cblEligibilityStatus.Items.Count; i++)
{
if (cblEligibilityStatus.Items[i].Selected)
{
selectedCriteria += cblEligibilityStatus.Items[i].Value + ",";
}
}
int l = selectedCriteria.LastIndexOf(',');
selectedCriteria = selectedCriteria.Remove(l);
if (cblEligibilityStatus.Items[0].Selected == false && cblEligibilityStatus.Items[1].Selected == false && cblEligibilityStatus.Items[2].Selected == false && cblEligibilityStatus.Items[3].Selected == false)
{
hidCriteria.Value = "0";
}
else
{
hidCriteria.Value = selectedCriteria;
}
hidCriteriaNull.Value = "";
if (cblEligibilityStatus.Items[4].Selected == true)
{
hidCriteriaNull.Value = cblEligibilityStatus.Items[4].Value;
}
hidCriteriaEligibilityRequired.Value = "";
if (cblEligibilityStatus.Items[5].Selected == false)
{
hidCriteriaEligibilityRequired.Value = "Y"; // Records with Eligibility_Required = '1'
}
else if (cblEligibilityStatus.Items[5].Selected == true)
{
hidCriteriaEligibilityRequired.Value = "N"; // All records Eligibility_Required = '1'/'2'
}
hidSortOption.Value = rblSortStudent.SelectedValue;
if (!string.IsNullOrEmpty(txtFrom.Text))
{
hidFromDate.Value = txtFrom.Text;
hidToDate.Value = txtTo.Text;
}
//setting inst id
if (hidInstID.Value.Equals(string.Empty))
{
if (ddlCollegeName.SelectedIndex != 0 || Collcode.Text != string.Empty)
{
//if (Collcode.Text != string.Empty)
//{
// dtCollege = new System.Data.DataTable();
// oclsEligibilityDBAccess = new clsEligibilityDBAccess();
// dtCollege = oclsEligibilityDBAccess.ListColleges(Convert.ToInt32(clsGetSettings.UniversityID));
// DataView odv = dtCollege.DefaultView;
// odv.RowFilter = "Inst_Code= '" + Collcode.Text + "'";
// if (odv.Count != 0)
// {
// collName = odv[0].Row.ItemArray[1].ToString();
// if ((collName + "," + odv[0].Row.ItemArray[3].ToString()).Equals(ddlCollegeName.SelectedItem.Text))
// {
// hidInstID.Value = ddlCollegeName.SelectedValue.Split('|')[0];
// hidCollName.Value = ddlCollegeName.SelectedItem.Text;
// }
// else
// {
// hidInstID.Value = odv[0].Row.ItemArray[0].ToString();
// hidCollName.Value = collName + "," + odv[0].Row.ItemArray[3].ToString();
// }
// }
//}
//if (hidInstID.Value.Equals("") || hidInstID.Value.Equals("0"))
//{
hidInstID.Value = ddlCollegeName.SelectedValue.Split('|')[0];
hidCollName.Value = ddlCollegeName.SelectedItem.Text;
//}
}
}
try
{
DataSet DS;
DS = clsEligibilityDBAccess.ProcessedEligibilityStudentsList_MUHS(hidUniID.Value, hidInstID.Value, hidFacID.Value, hidCrID.Value, hidMoLrnID.Value, hidPtrnID.Value, Convert.ToString(Session["ElgBranchID"]), Convert.ToString(Session["Elgpk_CrPr_Details_ID"]), Convert.ToString(Session["Elgpk_CrPrCh_ID"]), hid_fk_AcademicYr_ID.Value, hidSortOption.Value, hidCriteria.Value, hidCriteriaNull.Value, hidCriteriaEligibilityRequired.Value, hidFromDate.Value, hidToDate.Value);// hidStateID.Value, hidDistrictID.Value, hidTalukaID.Value, hidDOB.Value, hidFirstName.Value, hidLastName.Value, hidGender.Value);
if (DS.Tables.Count != 0)
{
DataView dv = new DataView();
dv.Table = DS.Tables[0];
Session["ViewElg_dtData"] = DS.Tables[0];
if (DS.Tables[0].Rows.Count > 0 && DS.Tables[0].ToString() != null)
{
if (ViewState["SortExpression"] != null)
{
dv.Sort = ViewState["SortExpression"].ToString() + ViewState["SortOrder"].ToString();
}
DGEligibility1.DataSource = dv;
tblDGEligibility.Style.Add("display", "block");
btnGenerate.Style.Add("display", "block");
DGEligibility1.DataBind();
divAllCriterion.Style.Add("display", "none");
lblnorecordfound.Style.Add("display", "none");
}
else
{
tblDGEligibility.Style.Add("display", "none");
btnBackDisplay.Style.Add("display", "block");
btnGenerate.Style.Add("display", "none");
lblnorecordfound.Style.Add("display", "block");
lblnorecordfound.CssClass = "errorNote";
lblnorecordfound.Text = "No Record(s) found.";
lblnorecordfound.Style.Add("display", "block");
Session.Remove("ViewElg_dtData");
}
}
else
{
tblDGEligibility.Style.Add("display", "none");
btnBackDisplay.Style.Add("display", "block");
btnGenerate.Style.Add("display", "none");
lblnorecordfound.Style.Add("display", "block");
lblnorecordfound.CssClass = "errorNote";
lblnorecordfound.Text = "No Record(s) found.";
lblnorecordfound.Style.Add("display", "block");
Session.Remove("ViewElg_dtData");
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
throw new Exception(ex.Message);
}
}
protected void btnSimpleSearch_Click(object sender, EventArgs e)
{
divYCMOU.Attributes.Add("style", "display:none");
divSimpleSearch.Attributes.Add("style", "display:block");
divDGEligibility.Style.Add("display", "block");
btnDisplay.Visible = false;
lblAdvSearch.Visible = false;
if (user.UserTypeCode == "2")
{
if (string.IsNullOrEmpty(txtPRN.Text.Trim()))
{
lblAcaYear.Text = " for " + hidCollName.Value;
}
else if (string.IsNullOrEmpty(txtElgFormNo.Text.Trim()))
{
lblAcaYear.Text = " for " + hidCollName.Value;
}
}
else
{
lblAcaYear.Text = "";
}
DataTable dt = new DataTable();
if (txtElgFormNo.Text != "")
{
Elg_FormNo = txtElgFormNo.Text.Trim();
}
else
{
Elg_FormNo = "0-0-0-0";
}
int cnt = 0;
string str = Elg_FormNo;
int pos = str.IndexOf('-');
string[] arr = new string[] { "0", "0", "0", "0" };
Regex objNotNaturalPattern = new Regex("^([0-9])$");
if (objNotNaturalPattern.IsMatch(txtPRN.Text.Trim()))
{
PRNumber = txtPRN.Text.Trim();
}
while (pos != -1)
{
str = str.Substring(pos + 1);
pos = str.IndexOf('-');
cnt++;
}
if (cnt == 3)
{
arr = new string[4];
arr = Elg_FormNo.Split('-'); //UniID = arr[0], InstID = arr[1], Year = arr[2], StudID = arr[3]
for (int i = 0; i < 4; i++)
{
if (arr[i] == "")
{
arr[i] = "0";
}
}
}
Hashtable oHt = new Hashtable();
oHt["RefUniID"] = arr[0];
oHt["RefInstID"] = arr[1];
oHt["RefStudentYear"] = arr[2];
oHt["RefStudentID"] = arr[3];
if (PRNumber == null)
{
PRNumber = txtPRN.Text.Trim();
}
oHt["PRN_number"] = PRNumber;
DataTable oDtGridView = CreateDataTable();
try
{
DataTable Dt;
oCollegeAdmissionReports = new clsCollegeAdmissionReports();
Dt = oCollegeAdmissionReports.ListStudentDetailsWithPaperChangeSimpleSearch(oHt);
if (Dt != null && Dt.Rows.Count > 0)
{
lblAcaYear.Text += " for " + Dt.Rows[0]["Course_Name"].ToString();
CreateTableForGridViewAndReport(oDtGridView, Dt);
if (oDtGridView.Rows.Count > 0 && oDtGridView != null)
{
DGEligibility1.DataSource = oDtGridView;
tblDGEligibility.Style.Add("display", "block");
DGEligibility1.DataBind();
DGEligibility1.Visible = true;
lblnorecordfound.Visible = false;
}
else
{
tblDGEligibility.Style.Add("display", "none");
Session.Remove("StudentDetailsWithPprChange");
lblnorecordfound.Visible = true;
}
if (user.UserTypeCode == "2")
{
oDtGridView.Columns.Remove("Inst_Name");
}
Session["StudentDetailsWithPprChange"] = oDtGridView;
}
else
{
tblDGEligibility.Style.Add("display", "none");
lblnorecordfound.Visible = true;
Session.Remove("StudentDetailsWithPprChange");
if (txtElgFormNo.Text == "")
{
lblnorecordfound.Text = "Student does not exist for entered " + lblPRNNomenclature.Text;
}
else
{
lblnorecordfound.Text = "Student does not exist for entered Eligibility form number";
}
lblAcaYear.Text = "";
}
}
catch (Exception ex)
{
throw ex;
}
//if (string.IsNullOrEmpty(hidInstID.Value))
//{
// lblAcaYear.Text = " for " + ddlFacDesc.SelectedItem.Text + " - " + ddlCrDesc.SelectedItem.Text + " - " + ddlCrBrnDesc.SelectedItem.Text + " - " + ddlCrPrDetailsDesc.SelectedItem.Text + " - " + ddlCrPrChDesc.SelectedItem.Text + " [Academic Year " + ddlAcademicYr.SelectedItem.Text + "]";
//}
//else
//{
// lblAcaYear.Text = " for " + hidCollName.Value + " - " + ddlFacDesc.SelectedItem.Text + " - " + ddlCrDesc.SelectedItem.Text + " - " + ddlCrBrnDesc.SelectedItem.Text + " - " + ddlCrPrDetailsDesc.SelectedItem.Text + " - " + ddlCrPrChDesc.SelectedItem.Text + " [Academic Year " + ddlAcademicYr.SelectedItem.Text + "]";
//}
}
