public ActionResult Create([Bind(Include = "id,code,productid_fx,startdate,deadline,request_text,request_file,desc_text,remark,whocreateid_fx,createdate")] FLOW_REQUEST fLOW_REQUEST) { Model1 ef = new Model1(); String username = Request.Cookies["username"].Value.ToString(); String cuuserid = ef.SYS_USER.Where(item => item.account_id == username).First <SYS_USER>().id.ToString(); var obj = ef.FLOW_REQUEST.Where(item => item.id >= 0); int nowcode = 0, maxid = 0; if (obj.Count <FLOW_REQUEST>() > 0) { maxid = obj.Max(item => item.id); nowcode = maxid + 1; } else { nowcode = 1; } fLOW_REQUEST.code = "REQ" + nowcode.ToString().PadLeft(5, '0'); fLOW_REQUEST.createdate = DateTime.Now; fLOW_REQUEST.whocreateid_fx = int.Parse(cuuserid); if (ModelState.IsValid) { db.FLOW_REQUEST.Add(fLOW_REQUEST); db.SaveChanges(); return(RedirectToAction("Index")); } List <FLOW_PRODUCT> categories = FLOW_PRODUCT.GETALL(); ViewData["Categories_prod"] = new SelectList(categories, "id", "name"); return(View(fLOW_REQUEST)); }
public ActionResult DeleteConfirmed(int id) { FLOW_REQUEST fLOW_REQUEST = db.FLOW_REQUEST.Find(id); db.FLOW_REQUEST.Remove(fLOW_REQUEST); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,code,productid_fx,startdate,deadline,request_text,request_file,desc_text,remark,whocreateid_fx,createdate")] FLOW_REQUEST fLOW_REQUEST) { if (ModelState.IsValid) { db.Entry(fLOW_REQUEST).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } List <FLOW_PRODUCT> categories = FLOW_PRODUCT.GETALL(); ViewData["Categories_prod"] = new SelectList(categories, "id", "name"); return(View(fLOW_REQUEST)); }
// GET: FLOW_REQUEST/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } FLOW_REQUEST fLOW_REQUEST = db.FLOW_REQUEST.Find(id); if (fLOW_REQUEST == null) { return(HttpNotFound()); } return(View(fLOW_REQUEST)); }
// GET: FLOW_REQUEST/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } FLOW_REQUEST fLOW_REQUEST = db.FLOW_REQUEST.Find(id); if (fLOW_REQUEST == null) { return(HttpNotFound()); } List <FLOW_PRODUCT> categories = FLOW_PRODUCT.GETALL(); ViewData["Categories_prod"] = new SelectList(categories, "id", "name"); return(View(fLOW_REQUEST)); }