public ActionResult DeleteConfirmed(int id)
 {
     InvCarRecordType invCarRecordType = db.InvCarRecordTypes.Find(id);
     db.InvCarRecordTypes.Remove(invCarRecordType);
     db.SaveChanges();
     return RedirectToAction("Index");
 }
 public ActionResult Edit([Bind(Include = "Id,Description,SysCode,OdoInterval,DaysInterval")] InvCarRecordType invCarRecordType)
 {
     if (ModelState.IsValid)
     {
         db.Entry(invCarRecordType).State = EntityState.Modified;
         db.SaveChanges();
         return RedirectToAction("Index");
     }
     return View(invCarRecordType);
 }
        public ActionResult Create([Bind(Include = "Id,Description,SysCode,OdoInterval,DaysInterval")] InvCarRecordType invCarRecordType)
        {
            if (ModelState.IsValid)
            {
                db.InvCarRecordTypes.Add(invCarRecordType);
                db.SaveChanges();
                return RedirectToAction("Index");
            }

            return View(invCarRecordType);
        }
 // GET: InvCarRecordTypes/Delete/5
 public ActionResult Delete(int? id)
 {
     if (id == null)
     {
         return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
     }
     InvCarRecordType invCarRecordType = db.InvCarRecordTypes.Find(id);
     if (invCarRecordType == null)
     {
         return HttpNotFound();
     }
     return View(invCarRecordType);
 }
        public ActionResult Create([Bind(Include = "Id,InvItemId,InvCarRecordTypeId,Odometer,dtDone,NextOdometer,NextSched,Remarks")] InvCarRecord invCarRecord)
        {
            if (ModelState.IsValid)
            {
                //get record type
                InvCarRecordType recordType = db.InvCarRecordTypes.Where(r => r.Id == invCarRecord.InvCarRecordTypeId).FirstOrDefault();
                int estOdo  = recordType.OdoInterval;
                int estDays = recordType.DaysInterval;

                //add estimated odometer and next schedule
                invCarRecord.NextOdometer = invCarRecord.Odometer + estOdo;
                invCarRecord.NextSched    = (DateTime)invCarRecord.dtDone.AddDays(estDays);

                db.InvCarRecords.Add(invCarRecord);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.InvCarRecordTypeId = new SelectList(db.InvCarRecordTypes, "Id", "Description", invCarRecord.InvCarRecordTypeId);
            ViewBag.InvItemId          = new SelectList(db.InvItems, "Id", "ItemCode", invCarRecord.InvItemId);
            return(View(invCarRecord));
        }