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)); }