/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
DataTable dtblMonthlySalaryDetails = new DataTable();
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalaryDetailsInfo infoMonthlySalaryDetailsInfo = new MonthlySalaryDetailsInfo();
dtblMonthlySalaryDetails = spMonthlySalary.MonthlySalarySettingsEmployeeViewAll(Convert.ToDateTime(dtpSalaryMonth.Text));
dgvMonthySalarySettings.DataSource = dtblMonthlySalaryDetails;
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);
}
}
public ActionResult DeleteAdvancePaymentFunction(string voucherNo, string employeeId, string salaryMonth)
{
string message = string.Empty;
try
{
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
if (!spMonthlySalary.CheckSalaryStatusForAdvancePayment(Convert.ToDecimal(employeeId), Convert.ToDateTime(salaryMonth)))
{
AdvancePaymentInfo infoAdvancepayment = new AdvancePaymentInfo();
AdvancePaymentSP spAdvancePayment = new AdvancePaymentSP();
LedgerPostingSP spLedgerPosting = new LedgerPostingSP();
spAdvancePayment.AdvancePaymentDelete(Convert.ToDecimal(decAdvancePaymentEditId.ToString()));
spLedgerPosting.LedgerPostDelete(voucherNo, decAdvancePaymentEditId);
}
else
{
message = "You can't delete,reference exist";
}
}
catch (Exception ex)
{
return(Json(new { success = "false", ex = "AP4" + ex.Message, message }));
}
return(Json(new { success = "true", ex = "no", message }));
}
/// <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();
DataTable dtblCompany = spCompany.CompanyViewDataTable(1);
ds.Tables.Add(dtblCompany);
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
DataTable dtblMonthlySalary = spMonthlySalary.MonthlySalryViewAllForMonthlySalaryReports(Convert.ToDateTime(dtpFromDate.Value.ToString()), Convert.ToDateTime(dtpToDate.Value.ToString()), cmbDesignation.Text, cmbEmployeeCode.Text, Convert.ToDateTime(dtpSalaryMonth.Value.ToString()));
ds.Tables.Add(dtblMonthlySalary);
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>
/// 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))
{
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
if (spMonthlySalary.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 fill Datagridview
/// </summary>
public void GridFill()
{
try
{
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
DataTable dtbl = spMonthlySalary.MonthlySalryViewAllForMonthlySalaryReports(Convert.ToDateTime(dtpFromDate.Value.ToString()), Convert.ToDateTime(dtpToDate.Value.ToString()), cmbDesignation.Text, cmbEmployeeCode.Text, Convert.ToDateTime(dtpSalaryMonth.Value.ToString()));
dgvMonthlySalary.DataSource = dtbl;
txtTotalAmount.Text = TotalAmount().ToString();
}
catch (Exception ex)
{
MessageBox.Show("MSR:1" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public ActionResult DeleteMonthlySalarySettings(string month)
{
try
{
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
spMonthlySalary.MonthlySalaryDeleteAll(spMonthlySalary.MonthlySalarySettingsMonthlySalaryIdSearchUsingSalaryMonth(Convert.ToDateTime(month)));
}
catch (Exception ex)
{
return(Json(new { success = "false", ex = "MSS5" + ex.Message }));
}
return(Json(new { success = "true", ex = "no" }));
}
public ActionResult MonthlySalarySettings()
{
ViewData["month"] = DateTime.UtcNow.ToString("yyyy-MM");
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
if (spMonthlySalary.MonthlySalarySettingsMonthlySalaryIdSearchUsingSalaryMonth(DateTime.Now) > 0)
{
ViewData["btnText"] = "Update";
}
else
{
ViewData["btnText"] = "Save";
ViewData["btnDel"] = "disabled";
}
return(View());
}
private DataTable GetMonthlySalarySettingsFromDB(string date)
{
DataTable dtblMonthlySalaryDetails = new DataTable();
try
{
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalaryDetailsInfo infoMonthlySalaryDetailsInfo = new MonthlySalaryDetailsInfo();
dtblMonthlySalaryDetails = spMonthlySalary.MonthlySalarySettingsEmployeeViewAll(Convert.ToDateTime(date));
}
catch (Exception ex)
{
}
return(dtblMonthlySalaryDetails);
}
/// <summary>
/// Function for Delete
/// </summary>
public void DeleteFunction()
{
try
{
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
string strMonth = dtpSalaryMonth.Text;
spMonthlySalary.MonthlySalaryDeleteAll(spMonthlySalary.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 Save
/// </summary>
public void SaveFunction()
{
try
{
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo();
infoMonthlySalary.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text);
infoMonthlySalary.Narration = txtNarration.Text.Trim();
infoMonthlySalary.Extra1 = string.Empty;
infoMonthlySalary.Extra2 = string.Empty;
decMasterIdForEdit = spMonthlySalary.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;
spMonthlySalaryDetails.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 to Enable/Disable delete button
/// </summary>
public void DeleteButtonEnableDisableChoose()
{
try
{
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
if (spMonthlySalary.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);
}
}
public string SaveMonthlySalarySettings(string month, string tableData)
{
try
{
List <Dictionary <string, object> > items = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(tableData);
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo();
infoMonthlySalary.SalaryMonth = Convert.ToDateTime(month);
infoMonthlySalary.Narration = string.Empty;
infoMonthlySalary.Extra1 = string.Empty;
infoMonthlySalary.Extra2 = string.Empty;
decimal decMasterIdForEdit = spMonthlySalary.MonthlySalaryAddWithIdentity(infoMonthlySalary);
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
int RowCount = items.Count;
for (int i = 0; i < RowCount; i++)
{
if (items[i]["employeeId"] != null)
{
infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(items[i]["employeeId"]);
if (items[i]["selectedSalaryPackageId"].ToString() != string.Empty && items[i]["selectedSalaryPackageId"].ToString() != "0")
{
infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(items[i]["selectedSalaryPackageId"].ToString());
infoMonthlySalaryDetails.Extra1 = string.Empty;
infoMonthlySalaryDetails.Extra2 = string.Empty;
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
spMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails);
}
}
}
}
catch (Exception ex)
{
return("MSS7" + ex.Message);
}
return("no");
}
public ActionResult GetMonthlySalarySettingsDetails(string month)
{
DataTable dtMonthly = GetMonthlySalarySettingsFromDB(month);
DataTable dtblSalaryPackage = new DataTable();
SalaryPackageSP spSalaryPackage = new SalaryPackageSP();
dtblSalaryPackage = spSalaryPackage.SalaryPackageViewAllForMonthlySalarySettings();
string jsonTableData = Utils.ConvertDataTabletoString(dtMonthly);
string jsonComboData = Utils.ConvertDataTabletoString(dtblSalaryPackage);
string jsonBtnStatus = string.Empty;
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
if (spMonthlySalary.MonthlySalarySettingsMonthlySalaryIdSearchUsingSalaryMonth(Convert.ToDateTime(month)) > 0)
{
jsonBtnStatus = "Update";
}
else
{
jsonBtnStatus = "Save";
}
return(Json(new { success = "true", tableData = jsonTableData, comboData = jsonComboData, btnStatus = jsonBtnStatus }));
}
public ActionResult EditAdvancePaymentFunction(string voucherNo, string employeeId, string salaryMonth, string chequeNo,
string date, string amount, string ledgerId, string chequeDate, string narration, string advancePaymentEditId)
{
string message = string.Empty;
string focus = string.Empty;
bool amountReadOnly = false;
try
{
employeeId = employeeId ?? string.Empty;
salaryMonth = salaryMonth ?? string.Empty;
chequeNo = chequeNo ?? string.Empty;
date = date ?? string.Empty;
amount = amount ?? string.Empty;
ledgerId = ledgerId ?? string.Empty;
chequeDate = chequeDate ?? string.Empty;
narration = narration ?? string.Empty;
decAdvancePaymentEditId = Convert.ToDecimal(advancePaymentEditId);
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
decimal decEmployeeId = Convert.ToDecimal(employeeId);
DateTime dtSalaryMonth = Convert.ToDateTime(salaryMonth);
if (!spMonthlySalary.CheckSalaryStatusForAdvancePayment(decEmployeeId, dtSalaryMonth))
{
AdvancePaymentSP spAdvancepayment = new AdvancePaymentSP();
AdvancePaymentInfo infoAdvancepayment = new AdvancePaymentInfo();
LedgerPostingSP spLedgerPosting = new LedgerPostingSP();
if (spAdvancepayment.CheckSalaryAlreadyPaidOrNot(decEmployeeId, dtSalaryMonth))
{
amountReadOnly = true;
}
infoAdvancepayment.AdvancePaymentId = decAdvancePaymentEditId;
infoAdvancepayment.EmployeeId = decEmployeeId;
infoAdvancepayment.SalaryMonth = dtSalaryMonth;
infoAdvancepayment.Chequenumber = chequeNo;
infoAdvancepayment.Date = Convert.ToDateTime(date);
infoAdvancepayment.Amount = Convert.ToDecimal(amount);
if (CheckAdvanceAmount(employeeId, amount))
{
if (isAutomatic)
{
infoAdvancepayment.VoucherNo = strVoucherNo;
}
else
{
infoAdvancepayment.VoucherNo = voucherNo;
}
if (isAutomatic)
{
infoAdvancepayment.InvoiceNo = strInvoiceNo;
}
else
{
infoAdvancepayment.InvoiceNo = voucherNo;
}
infoAdvancepayment.LedgerId = Convert.ToDecimal(ledgerId);
infoAdvancepayment.ChequeDate = Convert.ToDateTime(chequeDate);
infoAdvancepayment.Narration = narration;
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;
message = spAdvancepayment.AdvancePaymentEdit(infoAdvancepayment);
message = LedgerUpdate(voucherNo, amount, ledgerId);
}
else
{
message = "Advance of this month exceeds than amount set for the employee";
focus = "new_amount";
}
}
else
{
message = "You can't update,reference exist";
focus = "edit_salaryMonth";
}
}
catch (Exception ex)
{
return(Json(new { success = "true", ex = "AP3" + ex.Message }));
}
return(Json(new { success = "true", ex = "no", focus, message, amountReadOnly }));
}
public ActionResult SaveAdvancePaymentFunction(string voucherNo, string employeeId, string salaryMonth, string chequeNo,
string date, string amount, string ledgerId, string chequeDate, string narration)
{
string exception = string.Empty;
string message = string.Empty;
string focus = string.Empty;
string newVoucherNo = string.Empty;
try
{
employeeId = employeeId ?? string.Empty;
salaryMonth = salaryMonth ?? string.Empty;
chequeNo = chequeNo ?? string.Empty;
date = date ?? string.Empty;
amount = amount ?? string.Empty;
ledgerId = ledgerId ?? string.Empty;
chequeDate = chequeDate ?? string.Empty;
narration = narration ?? string.Empty;
AdvancePaymentSP spAdvancepayment = new AdvancePaymentSP();
AdvancePaymentInfo infoAdvancepayment = new AdvancePaymentInfo();
LedgerPostingSP spLedgerPosting = new LedgerPostingSP();
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
if (CheckAdvanceAmount(employeeId, amount))
{
if (!spMonthlySalary.CheckSalaryAlreadyPaidOrNotForAdvancePayment(Convert.ToDecimal(employeeId), Convert.ToDateTime(salaryMonth)))
{
if (!spAdvancepayment.CheckSalaryAlreadyPaidOrNot(Convert.ToDecimal(employeeId), Convert.ToDateTime(salaryMonth)))
{
if (isAutomatic == true)
{
infoAdvancepayment.VoucherNo = strVoucherNo;
}
else
{
infoAdvancepayment.VoucherNo = voucherNo;
}
infoAdvancepayment.EmployeeId = Convert.ToDecimal(employeeId);
infoAdvancepayment.SalaryMonth = Convert.ToDateTime(salaryMonth);
infoAdvancepayment.Chequenumber = chequeNo ?? string.Empty;
infoAdvancepayment.Date = Convert.ToDateTime(date);
infoAdvancepayment.Amount = Convert.ToDecimal(amount);
if (isAutomatic)
{
infoAdvancepayment.InvoiceNo = strInvoiceNo;
}
else
{
infoAdvancepayment.InvoiceNo = voucherNo;
}
infoAdvancepayment.LedgerId = Convert.ToDecimal(ledgerId);
infoAdvancepayment.ChequeDate = Convert.ToDateTime(chequeDate);
infoAdvancepayment.Narration = narration;
infoAdvancepayment.ExtraDate = DateTime.Now;
infoAdvancepayment.Extra1 = string.Empty;
infoAdvancepayment.Extra2 = string.Empty;
infoAdvancepayment.VoucherTypeId = decPaymentVoucherTypeId;
infoAdvancepayment.SuffixPrefixId = decPaymentSuffixPrefixId;
infoAdvancepayment.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
if (decAdvancePaymentsId != -1)
{
DataTable dtbl = new DataTable();
dtbl = spAdvancepayment.AdvancePaymentAddWithIdentity(infoAdvancepayment, isAutomatic);
foreach (DataRow dr in dtbl.Rows)
{
decAdvancePaymentId = Convert.ToDecimal(dr.ItemArray[0].ToString());
strUpdatedVoucherNumber = dr.ItemArray[1].ToString();
strUpdatedInvoiceNumber = dr.ItemArray[2].ToString();
}
if (!isAutomatic)
{
strVoucherNo = voucherNo;
}
if (isAutomatic)
{
if (Convert.ToDecimal(strUpdatedVoucherNumber) != Convert.ToDecimal(strVoucherNo))
{
message = "Voucher number changed from " + strInvoiceNo + " to " + strUpdatedInvoiceNumber + ".";
strVoucherNo = strUpdatedVoucherNumber.ToString();
strInvoiceNo = strUpdatedInvoiceNumber;
newVoucherNo = strVoucherNo;
}
}
focus = "AdvanceVoucherNo";
}
LedgerPosting(Convert.ToDecimal(ledgerId), decAdvancePaymentId, voucherNo, ledgerId, amount);
}
else
{
message = "Advance already paid for this month.";
focus = "new_salaryMonth";
}
}
else
{
message = "Cant pay advance for this month,Salary already paid.";
focus = "new_salaryMonth";
}
}
else
{
message = "Advance of this month exceeds than amount set for the employee";
focus = "new_amount";
}
}
catch (Exception ex)
{
return(Json(new { success = "true", ex = ex.Message }));
}
return(Json(new { success = "true", ex = "no", focus, message, newVoucherNo }));
}
/// <summary>
/// Function for Edit
/// </summary>
public void EditFunction()
{
try
{
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo();
EmployeeSP spEmployee = new EmployeeSP();
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;
spMonthlySalary.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;
spEmployee.EmployeePackageEdit(infoMonthlySalaryDetails.EmployeeId, infoMonthlySalaryDetails.SalaryPackageId);
spMonthlySalaryDetails.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());
spMonthlySalaryDetails.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;
spMonthlySalaryDetails.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 string EditMonthlySalarySettings(string month, string tableData)
{
try
{
List <Dictionary <string, object> > items = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(tableData);
decimal decMasterIdForEdit = 0;
MonthlySalarySP spMonthlySalary = new MonthlySalarySP();
MonthlySalaryInfo infoMonthlySalary = new MonthlySalaryInfo();
MonthlySalaryDetailsSP spMonthlySalaryDetails = new MonthlySalaryDetailsSP();
MonthlySalaryDetailsInfo infoMonthlySalaryDetails = new MonthlySalaryDetailsInfo();
EmployeeSP spEmployee = new EmployeeSP();
infoMonthlySalary.SalaryMonth = Convert.ToDateTime(month);
infoMonthlySalary.Narration = string.Empty;
infoMonthlySalary.Extra1 = string.Empty;
infoMonthlySalary.Extra2 = string.Empty;
int RowCount = items.Count;
for (int i = 0; i < RowCount; i++)
{
if (items[i]["monthlySalaryId"].GetType().Name != "JObject")
{
decMasterIdForEdit = Convert.ToDecimal(items[i]["monthlySalaryId"].ToString());
}
}
infoMonthlySalary.MonthlySalaryId = decMasterIdForEdit;
spMonthlySalary.MonthlySalarySettingsEdit(infoMonthlySalary);
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
for (int i = 0; i <= RowCount - 1; i++)
{
if (items[i]["monthlySalaryDetailsId"].GetType().Name != "JObject")
{
string st = items[i]["selectedSalaryPackageId"].ToString();
if (items[i]["selectedSalaryPackageId"].ToString() != "0")
{
if (items[i]["employeeId"].GetType().Name != "JObject" && items[i]["employeeId"].ToString() != string.Empty)
{
infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(items[i]["employeeId"].ToString());
}
if (items[i]["monthlySalaryDetailsId"].GetType().Name != "JObject" && items[i]["monthlySalaryDetailsId"].ToString() != string.Empty)
{
infoMonthlySalaryDetails.MonthlySalaryDetailsId = Convert.ToDecimal(items[i]["monthlySalaryDetailsId"].ToString());
}
if (items[i]["monthlySalaryId"].GetType().Name != "JObject" && items[i]["monthlySalaryId"].ToString() != "0")
{
infoMonthlySalaryDetails.MonthlySalaryId = Convert.ToDecimal(items[i]["monthlySalaryId"].ToString());
}
if (items[i]["selectedSalaryPackageId"].GetType().Name != "JObject" && items[i]["selectedSalaryPackageId"].ToString() != "0")
{
infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(items[i]["selectedSalaryPackageId"].ToString());
infoMonthlySalaryDetails.Extra1 = string.Empty;
infoMonthlySalaryDetails.Extra2 = string.Empty;
spEmployee.EmployeePackageEdit(infoMonthlySalaryDetails.EmployeeId, infoMonthlySalaryDetails.SalaryPackageId);
spMonthlySalaryDetails.MonthlySalaryDetailsEditUsingMasterIdAndDetailsId(infoMonthlySalaryDetails);
}
}
else
{
decimal decMonthlySalaryDetailsId = 0;
for (int j = 0; j < RowCount; j++)
{
if (items[j]["monthlySalaryDetailsId"].GetType().Name != "JObject" && items[j]["monthlySalaryDetailsId"].ToString() != string.Empty)
{
if (items[j]["selectedSalaryPackageId"].ToString() == "0")
{
decMonthlySalaryDetailsId = Convert.ToDecimal(items[j]["monthlySalaryDetailsId"].ToString());
spMonthlySalaryDetails.MonthlySalarySettingsDetailsIdDelete(decMonthlySalaryDetailsId);
}
}
}
}
}
else
{
if (items[i]["employeeId"].GetType().Name != "JObject" && items[i]["employeeId"].ToString() != string.Empty)
{
infoMonthlySalaryDetails.EmployeeId = Convert.ToDecimal(items[i]["employeeId"].ToString());
if (items[i]["selectedSalaryPackageId"].GetType().Name != "JObject" && items[i]["selectedSalaryPackageId"].ToString() != "0")
{
infoMonthlySalaryDetails.SalaryPackageId = Convert.ToDecimal(items[i]["selectedSalaryPackageId"].ToString());
infoMonthlySalaryDetails.Extra1 = string.Empty;
infoMonthlySalaryDetails.Extra2 = string.Empty;
infoMonthlySalaryDetails.MonthlySalaryId = decMasterIdForEdit;
spMonthlySalaryDetails.MonthlySalaryDetailsAddWithMonthlySalaryId(infoMonthlySalaryDetails);
}
}
}
}
}
catch (Exception ex)
{
return("MSS8" + ex.Message);
}
return("no");
}
