/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { if (cmbCashBankAC.Text.Trim() == string.Empty) { if (cmbCashBankAC.DropDownStyle != ComboBoxStyle.DropDown) { cmbCashBankAC.DropDownStyle = ComboBoxStyle.DropDown; } cmbCashBankAC.Text = "All"; } DataTable dtbl = new DataTable(); SalaryVoucherMasterSP spSalaryVoucherMaster = new SalaryVoucherMasterSP(); dtbl = spSalaryVoucherMaster.MonthlySalaryRegisterSearch(Convert.ToDateTime(txtVoucherDateFrom.Text.Trim().ToString()), Convert.ToDateTime(txtVoucherDateTo.Text.Trim().ToString()), Convert.ToDateTime(dtpSalaryMonth.Value.ToString("MMMM yyyy")), txtVoucherNo.Text.Trim(), cmbCashBankAC.Text.ToString(), cmbVoucherTypeName.Text.ToString()); dgvMonthlySalaryRegister.DataSource = dtbl; if (cmbCashBankAC.Text == "All") { cmbCashBankAC.Text = string.Empty; } } catch (Exception ex) { formMDI.infoError.ErrorString = "MSR2:" + ex.Message; } }
/// <summary> /// Function for print /// </summary> public void Print() { try { if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, this.Name, btnPrint.Text)) { if (cmbEmployee.Text == string.Empty || cmbEmployee.Text == "--Select--") { Messages.InformationMessage("Select an employee"); cmbEmployee.Focus(); } else { SalaryVoucherMasterSP spSalaryVoucherMaster = new SalaryVoucherMasterSP(); DateTime dtMon = DateTime.Parse(dtpSalaryMonth.Text); DateTime dtSalaryMonth = new DateTime(dtMon.Year, dtMon.Month, 1); decimal decEmployeeId = Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()); DataSet dsPaySlip = spSalaryVoucherMaster.PaySlipPrinting(decEmployeeId, dtSalaryMonth, 1); foreach (DataTable dtbl in dsPaySlip.Tables) { if (dtbl.TableName == "Table1") { if (dtbl.Rows.Count > 0) { frmReport frmReport = new frmReport(); frmReport.MdiParent = formMDI.MDIObj; frmReport.PaySlipPrinting(dsPaySlip); } else { MessageBox.Show("Salary not paid", "Oneaccount", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } } else { Messages.NoPrivillageMessage(); } } catch (Exception ex) { formMDI.infoError.ErrorString = "PS3:" + ex.Message; } }