public ActionResult Create([Bind(Include = "GenerateID,SerialNumber,DeviceType,CreateBy,UpdateBy,DateCreate,DateUpdate")] SerialNumberGenerate serialnumbergenerate)
        {
            var number = "";
            var srnb   = db.SerialNumberGenerates.Where(g => g.DeviceType == serialnumbergenerate.DeviceType).Select(g => g.SerialNumber).DefaultIfEmpty().First();

            if (srnb == null)
            {
                number = null;
            }
            else if (srnb != null)
            {
                number = db.SerialNumberGenerates.Where(g => g.DeviceType == serialnumbergenerate.DeviceType).OrderByDescending(g => g.GenerateID).First().SerialNumber;
            }
            if (string.IsNullOrEmpty(number))
            {
                number = "0000";
            }

            if (ModelState.IsValid)
            {
                var    template = db.SerialNumberTemplates.Where(t => t.DeviceType == serialnumbergenerate.DeviceType).Select(t => t.TemplateName).DefaultIfEmpty().First();
                string substr   = number.Substring(number.Length - 4);
                int    x        = int.Parse(substr);
                int    val      = x + 1;
                string sr       = val.ToString().PadLeft(4, '0');
                serialnumbergenerate.SerialNumber = template + sr;
                db.SerialNumberGenerates.Add(serialnumbergenerate);
                db.SaveChanges();
                return(RedirectToAction("GenerateSerialNumber", "Dashboard"));
            }
            ViewBag.DeviceType = new SelectList(db.SerialNumberTemplates.OrderBy(s => s.DeviceType), "DeviceType", "DeviceType", serialnumbergenerate.DeviceType);
            return(View(serialnumbergenerate));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            SerialNumberGenerate serialnumbergenerate = db.SerialNumberGenerates.Find(id);

            db.SerialNumberGenerates.Remove(serialnumbergenerate);
            db.SaveChanges();
            return(RedirectToAction("GenerateSerialNumber", "Dashboard"));
        }
 public ActionResult Edit([Bind(Include = "GenerateID,SerialNumber,DeviceType,CreateBy,UpdateBy,DateCreate,DateUpdate")] SerialNumberGenerate serialnumbergenerate)
 {
     if (ModelState.IsValid)
     {
         db.Entry(serialnumbergenerate).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("GenerateSerialNumber", "Dashboard"));
     }
     return(View(serialnumbergenerate));
 }
        public ActionResult Create()
        {
            SerialNumberGenerate serialnumbergenerate = new SerialNumberGenerate();

            serialnumbergenerate.CreateBy   = System.Web.HttpContext.Current.User.Identity.Name;
            serialnumbergenerate.UpdateBy   = System.Web.HttpContext.Current.User.Identity.Name;
            serialnumbergenerate.DateCreate = DateTime.Now;
            serialnumbergenerate.DateUpdate = DateTime.Now;
            ViewBag.DeviceType = new SelectList(db.SerialNumberTemplates.OrderBy(s => s.DeviceType), "DeviceType", "DeviceType", serialnumbergenerate.DeviceType);
            return(View(serialnumbergenerate));
        }
        // GET: /SerialNumberGenerate/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            SerialNumberGenerate serialnumbergenerate = db.SerialNumberGenerates.Find(id);

            if (serialnumbergenerate == null)
            {
                return(HttpNotFound());
            }
            return(View(serialnumbergenerate));
        }