public JsonResult GetDailySalaryVoucher(string dailySalaryMasterId)
{
bool isSuccess = true;
string message = "success";
string jsonResults = "";
string jsonCombo = "";
DailySalaryVoucherMasterInfo info = new DailySalaryVoucherMasterInfo();
bool isAutomatic = false;
try
{
DailySalaryVoucherMasterSP SpMaster = new DailySalaryVoucherMasterSP();
VoucherTypeSP spVoucherType = new VoucherTypeSP();
DataTable dtbl = new DataTable();
DailySalaryVoucherDetailsSP spDetails = new DailySalaryVoucherDetailsSP();
int nDailySalaryMasterId = int.Parse(dailySalaryMasterId);
info = SpMaster.DailySalaryVoucherViewFromRegister(nDailySalaryMasterId);
info.DailySalaryVoucehrMasterId = nDailySalaryMasterId;
isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(info.VoucherTypeId);
bool isEditMode = nDailySalaryMasterId > 0 ? true : false;
dtbl = spDetails.DailySalaryVoucherDetailsGridViewAll(info.SalaryDate.ToString(), isEditMode, info.VoucherNo);
jsonResults = Utils.ConvertDataTabletoString(dtbl);
DailySalaryVoucherMasterSP spMaster = new DailySalaryVoucherMasterSP();
DataTable newDtbl = new DataTable();
newDtbl = spMaster.DailySalaryVoucherCashOrBankLedgersComboFill();
jsonCombo = Utils.ConvertDataTabletoString(newDtbl);
}
catch (Exception ex)
{
isSuccess = false;
message = ex.Message;
}
return(Json(new {
isSuccess = isSuccess,
message = message,
data = new
{
dailySalaryMasterId = info.DailySalaryVoucehrMasterId,
voucherNo = info.VoucherNo,
invoiceNo = info.InvoiceNo,
date = info.Date.ToString("yyyy-MM-dd"),
salaryDate = info.SalaryDate.ToString("yyyy-MM-dd"),
totalAmount = info.TotalAmount,
narration = info.Narration,
suffixPrefixId = info.SuffixPrefixId,
voucherTypeId = info.VoucherTypeId,
ledgerId = info.LedgerId,
jsonDetails = jsonResults,
jsonCombo = jsonCombo
}
}));
}
public List <DataTable> DailySalaryVoucherCashOrBankLedgersComboFill()
{
DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP();
try
{
return(SpMaster.DailySalaryVoucherCashOrBankLedgersComboFill());
}
catch (Exception)
{
throw;
}
}
public List <DataTable> DailySalaryVoucherCashOrBankLedgersComboFill()
{
List <DataTable> listObj = new List <DataTable>();
try
{
listObj = SpDailySalaryVoucherMaster.DailySalaryVoucherCashOrBankLedgersComboFill();
}
catch (Exception ex)
{
MessageBox.Show("DSV8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(listObj);
}
public ActionResult GetDailySalaryVoucherForModal(string salaryDate)
{
bool isSuccess = true;
string message = string.Empty;
string jsonResult = string.Empty;
string jsonCombo = string.Empty;
string strVoucherNo = string.Empty;
string strTableName = "DailySalaryVoucherMaster";
try
{
VoucherTypeSP spVoucherType = new VoucherTypeSP();
DataTable dtblVouchetType = new DataTable();
dtblVouchetType = spVoucherType.VoucherTypeSelectionComboFill("Daily Salary Voucher");
int inCount = dtblVouchetType.Rows.Count;
string voucherType = string.Empty;
if (inCount == 1)
{
voucherType = dtblVouchetType.Rows[0].ItemArray[0].ToString();
decimal decDailyVoucherTypeId = decimal.Parse(voucherType);
TransactionsGeneralFill TransactionsGeneralFillobj = new TransactionsGeneralFill();
DailySalaryVoucherMasterSP spmaster = new DailySalaryVoucherMasterSP();
strVoucherNo = spmaster.SalaryVoucherMasterGetMaxPlusOne(decDailyVoucherTypeId).ToString();
strVoucherNo = TransactionsGeneralFillobj.VoucherNumberAutomaicGeneration(decDailyVoucherTypeId, Convert.ToDecimal(strVoucherNo), Convert.ToDateTime(salaryDate), strTableName);
}
DataTable dtbl = DailySalaryVoucherDetailsGridfill(false, "0", salaryDate);
jsonResult = Utils.ConvertDataTabletoString(dtbl);
DailySalaryVoucherMasterSP spMaster = new DailySalaryVoucherMasterSP();
DataTable newDtbl = new DataTable();
newDtbl = spMaster.DailySalaryVoucherCashOrBankLedgersComboFill();
jsonCombo = Utils.ConvertDataTabletoString(newDtbl);
}
catch (Exception ex)
{
isSuccess = false;
message = ex.Message;
}
return(Json(new { isSuccess, message, voucherNo = strVoucherNo, data = jsonResult, jsonCombo }));
}