using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using Payroll.BO; using Ease.CoreV35.Model; using Ease.CoreV35; using Microsoft.Reporting.WinForms; using Ease.CoreV35.DataAccess; using System.Data; namespace Payroll.Report { public partial class frmCCWiseBudgetReport : Form { ObjectsTemplate _BudgetProcessMonthlieDetails = new ObjectsTemplate(); ObjectsTemplate _BudgetMasters = null; public frmCCWiseBudgetReport() { InitializeComponent(); } private void btnClose_Click(object sender, EventArgs e) { this.Close(); } private void btnPreview_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; List dataSource = new List(); ObjectsTemplate oEmps = Employee.Get(); ObjectsTemplate oEmpCCs = EmployeeCostCenter.Get(); _BudgetProcessMonthlieDetails = BudgetProcessMonthlyDetail.Get(Ease.CoreV35.Utility.Global.DateFunctions.FirstDateOfMonth(dtpFromDate.Value), Ease.CoreV35.Utility.Global.DateFunctions.LastDateOfMonth(dtpToDate.Value), Convert.ToInt16(cmbBudget.SelectedValue.ToString())); if (_BudgetProcessMonthlieDetails.Count == 0) { MessageBox.Show("No data found", "Not Found", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } ObjectsTemplate oCrgs = new ObjectsTemplate(); oCrgs = Costcenter.Get(); DataTable oBody = new Payroll.Report.PayrollDataSet.dsEmpLeaveLedger.BudgetCCDataTable(); ObjectsTemplate oMonthlys=BudgetProcessMonthly.Get(Convert.ToInt16(cmbBudget.SelectedValue.ToString())); foreach (BudgetProcessMonthlyDetail oItem in _BudgetProcessMonthlieDetails) { Employee oEmp = oEmps.Find(delegate(Employee emp) { return oItem.EmployeeID == emp.ID; }); EmployeeCostCenter empCC = oEmpCCs.Find(delegate(EmployeeCostCenter cc) { return oItem.EmployeeID == cc.EmployeeID; }); if (empCC!=null) oBody.Rows.Add(empCC.Costcenter.Name, oEmp == null ? oItem.EmployeeID.ToString() : oEmp.EmployeeNo, oEmp == null ? oItem.EmployeeID.ToString() : oEmp.Name, "", oItem.Name, Ease.CoreV35.Utility.Global.NumericFunctions.TakaFormat(Math.Round(oItem.Calculatedamount,2)), "Budget Name: " + cmbBudget.Text + " From " + dtpFromDate.Value.ToString("MMM yyyy") + " To " + dtpToDate.Value.ToString("MMM yyyy")); } string embeddedResource = "Payroll.Report.RDLC.rptBudgetCCReport.rdlc"; string caption = "Cost Center Wise Budget Report"; dataSource = new List(); dataSource.Add(new ReportDataSource("dsEmpLeaveLedger_BudgetCC", oBody)); Cursor.Current = Cursors.Default; try { fReportViewer fViewer = new fReportViewer(); fViewer.PreviewReport(dataSource, embeddedResource, caption); } catch (Exception exp) { } } private void frmCCWiseBudgetReport_Load(object sender, EventArgs e) { _BudgetMasters = new ObjectsTemplate(); _BudgetMasters = BudgetMaster.Get(); cmbBudget.DataSource = _BudgetMasters; cmbBudget.DisplayMember = "Name"; cmbBudget.ValueMember = "ID"; } } }