private void fillGrid() { DataTable dtTmp = new DataTable(); clsInvoiceGenration obj = new clsInvoiceGenration(); dtTmp = obj.REPV2_Invoice_Genration_MonthlyReport(ddlAcademicYear.SelectedValue, ddlAcadYear.SelectedValue, ddlMonth.SelectedValue); try { if (dtTmp != null && dtTmp.Rows.Count > 0) { dtTmp.TableName = "Table1"; DS1.Tables.Add(dtTmp.Copy()); dtTmp = null; lblErrorMsg.Visible = false; GVStat.DataSource = SummaryTables(); GVStat.DataBind(); Session["dtdata"] = SummaryTables(); DTdata = (DataTable)Session["dtdata"]; } else { lblErrorMsg.Visible = true; lblErrorMsg.Text = "Record not Forund For Selected Criteria."; tblheader.Style.Add("display", "none"); divYear.Visible = true; } } catch (Exception) { } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { hidUniID.Value = Classes.clsGetSettings.UniversityID.ToString(); DataTable dt = clsCollegeAdmissionReports.GetAcademicYear(); ViewState["AcademicYear"] = dt; //Common.fillDropDown(ddlAcademicYr, dt, "", "Year", "pk_AcademicYear_ID", "--- Select ---"); //ddlAcademicYr.SelectedIndex = 0; } //hid_AcademicYear.Value = ddlAcademicYr.SelectedItem.Text; //hid_fk_AcademicYr_ID.Value = ddlAcademicYr.SelectedValue.ToString(); hid_AcademicYear.Value = ((DropDownList)YCMOU.FindControl("ddlAcadYear")).SelectedItem.Text; hid_fk_AcademicYr_ID.Value = ((DropDownList)YCMOU.FindControl("ddlAcadYear")).SelectedValue; //hiding not required portions of user control YCMOU.IsInstituteDisplay = false; YCMOU.IsFacultyDisplay = false; YCMOU.IsCourseDisply = false; YCMOU.IsCoursePartDisply = false; YCMOU.IsCourseTermDisply = false; YCMOU.IsBranchDisply = false; YCMOU.IsReportUserAndDateDisplay = false; YCMOU.isMISRpt.Value = "Yes"; YCMOU.OnProceedClick += btnNext_Click; //user = (clsUser)Session["User"]; #region Handling Redirection from Landing page Panels if (Request.QueryString["LandingPgStats"] != null && GVStat.Rows.Count == 0) { string AcYrID = string.Empty; string AcYrText = string.Empty; if (Request.QueryString["LandingPgStats"] != null) { AcYrID = Request.QueryString["LandingPgStats"].ToString().Split('|')[0].ToString(); AcYrText = Request.QueryString["LandingPgStats"].ToString().Split('|')[1].ToString(); } DT = clsCollegeAdmissionReports.FillMISReportAll(AcYrID, null); if (DT.Rows.Count > 0) { GVStat.DataSource = DT; GVStat.DataBind(); Button3.Style.Add("display", "block"); btnPDF.Style.Add("display", "block"); divDGStat.Style.Add("display", "block"); divYCMOU.Style.Add("display", "none"); Session["MISdtData"] = DT; lblAcaYear.Text = " [Academic Year " + AcYrText + "]"; } } #endregion }
private void fillGrid() { DataTable dtTmp = new DataTable(); try { if (YCMOU.IsRegionalCenterVisible.Equals(true)) { if (((RadioButton)YCMOU.FindControl("ChkSelectedRegionalCenter")).Checked) { dtTmp = clsCollegeAdmissionReports.REPV2_AllInstitutes_uploaded_dataLessThanOneYear(hid_fk_AcademicYr_ID.Value, ((DropDownList)YCMOU.FindControl("ddlRegionalCenter")).SelectedValue); } else { dtTmp = clsCollegeAdmissionReports.REPV2_AllInstitutes_uploaded_dataLessThanOneYear(hid_fk_AcademicYr_ID.Value, null); } } else { dtTmp = clsCollegeAdmissionReports.REPV2_AllInstitutes_uploaded_dataLessThanOneYear(hid_fk_AcademicYr_ID.Value, null); } //dtTmp.TableName = "Table1"; //DS1.Tables.Add(dtTmp.Copy()); //dtTmp = null; // GVStat.DataSource = SummaryTables(); GVStat.DataSource = dtTmp; GVStat.DataBind(); // Session["dtdata"] = SummaryTables(); Session["dtdata"] = dtTmp; DTdata = (DataTable)Session["dtdata"]; } catch (Exception) { } GVStat.Visible = true; if (GVStat.Rows.Count == 0) { divDGStat.Style.Add("display", "none"); //divAcademicYr.Style.Add("display", "block"); Button3.Style.Add("display", "none"); //lblAcYrError.Text = "No Record(s) found."; // tblNoRecForAcYr.Style.Add("display", "block"); tblSelect.Style.Add("display", "none"); tblheader.Style.Add("display", "none"); } if (GVStat.Rows.Count > 0) { divYCMOU.Style.Add("display", "none"); } }
private void SortGridView(string sortExpression, string direction) { grpRow1 = "-"; index = 0; cntStud = 0; grpRow1 = "-"; index = 0; cntCol = 0; DataView dv = new DataView(DT); dv.Sort = sortExpression + direction; GVStat.DataSource = dv; GVStat.DataBind(); }
protected void btnNext_Click(object sender, EventArgs e) { string RegCentreName = string.Empty; if (YCMOU.IsRegionalCenterVisible.Equals(true)) { if (((RadioButton)YCMOU.FindControl("ChkSelectedRegionalCenter")).Checked) { RegCentreName = ((DropDownList)YCMOU.FindControl("ddlRegionalCenter")).SelectedItem.Text; lblAcaYear.Text = " Regional Center " + RegCentreName + " [Academic Year " + ((DropDownList)YCMOU.FindControl("ddlAcadYear")).SelectedItem.Text + "]"; } else { lblAcaYear.Text = " All Regional Centers [Academic Year " + ((DropDownList)YCMOU.FindControl("ddlAcadYear")).SelectedItem.Text + "]"; } } else { lblAcaYear.Text = " [Academic Year " + ((DropDownList)YCMOU.FindControl("ddlAcadYear")).SelectedItem.Text + "]"; } tblExportedDataMsg.Style.Add("display", "none"); try { if (YCMOU.IsRegionalCenterVisible.Equals(true)) { if (((RadioButton)YCMOU.FindControl("ChkSelectedRegionalCenter")).Checked) { DT = clsCollegeAdmissionReports.FillMISReportAll(((DropDownList)YCMOU.FindControl("ddlAcadYear")).SelectedValue, ((DropDownList)YCMOU.FindControl("ddlRegionalCenter")).SelectedValue); } else { DT = clsCollegeAdmissionReports.FillMISReportAll(((DropDownList)YCMOU.FindControl("ddlAcadYear")).SelectedValue, null); } } else { DT = clsCollegeAdmissionReports.FillMISReportAll(((DropDownList)YCMOU.FindControl("ddlAcadYear")).SelectedValue, null); } Session["MISdtData"] = DT; if (DT.Rows.Count > 0) { GVStat.DataSource = DT; GVStat.DataBind(); Button3.Style.Add("display", "block"); btnPDF.Style.Add("display", "block"); //divAcademicYr.Style.Add("display", "none"); //BtnSubmit.Style.Add("display", "none"); divDGStat.Style.Add("display", "block"); divYCMOU.Style.Add("display", "none"); } if (((System.Data.DataTable)Session["MISdtData"]) == null || ((System.Data.DataTable)Session["MISdtData"]).Rows.Count == 0) { //lblAcaYear.Text = " [Academic Year " + ((DropDownList)YCMOU.FindControl("ddlAcadYear")).SelectedItem.Text + "]"; lblExportedData.Text = "No records found."; tblExportedDataMsg.Style.Add("display", "block"); Session.Remove("MISdtData"); divDGStat.Style.Add("display", "none"); } if (dtCollege != null) { dtCollege = null; } } catch (Exception Ex4) { throw new Exception(Ex4.Message); } }