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>");
}
}
