/// <summary> /// Function to fill Datagridview /// </summary> /// <param name="isEditmode"></param> public void DailySalaryVoucherDetailsGridfill(bool @isEditmode) { try { DataTable dtbl = new DataTable(); DailySalaryVoucherDetailsSP spDetails = new DailySalaryVoucherDetailsSP(); dtbl = spDetails.DailySalaryVoucherDetailsGridViewAll(dtpSalaryDate.Value.ToString(), isEditmode, strVoucherNoforEdit); dgvDailySalaryVoucher.DataSource = dtbl; } catch (Exception ex) { MessageBox.Show("DSV2:" + 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 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 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> /// Date vakidation and fills Datagridview /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void txtSalaryDate_Leave(object sender, EventArgs e) { try { DateValidation obj = new DateValidation(); obj.DateValidationFunction(txtSalaryDate); if (txtSalaryDate.Text == string.Empty) { txtSalaryDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy"); } //---for change date in Date time picker----// string strdate = txtSalaryDate.Text; dtpSalaryDate.Value = Convert.ToDateTime(strdate.ToString()); DataTable dtbl = new DataTable(); DailySalaryVoucherDetailsSP spDetails = new DailySalaryVoucherDetailsSP(); dtbl = spDetails.DailySalaryVoucherDetailsGridViewAll(txtSalaryDate.Text.ToString(), isEditmode, strVoucherNoforEdit); dgvDailySalaryVoucher.DataSource = dtbl; } catch (Exception ex) { MessageBox.Show("DSV30:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }