HttpStatusCodeResult StartJob(timessheet t)
 {
     db.timessheets.Add(t);
     db.SaveChanges();
     return new HttpStatusCodeResult(200);
 }
        //when job is started by mechanic
        public int TimeSheetStartTime(int? id)
        {
            timessheet tSheet = new timessheet();
            tSheet.JobID = (int)id;
            tSheet.StartTime = DateTime.Now;

            db.timessheets.Add(tSheet);

            job jb = GetJob(id);
            if (jb.Status == "new")
            {
                jb.TimeStarted = DateTime.Now;
            }
            jb.Status = "active";
            db.Entry(jb).State = System.Data.EntityState.Modified;

            mechanic mec = db.mechanics.Find(jb.MechanicID);
            mec.Available = false;
            db.Entry(mec).State = System.Data.EntityState.Modified;
            db.SaveChanges();

            return tSheet.TimeSheetID;
        }