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> DailySalaryVoucherDetailsGridViewAll(string strSalaryDate, bool isEditMode, string strVoucherNumber)
{
DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP();
try
{
return(spDetails.DailySalaryVoucherDetailsGridViewAll(strSalaryDate, isEditMode, strVoucherNumber));
}
catch (Exception)
{
throw;
}
}
public DataTable DailySalaryVoucherDetailsGridfill(bool @isEditmode, string voucherNo, string salaryDate)
{
DataTable dtbl = new DataTable();
try
{
DailySalaryVoucherDetailsSP spDetails = new DailySalaryVoucherDetailsSP();
dtbl = spDetails.DailySalaryVoucherDetailsGridViewAll(salaryDate, isEditmode, voucherNo);
}
catch (Exception ex)
{
}
return(dtbl);
}
public List <DataTable> DailySalaryVoucherDetailsGridViewAll(string strSalaryDate, bool isEditMode, string strVoucherNumber)
{
List <DataTable> listDailySalaryVoucherDetailsGridViewAll = new List <DataTable>();
try
{
listDailySalaryVoucherDetailsGridViewAll = SpDailySalaryVoucherDetails.DailySalaryVoucherDetailsGridViewAll(strSalaryDate, isEditMode, strVoucherNumber);
}
catch (Exception ex)
{
MessageBox.Show("DSV6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(listDailySalaryVoucherDetailsGridViewAll);
}