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