private void btnOK_Click(object sender, EventArgs e)
{
BalanceReportDataTable balanceReportDataTable;
ReportDocument reportDocument = new ReportDocument();
reportDocument.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\BalanceReportCR.rpt"));
ReportBll reportBll = new ReportBll();
DateTime @value = this.dtDate.Value;
DateTime date = @value.Date;
int selectedValue = (int)this.ddlAccounts.SelectedValue;
string str = string.Concat(this.ddlAccounts.SelectedValue.ToString(), " | ", this.ddlAccounts.GetItemText(this.ddlAccounts.SelectedItem));
if (this.category != 0)
{
balanceReportDataTable = reportBll.BalanceReportByCategory(selectedValue, date);
}
else
{
balanceReportDataTable = reportBll.BalanceReportByAccount(selectedValue, date);
}
reportDocument.SetDataSource(balanceReportDataTable);
ParameterValues parameterValue1 = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue1 = new ParameterDiscreteValue();
parameterDiscreteValue1.set_Value(str);
parameterValue1.Add(parameterDiscreteValue1);
reportDocument.DataDefinition.ParameterFields["account"].ApplyCurrentValues(parameterValue1);
ParameterValues parameterValue2 = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue2 = new ParameterDiscreteValue();
parameterDiscreteValue2.set_Value(date);
parameterValue2.Add(parameterDiscreteValue2);
reportDocument.DataDefinition.ParameterFields["dtTo"].ApplyCurrentValues(parameterValue2);
ReportFrom reportFrom = new ReportFrom();
reportFrom.crViewer.set_ReportSource(reportDocument);
reportFrom.MdiParent = this.form1;
reportFrom.Anchor = AnchorStyles.Top | AnchorStyles.Right;
reportFrom.Dock = DockStyle.Fill;
reportFrom.reportType = ReportType.None;
reportFrom.Show();
base.Close();
base.Dispose();
}
internal void btnPrint_Click(object sender, EventArgs e)
{
if (this.dgvJournal.Rows.Count <= 0)
{
MessageBox.Show("لا يوجد بيانات للطباعه");
}
else
{
if (this._journal.getJournal().Count == 0)
{
MessageBox.Show("لا يمكن طباعة بيانات غير مرحلة");
}
else
{
ReportDocument reportDocument = new ReportDocument();
reportDocument.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\JournalCR.rpt"));
DailyJournalDataTable dailyJournalDataTable = this.fillTable(this._journal.getJournal());
reportDocument.SetDataSource(dailyJournalDataTable);
ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue();
ParameterValues parameterValue = new ParameterValues();
if (string.IsNullOrEmpty(this.dateString))
{
DateTime @value = this.dtDate.Value.set_Value(@value.ToShortDateString());
}
else
{
parameterDiscreteValue.set_Value(this.dateString);
}
parameterValue.Add(parameterDiscreteValue);
reportDocument.DataDefinition.ParameterFields["date"].ApplyCurrentValues(parameterValue);
if (this.printDialog1.ShowDialog() == 1)
{
reportDocument.PrintOptions.set_PrinterName(this.printDialog1.PrinterSettings.PrinterName);
reportDocument.PrintToPrinter(1, false, 1, 1);
}
}
}
}
private void TransactionsReportFrom_Load(object sender, EventArgs e)
{
string str;
ReportDocument reportDocument;
ReportDataTable reportDataTable;
ParameterValues parameterValue;
ParameterDiscreteValue parameterDiscreteValue;
ParameterValues parameterValue2;
ParameterDiscreteValue parameterDiscreteValue2;
ParameterValues parameterValue3;
ParameterDiscreteValue parameterDiscreteValue3;
ParameterValues parameterValue4;
ParameterDiscreteValue parameterDiscreteValue4;
ReportDocument reportDocument2;
ParameterValues parameterValue5;
ParameterDiscreteValue parameterDiscreteValue5;
ParameterValues parameterValue6;
ParameterDiscreteValue parameterDiscreteValue6;
ReportDocument reportDocument3;
ParameterValues parameterValue7;
ParameterDiscreteValue parameterDiscreteValue7;
ParameterValues parameterValue8;
ParameterDiscreteValue parameterDiscreteValue8;
ReportDocument reportDocument4;
ParameterValues parameterValue9;
ParameterDiscreteValue parameterDiscreteValue9;
ParameterValues parameterValue10;
ParameterDiscreteValue parameterDiscreteValue10;
ReportDocument reportDocument5;
AccountsViewDataTable accountsViewDataTable;
ReportDocument reportDocument6;
ReportDocument reportDocument7;
ReportDocument reportDocument8;
ParameterValues parameterValue11;
ParameterDiscreteValue parameterDiscreteValue11;
ParameterValues parameterValue12;
ParameterDiscreteValue parameterDiscreteValue12;
AccountsBLL accountsBLL = new AccountsBLL();
Cursor.Current = Cursors.WaitCursor;
base.WindowState = FormWindowState.Maximized;
switch (this.reportType)
{
case ReportType.TrialBalance:
{
this.set_Text("ميزان المراجعة");
reportDocument3 = new ReportDocument();
reportDocument3.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\TrialBalanceCR.rpt"));
reportDocument3.SetDataSource(this._reportBll.getTrialBalance(this.From, this.To));
parameterValue7 = new ParameterValues();
parameterDiscreteValue7 = new ParameterDiscreteValue();
parameterDiscreteValue7.set_Value(this.From);
parameterValue7.Add(parameterDiscreteValue7);
reportDocument3.DataDefinition.ParameterFields["from"].ApplyCurrentValues(parameterValue7);
parameterValue8 = new ParameterValues();
parameterDiscreteValue8 = new ParameterDiscreteValue();
parameterDiscreteValue8.set_Value(this.To);
parameterValue8.Add(parameterDiscreteValue8);
reportDocument3.DataDefinition.ParameterFields["to"].ApplyCurrentValues(parameterValue8);
this.crViewer.set_ReportSource(reportDocument3);
}
case ReportType.BalanceSheet:
{
this.set_Text("الميزانية العمومية");
reportDocument4 = new ReportDocument();
reportDocument4.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\BalanceSheetCR.rpt"));
reportDocument4.SetDataSource(this._reportBll.getBalanceSheet(this.From, this.To));
parameterValue9 = new ParameterValues();
parameterDiscreteValue9 = new ParameterDiscreteValue();
parameterDiscreteValue9.set_Value(this.From);
parameterValue9.Add(parameterDiscreteValue9);
reportDocument4.DataDefinition.ParameterFields["from"].ApplyCurrentValues(parameterValue9);
parameterValue10 = new ParameterValues();
parameterDiscreteValue10 = new ParameterDiscreteValue();
parameterDiscreteValue10.set_Value(this.To);
parameterValue10.Add(parameterDiscreteValue10);
reportDocument4.DataDefinition.ParameterFields["to"].ApplyCurrentValues(parameterValue10);
this.crViewer.set_ReportSource(reportDocument4);
}
case ReportType.Transactions:
{
this.set_Text("كشف حركة حساب");
str = accountsBLL.GetAccountByID(this.account)[0].GL_Name_VC;
reportDocument = new ReportDocument();
reportDocument.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\reportTest.rpt"));
reportDataTable = this._reportBll.getByCodeDate(this.From, this.To, this.account);
reportDocument.SetDataSource(reportDataTable);
parameterValue = new ParameterValues();
parameterDiscreteValue = new ParameterDiscreteValue();
parameterDiscreteValue.set_Value(str);
parameterValue.Add(parameterDiscreteValue);
reportDocument.DataDefinition.ParameterFields["account"].ApplyCurrentValues(parameterValue);
parameterValue2 = new ParameterValues();
parameterDiscreteValue2 = new ParameterDiscreteValue();
parameterDiscreteValue2.set_Value(this.From);
parameterValue2.Add(parameterDiscreteValue2);
reportDocument.DataDefinition.ParameterFields["dtFrom"].ApplyCurrentValues(parameterValue2);
parameterValue3 = new ParameterValues();
parameterDiscreteValue3 = new ParameterDiscreteValue();
parameterDiscreteValue3.set_Value(this.To);
parameterValue3.Add(parameterDiscreteValue3);
reportDocument.DataDefinition.ParameterFields["dtTo"].ApplyCurrentValues(parameterValue3);
parameterValue4 = new ParameterValues();
parameterDiscreteValue4 = new ParameterDiscreteValue();
parameterDiscreteValue4.set_Value(reportDataTable[reportDataTable.Count - 1].Balance);
parameterValue4.Add(parameterDiscreteValue4);
reportDocument.DataDefinition.ParameterFields["tBalance"].ApplyCurrentValues(parameterValue4);
this.crViewer.set_ReportSource(reportDocument);
}
case ReportType.ProfitAndLoss:
{
this.set_Text("بيان الأرباح والخسائر");
reportDocument2 = new ReportDocument();
reportDocument2.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\ProfitLossCR.rpt"));
reportDocument2.SetDataSource(this._reportBll.getProfitAndLoss(this.From, this.To));
parameterValue5 = new ParameterValues();
parameterDiscreteValue5 = new ParameterDiscreteValue();
parameterDiscreteValue5.set_Value(this.From);
parameterValue5.Add(parameterDiscreteValue5);
reportDocument2.DataDefinition.ParameterFields["from"].ApplyCurrentValues(parameterValue5);
parameterValue6 = new ParameterValues();
parameterDiscreteValue6 = new ParameterDiscreteValue();
parameterDiscreteValue6.set_Value(this.To);
parameterValue6.Add(parameterDiscreteValue6);
reportDocument2.DataDefinition.ParameterFields["to"].ApplyCurrentValues(parameterValue6);
this.crViewer.set_ReportSource(reportDocument2);
}
case ReportType.Accounts:
{
this.set_Text("كشف أرصدة مجموعة حسابات");
reportDocument5 = new ReportDocument();
reportDocument5.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\AccountsCR.rpt"));
accountsViewDataTable = new AccountsBLL().GetAccountsView();
reportDocument5.SetDataSource(accountsViewDataTable);
this.crViewer.set_ReportSource(reportDocument5);
this.set_Text("الموظفون");
reportDocument6 = new ReportDocument();
reportDocument6.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\EmployeeCR.rpt"));
reportDocument6.SetDataSource(new EmployeeBll().getEmployee());
this.crViewer.set_ReportSource(reportDocument6);
this.set_Text("الموردون");
reportDocument7 = new ReportDocument();
reportDocument7.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\SupplierCR.rpt"));
reportDocument7.SetDataSource(new SupplierBll().getSuppliers());
this.crViewer.set_ReportSource(reportDocument7);
this.set_Text("مجمع الإهلاك");
reportDocument8 = new ReportDocument();
reportDocument8.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\fixedCR.rpt"));
reportDocument8.SetDataSource(this._reportBll.FixedAssetsReport(this.From, this.To));
parameterValue11 = new ParameterValues();
parameterDiscreteValue11 = new ParameterDiscreteValue();
parameterDiscreteValue11.set_Value(this.From);
parameterValue11.Add(parameterDiscreteValue11);
reportDocument8.DataDefinition.ParameterFields["from"].ApplyCurrentValues(parameterValue11);
parameterValue12 = new ParameterValues();
parameterDiscreteValue12 = new ParameterDiscreteValue();
parameterDiscreteValue12.set_Value(this.To);
parameterValue12.Add(parameterDiscreteValue12);
reportDocument8.DataDefinition.ParameterFields["to"].ApplyCurrentValues(parameterValue12);
this.crViewer.set_ReportSource(reportDocument8);
goto;
}
case ReportType.None:
{
this.set_Cursor(Cursors.Default);
return;
}
}
}
internal void tsPrint_Click(object sender, EventArgs e)
{
if (WithdrawalForm._print != 0)
{
if (this.printDialog1.ShowDialog() == 1)
{
VoucherDataTable voucher = this._voucher.getVoucher(WithdrawalForm._voucherID);
ReportDocument reportDocument = new ReportDocument();
reportDocument.Load(string.Concat(Path.GetDirectoryName(Application.ExecutablePath), "\\VoucherCR.rpt"));
ParameterValues parameterValue1 = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue1 = new ParameterDiscreteValue();
parameterDiscreteValue1.set_Value("سند صرف");
parameterValue1.Add(parameterDiscreteValue1);
reportDocument.DataDefinition.ParameterFields["title"].ApplyCurrentValues(parameterValue1);
ParameterValues parameterValue2 = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue2 = new ParameterDiscreteValue();
parameterDiscreteValue2.set_Value(this.lblName.Text);
parameterValue2.Add(parameterDiscreteValue2);
reportDocument.DataDefinition.ParameterFields["lblAccName"].ApplyCurrentValues(parameterValue2);
ParameterValues parameterValue3 = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue3 = new ParameterDiscreteValue();
parameterDiscreteValue3.set_Value(voucher[0].CName);
parameterValue3.Add(parameterDiscreteValue3);
reportDocument.DataDefinition.ParameterFields["AccName"].ApplyCurrentValues(parameterValue3);
ParameterValues parameterValue4 = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue4 = new ParameterDiscreteValue();
parameterDiscreteValue4.set_Value(voucher[0].CAcc);
parameterValue4.Add(parameterDiscreteValue4);
reportDocument.DataDefinition.ParameterFields["AccNumber"].ApplyCurrentValues(parameterValue4);
ParameterValues parameterValue5 = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue5 = new ParameterDiscreteValue();
parameterDiscreteValue5.set_Value(voucher[0].Amount_NU);
parameterValue5.Add(parameterDiscreteValue5);
reportDocument.DataDefinition.ParameterFields["Amount"].ApplyCurrentValues(parameterValue5);
ParameterValues parameterValue6 = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue6 = new ParameterDiscreteValue();
parameterDiscreteValue6.set_Value(voucher[0].Descrip_VC);
parameterValue6.Add(parameterDiscreteValue6);
reportDocument.DataDefinition.ParameterFields["Desc"].ApplyCurrentValues(parameterValue6);
ParameterValues parameterValue7 = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue7 = new ParameterDiscreteValue();
try
{
int item = voucher[0].chkNumber.set_Value((!voucher[0].chkNumber ? "" : item.ToString()));
}
catch
{
parameterDiscreteValue7.set_Value("");
}
parameterValue7.Add(parameterDiscreteValue7);
reportDocument.DataDefinition.ParameterFields["chkNumber"].ApplyCurrentValues(parameterValue7);
ParameterValues parameterValue8 = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue8 = new ParameterDiscreteValue();
parameterDiscreteValue8.set_Value((!voucher[0].BankName ? "" : voucher[0].BankName));
parameterValue8.Add(parameterDiscreteValue8);
reportDocument.DataDefinition.ParameterFields["Bank"].ApplyCurrentValues(parameterValue8);
ParameterValues parameterValue9 = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue9 = new ParameterDiscreteValue();
DateTime dateDT = voucher[0].Date_DT.set_Value(dateDT.ToShortDateString());
parameterValue9.Add(parameterDiscreteValue9);
reportDocument.DataDefinition.ParameterFields["Date"].ApplyCurrentValues(parameterValue9);
ParameterValues parameterValue10 = new ParameterValues();
ParameterDiscreteValue parameterDiscreteValue10 = new ParameterDiscreteValue();
parameterDiscreteValue10.set_Value(WithdrawalForm._voucherID);
parameterValue10.Add(parameterDiscreteValue10);
reportDocument.DataDefinition.ParameterFields["VNumber"].ApplyCurrentValues(parameterValue10);
reportDocument.PrintOptions.set_PrinterName(this.printDialog1.PrinterSettings.PrinterName);
reportDocument.PrintToPrinter(this.printDialog1.PrinterSettings.Copies, this.printDialog1.PrinterSettings.Collate, 1, 1);
MessageBox.Show(string.Concat("Report Error", exception.Message));
}
try
{
}
catch (Exception exception)
{
}
}
else
{
MessageBox.Show("الرجاء حفظ السند");
}
}
