private void SetParameters(ReportDocument Report)
{
DateTime dteRetValue = Constants.C_DATE_MIN_VALUE;
ParameterFieldDefinition paramField;
ParameterValues currentValues;
ParameterDiscreteValue discreteParam;
paramField = Report.DataDefinition.ParameterFields["CompanyName"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = CompanyDetails.CompanyName;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PrintedBy"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = Session["Name"].ToString();
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
switch (cboReportType.SelectedItem.Value)
{
case ReportTypes.CREDITS_Purchases:
#region purchases
paramField = Report.DataDefinition.ParameterFields["CreditCardTypeName"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = cboCreditType.SelectedItem.Text;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PurchaseStartDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = DateTime.TryParse(txtTrxStartDate.Text, out dteRetValue) ? dteRetValue.ToString("yyyy-MM-dd") : Constants.C_DATE_MIN_VALUE.ToString("yyyy-MM-dd");
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PurchaseEndDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = DateTime.TryParse(txtTrxEndDate.Text, out dteRetValue) ? dteRetValue.ToString("yyyy-MM-dd") : Constants.C_DATE_MIN_VALUE.ToString("yyyy-MM-dd");
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
#endregion
break;
case ReportTypes.CREDITS_Payments:
#region payments
paramField = Report.DataDefinition.ParameterFields["CreditCardTypeName"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = cboCreditType.SelectedItem.Text;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PaymentStartDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = DateTime.TryParse(txtTrxStartDate.Text, out dteRetValue) ? dteRetValue.ToString("yyyy-MM-dd") : Constants.C_DATE_MIN_VALUE.ToString("yyyy-MM-dd");
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PaymentEndDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = DateTime.TryParse(txtTrxEndDate.Text, out dteRetValue) ? dteRetValue.ToString("yyyy-MM-dd") : Constants.C_DATE_MIN_VALUE.ToString("yyyy-MM-dd");
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
#endregion
break;
case ReportTypes.CREDITS_CreditorsLedgerSummary:
#region ledger summary
paramField = Report.DataDefinition.ParameterFields["CreditCardTypeName"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = cboCreditType.SelectedItem.Text;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
Data.CreditBills clsCreditBills = new Data.CreditBills();
Data.CreditBillDetails clsCreditBillDetails = clsCreditBills.Details(CreditType.Individual, DateTime.Parse(cboBillingDate.SelectedItem.Value), Int16.Parse(cboCreditType.SelectedItem.Value));
clsCreditBills.CommitAndDispose();
paramField = Report.DataDefinition.ParameterFields["CreditPurcStartDateToProcess"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsCreditBillDetails.CreditPurcStartDateToProcess;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["CreditPurcEndDateToProcess"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsCreditBillDetails.CreditPurcEndDateToProcess;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PaymentDueDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsCreditBillDetails.CreditPaymentDueDate;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["BillingDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = DateTime.Parse(cboBillingDate.SelectedItem.Value);
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["ShowDetails"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = true;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
#endregion
break;
default:
break;
}
}
private void SetParameters (ReportDocument Report)
{
DateTime dteRetValue = Constants.C_DATE_MIN_VALUE;
ParameterFieldDefinition paramField;
ParameterValues currentValues;
ParameterDiscreteValue discreteParam;
paramField = Report.DataDefinition.ParameterFields["CompanyName"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = CompanyDetails.CompanyName;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PrintedBy"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = Session["Name"].ToString();
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
switch (cboReportType.SelectedItem.Value)
{
case ReportTypes.CREDITS_Purchases:
#region purchases
paramField = Report.DataDefinition.ParameterFields["CreditCardTypeName"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = cboCreditType.SelectedItem.Text;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PurchaseStartDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = DateTime.TryParse(txtTrxStartDate.Text, out dteRetValue) ? dteRetValue.ToString("yyyy-MM-dd") : Constants.C_DATE_MIN_VALUE.ToString("yyyy-MM-dd");
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PurchaseEndDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = DateTime.TryParse(txtTrxEndDate.Text, out dteRetValue) ? dteRetValue.ToString("yyyy-MM-dd") : Constants.C_DATE_MIN_VALUE.ToString("yyyy-MM-dd");
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
#endregion
break;
case ReportTypes.CREDITS_Payments:
#region payments
paramField = Report.DataDefinition.ParameterFields["CreditCardTypeName"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = cboCreditType.SelectedItem.Text;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PaymentStartDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = DateTime.TryParse(txtTrxStartDate.Text, out dteRetValue) ? dteRetValue.ToString("yyyy-MM-dd") : Constants.C_DATE_MIN_VALUE.ToString("yyyy-MM-dd");
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PaymentEndDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = DateTime.TryParse(txtTrxEndDate.Text, out dteRetValue) ? dteRetValue.ToString("yyyy-MM-dd") : Constants.C_DATE_MIN_VALUE.ToString("yyyy-MM-dd");
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
#endregion
break;
case ReportTypes.CREDITS_CreditorsLedgerSummary:
#region ledger summary
paramField = Report.DataDefinition.ParameterFields["CreditCardTypeName"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = cboCreditType.SelectedItem.Text;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
Data.CreditBills clsCreditBills = new Data.CreditBills();
Data.CreditBillDetails clsCreditBillDetails = clsCreditBills.Details(CreditType.Individual, DateTime.Parse(cboBillingDate.SelectedItem.Value), Int16.Parse(cboCreditType.SelectedItem.Value));
clsCreditBills.CommitAndDispose();
paramField = Report.DataDefinition.ParameterFields["CreditPurcStartDateToProcess"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsCreditBillDetails.CreditPurcStartDateToProcess;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["CreditPurcEndDateToProcess"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsCreditBillDetails.CreditPurcEndDateToProcess;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["PaymentDueDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = clsCreditBillDetails.CreditPaymentDueDate;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["BillingDate"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = DateTime.Parse(cboBillingDate.SelectedItem.Value);
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = Report.DataDefinition.ParameterFields["ShowDetails"];
discreteParam = new ParameterDiscreteValue();
discreteParam.Value = true;
currentValues = new ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
#endregion
break;
default:
break;
}
}
