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