protected void ctlPrint_Click(object sender, ImageClickEventArgs e)
{
VoTravelExpenseReport vo = ctlTravelExpenseCriteria.BindCriteria();
//StringBuilder scriptBuilder = new StringBuilder("document.location.href = 'TravelExpenseReportOutput.aspx?");
StringBuilder scriptBuilder = new StringBuilder("window.open('TravelExpenseReportOutput.aspx?");
scriptBuilder.AppendFormat("UserName={0}", UserAccount.UserName);
scriptBuilder.AppendFormat("&Company={0}", vo.CompanyID);
scriptBuilder.AppendFormat("&FromDate={0}", UIHelper.ToDateString(vo.FromDate, "dd/MM/yyyy"));
scriptBuilder.AppendFormat("&ToDate={0}", UIHelper.ToDateString(vo.ToDate, "dd/MM/yyyy"));
scriptBuilder.AppendFormat("&FromTravelDate={0}", UIHelper.ToDateString(vo.FromTravelDate, "dd/MM/yyyy"));
scriptBuilder.AppendFormat("&ToTravelDate={0}", UIHelper.ToDateString(vo.ToTravelDate, "dd/MM/yyyy"));
scriptBuilder.AppendFormat("&FromTANo={0}", vo.FromTaDocumentNo);
scriptBuilder.AppendFormat("&ToTANo={0}", vo.ToTaDocumentNo);
scriptBuilder.AppendFormat("&FromTraveller={0}", vo.FromTraveller);
scriptBuilder.AppendFormat("&ToTraveller={0}", vo.ToTraveller);
scriptBuilder.AppendFormat("&TAStatus={0}", vo.TaStatus);
scriptBuilder.Append("') ;");
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), string.Empty, scriptBuilder.ToString(), true);
}
public VoTravelExpenseReport BindCriteria()
{
VoTravelExpenseReport vo = new VoTravelExpenseReport();
vo.CompanyID = UIHelper.ParseLong(ctlCompanyField.CompanyID);
vo.FromDate = UIHelper.ParseDate(ctlFromDate.DateValue);
vo.ToDate = UIHelper.ParseDate(ctlToDate.DateValue);
vo.FromTravelDate = UIHelper.ParseDate(ctlFromTravelDate.DateValue);
vo.ToTravelDate = UIHelper.ParseDate(ctlToTravelDate.DateValue);
vo.FromTaDocumentNo = ctlFromTaNo.TaDocumentNo;
vo.ToTaDocumentNo = ctlToTaNo.TaDocumentNo;
SuUser travellerFrom = QueryProvider.SuUserQuery.FindByIdentity(UIHelper.ParseLong(ctlFromTraveller.EmployeeID));
SuUser travellerTo = QueryProvider.SuUserQuery.FindByIdentity(UIHelper.ParseLong(ctlToTraveller.EmployeeID));
vo.FromTraveller = travellerFrom == null ? string.Empty : travellerFrom.EmployeeCode;
vo.ToTraveller = travellerTo == null? string.Empty : travellerTo.EmployeeCode;
vo.TaStatus = ctlTAStatus.SelectedValue;
vo.ShowParam1 = string.Format("Company : {0}, TA Date : {1} - {2}, Travel Date : {3} - {4}, TA No. : {5} - {6}", new object[] { ctlCompanyField.CompanyCode, ctlFromDate.DateValue, ctlToDate.DateValue, ctlFromTravelDate.DateValue, ctlToTravelDate.DateValue, ctlFromTaNo.TaDocumentNo, ctlToTaNo.TaDocumentNo });
vo.ShowParam2 = string.Format("Traveller : {0} - {1}, TA Status : {2}", new object[] { vo.FromTraveller, vo.ToTraveller, ctlTAStatus.SelectedItem.Text });
return(vo);
}
protected void ctlPreview_Click(object sender, ImageClickEventArgs e)
{
TravelExpenseReport_Viewer.Visible = true;
VoTravelExpenseReport vo = ctlTravelExpenseCriteria.BindCriteria();
List <ReportParameters> rptParam = new List <ReportParameters>();
ReportParameters paramUserName = new ReportParameters();
paramUserName.Name = "UserName";
paramUserName.Value = UserAccount.UserName;
rptParam.Add(paramUserName);
ReportParameters paramCompany = new ReportParameters();
paramCompany.Name = "Company";
paramCompany.Value = vo.CompanyID == null ? "0" : vo.CompanyID.ToString();
rptParam.Add(paramCompany);
ReportParameters paramFromDate = new ReportParameters();
paramFromDate.Name = "FromDate";
paramFromDate.Value = vo.FromDate == null ? string.Empty : UIHelper.ToDateString(vo.FromDate, "dd/MM/yyyy");
rptParam.Add(paramFromDate);
ReportParameters paramToDate = new ReportParameters();
paramToDate.Name = "ToDate";
paramToDate.Value = vo.ToDate == null ? string.Empty : UIHelper.ToDateString(vo.ToDate, "dd/MM/yyyy");
rptParam.Add(paramToDate);
ReportParameters paramFromTravelDate = new ReportParameters();
paramFromTravelDate.Name = "FromTravelDate";
paramFromTravelDate.Value = vo.FromTravelDate == null ? string.Empty : UIHelper.ToDateString(vo.FromTravelDate, "dd/MM/yyyy");
rptParam.Add(paramFromTravelDate);
ReportParameters paramToTravelDate = new ReportParameters();
paramToTravelDate.Name = "ToTravelDate";
paramToTravelDate.Value = vo.ToTravelDate == null ? string.Empty : UIHelper.ToDateString(vo.ToTravelDate, "dd/MM/yyyy");
rptParam.Add(paramToTravelDate);
ReportParameters paramFromTANo = new ReportParameters();
paramFromTANo.Name = "FromTANo";
paramFromTANo.Value = vo.FromTaDocumentNo == null ? string.Empty : vo.FromTaDocumentNo;
rptParam.Add(paramFromTANo);
ReportParameters paramToTANo = new ReportParameters();
paramToTANo.Name = "ToTANo";
paramToTANo.Value = vo.ToTaDocumentNo == null ? string.Empty : vo.ToTaDocumentNo;
rptParam.Add(paramToTANo);
ReportParameters paramFromTraveller = new ReportParameters();
paramFromTraveller.Name = "FromTraveller";
paramFromTraveller.Value = vo.FromTraveller == null ? string.Empty : vo.FromTraveller.ToString();
rptParam.Add(paramFromTraveller);
ReportParameters paramToTraveller = new ReportParameters();
paramToTraveller.Name = "ToTraveller";
paramToTraveller.Value = vo.ToTraveller == null ? string.Empty : vo.ToTraveller.ToString();
rptParam.Add(paramToTraveller);
ReportParameters paramTAStatus = new ReportParameters();
paramTAStatus.Name = "TAStatus";
paramTAStatus.Value = vo.TaStatus == null ? string.Empty : vo.TaStatus;
rptParam.Add(paramTAStatus);
ReportParameters paramShowParam1 = new ReportParameters();
paramShowParam1.Name = "ShowParam1";
paramShowParam1.Value = vo.ShowParam1;
rptParam.Add(paramShowParam1);
ReportParameters paramShowParam2 = new ReportParameters();
paramShowParam2.Name = "ShowParam2";
paramShowParam2.Value = vo.ShowParam2;
rptParam.Add(paramShowParam2);
TravelExpenseReport_Viewer.InitializeReport();
TravelExpenseReport_Viewer.Parameters = rptParam;
TravelExpenseReport_Viewer.Visible = true;
TravelExpenseReport_Viewer.ShowReport();
}
