public JsonResult Edit(jobdetail job)
{
using (jQueryAjaxEntities db = new jQueryAjaxEntities())
{
db.Entry(job).State = EntityState.Modified;
db.SaveChanges();
}
return(Json("Success", JsonRequestBehavior.AllowGet));
}
public JsonResult AddJob(jobdetail job)
{
using (jQueryAjaxEntities db = new jQueryAjaxEntities())
{
db.jobdetails.Add(job);
db.SaveChanges();
return(Json("Success"));
}
}
public JsonResult Delete(int id)
{
using (jQueryAjaxEntities db = new jQueryAjaxEntities())
{
jobdetail job = db.jobdetails.Where(x => x.JobID == id).FirstOrDefault <jobdetail>();
db.jobdetails.Remove(job);
db.SaveChanges();
}
return(Json("Success", JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(int?id)
{
jobdetail job = new jobdetail();
using (jQueryAjaxEntities db = new jQueryAjaxEntities())
{
job = db.jobdetails.Where(x => x.JobID == id).FirstOrDefault <jobdetail>();
}
return(View(job));
}
public JsonResult GetJobDetails()
{
using (jQueryAjaxEntities db = new jQueryAjaxEntities())
{
List <jobdetailsDTO> job = db.jobdetails.Select(x => new jobdetailsDTO
{
JobID = x.JobID,
Task_Name = x.Task_Name,
Description = x.Description,
Date_Started = x.Date_Started,
Date_Finished = x.Date_Finished,
Status = x.Status,
}).ToList();
return(Json(job, JsonRequestBehavior.AllowGet));
}
}
