public JsonResult GetVoucher()
{
var result = (from voucher in db.Vouchers
join record in db.VoucherRecords on voucher.Id equals record.VoucherId
where voucher.Id == record.VoucherId
select new { voucher.Id, voucher.VoucherNo, voucher.Name, record.Description, voucher.Date, record.Amount, record.Type, l_name = record.Ledger.Name }).ToList();
// var voucherresult = db.Vouchers.ToList();
List <Voucher_list> list = new List <Voucher_list>();
foreach (var item in result)
{
Voucher_list vl = new Voucher_list();
vl.ID = item.Id;
vl.VoucherNo = item.VoucherNo;
vl.Name = item.Name;
vl.Notes = item.Description;
vl.Date = item.Date;
vl.Amount = item.Amount;
vl.LedgerName = item.l_name;
vl.type = item.Type;
list.Add(vl);
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
public ActionResult GetCash()
{
var result = db.Vouchers.ToList();
List <Voucher_list> list = new List <Voucher_list>();
foreach (var item in result)
{
Voucher_list vl = new Voucher_list();
vl.Name = item.Name;
vl.Notes = item.Notes;
vl.Date = item.Date;
vl.CreatedBy = item.CreatedBy;
list.Add(vl);
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
