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 }));
}
public bool CheckSalaryStatusForAdvancePayment(decimal decEmployeeId, DateTime date)
{
bool isStatus = false;
try
{
isStatus = SPMonthlySalary.CheckSalaryStatusForAdvancePayment(decEmployeeId, date);
}
catch (Exception ex)
{
MessageBox.Show("MS7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(isStatus);
}
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 }));
}