}//--------------------------- //###########################################END BUTTON btnClose EVENTS##################################################### //###########################################BUTTON btnClose EVENTS##################################################### //event is raised when the control is clicked private void btnPrintClick(object sender, EventArgs e) { try { using (AdministratorServices.ClassAdministratorServices.CrystalReport.CrystalTransaction rptTransaction = new AdministratorServices.ClassAdministratorServices.CrystalReport.CrystalTransaction()) { rptTransaction.Database.Tables["transaction_table"].SetDataSource(_transactionDoneTable); rptTransaction.SetParameterValue("@complete_name", RemoteClient.ProcStatic.GetCompleteNameMiddleInitial(_transactionLogInfo.UserInfo.PersonInfo.LastName, _transactionLogInfo.UserInfo.PersonInfo.FirstName, _transactionLogInfo.UserInfo.PersonInfo.MiddleName)); rptTransaction.SetParameterValue("@user_name", _transactionLogInfo.UserInfo.UserName); rptTransaction.SetParameterValue("@access", _transactionLogInfo.AccessDescription); rptTransaction.SetParameterValue("@transaction_date", _transactionLogInfo.TransactionDate); rptTransaction.SetParameterValue("@network_information", _transactionLogInfo.NetworkInformation); rptTransaction.SetParameterValue("@print_Info", "Date/Time Printed: " + DateTime.Parse(_administrationManager.ServerDateTime).ToShortDateString() + " " + DateTime.Parse(_administrationManager.ServerDateTime).ToShortTimeString() + " Printed by: " + RemoteClient.ProcStatic.GetCompleteNameMiddleInitial(_userInfo.PersonInfo.LastName, _userInfo.PersonInfo.FirstName, _userInfo.PersonInfo.MiddleName)); using (RemoteClient.CrystalReportViewer frmViewer = new RemoteClient.CrystalReportViewer(rptTransaction)) { frmViewer.Text = "Transaction Log"; frmViewer.ShowDialog(); } } } catch (Exception ex) { RemoteClient.ProcStatic.ShowErrorDialog(ex.Message, "Error Printing"); } }//------------------------
//this procedure prints the employee deduction list public void PrintEmployeeDeductionList(CommonExchange.SysAccess userInfo, CommonExchange.Employee empInfo, DateTime dateFrom, DateTime dateTo) { DataTable reportTable = new DataTable("EarningDeduction"); reportTable.Columns.Add("id", System.Type.GetType("System.Int64")); reportTable.Columns.Add("date_string", System.Type.GetType("System.String")); reportTable.Columns.Add("description", System.Type.GetType("System.String")); reportTable.Columns.Add("amount", System.Type.GetType("System.Decimal")); foreach (DataRow decRow in _decTableBySearch.Rows) { DataRow newRow = reportTable.NewRow(); newRow["id"] = decRow["deduction_id"]; newRow["date_string"] = DateTime.Parse(decRow["deduction_date"].ToString()).ToShortDateString() + " " + DateTime.Parse(decRow["deduction_date"].ToString()).ToShortTimeString(); newRow["description"] = decRow["deduction_description"]; newRow["amount"] = decRow["amount"]; reportTable.Rows.Add(newRow); } reportTable.AcceptChanges(); using (ClassEarningDeductionManager.CrystalReport.CrystalEmployeeEarningDeductionList rptDeduction = new EmployeeServices.ClassEarningDeductionManager.CrystalReport.CrystalEmployeeEarningDeductionList()) { rptDeduction.Database.Tables["earning_deduction"].SetDataSource(reportTable); rptDeduction.SetParameterValue("@school_name", CommonExchange.SchoolInformation.SchoolName); rptDeduction.SetParameterValue("@address", CommonExchange.SchoolInformation.Address); rptDeduction.SetParameterValue("@phone_nos", CommonExchange.SchoolInformation.PhoneNos); rptDeduction.SetParameterValue("@report_name", "Employee Deduction Summary"); rptDeduction.SetParameterValue("@date_covered", "as of " + dateFrom.ToLongDateString() + " to " + dateTo.ToLongDateString()); rptDeduction.SetParameterValue("@employee_id", empInfo.EmployeeId); rptDeduction.SetParameterValue("@employee_name", RemoteClient.ProcStatic.GetCompleteNameMiddleInitial(empInfo.PersonInfo.LastName, empInfo.PersonInfo.FirstName, empInfo.PersonInfo.MiddleName)); rptDeduction.SetParameterValue("@printer_info", "Date/Time Printed: " + DateTime.Parse(_serverDateTime).ToShortDateString() + " " + DateTime.Parse(_serverDateTime).ToShortTimeString() + " Printed by: " + RemoteClient.ProcStatic.GetCompleteNameMiddleInitial(userInfo.PersonInfo.LastName, userInfo.PersonInfo.FirstName, userInfo.PersonInfo.MiddleName)); rptDeduction.SetParameterValue("@total", "Total deductions-to-date:"); using (RemoteClient.CrystalReportViewer frmViewer = new RemoteClient.CrystalReportViewer(rptDeduction)) { frmViewer.ShowDialog(); } } } //-----------------------------------------
//this procedure will print chart of Account public void PrintChartOfAccount(CommonExchange.SysAccess userInfo) { DataTable accountTable = new DataTable("Account Table"); accountTable.Columns.Add("sysid_account", System.Type.GetType("System.String")); accountTable.Columns.Add("account_code", System.Type.GetType("System.String")); accountTable.Columns.Add("account_name", System.Type.GetType("System.String")); if (_chartOfAccountsTable != null) { foreach (DataRow accountRow in _chartOfAccountsTable.Rows) { DataRow newRow = accountTable.NewRow(); newRow["sysid_account"] = RemoteServerLib.ProcStatic.DataRowConvert(accountRow, "sysid_account", String.Empty); newRow["account_code"] = RemoteServerLib.ProcStatic.DataRowConvert(accountRow, "account_code", String.Empty); newRow["account_name"] = RemoteServerLib.ProcStatic.DataRowConvert(accountRow, "account_name", String.Empty); accountTable.Rows.Add(newRow); } } using (AccountingServices.ClassChartOfAccountManager.CrystalReport.CrystalChartOfAccount rptChartOfAccount = new AccountingServices.ClassChartOfAccountManager.CrystalReport.CrystalChartOfAccount()) { rptChartOfAccount.Database.Tables["account_table"].SetDataSource(accountTable); rptChartOfAccount.SetParameterValue("@school_name", CommonExchange.SchoolInformation.SchoolName); rptChartOfAccount.SetParameterValue("@form_name", "Chart of Accounts"); rptChartOfAccount.SetParameterValue("@date_printed", DateTime.Parse(this.ServerDateTime).ToLongDateString()); rptChartOfAccount.SetParameterValue("@print_Info", "Date/Time Printed: " + DateTime.Parse(this.ServerDateTime).ToShortDateString() + " " + DateTime.Parse(this.ServerDateTime).ToShortTimeString() + " Printed by: " + RemoteClient.ProcStatic.GetCompleteNameMiddleInitial(userInfo.PersonInfo.LastName, userInfo.PersonInfo.FirstName, userInfo.PersonInfo.MiddleName)); using (RemoteClient.CrystalReportViewer frmViewer = new RemoteClient.CrystalReportViewer(rptChartOfAccount)) { frmViewer.Text = "Chart of Account"; frmViewer.ShowDialog(); } } }//----------------------------------