/// <summary> /// On 'Print' button click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPrint_Click(object sender, EventArgs e) { try { if (dgvBonusDeductionReport.RowCount > 0) { DataSet ds = new DataSet(); CompanySP spCompany = new CompanySP(); DataTable dtblCompany = spCompany.CompanyViewDataTable(1); ds.Tables.Add(dtblCompany); BonusDedutionSP spBonusDeduction = new BonusDedutionSP(); DataTable dtblBonusDeduction = spBonusDeduction.BonusDeductionReportGridFill(dtpFromDate.Text, dtpToDate.Text, dtpSalaryMonth.Text, cmbDesignation.Text, cmbEmployee.Text, strBonusOrDeduction); ds.Tables.Add(dtblBonusDeduction); frmReport frmReportObj = new frmReport(); frmReportObj.MdiParent = formMDI.MDIObj; frmReportObj.BonusDeductionReportPrinting(ds); } else { Messages.InformationMessage("No data found"); } } catch (Exception ex) { MessageBox.Show("BDR:8" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to get all the values for Report based on parameters /// </summary> /// <param name="strFromdate"></param> /// <param name="strTodate"></param> /// <param name="strSalaryMonth"></param> /// <param name="strDesignation"></param> /// <param name="strEmployee"></param> /// <param name="strBonusOrDeduction"></param> /// <returns></returns> public List <DataTable> BonusDeductionReportGridFill(string strFromdate, string strTodate, string strSalaryMonth, string strDesignation, string strEmployee, string strBonusOrDeduction) { List <DataTable> listobj = new List <DataTable>(); try { listobj = SPBonusDedution.BonusDeductionReportGridFill(strFromdate, strTodate, strSalaryMonth, strDesignation, strEmployee, strBonusOrDeduction); } catch (Exception ex) { MessageBox.Show("BDBll14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(listobj); }
/// <summary> /// Function to fill Datagridview /// </summary> private void GridFill() { try { if (rbtnBonus.Checked) { strBonusOrDeduction = rbtnBonus.Text; } else if (rbtnDeduction.Checked) { strBonusOrDeduction = rbtnDeduction.Text; } BonusDedutionSP spBonusDeduction = new BonusDedutionSP(); dgvBonusDeductionReport.DataSource = spBonusDeduction.BonusDeductionReportGridFill(txtDate.Text, txtTodate.Text, dtpSalaryMonth.Text, cmbDesignation.Text, cmbEmployee.Text, strBonusOrDeduction); dgvBonusDeductionReport.Columns["employeeId"].Visible = false; } catch (Exception ex) { MessageBox.Show("BDR:3" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }