protected void Page_Load(object sender, EventArgs e)
{
int month = int.Parse(Request["intMonth"] == null ? "0" : Request["intMonth"].ToString());
int year = int.Parse(Request["enddate"] == null ? "0" : Request["intYear"].ToString());
//Create datetime use to used to parameter values.
DateTime dt = new DateTime(year, month, 1);
DateTime startDate = dt.AddDays(14);
DateTime endDate = dt.AddMonths(-1).AddDays(15);
List <ReportParameter> rptParam = new List <ReportParameter>();
ReportParameter paramCompanyID = new ReportParameter();
paramCompanyID.ParamterName = "CompanyCode";
paramCompanyID.ParamterValue = Request["CompanyCode"] == null ? string.Empty : Request["CompanyCode"].ToString();
rptParam.Add(paramCompanyID);
ReportParameter startdate = new ReportParameter();
startdate.ParamterName = "startdate";
startdate.ParamterValue = startDate.ToString("dd/MM/yyyy");
rptParam.Add(startdate);
ReportParameter enddate = new ReportParameter();
enddate.ParamterName = "enddate";
enddate.ParamterValue = endDate.ToString("dd/MM/yyyy");
rptParam.Add(enddate);
// find report file name later
byte[] results = new FilesGenerator().GetByte(ParameterServices.ReportingURL, ParameterServices.ReportUserName, ParameterServices.ReportPassword, ParameterServices.ReportDomainName, ParameterServices.ReportFolderPath, "PayrollReport", rptParam, FilesGenerator.ExportType.PDF);
ReportHelper.FlushReport(this.Page, results, ReportHelper.ReportType.PDF);
}
protected void btnReporting_Click(object sender, EventArgs e)
{
string outputFolder = "C:\\ReportOutPutWeb";
string reportpath = "eAccountingReports";
string reportname = "TAReport";
string filesname = reportname + new Guid().ToString() + new Random(1).Next(100000).ToString();
List <ReportParameter> param = new List <ReportParameter>();
ReportParameter param1 = new ReportParameter();
param1.ParamterName = "TADocID";
param1.ParamterValue = "47";
param.Add(param1);
FilesGenerator rp = new FilesGenerator();
string reportServer = ParameterServices.ReportingURL;
string ReportUserName = ParameterServices.ReportUserName;
string ReportPassword = ParameterServices.ReportPassword;
string ReportDomainName = ParameterServices.ReportDomainName;
byte[] results = rp.GetByte(reportServer, ReportUserName, ReportPassword, ReportDomainName, reportpath, reportname, param, FilesGenerator.ExportType.PDF);
if (!Directory.Exists(outputFolder))
{
Directory.CreateDirectory(outputFolder);
}
FileStream stream = File.Create(outputFolder + "\\" + filesname + ".pdf", results.Length);
stream.Write(results, 0, results.Length);
stream.Close();
}
private void ExportSummaryExpenseReportExcel()
{
List <ReportParameter> rptParam = new List <ReportParameter>();
ReportParameter paramCompanyCode = new ReportParameter();
paramCompanyCode.ParamterName = "CompanyCode";
paramCompanyCode.ParamterValue = txtCompanyList.Text;
rptParam.Add(paramCompanyCode);
ReportParameter paramdocTypeID = new ReportParameter();
paramdocTypeID.ParamterName = "docTypeID";
paramdocTypeID.ParamterValue = ctlDropDownDocType.SelectedValue.ToString();
rptParam.Add(paramdocTypeID);
ReportParameter paramFromDocDate = new ReportParameter();
paramFromDocDate.ParamterName = "FromDocDate";
paramFromDocDate.ParamterValue = ctlFromDocDate.DateValue;
rptParam.Add(paramFromDocDate);
ReportParameter paramToDocDate = new ReportParameter();
paramToDocDate.ParamterName = "ToDocDate";
paramToDocDate.ParamterValue = ctlToDocDate.DateValue;
rptParam.Add(paramToDocDate);
// find report file name later
byte[] results = new FilesGenerator().GetByte(ParameterServices.ReportingURL, ParameterServices.ReportUserName, ParameterServices.ReportPassword, ParameterServices.ReportDomainName, ParameterServices.ReportFolderPath, "SummaryExpenseReport", rptParam, FilesGenerator.ExportType.EXCEL);
ReportHelper.FlushReportEXCEL(this.Page, results, "SummeryExpenseReport_" + DateTime.Today.ToString("MM/dd/yyyy", new CultureInfo("en-US")));
}
public byte[] GenerateReimbursementReport(string markList, string unMarkList, string pbCode, string pbName, string companyName, string username, string maxPaidDate, string minPaidDate)
{
ReimbursementReportValueObj obj = ScgeAccountingQueryProvider.SCGDocumentQuery.GetPeriodPaidDate(markList, unMarkList);
if (string.IsNullOrEmpty(minPaidDate))
{
minPaidDate = obj.MinPaidDate.HasValue ? obj.MinPaidDate.Value.ToString("MMM dd, yyyy") : string.Empty;
}
if (string.IsNullOrEmpty(maxPaidDate))
{
maxPaidDate = obj.MaxPaidDate.HasValue ? obj.MaxPaidDate.Value.ToString("MMM dd, yyyy") : string.Empty;
}
List <ReportParameter> param = new List <ReportParameter>();
ReportParameter param1 = new ReportParameter();
ReportParameter param2 = new ReportParameter();
ReportParameter param3 = new ReportParameter();
ReportParameter param4 = new ReportParameter();
ReportParameter param5 = new ReportParameter();
ReportParameter param6 = new ReportParameter();
ReportParameter param7 = new ReportParameter();
ReportParameter param8 = new ReportParameter();
param1.ParamterName = "markList";
param1.ParamterValue = markList;
param2.ParamterName = "unMarkList";
param2.ParamterValue = unMarkList;
param3.ParamterName = "pbCode";
param3.ParamterValue = pbCode;
param4.ParamterName = "companyName";
param4.ParamterValue = companyName;
param5.ParamterName = "username";
param5.ParamterValue = username;
param6.ParamterName = "maxPaidDate";
param6.ParamterValue = maxPaidDate;
param7.ParamterName = "minPaidDate";
param7.ParamterValue = minPaidDate;
param8.ParamterName = "pbName";
param8.ParamterValue = pbName;
param.Add(param1);
param.Add(param2);
param.Add(param3);
param.Add(param4);
param.Add(param5);
param.Add(param6);
param.Add(param7);
param.Add(param8);
FilesGenerator rp = new FilesGenerator();
byte[] results = rp.GetByte(ParameterServices.ReportingURL, ParameterServices.ReportUserName, ParameterServices.ReportPassword, ParameterServices.ReportDomainName, ParameterServices.ReportFolderPath, "ReimbursementReport", param, FilesGenerator.ExportType.PDF);
//byte[] results = rp.GetByte("http://172.20.56.116:81/ReportServer/ReportExecution2005.asmx", "RSeAccounting", "p@ssw0rd", "SCG-EACCOUNTING", "eAccountingReports", report.ReportName, param, FilesGenerator.ExportType.PDF);
return(results);
}
public void GenerateReport(string letterNoList)
{
List <ReportParameter> rptParam = new List <ReportParameter>();
ReportParameter paramLetterNo = new ReportParameter();
paramLetterNo.ParamterName = "LetterNo";
paramLetterNo.ParamterValue = letterNoList;
rptParam.Add(paramLetterNo);
byte[] results = new FilesGenerator().GetByte(ParameterServices.ReportingURL, ParameterServices.ReportUserName, ParameterServices.ReportPassword, ParameterServices.ReportDomainName, ParameterServices.ReportFolderPath, "MoneyBuyingRequestLetter", rptParam, FilesGenerator.ExportType.PDF);
ReportHelper.FlushReportPDF(this.Page, results, "MoneyBuyingRequestLetter");
}
protected void ctlButtonPrint_Click(object sender, EventArgs e)
{
DateTimeFormatInfo mmddFormat = new CultureInfo("en-US", false).DateTimeFormat;
if (string.IsNullOrEmpty(Calendar1.Text))
{
ValidationErrors.AddError("Export.Error", new ErrorMessage("Fromdate is required."));
}
if (string.IsNullOrEmpty(Calendar2.Text))
{
ValidationErrors.AddError("Export.Error", new ErrorMessage("Todate is required."));
}
if (Calendar1.Text.Length != 0 && Calendar2.Text.Length != 0)
{
if (Calendar2.Value.Value < Calendar1.Value.Value)
{
ValidationErrors.AddError("Export.Error", new ErrorMessage("Invalid Year."));
}
else
{
List <ReportParameter> rptParam = new List <ReportParameter>();
DateTime _Fromdate = Calendar1.Value.Value;
DateTime _Todate = Calendar2.Value.Value;
ReportParameter paramFromDate = new ReportParameter();
paramFromDate.ParamterName = "fromdate";
paramFromDate.ParamterValue = _Fromdate.ToString("yyyy-MM-dd", mmddFormat);
rptParam.Add(paramFromDate);
ReportParameter paramToDate = new ReportParameter();
paramToDate.ParamterName = "Todate";
paramToDate.ParamterValue = _Todate.ToString("yyyy-MM-dd", mmddFormat);
rptParam.Add(paramToDate);
ReportParameter paramCompanyCode = new ReportParameter();
paramCompanyCode.ParamterName = "CompanyID";
if (string.IsNullOrEmpty(CompanyTextboxAutoComplete1.Text))
{
paramCompanyCode.ParamterValue = " ";
}
if (!string.IsNullOrEmpty(CompanyTextboxAutoComplete1.Text))
{
paramCompanyCode.ParamterValue = CompanyTextboxAutoComplete1.CompanyCode.Equals(string.Empty) ? string.Empty : CompanyTextboxAutoComplete1.CompanyCode;
}
rptParam.Add(paramCompanyCode);
byte[] results = new FilesGenerator().GetByte(ParameterServices.ReportingURL, ParameterServices.ReportUserName, ParameterServices.ReportPassword, ParameterServices.ReportDomainName, ParameterServices.ReportFolderPath, "CompanyMoneyTransfer", rptParam, FilesGenerator.ExportType.EXCEL);
ReportHelper.FlushReportEXCEL(this.Page, results, "CompanyMoneyTransferReport_[" + _Fromdate.ToString("yyyy-MM-dd", mmddFormat) + "]_[" + _Todate.ToString("yyyy-MM-dd", mmddFormat) + "]");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
List <ReportParameter> rptParam = new List <ReportParameter>();
ReportParameter paramUserName = new ReportParameter();
paramUserName.ParamterName = "UserName";
paramUserName.ParamterValue = Request["userName"] == null ? string.Empty : Request["userName"].ToString();
rptParam.Add(paramUserName);
ReportParameter paramFromEmpID = new ReportParameter();
paramFromEmpID.ParamterName = "FromEmployeeCode";
paramFromEmpID.ParamterValue = Request["fEmpCode"] == null ? "0" : Request["fEmpCode"].ToString();
rptParam.Add(paramFromEmpID);
ReportParameter paramToEmpID = new ReportParameter();
paramToEmpID.ParamterName = "ToEmployeeCode";
paramToEmpID.ParamterValue = Request["tEmpCode"] == null ? "0" : Request["tEmpCode"].ToString();
rptParam.Add(paramToEmpID);
ReportParameter paramFromDueDate = new ReportParameter();
paramFromDueDate.ParamterName = "FromDueDate";
paramFromDueDate.ParamterValue = Request["fDueDate"] == null ? "01/01/1990" : Request["fDueDate"].ToString();
rptParam.Add(paramFromDueDate);
ReportParameter paramToDueDate = new ReportParameter();
paramToDueDate.ParamterName = "ToDueDate";
paramToDueDate.ParamterValue = Request["tDueDate"] == null ? "31/12/2050" : Request["tDueDate"].ToString();
rptParam.Add(paramToDueDate);
ReportParameter paramDocState = new ReportParameter();
paramDocState.ParamterName = "DocumentStatus";
paramDocState.ParamterValue = Request["docState"] == null ? "" : Request["docState"].ToString();
rptParam.Add(paramDocState);
ReportParameter paramShowParam = new ReportParameter();
paramShowParam.ParamterName = "ShowParam";
paramShowParam.ParamterValue = Request["ShowParam"] == null ? "" : Request["ShowParam"].ToString();
rptParam.Add(paramShowParam);
// find report file name later
byte[] results = new FilesGenerator().GetByte(ParameterServices.ReportingURL, ParameterServices.ReportUserName, ParameterServices.ReportPassword, ParameterServices.ReportDomainName, ParameterServices.ReportFolderPath, "EmployeeExpenseStatement", rptParam, FilesGenerator.ExportType.PDF);
ReportHelper.FlushReport(this.Page, results, ReportHelper.ReportType.PDF);
}
private static async Task Main(string[] args)
{
var fileSystem = new FileSystem(args[0]);
var generators = new FilesGenerator(IdentifyGenerators());
generators.Generating += (sender, file) => Console.WriteLine(file.Name);
await generators.Generate(fileSystem);
Console.WriteLine();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Press any key...");
Console.ReadKey();
}
public byte[] GeneratePayIn(long documentID)
{
DocumentReportName report = ScgeAccountingQueryProvider.SCGDocumentQuery.GetReportNameByDocumentID(documentID);
List <ReportParameter> param = new List <ReportParameter>();
ReportParameter param1 = new ReportParameter();
param1.ParamterName = "DocumentID";
param1.ParamterValue = documentID.ToString();
param.Add(param1);
FilesGenerator rp = new FilesGenerator();
byte[] results = rp.GetByte(ParameterServices.ReportingURL, ParameterServices.ReportUserName, ParameterServices.ReportPassword, ParameterServices.ReportDomainName, ParameterServices.ReportFolderPath, "PayInReport", param, FilesGenerator.ExportType.PDF);
//byte[] results = rp.GetByte("http://172.20.56.116:81/ReportServer/ReportExecution2005.asmx", "RSeAccounting", "p@ssw0rd", "SCG-EACCOUNTING", "eAccountingReports", report.ReportName, param, FilesGenerator.ExportType.PDF);
return(results);
}
protected void Page_Load(object sender, EventArgs e)
{
List <ReportParameter> rptParam = new List <ReportParameter>();
//ReportParameter paramCompanyID = new ReportParameter();
//paramCompanyID.ParamterName = "companyId";
//paramCompanyID.ParamterValue = Request["companyId"] == null ? string.Empty : Request["companyId"].ToString();
//rptParam.Add(paramCompanyID);
//ReportParameter paramFromRequesterID = new ReportParameter();
//paramFromRequesterID.ParamterName = "requesterId";
//paramFromRequesterID.ParamterValue = Request["requesterId"] == null ? string.Empty : Request["requesterId"].ToString();
//rptParam.Add(paramFromRequesterID);
//ReportParameter paramFromDate = new ReportParameter();
//paramFromDate.ParamterName = "fromDate";
//paramFromDate.ParamterValue = Request["fromDate"] == null ? null : Request["fromDate"].ToString();
//rptParam.Add(paramFromDate);
//ReportParameter paramToDate = new ReportParameter();
//paramToDate.ParamterName = "toDate";
//paramToDate.ParamterValue = Request["toDate"] == null ? null : Request["toDate"].ToString();
//rptParam.Add(paramToDate);
ReportParameter paramgroupId = new ReportParameter();
paramgroupId.ParamterName = "groupId";
paramgroupId.ParamterValue = "5";
rptParam.Add(paramgroupId);
//ReportParameter paramToRequesterID = new ReportParameter();
//paramToRequesterID.ParamterName = "ApproverID";
//paramToRequesterID.ParamterValue = Request["ApproverID"] == null ? "0" : Request["ApproverID"].ToString();
//rptParam.Add(paramToRequesterID);
//ReportParameter paramList1 = new ReportParameter();
//paramList1.ParamterName = "ParameterList";
//paramList1.ParamterValue = Request["ParameterList"] == null ? string.Empty : Request["ParameterList"].ToString();
//rptParam.Add(paramList1);
// find report file name later
byte[] results = new FilesGenerator().GetByte(ParameterServices.ReportingURL, ParameterServices.ReportUserName, ParameterServices.ReportPassword, ParameterServices.ReportDomainName, ParameterServices.ReportFolderPath, "FixAdvanceDuplicateReportV2", rptParam, FilesGenerator.ExportType.EXCEL);
ReportHelper.FlushReport(this.Page, results, ReportHelper.ReportType.PDF);
}
private void ExportPayrollPDF()
{
int month = int.Parse(ctlDropDownMonth.SelectedValue);
int year = int.Parse(ctlTextboxYear.Text);
//Create datetime use to used to parameter values.
DateTime dt = new DateTime(year, month, 1);
DateTime endDate = dt.AddDays(14);
DateTime startDate = dt.AddMonths(-1).AddDays(15);
List <ReportParameter> rptParam = new List <ReportParameter>();
ReportParameter paramCompanyCode = new ReportParameter();
paramCompanyCode.ParamterName = "CompanyCode";
paramCompanyCode.ParamterValue = txtCompanyList.Text.Equals(string.Empty) ? string.Empty : txtCompanyList.Text;
rptParam.Add(paramCompanyCode);
ReportParameter PersonalLevel = new ReportParameter();
PersonalLevel.ParamterName = "Ordinal";
PersonalLevel.ParamterValue = rblPersonalLevel.SelectedValue.ToString();
rptParam.Add(PersonalLevel);
ReportParameter startdate = new ReportParameter();
startdate.ParamterName = "startdate";
startdate.ParamterValue = startDate.ToString("MM/dd/yyyy", new CultureInfo("en-US"));
rptParam.Add(startdate);
ReportParameter enddate = new ReportParameter();
enddate.ParamterName = "enddate";
enddate.ParamterValue = endDate.ToString("MM/dd/yyyy", new CultureInfo("en-US"));
rptParam.Add(enddate);
// find report file name later
byte[] results = new FilesGenerator().GetByte(ParameterServices.ReportingURL, ParameterServices.ReportUserName, ParameterServices.ReportPassword, ParameterServices.ReportDomainName, ParameterServices.ReportFolderPath, "PayrollReport", rptParam, FilesGenerator.ExportType.PDF);
ReportHelper.FlushReportPDF(this.Page, results, "PayrollReport_0" + ctlDropDownMonth.SelectedValue + ctlTextboxYear.Text);
}
public void GenerateFiles(string targetPath)
{
BuildAllDefinitions();
FilesGenerator.GenerateFiles(targetPath, typeUnitFactory, FilesGenerationContext.Create(Options.LinterDisableMode));
}
protected void Page_Load(object sender, EventArgs e)
{
List <ReportParameter> rptParam = new List <ReportParameter>();
ReportParameter paramUserName = new ReportParameter();
paramUserName.ParamterName = "UserName";
paramUserName.ParamterValue = Request["userName"] == null ? string.Empty : Request["userName"].ToString();
rptParam.Add(paramUserName);
ReportParameter paramCompany = new ReportParameter();
paramCompany.ParamterName = "Company";
paramCompany.ParamterValue = Request["Company"] == null ? "0" : Request["Company"].ToString();
rptParam.Add(paramCompany);
ReportParameter paramFromDate = new ReportParameter();
paramFromDate.ParamterName = "FromDate";
paramFromDate.ParamterValue = Request["FromDate"] == null ? "01/01/1990" : Request["FromDate"].ToString();
rptParam.Add(paramFromDate);
ReportParameter paramToDate = new ReportParameter();
paramToDate.ParamterName = "ToDate";
paramToDate.ParamterValue = Request["ToDate"] == null ? "31/12/2050" : Request["ToDate"].ToString();
rptParam.Add(paramToDate);
ReportParameter paramFromTravelDate = new ReportParameter();
paramFromTravelDate.ParamterName = "FromTravelDate";
paramFromTravelDate.ParamterValue = Request["FromTravelDate"] == null ? "01/01/1990" : Request["FromTravelDate"].ToString();
rptParam.Add(paramFromTravelDate);
ReportParameter paramToTravelDate = new ReportParameter();
paramToTravelDate.ParamterName = "ToTravelDate";
paramToTravelDate.ParamterValue = Request["ToTravelDate"] == null ? "31/12/2050" : Request["ToTravelDate"].ToString();
rptParam.Add(paramToTravelDate);
ReportParameter paramFromTANo = new ReportParameter();
paramFromTANo.ParamterName = "FromTANo";
paramFromTANo.ParamterValue = Request["FromTANo"] == null ? string.Empty : Request["FromTANo"].ToString();
rptParam.Add(paramFromTANo);
ReportParameter paramToTANo = new ReportParameter();
paramToTANo.ParamterName = "ToTANo";
paramToTANo.ParamterValue = Request["ToTANo"] == null ? string.Empty : Request["ToTANo"].ToString();
rptParam.Add(paramToTANo);
ReportParameter paramFromTraveller = new ReportParameter();
paramFromTraveller.ParamterName = "FromTraveller";
paramFromTraveller.ParamterValue = Request["FromTraveller"] == null ? "0" : Request["FromTraveller"].ToString();
rptParam.Add(paramFromTraveller);
ReportParameter paramToTraveller = new ReportParameter();
paramToTraveller.ParamterName = "ToTraveller";
paramToTraveller.ParamterValue = Request["ToTraveller"] == null ? "0" : Request["ToTraveller"].ToString();
rptParam.Add(paramToTraveller);
ReportParameter paramTAStatus = new ReportParameter();
paramTAStatus.ParamterName = "TAStatus";
paramTAStatus.ParamterValue = Request["TAStatus"] == null ? string.Empty : Request["TAStatus"].ToString();
rptParam.Add(paramTAStatus);
// find report file name later
byte[] results = new FilesGenerator().GetByte(ParameterServices.ReportingURL, ParameterServices.ReportUserName, ParameterServices.ReportPassword, ParameterServices.ReportDomainName, ParameterServices.ReportFolderPath, "SummaryOfTravelAndExpenseReport", rptParam, FilesGenerator.ExportType.PDF);
ReportHelper.FlushReport(this.Page, results, ReportHelper.ReportType.PDF);
}
public byte[] GeneratePDF(long documentID)
{
DocumentReportName report = ScgeAccountingQueryProvider.SCGDocumentQuery.GetReportNameByDocumentID(documentID);
List <ReportParameter> param = new List <ReportParameter>();
ReportParameter param1 = new ReportParameter();
//Hard code for parameter name.
if (report.ReportName == "AVReportDomestic")
{
param1.ParamterName = "AdvanceID";
}
else if (report.ReportName == "AVReportForeign")
{
param1.ParamterName = "AdvanceID";
}
else if (report.ReportName == "TAReport")
{
param1.ParamterName = "TADocID";
}
else if (report.ReportName == "RMTADVReport")
{
param1.ParamterName = "RemittanceID";
}
else if (report.ReportName == "AdvReimbursementDomestic")
{
param1.ParamterName = "expenseId";
}
else if (report.ReportName == "PettyCashReimbursementDM")
{
param1.ParamterName = "expenseId";
}
else if (report.ReportName == "AdvReimbursementForeign")
{
param1.ParamterName = "expenseId";
}
else if (report.ReportName == "PettyCashReimbursementFR")
{
param1.ParamterName = "expenseId";
}
else if (report.ReportName == "MPADocumentPrintForm")
{
param1.ParamterName = "MPADocumentID";
}
else if (report.ReportName == "CADocumentPrintForm")
{
param1.ParamterName = "CADocumentID";
}
else if (report.ReportName == "FixedAdvanceDocumentPrintForm")
{
param1.ParamterName = "DocumentID";
}
else
{
return(null);
}
param1.ParamterValue = report.ReportParam;
param.Add(param1);
FilesGenerator rp = new FilesGenerator();
byte[] results = rp.GetByte(ParameterServices.ReportingURL, ParameterServices.ReportUserName, ParameterServices.ReportPassword, ParameterServices.ReportDomainName, ParameterServices.ReportFolderPath, report.ReportName, param, FilesGenerator.ExportType.PDF);
//byte[] results = rp.GetByte("http://172.20.56.116:81/ReportServer/ReportExecution2005.asmx", "RSeAccounting", "p@ssw0rd", "SCG-EACCOUNTING", "eAccountingReports", report.ReportName, param, FilesGenerator.ExportType.PDF);
return(results);
}
public void GenerateFiles(string targetPath, JavaScriptTypeChecker javaScriptTypeChecker)
{
ValidateOptions(Options, javaScriptTypeChecker);
BuildAllDefinitions();
FilesGenerator.GenerateFiles(targetPath, typeUnitFactory, FilesGenerationContext.Create(javaScriptTypeChecker, Options.LinterDisableMode));
}
protected void Page_Load(object sender, EventArgs e)
{
List <ReportParameter> rptParam = new List <ReportParameter>();
ReportParameter paramUserName = new ReportParameter();
paramUserName.ParamterName = "UserName";
paramUserName.ParamterValue = Request["userName"] == null ? string.Empty : Request["userName"].ToString();
rptParam.Add(paramUserName);
ReportParameter paramCompanyID = new ReportParameter();
paramCompanyID.ParamterName = "CompanyID";
paramCompanyID.ParamterValue = Request["CompanyID"] == null ? "0" : Request["CompanyID"].ToString();
rptParam.Add(paramCompanyID);
ReportParameter paramFromRequesterID = new ReportParameter();
paramFromRequesterID.ParamterName = "FromRequesterID";
paramFromRequesterID.ParamterValue = Request["FromRequesterID"] == null ? "0" : Request["FromRequesterID"].ToString();
rptParam.Add(paramFromRequesterID);
ReportParameter paramToRequesterID = new ReportParameter();
paramToRequesterID.ParamterName = "ToRequesterID";
paramToRequesterID.ParamterValue = Request["ToRequesterID"] == null ? "0" : Request["ToRequesterID"].ToString();
rptParam.Add(paramToRequesterID);
ReportParameter paramFromCarRegis = new ReportParameter();
paramFromCarRegis.ParamterName = "FromCarRegis";
paramFromCarRegis.ParamterValue = Request["FromCarRegis"] == null ? string.Empty : Request["FromCarRegis"].ToString();
rptParam.Add(paramFromCarRegis);
ReportParameter paramToCarRegis = new ReportParameter();
paramToCarRegis.ParamterName = "ToCarRegis";
paramToCarRegis.ParamterValue = Request["ToCarRegis"] == null ? string.Empty : Request["ToCarRegis"].ToString();
rptParam.Add(paramToCarRegis);
ReportParameter paramFromTANo = new ReportParameter();
paramFromTANo.ParamterName = "FromTANo";
paramFromTANo.ParamterValue = Request["FromTANo"] == null ? string.Empty : Request["FromTANo"].ToString();
rptParam.Add(paramFromTANo);
ReportParameter paramToTANo = new ReportParameter();
paramToTANo.ParamterName = "ToTANo";
paramToTANo.ParamterValue = Request["ToTANo"] == null ? string.Empty : Request["ToTANo"].ToString();
rptParam.Add(paramToTANo);
ReportParameter paramDocumentStatus = new ReportParameter();
paramDocumentStatus.ParamterName = "DocumentStatus";
paramDocumentStatus.ParamterValue = Request["DocumentStatus"] == null ? string.Empty : Request["DocumentStatus"].ToString();
rptParam.Add(paramDocumentStatus);
ReportParameter paramList1 = new ReportParameter();
paramList1.ParamterName = "ParameterList";
paramList1.ParamterValue = Request["ParameterList"] == null ? string.Empty : Request["ParameterList"].ToString();
rptParam.Add(paramList1);
ReportParameter paramList2 = new ReportParameter();
paramList2.ParamterName = "ParameterList2";
paramList2.ParamterValue = Request["ParameterList2"] == null ? string.Empty : Request["ParameterList2"].ToString();
rptParam.Add(paramList2);
// find report file name later
byte[] results = new FilesGenerator().GetByte(ParameterServices.ReportingURL, ParameterServices.ReportUserName, ParameterServices.ReportPassword, ParameterServices.ReportDomainName, ParameterServices.ReportFolderPath, "VehicleMileageReport", rptParam, FilesGenerator.ExportType.PDF);
ReportHelper.FlushReport(this.Page, results, ReportHelper.ReportType.PDF);
}
public static void ExportDocumentImage()
{
DbDocumentImagePosting docImgPst;
Console.WriteLine("Export document image utilities are initializing.");
Console.WriteLine("Create Fresh-New ImagePosting.");
imagePostService.ImportFreshNewImagePosting();
IList <SapInstanceData> sapInstances = Factory.DbSapInstanceQuery.GetSapInstanceList();
foreach (SapInstanceData sapInstance in sapInstances)
{
//bat file set ExportPath = root directory. etc: C:\SAPUpload\eXpense\
string newExportPath = RootPath + sapInstance.AliasName + "\\" + ExportImagePath + "\\" + DateTime.Now.ToString("yyMMdd");
string newExportPathTemp = RootPath + sapInstance.AliasName + "\\" + ExportImagePath + "\\Temp";
string exportfileName = ExportImageFile + DateTime.Now.Date.ToString("yyyyMMdd");
StreamWriter writer;
try
{
if (!Directory.Exists(newExportPath))
{
Directory.CreateDirectory(newExportPath);
}
writer = new StreamWriter(newExportPath + "\\" + exportfileName + ".txt");
}
catch (Exception)
{
Console.WriteLine("Could not find " + newExportPath + "\\" + exportfileName + ".txt");
Console.WriteLine("Program was terminated.");
return;
}
Console.WriteLine("Reading data from database ...");
IList <ExportDocumentImage> Doclist = docQuery.FindDocumentImage("N", sapInstance.Code);
string textLineTemplate = "{0}-{1}-{2}-{3}-{4}-{5}-{6}{7}";
int nn = 0;
Console.WriteLine("Exporting to " + newExportPath + "\\...");
foreach (ExportDocumentImage item in Doclist)
{
nn++;
Console.WriteLine("Formating log representation.");
#region Format text line representation
try
{
item.CompanyCode = item.CompanyCode.Substring(0, 4);
}
catch (ArgumentOutOfRangeException)
{
item.CompanyCode = item.CompanyCode.PadLeft(4);
}
try
{
item.DocNumber = item.DocNumber.Substring(0, 10);
}
catch (ArgumentOutOfRangeException)
{
item.DocNumber = item.DocNumber.PadLeft(10, ' ');
}
try
{
item.ImageDocumentType = item.ImageDocumentType.Substring(0, 7);
}
catch (ArgumentOutOfRangeException)
{
item.ImageDocumentType = item.ImageDocumentType.PadLeft(7, ' ');
}
nn = nn % 100;
string strn;
strn = nn.ToString();
if (strn.Length == 1)
{
strn = "0" + strn;
}
//nullreferance safety
string BoxID = "";
BoxID += expDocumentQuery.GetBoxIDByDocuemntID(item.DocumentID);
string docType = "";
if (item.ImageDocumentType == "Advance")
{
docType = ImageTypeAdv;
}
else if (item.ImageDocumentType == "Expense")
{
docType = ImageTypeExp;
}
else if (item.ImageDocumentType == "Remiitance")
{
docType = ImageTypeRem;
}
#endregion
SaveLogToDatabase(item.DocumentID.ToString(), "New", "Wait for Regenerate");
#region craete filename
string textLine = string.Format(textLineTemplate,
"BKPF",
item.FI_DOC,
item.DocumentDate.Year.ToString(),
item.CompanyCode,
strn,
docType,
BoxID,
".pdf"
);
#endregion
#region Zone create PDF
docImgPst = imagePostService.FindByIdentity(item.DocumentID);
if (docImgPst == null)
{
continue;
}
Console.WriteLine("Creating PDF content.");
string filesname = textLine;
try
{
byte[] pdfContent = docService.GeneratePDF(docImgPst.DocumentID);
FilesGenerator rp = new FilesGenerator();
if (!Directory.Exists(newExportPathTemp))
{
Directory.CreateDirectory(newExportPathTemp);
}
FileStream stream = File.Create(newExportPathTemp + "\\" + filesname, pdfContent.Length);
stream.Write(pdfContent, 0, pdfContent.Length);
stream.Close();
docImgPst.Status = "G";
docImgPst.ImageDocID = textLine;
docImgPst.Message = "Generated";
SaveLogToDatabase(item.DocumentID.ToString(), "New", "Generated");
}
catch (Exception ex)
{
Console.WriteLine("DocID=" + docImgPst.DocumentID + ", FiDoc=" + docImgPst.FIDocNumber + " => " + ex.ToString());
docImgPst.Status = "N";
docImgPst.Message = "Wait for Regenerate";
SaveLogToDatabase(item.DocumentID.ToString(), "New", "Wait for Regenerate");
continue;
}
finally
{
imagePostService.Update(docImgPst);
}//Save log to database
#endregion
}
//Loop for create IndexTextFile
//Query both of Fail and Generated.
IList <ExportDocumentImage> failDoclist = docQuery.FindDocumentImage("GF", sapInstance.Code);
Console.WriteLine("Create indexfile with generated and yesterday fail.");
foreach (ExportDocumentImage item in failDoclist)
{
if (!Directory.Exists(newExportPath))
{
Directory.CreateDirectory(newExportPath);
}
docImgPst = imagePostService.FindByIdentity(item.DocumentID);
Interface.Utilities.FileManager.CopyFile(newExportPathTemp + "\\" + docImgPst.ImageDocID, newExportPath + "\\" + docImgPst.ImageDocID);
docImgPst.Status = "P";
docImgPst.Message = "Posting";
imagePostService.Update(docImgPst);
writer.WriteLine(docImgPst.ImageDocID);
SaveLogToDatabase(item.DocumentID.ToString(), "File", "Posting");
}
writer.Close();
Console.WriteLine("Finnish.");
}
//string filePath = ExportImagePath;
//string exportfileName = ExportImageFile + DateTime.Now.Date.ToString("yyyyMMdd");
//StreamWriter writer;
//try
//{
// if (!Directory.Exists(ExportImagePath + DateTime.Now.ToString("yyMMdd")))
// {
// Directory.CreateDirectory(ExportImagePath + DateTime.Now.ToString("yyMMdd"));
// }
// writer = new StreamWriter(ExportImagePath + DateTime.Now.ToString("yyMMdd") + "\\" + exportfileName + ".txt");
//}
//catch (Exception)
//{
// Console.WriteLine("Could not find " + exportfileName + exportfileName + ".txt");
// Console.WriteLine("Program was terminated.");
// return;
//}
//Console.WriteLine("Reading data from database ...");
//IList<ExportDocumentImage> Doclist = docQuery.FindDocumentImage("N");
//string textLineTemplate = "{0}-{1}-{2}-{3}-{4}-{5}-{6}{7}";
//int nn = 0;
//Console.WriteLine("Exporting to " + filePath + "...");
//foreach (ExportDocumentImage item in Doclist)
//{
// nn++;
// Console.WriteLine("Formating log representation.");
// #region Format text line representation
// try
// {
// item.CompanyCode = item.CompanyCode.Substring(0, 4);
// }
// catch (ArgumentOutOfRangeException)
// {
// item.CompanyCode = item.CompanyCode.PadLeft(4);
// }
// try
// {
// item.DocNumber = item.DocNumber.Substring(0, 10);
// }
// catch (ArgumentOutOfRangeException)
// {
// item.DocNumber = item.DocNumber.PadLeft(10, ' ');
// }
// try
// {
// item.ImageDocumentType = item.ImageDocumentType.Substring(0, 7);
// }
// catch (ArgumentOutOfRangeException)
// {
// item.ImageDocumentType = item.ImageDocumentType.PadLeft(7, ' ');
// }
// nn = nn % 100;
// string strn;
// strn = nn.ToString();
// if (strn.Length == 1)
// {
// strn = "0" + strn;
// }
// //nullreferance safety
// string BoxID = "";
// BoxID += expDocumentQuery.GetBoxIDByDocuemntID(item.DocumentID);
// string docType = "";
// if (item.ImageDocumentType == "Advance")
// {
// docType = ImageTypeAdv;
// }
// else if (item.ImageDocumentType == "Expense")
// {
// docType = ImageTypeExp;
// }
// else if (item.ImageDocumentType == "Remiitance")
// {
// docType = ImageTypeRem;
// }
// #endregion
// SaveLogToDatabase(item.DocumentID.ToString(), "New", "Wait for Regenerate");
// #region craete filename
// string textLine = string.Format(textLineTemplate,
// "BKPF",
// item.FI_DOC,
// item.DocumentDate.Year.ToString(),
// item.CompanyCode,
// strn,
// docType,
// BoxID,
// ".pdf"
// );
// #endregion
// string tempFodler = ExportImagePath + "temp";
// Console.WriteLine("Creating PDF content.");
// #region Zone create PDF
// docImgPst = imagePostService.FindByIdentity(item.DocumentID);
// if (docImgPst == null)
// {
// continue;
// }
// string filesname = textLine;
// Console.WriteLine("Creating PDF content.");
// try
// {
// byte[] pdfContent = docService.GeneratePDF(docImgPst.DocumentID);
// FilesGenerator rp = new FilesGenerator();
// if (!Directory.Exists(tempFodler))
// {
// Directory.CreateDirectory(tempFodler);
// }
// FileStream stream = File.Create(tempFodler + "\\" + filesname, pdfContent.Length);
// stream.Write(pdfContent, 0, pdfContent.Length);
// stream.Close();
// docImgPst.Status = "G";
// docImgPst.ImageDocID = textLine;
// docImgPst.Message = "Generated";
// SaveLogToDatabase(item.DocumentID.ToString(), "New", "Generated");
// }
// catch (Exception ex)
// {
// Console.WriteLine("DocID=" + docImgPst.DocumentID + ", FiDoc=" + docImgPst.FIDocNumber + " => " + ex.ToString());
// docImgPst.Status = "N";
// docImgPst.Message = "Wait for Regenerate";
// SaveLogToDatabase(item.DocumentID.ToString(), "New", "Wait for Regenerate");
// continue;
// }
// finally
// {
// imagePostService.Update(docImgPst);
// }//Save log to database
// #endregion
//}
////Loop for create IndexTextFile
////Query both of Fail and Generated.
//IList<ExportDocumentImage> failDoclist = docQuery.FindDocumentImage("GF");
//Console.WriteLine("Create indexfile with generated and yesterday fail.");
//foreach (ExportDocumentImage item in failDoclist)
//{
// string outputFolder = ExportImagePath + "\\" + DateTime.Now.ToString("yyMMdd");
// if (!Directory.Exists(outputFolder))
// {
// Directory.CreateDirectory(outputFolder);
// }
// docImgPst = imagePostService.FindByIdentity(item.DocumentID);
// Interface.Utilities.FileManager.CopyFile(ExportImagePath + "temp\\" + docImgPst.ImageDocID, ExportImagePath + DateTime.Now.ToString("yyMMdd") + "\\" + docImgPst.ImageDocID);
// docImgPst.Status = "P";
// docImgPst.Message = "Posting";
// imagePostService.Update(docImgPst);
// writer.WriteLine(docImgPst.ImageDocID);
// SaveLogToDatabase(item.DocumentID.ToString(), "File", "Posting");
//}
//writer.Close();
//Console.WriteLine("Finnish.");
}
