public IActionResult PartialConveyance()
{
ViewData["AccountSubLedgerName"] = new SelectList(_work.AccountSubLedger.GetAll(), "Id", "AccountSubLedgerName");
Voucher voucher = _work.Voucher.FindByVoucherType(VoucherTypes.Contra);
VoucherNumber lastVoucherNumber = _work.VoucherNumber.GetVoucherTypeWiseLastOrDefault(voucher.Id);
if (lastVoucherNumber == null)
{
lastVoucherNumber = new VoucherNumber();
}
VoucherNumber unsavedVoucherNumber = _work.VoucherNumber.GetVoucherTypeWiseUnsavedVoucher(voucher.Id);
TempVoucherHead tempVoucherHead = new TempVoucherHead();
if (unsavedVoucherNumber == null)
{
tempVoucherHead.SetVoucherNumber(VoucherTypes.Contra, lastVoucherNumber.Number);
tempVoucherHead.VoucherId = voucher.Id;
tempVoucherHead.VoucherType = voucher.VoucherType;
tempVoucherHead.VoucherSaveState = VoucherSaveStates.Unsaved;
_work.TempVoucherHead.Add(tempVoucherHead);
// === voucher number === //
VoucherNumber voucherNumber = new VoucherNumber
{
Number = tempVoucherHead.VoucherNumber,
State = tempVoucherHead.VoucherSaveState,
VoucherId = voucher.Id
};
_work.VoucherNumber.Add(voucherNumber);
// === === === //
bool isSaved = _work.Save() > 0;
if (isSaved)
{
return(PartialView("_Conveyance", tempVoucherHead));
}
}
else
{
TempVoucherHead unsavedVoucher = _work.TempVoucherHead.GetVoucherNumberWiseVoucher(unsavedVoucherNumber.Number);
return(PartialView("_Conveyance", unsavedVoucher));
}
return(PartialView("_Conveyance", tempVoucherHead));
}
public IActionResult PartialJournal()
{
Voucher voucher = _work.Voucher.FindByVoucherType(VoucherTypes.Contra);
VoucherNumber lastVoucherNumber = _work.VoucherNumber.GetVoucherTypeWiseLastOrDefault(voucher.Id);
if (lastVoucherNumber == null)
{
lastVoucherNumber = new VoucherNumber();
}
VoucherNumber unsavedVoucherNumber = _work.VoucherNumber.GetVoucherTypeWiseUnsavedVoucher(voucher.Id);
TempVoucherHead tempVoucherHead = new TempVoucherHead();
if (unsavedVoucherNumber == null)
{
tempVoucherHead.SetVoucherNumber(VoucherTypes.Contra, lastVoucherNumber.Number);
tempVoucherHead.VoucherId = voucher.Id;
tempVoucherHead.VoucherType = voucher.VoucherType;
tempVoucherHead.VoucherSaveState = VoucherSaveStates.Unsaved;
_work.TempVoucherHead.Add(tempVoucherHead);
// === voucher number === //
VoucherNumber voucherNumber = new VoucherNumber
{
Number = tempVoucherHead.VoucherNumber,
State = tempVoucherHead.VoucherSaveState,
VoucherId = voucher.Id
};
_work.VoucherNumber.Add(voucherNumber);
// === === === //
bool isSaved = _work.Save() > 0;
if (isSaved)
{
return(PartialView("_Journal", tempVoucherHead));
}
}
else
{
TempVoucherHead unsavedVoucher = _work.TempVoucherHead.GetVoucherNumberWiseVoucher(unsavedVoucherNumber.Number);
return(PartialView("_Journal", unsavedVoucher));
}
return(PartialView("_Journal", tempVoucherHead));
}
internal object ProcessAPI <T1, T2>(VoucherNumber regObj, out APIOutMessage msg)
{
throw new NotImplementedException();
}
public IActionResult SaveDebitVoucher(DebitVoucherViewModel debitVoucherViewModel)
{
if (!string.IsNullOrEmpty(debitVoucherViewModel.VoucherNumber))
{
var tempVoucherHead = _work.TempVoucherHead.Find(x => x.VoucherNumber == debitVoucherViewModel.VoucherNumber).FirstOrDefault();
if (tempVoucherHead != null)
{
VoucherHead voucherHead = new VoucherHead
{
VoucherId = tempVoucherHead.VoucherId,
VoucherNumber = debitVoucherViewModel.VoucherNumber,
EntryDate = Convert.ToDateTime(debitVoucherViewModel.Date),
PaidTo = debitVoucherViewModel.PaidTo,
PreparedBy = debitVoucherViewModel.PreparedBy,
PreparedByUserId = debitVoucherViewModel.PreparedByUserId,
ReceivedBy = debitVoucherViewModel.ReceivedBy,
VoucherSaveState = VoucherSaveStates.Saved
};
_work.VoucherHead.Add(voucherHead);
// === voucher number === //
VoucherNumber voucherNumber = _work.VoucherNumber.Find(x => x.Number == debitVoucherViewModel.VoucherNumber).FirstOrDefault();
if (voucherNumber.State != VoucherSaveStates.Saved)
{
voucherNumber.State = VoucherSaveStates.Saved;
_work.VoucherNumber.Update(voucherNumber);
}
// === === === //
foreach (var item in debitVoucherViewModel.DebitVoucherItems)
{
VoucherDetail voucherDetail = new VoucherDetail
{
VoucherNumber = debitVoucherViewModel.VoucherNumber,
Particulars = item.Particulars,
VoucherHeadId = voucherHead.Id,
AccountSubLedgerId = item.LedgerId == 0 ? (int?)null : item.LedgerId,
Ref = item.Ref,
DebitAmount = item.DebitAmount,
CreditAmount = item.CreditAmount
};
if (item.VoucherItemType == "Dr")
{
voucherDetail.TransactionTypes = TransactionTypes.Debit;
}
else if (item.VoucherItemType == "Cr")
{
voucherDetail.TransactionTypes = TransactionTypes.Credit;
}
_work.VoucherDetail.Add(voucherDetail);
}
bool isSaved = _work.Save() > 0;
_sql.DeleteVoucherHead(debitVoucherViewModel.VoucherNumber); //CHANGE ISDELETED & ISACTIVE VALUE
_sql.DeleteVoucherDetail(debitVoucherViewModel.VoucherNumber); //DELETE TEMP VOUCHER DETAILS
if (isSaved)
{
return(Json(true));
}
return(Json(false));
}
}
return(Json(false));
}
public IActionResult DebitVoucher(DebitVoucherViewModel debitVoucherViewModel)
{
if (!string.IsNullOrEmpty(debitVoucherViewModel.VoucherNumber))
{
var tempVoucherHead = _work.TempVoucherHead.GetVoucherNumberWiseVoucher(debitVoucherViewModel.VoucherNumber);
if (tempVoucherHead != null)
{
tempVoucherHead.VoucherNumber = debitVoucherViewModel.VoucherNumber;
tempVoucherHead.EntryDate = Convert.ToDateTime(debitVoucherViewModel.Date);
tempVoucherHead.PaidTo = debitVoucherViewModel.PaidTo;
tempVoucherHead.PreparedBy = debitVoucherViewModel.PreparedBy;
tempVoucherHead.PreparedByUserId = debitVoucherViewModel.PreparedByUserId;
tempVoucherHead.ReceivedBy = debitVoucherViewModel.ReceivedBy;
tempVoucherHead.VoucherSaveState = VoucherSaveStates.Running;
_work.TempVoucherHead.Update(tempVoucherHead);
// === voucher number === //
VoucherNumber voucherNumber = _work.VoucherNumber.Find(x => x.Number == debitVoucherViewModel.VoucherNumber).FirstOrDefault();
if (voucherNumber.State != VoucherSaveStates.Running)
{
voucherNumber.State = VoucherSaveStates.Running;
_work.VoucherNumber.Update(voucherNumber);
}
// === === === //
_sql.DeleteVoucherDetail(debitVoucherViewModel.VoucherNumber); //DELETE PREVIOUS TEMP VOUCHER DETAILS
foreach (var item in debitVoucherViewModel.DebitVoucherItems)
{
TempVoucherDetail tempVoucherDetail = new TempVoucherDetail
{
VoucherNumber = debitVoucherViewModel.VoucherNumber,
Particulars = item.Particulars,
TempVoucherHeadId = tempVoucherHead.Id,
AccountSubLedgerId = item.LedgerId == 0 ? (int?)null : item.LedgerId,
Ref = item.Ref,
DebitAmount = item.DebitAmount,
CreditAmount = item.CreditAmount
};
if (item.VoucherItemType == "Dr")
{
tempVoucherDetail.TransactionTypes = TransactionTypes.Debit;
}
else if (item.VoucherItemType == "Cr")
{
tempVoucherDetail.TransactionTypes = TransactionTypes.Credit;
}
_work.TempVoucherDetail.Add(tempVoucherDetail);
}
bool isSaved = _work.Save() > 0;
if (isSaved)
{
return(Json(true));
}
return(Json(false));
}
}
return(Json(false));
}
