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)); }