public ActionResult Edit([Bind(Include = "Id,DownTimeReport,ReportDate,UploadTime,TimeStamp,DayOftheWeek")] DownTimeLossReason downTimeLossReason)
 {
     if (ModelState.IsValid)
     {
         db.Entry(downTimeLossReason).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(downTimeLossReason));
 }
        public ActionResult Create([Bind(Include = "Id,DownTimeReport,ReportDate,UploadTime,TimeStamp,DayOftheWeek")] DownTimeLossReason downTimeLossReason)
        {
            if (ModelState.IsValid)
            {
                downTimeLossReason.DayOftheWeek = DateTime.Today.Date.DayOfWeek.ToString();
                downTimeLossReason.TimeStamp    = DateTime.Now;
                downTimeLossReason.UploadTime   = DateTime.Now.TimeOfDay.ToString();
                db.DownTimeLossReasons.Add(downTimeLossReason);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(downTimeLossReason));
        }
        // GET: DownTimeLossReasons/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            DownTimeLossReason downTimeLossReason = db.DownTimeLossReasons.Find(id);

            if (downTimeLossReason == null)
            {
                return(HttpNotFound());
            }
            return(View(downTimeLossReason));
        }
 public ActionResult RemoveRecord(int id)
 {
     try
     {
         DownTimeLossReason downTimeLossReason = db.DownTimeLossReasons.Find(id);
         db.DownTimeLossReasons.Remove(downTimeLossReason);
         db.SaveChanges();
         return(Json(true, JsonRequestBehavior.AllowGet));;
     }
     catch (Exception)
     {
         return(Json(false, JsonRequestBehavior.AllowGet));;
     }
 }
        public string LoadBulkData(string mydata)
        {
            var serializeData = JsonConvert.DeserializeObject <List <DownTimeLossReason> >(mydata);

            foreach (var data in serializeData)
            {
                DownTimeLossReason postdata = new DownTimeLossReason
                {
                    DownTimeReport = data.DownTimeReport,
                    ReportDate     = data.ReportDate,
                    TimeStamp      = DateTime.Now,
                    UploadTime     = DateTime.Now.TimeOfDay.ToString()
                };
                db.DownTimeLossReasons.Add(postdata);
            }
            db.SaveChanges();
            return(null);
        }