Ejemplo n.º 1
0
        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));
        }