Ejemplo n.º 1
0
        public ActionResult StudentReport(DateTime fromdate, DateTime todate, Stu_rec sturec)
        {
            //dynamic expando = new ExpandoObject();
            //var marksModel = expando as IDictionary<string, object>;
            List <Stu_rec> sturecord     = new List <Stu_rec>();
            var            receiptdetail = from Recipt_Details in db.Recipt_Details
                                           join tblstudentdata in db.tblstudentdata on Recipt_Details.RollNo equals tblstudentdata.rollno
                                           join Course in db.Courses on Recipt_Details.CourseId equals Course.CourseId
                                           where tblstudentdata.Status == true && Recipt_Details.Date >= fromdate && Recipt_Details.Date <= todate
                                           select new
            {
                ID = Recipt_Details.Id,
                Recipt_Details.RollNo,
                Recipt_Details.Amount,
                Recipt_Details.Date,
                Recipt_Details.ReciptNo,
                Course.CourseName,
                tblstudentdata.name,
            };

            foreach (var item in receiptdetail)
            {
                sturecord.Add(new Stu_rec()
                {
                    id         = item.ID,
                    name       = item.name,
                    RollNo     = item.RollNo,
                    Amount     = item.Amount,
                    CourseName = item.CourseName,
                    Date       = item.Date,
                    ReciptNo   = item.ReciptNo
                });
            }
            return(View(sturecord));
        }
        public ActionResult TotalReport(DateTime fromdate, DateTime todate, Stu_rec sturec)
        {
            //string a = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist();


            ////dynamic expando = new ExpandoObject();
            ////var marksModel = expando as IDictionary<string, object>;
            //List<Stu_rec> sturecord = new List<Stu_rec>();
            //var receiptdetail = from Recipt_Details in db.Recipt_Details.Where(x => x.franchid == a)
            //                    join tblstudentdata in db.tblstudentdata.Where(x => x.uid == a) on Recipt_Details.RollNo equals tblstudentdata.rollno
            //                    join Course in db.Courses.Where(x => x.franchid == a) on Recipt_Details.CourseId equals Course.CourseId
            //                    where tblstudentdata.Status == true && Recipt_Details.Date >= fromdate && Recipt_Details.Date <= todate
            //                    select new
            //                    {
            //                        ID = Recipt_Details.Id,
            //                        Recipt_Details.RollNo,
            //                        Recipt_Details.Amount,
            //                        Recipt_Details.Date,
            //                        Recipt_Details.ReciptNo,
            //                        Course.CourseName,
            //                        tblstudentdata.name,

            //                    };
            //foreach (var item in receiptdetail)
            //{
            //    sturecord.Add(new Stu_rec()
            //    {
            //        id = item.ID,
            //        name = item.name,
            //        RollNo = item.RollNo,
            //        Amount = item.Amount,
            //        CourseName = item.CourseName,
            //        Date = item.Date,
            //        ReciptNo = item.ReciptNo
            //    });
            //}
            return(View(db.tblstudentdata.Where(x => x.Status == true && x.date >= fromdate && x.date <= todate).OrderBy(x => x.date)));
        }