/// <summary> /// Fills the PayHead type and calculates the salary amount on cellvalue changed /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvSalaryPackage_CellValueChanged(object sender, DataGridViewCellEventArgs e) { SalaryPackageDetailsSP SPSalaryPackageDetails = new SalaryPackageDetailsSP(); try { if (e.RowIndex != -1 && e.ColumnIndex != -1) { if (e.ColumnIndex == dgvSalaryPackage.Columns["dgvcmbPayHead"].Index) { if (dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvcmbPayHead"].Value != null && dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvcmbPayHead"].Value.ToString() != string.Empty) { string strPayHeadType = SPSalaryPackageDetails.PayHeadTypeView(Convert.ToDecimal(dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvcmbPayHead"].Value.ToString())); if (strPayHeadType != string.Empty) { dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtType"].Value = strPayHeadType; } } } bool isStatus = true; if (dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtSlNo"].Value != null && dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtSlNo"].Value.ToString() != string.Empty) { if (dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvcmbPayHead"].Value != null && dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvcmbPayHead"].Value.ToString() != string.Empty) { if (dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value != null && dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value.ToString() != string.Empty) { isStatus = true; } else { isStatus = false; } } else { isStatus = false; } } else { isStatus = false; } if (isStatus) { dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtStatus"].Value = "Complete"; } else { dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtStatus"].Value = string.Empty; } decimal decGrandTotal = 0; if (dgvSalaryPackage.RowCount > 1) { if (dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value != null) { foreach (DataGridViewRow drRow in dgvSalaryPackage.Rows) { if (!dgvSalaryPackage.CurrentRow.IsNewRow) { if (!drRow.IsNewRow) { if (drRow.Cells["dgvtxtAmount"].Value != null && drRow.Cells["dgvtxtType"].Value != null) { if (drRow.Cells["dgvtxtType"].Value.ToString() != "Deduction") { decGrandTotal += Convert.ToDecimal(drRow.Cells["dgvtxtAmount"].Value.ToString()); lblSalaryAmount.Text = decGrandTotal.ToString(); } else { decGrandTotal -= Convert.ToDecimal(drRow.Cells["dgvtxtAmount"].Value.ToString()); lblSalaryAmount.Text = decGrandTotal.ToString(); } } } } } } } } } catch (Exception ex) { MessageBox.Show("SPC14" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Fills the PayHead type and calculates the salary amount on cellvalue changed /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvSalaryPackage_CellValueChanged(object sender, DataGridViewCellEventArgs e) { SalaryPackageDetailsSP SPSalaryPackageDetails = new SalaryPackageDetailsSP(); try { if (e.RowIndex != -1 && e.ColumnIndex != -1) { if (e.ColumnIndex == dgvSalaryPackage.Columns["dgvcmbPayHead"].Index) { if (dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvcmbPayHead"].Value != null && dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvcmbPayHead"].Value.ToString() != string.Empty) { string strPayHeadType = SPSalaryPackageDetails.PayHeadTypeView(Convert.ToDecimal(dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvcmbPayHead"].Value.ToString())); if (strPayHeadType != string.Empty) { dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtType"].Value = strPayHeadType; } } } bool isStatus = true; if (dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtSlNo"].Value != null && dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtSlNo"].Value.ToString() != string.Empty) { if (dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvcmbPayHead"].Value != null && dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvcmbPayHead"].Value.ToString() != string.Empty) { if (dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value != null && dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value.ToString() != string.Empty) { isStatus = true; } else { isStatus = false; } } else { isStatus = false; } } else { isStatus = false; } if (isStatus) { dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtStatus"].Value = "Complete"; } else { dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtStatus"].Value = string.Empty; } decimal decGrandTotal = 0; if (dgvSalaryPackage.RowCount > 1) { if (dgvSalaryPackage.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value != null) { foreach (DataGridViewRow drRow in dgvSalaryPackage.Rows) { if (!dgvSalaryPackage.CurrentRow.IsNewRow) { if (!drRow.IsNewRow) { if (drRow.Cells["dgvtxtAmount"].Value != null && drRow.Cells["dgvtxtType"].Value != null) { if (drRow.Cells["dgvtxtType"].Value.ToString() != "Deduction") { decGrandTotal += Convert.ToDecimal(drRow.Cells["dgvtxtAmount"].Value.ToString()); lblSalaryAmount.Text = decGrandTotal.ToString(); } else { decGrandTotal -= Convert.ToDecimal(drRow.Cells["dgvtxtAmount"].Value.ToString()); lblSalaryAmount.Text = decGrandTotal.ToString(); } } } } } } } } } catch (Exception ex) { formMDI.infoError.ErrorString = "SPC15:" + ex.Message; } }