protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { if (Session[clsConstant.TOKEN] == null) { UrlParameterPasser urlWrapper = new UrlParameterPasser(); urlWrapper["pageaccesserr"] = "1"; urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx"; urlWrapper.PassParameters(); } if (Utility.CheckAccess("DisbursementAchievementReport") == false) { UrlParameterPasser urlWrapper = new UrlParameterPasser(); urlWrapper["pageaccesserr"] = "1"; //urlWrapper.Url = "../Logout.aspx"; urlWrapper.Url = "../DocumentLogSystem/DashBoard.aspx"; urlWrapper.PassParameters(); } if (!Convert.ToBoolean(Session[clsConstant.SESS_VIEWTYPE])) { //this.MakeReadOnly(this.Controls); } objCommon = new CommonFunction(); disbReport = new DisbursementReport(); drpLoanNumber.DataSource = objCommon.getDropDownList(clsConstant.SP_GET_LOAN, null); drpLoanNumber.DataTextField = "DisplayFieldText"; drpLoanNumber.DataValueField = "ValueFieldText"; drpLoanNumber.DataBind(); drpYear.DataSource = objCommon.getDropDownList(clsConstant.SP_GET_YEAR, null); drpYear.DataTextField = "DisplayFieldText"; drpYear.DataValueField = "ValueFieldText"; drpYear.DataBind(); drpSector.DataSource = objCommon.getDropDownList(clsConstant.SP_GET_DOC_CATEGORY, null); drpSector.DataTextField = "DisplayFieldText"; drpSector.DataValueField = "ValueFieldText"; drpSector.DataBind(); /*******Comment By Nitin 18 July 2012**********/ //dt = new DataTable(); //dt = disbReport.BindGridview(); //grdDisbursementAchievementReport.DataSource = dt; //grdDisbursementAchievementReport.DataBind(); //Session[clsConstant.SESS_TABLE] = dt; GridViewBind(); } } catch (Exception ex) { logger.Error(ex); } }
private void dataBind() { dt = new DataTable(); disbReport = new DisbursementReport(); dt = disbReport.DisbursementReportSearch(0, Convert.ToInt32(drpLoanNumber.SelectedValue), Convert.ToInt32(drpSector.SelectedValue), Convert.ToInt32(drpYear.SelectedValue)); dt = getTableValue(dt); grdDisbursementAchievementReport.DataSource = dt; grdDisbursementAchievementReport.DataBind(); Session[clsConstant.SESS_TABLE] = dt; }
protected void grdDisbursementAchievementReport_PageIndexChanging(object sender, GridViewPageEventArgs e) { disbReport = new DisbursementReport(); try { grdDisbursementAchievementReport.PageIndex = e.NewPageIndex; dataBind(); } catch (Exception ex) { logger.Error(ex); } }
public ActionResult PrintDisbursementPdf(IEnumerable <int> disbId) { Disbursement targetDisbursement = _disbursementDAO.FindById(disbId.First()); List <DisbursementItem> targetList = targetDisbursement.DisbursementItems.ToList(); // Get Dep Rep Employee depRep = targetDisbursement.Department.Employees .Where(emp => emp.IdRole == 3) .FirstOrDefault(); DisbursementReport disbursementReport = new DisbursementReport(); byte[] abytes = disbursementReport.PrepareReport(targetDisbursement, targetList, depRep); String filename = $"{targetDisbursement.Date.ToString("yyyyMMdd")}_Disbursement_{targetDisbursement.IdDisbursement}.pdf"; return(File(abytes, "application/pdf", filename)); }
protected void GridViewBind() { dt = new DataTable(); disbReport = new DisbursementReport(); dt = disbReport.BindGridview(); dt = getTableValue(dt); grdDisbursementAchievementReport.DataSource = dt; grdDisbursementAchievementReport.DataBind(); Session[clsConstant.SESS_TABLE] = dt; if (!IsPostBack) { //info.AddMergedColumns(new int[] { 4, 5, 6, 7 }, "<b>Target</b>"); //info.AddMergedColumns(new int[] { 8, 9, 10, 11 }, "<b>Actual</b>"); info.AddMergedColumns(new int[] { 4, 5 }, "<b>Quarter 1</b>"); info.AddMergedColumns(new int[] { 6, 7 }, "<b>Quarter 2</b>"); info.AddMergedColumns(new int[] { 8, 9 }, "<b>Quarter 3</b>"); info.AddMergedColumns(new int[] { 10, 11 }, "<b>Quarter 4</b>"); } }