public ActionResult Save(Tbl_Records rec)
        {
            bool status = false;

            if (ModelState.IsValid)
            {
                using (DboKursListesiEntities db = new DboKursListesiEntities())
                {
                    if (rec.recordId > 0)
                    {
                        var v = db.Tbl_Records.FirstOrDefault(a => a.recordId == rec.recordId);
                        if (v != null)
                        {
                            v.CourseName      = rec.CourseName;
                            db.Entry(v).State = EntityState.Modified;
                        }
                    }
                    else
                    {
                        db.Tbl_Records.Add(rec);
                    }
                    db.SaveChanges();
                    status = true;
                }
            }
            return(new JsonResult {
                Data = new { status }
            });
        }
 public JsonResult GetChart()
 {
     using (DboKursListesiEntities db = new DboKursListesiEntities())
     {
         var courses = (from d1 in db.Tbl_Records
                        join d2 in db.Tbl_RecordsInfo on d1.recordId equals d2.recordId
                        select new
         {
             CourseName = d1.CourseName,
             fee = d2.fee
         }).ToArray();
         return(Json(courses, JsonRequestBehavior.AllowGet));
     }
 }
        public ActionResult GetCurrentCourses()
        {
            using (DboKursListesiEntities _db = new DboKursListesiEntities())
            {
                var courses = (from d1 in _db.Tbl_Records
                               select new
                {
                    recordId = d1.recordId,
                    CourseName = d1.CourseName,
                    recordDate = d1.recordDate
                }).OrderByDescending(x => x.recordDate.Value).ToList();

                return(Json(new { data = courses }, JsonRequestBehavior.AllowGet));
            }
        }
 public ActionResult GetCourses()
 {
     using (DboKursListesiEntities db = new DboKursListesiEntities())
     {
         var courses = (from d1 in db.Tbl_Records
                        join d2 in db.Tbl_RecordsInfo on d1.recordId equals d2.recordId
                        select new
         {
             d1.recordId,
             d1.CourseName,
             d1.recordDate,
             d2.InfoId,
             d2.fee,
             d2.date,
         }).OrderByDescending(x => x.date.Value).ToList();
         return(Json(new { data = courses }, JsonRequestBehavior.AllowGet));
     }
 }
        public JsonResult Remove(int InfoId)
        {
            bool status = false;

            using (DboKursListesiEntities _db = new DboKursListesiEntities())
            {
                var record = _db.Tbl_RecordsInfo.FirstOrDefault(a => a.InfoId == InfoId);


                if (record != null)
                {
                    _db.Tbl_RecordsInfo.Remove(record);
                }
                _db.SaveChanges();
                status = true;
            }

            return(new JsonResult {
                Data = new { status = status }
            });
        }