public ActionResult Create(JobStatusHistory history) { try { if (ModelState.IsValid) { _unitOfWork.JobStatusHistory.Add(history); _unitOfWork.Complete(); return(RedirectToAction("Index")); } return(View(history)); } catch { return(View()); } }
public ActionResult jobstatushistorydata(int jobsid) { JobStatusHistory objJobStatusHistory = new JobStatusHistory(); List <JobStatusHistory> lststatushistory = new List <JobStatusHistory>(); JobStatusHistory objsummary; DateTime lastDate = Convert.ToDateTime("1/1/2000").Date; int laststaus = 0; var joblist = (from j in DB.tbl_Job_Status_History join S in DB.tbl_Job_Status on j.StatusID equals S.StatusID where j.JobID == jobsid orderby j.StatusDateChanged select new { j, S }).ToList(); foreach (var item in joblist) { objJobStatusHistory.statuses = item.S.Status; lastDate = item.j.StatusDateChanged.Value; objJobStatusHistory.statuschangeddate = item.j.StatusDateChanged.Value.ToShortDateString(); objJobStatusHistory.time = item.j.StatusDateChanged.Value.ToShortTimeString(); if (item.j.ChangedOnTabletYN != false) { objJobStatusHistory.tablet = "YES"; } else { objJobStatusHistory.tablet = "NO"; } objJobStatusHistory.changedto = item.j.ChangedfromTo; objJobStatusHistory.field = item.j.ChangedField; objJobStatusHistory.bywhom = item.j.ChangedBy; objsummary = new JobStatusHistory { statuses = objJobStatusHistory.statuses, statuschangeddate = objJobStatusHistory.statuschangeddate, time = objJobStatusHistory.time, changedto = objJobStatusHistory.changedto, field = objJobStatusHistory.field, bywhom = objJobStatusHistory.bywhom, tablet = objJobStatusHistory.tablet }; lststatushistory.Add(objsummary); } if (laststaus != 6 && laststaus != 7) { var jobrec = (from J in DB.tbl_Job where J.JobID == jobsid select new { J.CallCompleted, J.StatusID }).Single(); if (jobrec.CallCompleted > lastDate) { objJobStatusHistory.statuses = "Completed"; objJobStatusHistory.statuschangeddate = jobrec.CallCompleted.Value.ToShortDateString(); objJobStatusHistory.time = jobrec.CallCompleted.Value.ToShortTimeString(); objJobStatusHistory.tablet = "---"; objJobStatusHistory.changedto = ""; objJobStatusHistory.field = ""; objJobStatusHistory.bywhom = ""; objsummary = new JobStatusHistory { statuses = objJobStatusHistory.statuses, statuschangeddate = objJobStatusHistory.statuschangeddate, time = objJobStatusHistory.time, changedto = objJobStatusHistory.changedto, field = objJobStatusHistory.field, bywhom = objJobStatusHistory.bywhom, tablet = objJobStatusHistory.tablet }; lststatushistory.Add(objsummary); } } return(Json(lststatushistory)); }