/// <summary> /// On 'Delete' button click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, EventArgs e) { try { if (CheckUserPrivilege.PrivilegeCheck(PublicVariables._decCurrentUserId, this.Name, btnDelete.Text)) { MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); if (BllMonthlySalary.MonthlySalarySettingsMonthlySalaryIdSearchUsingSalaryMonth(Convert.ToDateTime(dtpSalaryMonth.Text)) > 0) { Delete(); } else { btnDelete.Enabled = false; } } else { Messages.NoPrivillageMessage(); } } catch (Exception ex) { MessageBox.Show("MSS14" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to Enable/Disable delete button /// </summary> public void DeleteButtonEnableDisableChoose() { try { MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); if (BllMonthlySalary.MonthlySalarySettingsMonthlySalaryIdSearchUsingSalaryMonth(Convert.ToDateTime(dtpSalaryMonth.Text)) > 0) { btnDelete.Enabled = true; btnSave.Text = "Update"; } else { btnDelete.Enabled = false; btnSave.Text = "Save"; } } catch (Exception ex) { MessageBox.Show("MSS3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { List<DataTable> ListMonthlySalaryDetails = new List<DataTable>(); MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo(); MonthlySalaryVoucherBll BllMonthlySalaryDetails = new MonthlySalaryVoucherBll(); MonthlySalaryDetailsInfo infoMonthlySalaryDetailsInfo = new MonthlySalaryDetailsInfo(); ListMonthlySalaryDetails = BllMonthlySalary.MonthlySalarySettingsEmployeeViewAll(Convert.ToDateTime(dtpSalaryMonth.Text)); dgvMonthySalarySettings.DataSource = ListMonthlySalaryDetails[0]; int inRowCount = dgvMonthySalarySettings.RowCount; string strNarration = string.Empty; for (int i = 0; i < inRowCount; i++) { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtnarration"].Value.ToString() != string.Empty) { strNarration = dgvMonthySalarySettings.Rows[i].Cells["dgvtxtnarration"].Value.ToString(); } } for (int i = 0; i < inRowCount; i++) { //select default package for employee if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value.ToString() != "") { dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value = dgvMonthySalarySettings.Rows[i].Cells["dgvtxtdefaultPackageId"].Value; } } txtNarration.Text = strNarration; } catch (Exception ex) { MessageBox.Show("MSS4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for Save /// </summary> public void SaveFunction() { try { MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo(); MonthlySalaryVoucherBll BllMonthlySalaryDetails = new MonthlySalaryVoucherBll(); MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo(); infoMonthlySalary.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text); infoMonthlySalary.Narration = txtNarration.Text.Trim(); infoMonthlySalary.Extra1 = string.Empty; infoMonthlySalary.Extra2 = string.Empty; decMasterIdForEdit = BllMonthlySalary.MonthlySalaryAddWithIdentity(infoMonthlySalary); infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; int RowCount = dgvMonthySalarySettings.RowCount; for (int i = 0; i < RowCount; i++) { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty) { infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString()); if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0") { infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString()); infoMonthlySalaryDetails.Extra1 = string.Empty; infoMonthlySalaryDetails.Extra2 = string.Empty; infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; BllMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails); } } } Messages.SavedMessage(); GridFill(); dtpSalaryMonth.Focus(); btnDelete.Enabled = true; DeleteButtonEnableDisableChoose(); } catch (Exception ex) { MessageBox.Show("MSS7" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for Delete /// </summary> public void DeleteFunction() { try { MonthlySalaryVoucherBll BllMonthlySalaryDetails = new MonthlySalaryVoucherBll(); MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); string strMonth = dtpSalaryMonth.Text; BllMonthlySalary.MonthlySalaryDeleteAll(BllMonthlySalary.MonthlySalarySettingsMonthlySalaryIdSearchUsingSalaryMonth(Convert.ToDateTime(dtpSalaryMonth.Text))); Messages.DeletedMessage(); SalaryPackageComboFill(); GridFill(); UpdateDataGridViewRowColors(); DeleteButtonEnableDisableChoose(); dtpSalaryMonth.Focus(); } catch (Exception ex) { MessageBox.Show("MSS5" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for Edit /// </summary> public void EditFunction() { try { MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo(); MonthlySalaryVoucherBll BllMonthlySalaryDetails = new MonthlySalaryVoucherBll(); MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo(); EmployeeCreationBll BllEmployeeCreation = new EmployeeCreationBll(); infoMonthlySalary.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text); infoMonthlySalary.Narration = txtNarration.Text.Trim(); infoMonthlySalary.Extra1 = string.Empty; infoMonthlySalary.Extra2 = string.Empty; int RowCount = dgvMonthySalarySettings.RowCount; for (int i = 0; i <= RowCount - 1; i++) { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString() != string.Empty) { decMasterIdForEdit = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString()); } } infoMonthlySalary.MonthlySalaryId = decMasterIdForEdit; BllMonthlySalary.MonthlySalarySettingsEdit(infoMonthlySalary); infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; for (int i = 0; i <= RowCount - 1; i++) { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty) { string st = dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].FormattedValue.ToString(); if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].FormattedValue.ToString() != "--Select--") { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty) { infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString()); } if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty) { infoMonthlySalaryDetails.MonthlySalaryDetailsId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString()); } if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString() != "0") { infoMonthlySalaryDetails.MonthlySalaryId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtMonthlySalaryId"].Value.ToString()); } if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0") { infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString()); infoMonthlySalaryDetails.Extra1 = string.Empty; infoMonthlySalaryDetails.Extra2 = string.Empty; BllEmployeeCreation.EmployeePackageEdit(infoMonthlySalaryDetails.EmployeeId, infoMonthlySalaryDetails.SalaryPackageId); BllMonthlySalaryDetails.MonthlySalaryDetailsEditUsingMasterIdAndDetailsId(infoMonthlySalaryDetails); } } else { decimal decMonthlySalaryDetailsId = 0; for (int j = 0; j < RowCount; j++) { if (dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value != null && dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString() != string.Empty) { if (dgvMonthySalarySettings.Rows[j].Cells["dgvcmbPackage"].FormattedValue.ToString() == "--Select--") { decMonthlySalaryDetailsId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[j].Cells["dgvtxtMonthlySalaryDetailsId"].Value.ToString()); BllMonthlySalaryDetails.MonthlySalarySettingsDetailsIdDelete(decMonthlySalaryDetailsId); } } } } } else { if (dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString() != string.Empty) { infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvtxtEmployeeId"].Value.ToString()); if (dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value != null && dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString() != "0") { infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(dgvMonthySalarySettings.Rows[i].Cells["dgvcmbPackage"].Value.ToString()); infoMonthlySalaryDetails.Extra1 = string.Empty; infoMonthlySalaryDetails.Extra2 = string.Empty; infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit; BllMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails); } } } } Messages.UpdatedMessage(); GridFill(); dtpSalaryMonth.Focus(); btnDelete.Enabled = true; DeleteButtonEnableDisableChoose(); } catch (Exception ex) { MessageBox.Show("MSS8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void SaveFunction() { try { AdvancePaymentBll bllAdvancePayment = new AdvancePaymentBll(); AdvancePaymentInfo infoAdvancepayment = new AdvancePaymentInfo(); LedgerPostingBll BllLedgerPosting = new LedgerPostingBll(); MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); if (CheckAdvanceAmount()) { if (!BllMonthlySalary.CheckSalaryAlreadyPaidOrNotForAdvancePayment(Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()), dtpSalaryMonth.Value)) { if (!bllAdvancePayment.CheckSalaryAlreadyPaidOrNot(Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()), dtpSalaryMonth.Value)) { if (isAutomatic == true) { infoAdvancepayment.VoucherNo = strVoucherNo; } else { infoAdvancepayment.VoucherNo = txtAdvanceVoucherNo.Text.Trim(); } infoAdvancepayment.EmployeeId = Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()); infoAdvancepayment.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text.ToString()); infoAdvancepayment.Chequenumber = txtCheckNo.Text.ToString(); infoAdvancepayment.Date = Convert.ToDateTime(txtDate.Text.ToString()); infoAdvancepayment.Amount = Convert.ToDecimal(txtAmount.Text.ToString()); if (isAutomatic) { infoAdvancepayment.InvoiceNo = strInvoiceNo; } else { infoAdvancepayment.InvoiceNo = txtAdvanceVoucherNo.Text.Trim(); } infoAdvancepayment.LedgerId = Convert.ToDecimal(cmbCashOrBank.SelectedValue.ToString()); infoAdvancepayment.ChequeDate = Convert.ToDateTime(txtChequeDate.Text.ToString()); infoAdvancepayment.Narration = txtNarration.Text.Trim(); infoAdvancepayment.ExtraDate = Convert.ToDateTime(DateTime.Now.ToString()); infoAdvancepayment.Extra1 = string.Empty; infoAdvancepayment.Extra2 = string.Empty; infoAdvancepayment.VoucherTypeId = decPaymentVoucherTypeId; infoAdvancepayment.SuffixPrefixId = decPaymentSuffixPrefixId; infoAdvancepayment.FinancialYearId = PublicVariables._decCurrentFinancialYearId; if (btnAdvancePaymentSave.Text == "Save") { if (decAdvancePaymentsId != -1) { List<DataTable> ListObj = new List<DataTable>(); ListObj = bllAdvancePayment.AdvancePaymentAddWithIdentity(infoAdvancepayment, isAutomatic); foreach (DataRow dr in ListObj[0].Rows) { decAdvancePaymentId = Convert.ToDecimal(dr.ItemArray[0].ToString()); strUpdatedVoucherNumber = dr.ItemArray[1].ToString(); strUpdatedInvoiceNumber = dr.ItemArray[2].ToString(); } if (!isAutomatic) { strVoucherNo = txtAdvanceVoucherNo.Text.Trim(); } if (isAutomatic) { if (Convert.ToDecimal(strUpdatedVoucherNumber) != Convert.ToDecimal(strVoucherNo)) { Messages.InformationMessage("Voucher number changed from " + strInvoiceNo + " to " + strUpdatedInvoiceNumber); strVoucherNo = strUpdatedVoucherNumber.ToString(); strInvoiceNo = strUpdatedInvoiceNumber; } } txtAdvanceVoucherNo.Focus(); } LedgerPosting(Convert.ToDecimal(cmbCashOrBank.SelectedValue.ToString()), decAdvancePaymentId); Messages.SavedMessage(); Clear(); } } else { Messages.InformationMessage(" Advance already paid for this month"); dtpSalaryMonth.Focus(); } } else { Messages.InformationMessage("Cant pay advance for this month,Salary already paid"); dtpSalaryMonth.Focus(); } } } catch (Exception ex) { MessageBox.Show("AP1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to edit /// </summary> public void EditFunction() { try { MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); if (!BllMonthlySalary.CheckSalaryStatusForAdvancePayment(Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()), dtpSalaryMonth.Value)) { AdvancePaymentBll bllAdvancepayment = new AdvancePaymentBll(); AdvancePaymentInfo infoAdvancepayment = new AdvancePaymentInfo(); LedgerPostingBll BllLedgerPosting = new LedgerPostingBll(); if (bllAdvancepayment.CheckSalaryAlreadyPaidOrNot(Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()), dtpSalaryMonth.Value)) { txtAmount.ReadOnly = true; } infoAdvancepayment.AdvancePaymentId = (Convert.ToDecimal(decAdvancePaymentEditId.ToString())); infoAdvancepayment.EmployeeId = Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()); infoAdvancepayment.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text.ToString()); infoAdvancepayment.Chequenumber = txtCheckNo.Text.ToString(); infoAdvancepayment.Date = Convert.ToDateTime(txtDate.Text.ToString()); infoAdvancepayment.Amount = Convert.ToDecimal(txtAmount.Text.ToString()); if (CheckAdvanceAmount()) { if (isAutomatic) { infoAdvancepayment.VoucherNo = strVoucherNo; } else { infoAdvancepayment.VoucherNo = txtAdvanceVoucherNo.Text.Trim(); } if (isAutomatic) { infoAdvancepayment.InvoiceNo = strInvoiceNo; } else { infoAdvancepayment.InvoiceNo = txtAdvanceVoucherNo.Text.Trim(); } infoAdvancepayment.LedgerId = Convert.ToDecimal(cmbCashOrBank.SelectedValue.ToString()); infoAdvancepayment.ChequeDate = Convert.ToDateTime(txtChequeDate.Text.ToString()); infoAdvancepayment.Narration = txtNarration.Text.Trim(); infoAdvancepayment.ExtraDate = Convert.ToDateTime(DateTime.Now.ToString()); infoAdvancepayment.Extra1 = string.Empty; infoAdvancepayment.Extra2 = string.Empty; infoAdvancepayment.VoucherTypeId = decPaymentVoucherTypeId; infoAdvancepayment.SuffixPrefixId = decPaymentSuffixPrefixId; infoAdvancepayment.FinancialYearId = PublicVariables._decCurrentFinancialYearId; bllAdvancepayment.AdvancePaymentEdit(infoAdvancepayment); LedgerUpdate(); Messages.UpdatedMessage(); txtAdvanceVoucherNo.Focus(); this.Close(); } } else { Messages.ReferenceExistsMessageForUpdate(); dtpSalaryMonth.Focus(); } } catch (Exception ex) { MessageBox.Show("AP3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to delete /// </summary> public void DeleteFunction() { try { MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); if (!BllMonthlySalary.CheckSalaryStatusForAdvancePayment(Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()), dtpSalaryMonth.Value)) { AdvancePaymentInfo infoAdvancepayment = new AdvancePaymentInfo(); AdvancePaymentBll bllAdvancePayment = new AdvancePaymentBll(); LedgerPostingBll BllLedgerPosting = new LedgerPostingBll(); bllAdvancePayment.AdvancePaymentDelete(Convert.ToDecimal(decAdvancePaymentEditId.ToString())); BllLedgerPosting.LedgerPostDelete(txtAdvanceVoucherNo.Text.Trim(), decAdvancePaymentEditId); Messages.DeletedMessage(); txtAdvanceVoucherNo.Focus(); Clear(); this.Close(); } else { Messages.ReferenceExistsMessage(); dtpSalaryMonth.Focus(); } } catch (Exception ex) { MessageBox.Show("AP14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// On 'Print' button click for print /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPrint_Click(object sender, EventArgs e) { try { if (dgvMonthlySalary.Rows.Count > 0) { DataSet ds = new DataSet(); //CompanySP spCompany = new CompanySP(); CompanyCreationBll bllCompanyCreation = new CompanyCreationBll(); List<DataTable> listObjCompany = bllCompanyCreation.CompanyViewDataTable(1); ds.Tables.Add(listObjCompany[0]); MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); List<DataTable> ListMonthlySalary = BllMonthlySalary.MonthlySalryViewAllForMonthlySalaryReports(Convert.ToDateTime(dtpFromDate.Value.ToString()), Convert.ToDateTime(dtpToDate.Value.ToString()), cmbDesignation.Text, cmbEmployeeCode.Text, Convert.ToDateTime(dtpSalaryMonth.Value.ToString())); ds.Tables.Add(ListMonthlySalary[0]); frmReport frmReportObj = new frmReport(); frmReportObj.MdiParent = formMDI.MDIObj; frmReportObj.MonthlySalaryReportPrinting(ds); } else { Messages.InformationMessage("No data found"); } } catch (Exception ex) { MessageBox.Show("MSR:9" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { MonthlySalaryVoucherBll BllMonthlySalary = new MonthlySalaryVoucherBll(); List<DataTable> listObj = BllMonthlySalary.MonthlySalryViewAllForMonthlySalaryReports(Convert.ToDateTime(dtpFromDate.Value.ToString()), Convert.ToDateTime(dtpToDate.Value.ToString()), cmbDesignation.Text, cmbEmployeeCode.Text, Convert.ToDateTime(dtpSalaryMonth.Value.ToString())); dgvMonthlySalary.DataSource = listObj[0]; txtTotalAmount.Text = TotalAmount().ToString(); } catch (Exception ex) { MessageBox.Show("MSR:1" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }