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 + "]"; //} }