public ActionResult ReportRecords() { //var Date = DateTime.Now.ToString("d/M/yyyy"); //var result = from Voucher in db.Vouchers // join VoucherRecord in db.VoucherRecords on Voucher.Id equals VoucherRecord.VoucherId // join Leadger in db.Ledgers on VoucherRecord.LedgerId equals Leadger.Id // where VoucherRecord.Ledger.Name == "Admin Drawer" && Voucher.Date.ToString() == Date // select new // { // VoucherRecord.Type, // Voucher.Date, // VoucherRecord.Amount, // Voucher.Id, // VoucherRecord.Description, // }; //var x = 0; var result = db.TodayExpense(); return(Json(result, JsonRequestBehavior.AllowGet)); }