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