/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { DataTable dtblDailySalaryRegister = new DataTable(); DailySalaryVoucherMasterSP spDailySalaryVoucherMasterSP = new DailySalaryVoucherMasterSP(); dtblDailySalaryRegister = spDailySalaryVoucherMasterSP.DailySalaryRegisterSearch(Convert.ToDateTime(txtVoucherDateFrom.Text.ToString()), Convert.ToDateTime(txtVoucherDateTo.Text.ToString()), Convert.ToDateTime(txtSalaryDateFrom.Text.ToString()), Convert.ToDateTime(txtSalaryDateTo.Text.ToString()), txtVoucherNo.Text); dgvDailySalaryRegister.DataSource = dtblDailySalaryRegister; } catch (Exception ex) { formMDI.infoError.ErrorString = "DSR2:" + ex.Message; } }
/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { DataTable dtblDailySalaryRegister = new DataTable(); DailySalaryVoucherMasterSP spDailySalaryVoucherMasterSP = new DailySalaryVoucherMasterSP(); dtblDailySalaryRegister = spDailySalaryVoucherMasterSP.DailySalaryRegisterSearch(Convert.ToDateTime(txtVoucherDateFrom.Text.ToString()), Convert.ToDateTime(txtVoucherDateTo.Text.ToString()), Convert.ToDateTime(txtSalaryDateFrom.Text.ToString()), Convert.ToDateTime(txtSalaryDateTo.Text.ToString()), txtVoucherNo.Text); dgvDailySalaryRegister.DataSource = dtblDailySalaryRegister; } catch (Exception ex) { MessageBox.Show("DSR2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to Fill Cash Or Bank Combobox /// </summary> public void DailySalaryVoucherCashorBankComboFill() { try { DailySalaryVoucherMasterSP spMaster = new DailySalaryVoucherMasterSP(); DataTable dtblDailySalaryVoucherMaster = new DataTable(); dtblDailySalaryVoucherMaster = spMaster.DailySalaryVoucherCashOrBankLedgersComboFill(); cmbCashorBankAccount.DataSource = dtblDailySalaryVoucherMaster; cmbCashorBankAccount.ValueMember = "ledgerId"; cmbCashorBankAccount.DisplayMember = "ledgerName"; cmbCashorBankAccount.SelectedIndex = -1; } catch (Exception ex) { MessageBox.Show("DSV1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to generate Voucher number as per settings /// </summary> public void VoucherNumberGeneration() { try { TransactionsGeneralFill TransactionsGeneralFillobj = new TransactionsGeneralFill(); DailySalaryVoucherMasterSP spmaster = new DailySalaryVoucherMasterSP(); //--------------------------Automatic Generation------------------------// if (strVoucherNo == string.Empty) { strVoucherNo = "0"; } strVoucherNo = TransactionsGeneralFillobj.VoucherNumberAutomaicGeneration(decDailyVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, strTableName); if (Convert.ToDecimal(strVoucherNo) != spmaster.SalaryVoucherMasterGetMaxPlusOne(decDailyVoucherTypeId)) { strVoucherNo = spmaster.SalaryVoucherMasterGetMaxPlusOne(decDailyVoucherTypeId).ToString(); strVoucherNo = TransactionsGeneralFillobj.VoucherNumberAutomaicGeneration(decDailyVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, strTableName); if (spmaster.DailySalaryVoucherMasterGetMax(decDailyVoucherTypeId) == "0") { strVoucherNo = "0"; strVoucherNo = TransactionsGeneralFillobj.VoucherNumberAutomaicGeneration(decDailyVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, strTableName); } } //---------------------------------------------------------------------------------// if (isAutomatic) { SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo(); SuffixPrefixSP spSuffisprefix = new SuffixPrefixSP(); infoSuffixPrefix = spSuffisprefix.GetSuffixPrefixDetails(decDailyVoucherTypeId, dtpDate.Value); strPrefix = infoSuffixPrefix.Prefix; strSuffix = infoSuffixPrefix.Suffix; strInvoiceNo = strPrefix + strVoucherNo + strSuffix; txtVoucherNo.Text = strInvoiceNo; txtVoucherNo.ReadOnly = true; } } catch (Exception ex) { MessageBox.Show("DSV14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for Delete /// </summary> public void DeleteFunction() { try { DailySalaryVoucherMasterSP spMaster = new DailySalaryVoucherMasterSP(); DailySalaryVoucherDetailsSP spDetails = new DailySalaryVoucherDetailsSP(); LedgerPostingSP spLedgerPosting = new LedgerPostingSP(); if (PublicVariables.isMessageDelete) { if (Messages.DeleteMessage()) { spMaster.DailySalaryVoucherMasterDelete(decMasterIdforEdit); spDetails.DailySalaryVoucherDetailsDeleteUsingMasterId(decMasterIdforEdit); spLedgerPosting.LedgerPostDelete(txtVoucherNo.Text, decDailyVoucherTypeId); Messages.DeletedMessage(); Clear(); DailySalaryVoucherDetailsGridfill(isEditmode); } } else { spMaster.DailySalaryVoucherMasterDelete(decMasterIdforEdit); spDetails.DailySalaryVoucherDetailsDeleteUsingMasterId(decMasterIdforEdit); spLedgerPosting.LedgerPostDelete(txtVoucherNo.Text, decDailyVoucherTypeId); Messages.DeletedMessage(); Clear(); DailySalaryVoucherDetailsGridfill(isEditmode); } } catch (Exception ex) { MessageBox.Show("DSV13:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for Edit /// </summary> public void EditFunction() { try { DailySalaryVoucherMasterInfo infoMaster = new DailySalaryVoucherMasterInfo(); DailySalaryVoucherMasterSP spMaster = new DailySalaryVoucherMasterSP(); DailySalaryVoucherDetailsInfo infoDetails = new DailySalaryVoucherDetailsInfo(); DailySalaryVoucherDetailsSP spDetails = new DailySalaryVoucherDetailsSP(); LedgerPostingSP spLedgerPosting = new LedgerPostingSP(); infoMaster.DailySalaryVoucehrMasterId = decMasterIdforEdit; infoMaster.Date = Convert.ToDateTime(dtpDate.Value.ToString()); infoMaster.LedgerId = Convert.ToDecimal(cmbCashorBankAccount.SelectedValue.ToString()); infoMaster.Narration = txtNarration.Text; infoMaster.TotalAmount = Convert.ToDecimal(lblShowTotelamount.Text.ToString()); if (isAutomatic) { infoMaster.VoucherNo = strVoucherNo; } else { infoMaster.VoucherNo = txtVoucherNo.Text.Trim(); } if (isAutomatic) { infoMaster.InvoiceNo = strInvoiceNo; } else { infoMaster.InvoiceNo = txtVoucherNo.Text.Trim(); } infoMaster.Extra1 = string.Empty; infoMaster.Extra2 = string.Empty; infoMaster.SuffixPrefixId = decDailySuffixPrefixId; infoMaster.VoucherTypeId = decDailyVoucherTypeId; infoMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId; infoMaster.SalaryDate = Convert.ToDateTime(dtpSalaryDate.Text.ToString()); infoDetails.Extra1 = string.Empty;// Fields not in design// infoDetails.Extra2 = string.Empty;// Fields not in design// spMaster.DailySalaryVoucherMasterEdit(infoMaster); int inRowCount = dgvDailySalaryVoucher.RowCount; for (int i = 0; i < inRowCount; i++) { if (dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value.ToString() != string.Empty) { infoDetails.EmployeeId = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value.ToString()); } if (dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value.ToString() != string.Empty) { infoDetails.Wage = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value.ToString()); } if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() != string.Empty) { infoDetails.Status = dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString(); } if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() == string.Empty && dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtDailySalaryVocherMasterId"].Value.ToString() != string.Empty) { decimal DailySalaryVoucherDetailsId = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtdailySalaryVoucherDetailsId"].Value.ToString()); spDetails.DailySalaryVoucherDetailsDelete(DailySalaryVoucherDetailsId); LedgerUpdate(); } if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() == "paid" && dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtDailySalaryVocherMasterId"].Value.ToString() == string.Empty) { infoDetails.DailySalaryVocherMasterId = decMasterIdforEdit; spDetails.DailySalaryVoucherDetailsAdd(infoDetails); //spMaster.DailySalaryVoucherMasterEdit(infoMaster); LedgerUpdate(); } if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() == string.Empty && dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtDailySalaryVocherMasterId"].Value.ToString() == string.Empty) { spMaster.DailySalaryVoucherMasterEdit(infoMaster); LedgerUpdate(); } } if (spDetails.DailySalaryVoucherDetailsCount(decMasterIdforEdit) == 0) { spMaster.DailySalaryVoucherMasterDelete(decMasterIdforEdit); } Messages.UpdatedMessage(); Clear(); if (frmDailySalaryRegisterobj != null) { this.Close(); } } catch (Exception ex) { MessageBox.Show("DSV12:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to Save /// </summary> public void SaveFunction() { try { DailySalaryVoucherMasterInfo infoMaster = new DailySalaryVoucherMasterInfo(); DailySalaryVoucherMasterSP spMaster = new DailySalaryVoucherMasterSP(); DailySalaryVoucherDetailsInfo infoDetails = new DailySalaryVoucherDetailsInfo(); DailySalaryVoucherDetailsSP spDetails = new DailySalaryVoucherDetailsSP(); //-------------In multi user case check whether salary is paying for the same persone--------------// int inCounts = dgvDailySalaryVoucher.RowCount; int incont = 0; decimal decVal = 0; for (int i = 0; i < inCounts; i++) { decVal = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value.ToString()); if (spDetails.CheckWhetherDailySalaryAlreadyPaid(decVal, dtpSalaryDate.Value) != "0") { strEployeeNames = strEployeeNames + spDetails.CheckWhetherDailySalaryAlreadyPaid(decVal, dtpSalaryDate.Value) + ","; foreach (char ch in strEployeeNames) { if (ch == ',') { incont++; } } if (incont == 15) { incont = 0; strEployeeNames = strEployeeNames + Environment.NewLine; } } } if (spDetails.CheckWhetherDailySalaryAlreadyPaid(decVal, dtpSalaryDate.Value) != "0") { Messages.InformationMessage("Salary already paid for - " + " " + strEployeeNames); DailySalaryVoucherDetailsGridfill(isEditmode); } else { if (isAutomatic) { infoMaster.VoucherNo = strVoucherNo; } else { infoMaster.VoucherNo = txtVoucherNo.Text.Trim(); } infoMaster.Date = DateTime.Parse(dtpDate.Text.ToString()); infoMaster.SalaryDate = DateTime.Parse(dtpSalaryDate.Text.ToString()); infoMaster.LedgerId = Convert.ToDecimal(cmbCashorBankAccount.SelectedValue.ToString()); infoMaster.Narration = txtNarration.Text.Trim(); infoMaster.TotalAmount = Convert.ToDecimal(lblShowTotelamount.Text.ToString()); infoMaster.Extra1 = string.Empty; // Fields not in design// infoMaster.Extra2 = string.Empty; // Fields not in design// if (isAutomatic) { infoMaster.InvoiceNo = strInvoiceNo; } else { infoMaster.InvoiceNo = txtVoucherNo.Text.Trim(); } infoMaster.SuffixPrefixId = decDailySuffixPrefixId; infoMaster.VoucherTypeId = decDailyVoucherTypeId; infoMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId; int inval = 0; int inCount = dgvDailySalaryVoucher.RowCount; for (int i = 0; i < inCount; i++) { if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() == "paid") { inval++; } } if (inval >= 0) { //-------------checks Voucher No. repeating in Multi user case----------// DataTable dtbl = new DataTable(); dtbl = spMaster.DailySalaryVoucherMasterAddWithIdentity(infoMaster, isAutomatic); foreach (DataRow dr in dtbl.Rows) { decMasterId = Convert.ToDecimal(dr.ItemArray[0].ToString()); strUpdatedVoucherNo = dr.ItemArray[1].ToString(); strUpdatedInvoiceNo = dr.ItemArray[2].ToString(); } if (!isAutomatic) { strVoucherNo = txtVoucherNo.Text; } if (isAutomatic) { if (Convert.ToDecimal(strUpdatedVoucherNo) != Convert.ToDecimal(strVoucherNo)) { Messages.InformationMessage("Voucher number changed from " + strInvoiceNo + " to " + strUpdatedInvoiceNo); strVoucherNo = strUpdatedVoucherNo.ToString(); strInvoiceNo = strUpdatedInvoiceNo; } } //-------------------------------------// LedgerPosting(Convert.ToDecimal(cmbCashorBankAccount.SelectedValue.ToString())); infoDetails.DailySalaryVocherMasterId = decMasterId; infoDetails.Extra1 = string.Empty;// Fields not in design// infoDetails.Extra2 = string.Empty;// Fields not in design// int inRowCount = dgvDailySalaryVoucher.RowCount; for (int i = 0; i < inRowCount; i++) { if (dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value.ToString() != string.Empty) { infoDetails.EmployeeId = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value.ToString()); } if (dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value.ToString() != string.Empty) { infoDetails.Wage = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value.ToString()); } if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() != string.Empty) { infoDetails.Status = dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString(); } if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() == "paid" && dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtDailySalaryVocherMasterId"].Value.ToString() == string.Empty) { infoDetails.DailySalaryVocherMasterId = decMasterId; spDetails.DailySalaryVoucherDetailsAdd(infoDetails); } } Messages.SavedMessage(); DailySalaryVoucherDetailsGridfill(isEditmode); Clear(); } else { strVoucherNo = spMaster.DailySalaryVoucherMasterGetMax(decDailyVoucherTypeId); Messages.InformationMessage("Can't save without atleast one employee"); Clear(); } } } catch (Exception ex) { MessageBox.Show("DSV11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to call Save Or Edit /// </summary> public void SaveorEdit() { try { DailySalaryVoucherMasterSP spMaster = new DailySalaryVoucherMasterSP(); if (txtVoucherNo.Text == string.Empty) { Messages.InformationMessage("Enter voucher number"); txtVoucherNo.Focus(); } else if (dtpDate.Value.ToString() == string.Empty) { Messages.InformationMessage("Select voucher date"); dtpDate.Focus(); } else if (dtpSalaryDate.Value.ToString() == string.Empty) { Messages.InformationMessage("Select salary date"); txtSalaryDate.Focus(); } else if (cmbCashorBankAccount.Text == string.Empty) { Messages.InformationMessage("Select cash or bank account"); cmbCashorBankAccount.Focus(); } else if (dgvDailySalaryVoucher.Rows.Count == 0) { Messages.InformationMessage("Cant Save without atleast one employee"); } else { if (isEditmode == false) { if (PublicVariables.isMessageAdd) { if (Messages.SaveMessage()) { if (!isAutomatic) { if (spMaster.DailySalaryVoucherCheckExistence(txtVoucherNo.Text.Trim(), decDailyVoucherTypeId, 0) == false) { SaveFunction(); } else { Messages.InformationMessage("Voucher number already exist"); txtVoucherNo.Focus(); } } else { SaveFunction(); } } //else //{ // if (!isAutomatic) // { // if (spMaster.DailySalaryVoucherCheckExistence(txtVoucherNo.Text.Trim(), decDailyVoucherTypeId, 0) == false) // { // SaveFunction(); // } // else // { // Messages.InformationMessage("Voucher number already exist"); // txtVoucherNo.Focus(); // } // } // else // { // SaveFunction(); // } //} } else { if (!isAutomatic) { if (spMaster.DailySalaryVoucherCheckExistence(txtVoucherNo.Text.Trim(), decDailyVoucherTypeId, 0) == false) { SaveFunction(); } else { Messages.InformationMessage("Voucher number already exist"); txtVoucherNo.Focus(); } } else { SaveFunction(); } } } else { if (isEditmode) { if (PublicVariables.isMessageEdit) { if (Messages.UpdateMessage()) { if (!isAutomatic) { if (spMaster.DailySalaryVoucherCheckExistence(txtVoucherNo.Text.Trim(), decDailyVoucherTypeId, 0) == false) { EditFunction(); } else { Messages.InformationMessage("Voucher number already exist"); txtVoucherNo.Focus(); } } else { EditFunction(); } } } else { if (!isAutomatic) { if (spMaster.DailySalaryVoucherCheckExistence(txtVoucherNo.Text.Trim(), decDailyVoucherTypeId, 0) == false) { EditFunction(); } else { Messages.InformationMessage("Voucher number already exist"); txtVoucherNo.Focus(); } } else { EditFunction(); } } } } } } catch (Exception ex) { MessageBox.Show("DSV10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill controls for updation /// </summary> public void fillFunction() { try { DailySalaryVoucherMasterSP SpMaster = new DailySalaryVoucherMasterSP(); DailySalaryVoucherMasterInfo InfoMaster = new DailySalaryVoucherMasterInfo(); VoucherTypeSP spVoucherType = new VoucherTypeSP(); InfoMaster = SpMaster.DailySalaryVoucherViewFromRegister(decMasterIdforEdit); strVoucherNoforEdit = InfoMaster.VoucherNo; strVoucherNo = InfoMaster.VoucherNo; txtVoucherNo.Text = InfoMaster.InvoiceNo; strInvoiceNo = InfoMaster.InvoiceNo; dtpDate.Text = InfoMaster.Date.ToString(); dtpSalaryDate.Text = InfoMaster.SalaryDate.ToString(); lblShowTotelamount.Text = Math.Round(Convert.ToDecimal(InfoMaster.TotalAmount.ToString("0.00000")), PublicVariables._inNoOfDecimalPlaces).ToString(); txtNarration.Text = InfoMaster.Narration; decDailySuffixPrefixId = InfoMaster.SuffixPrefixId; decDailyVoucherTypeId = InfoMaster.VoucherTypeId; cmbCashorBankAccount.SelectedValue = InfoMaster.LedgerId.ToString(); isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(decDailyVoucherTypeId); if (isAutomatic) { txtVoucherNo.Enabled = false; } else { txtVoucherNo.Enabled = true; } dtpSalaryDate.Enabled = false; txtSalaryDate.Enabled = false; DailySalaryVoucherDetailsGridfill(isEditmode); } catch (Exception ex) { MessageBox.Show("DSV6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }