public ActionResult Edit([Bind(Include = "productid_fx,missiontype,projmotid_fx,id,code,projectid_fx,fromwhoid_fx,towhoid_fx,fromdate,todate,dad_mission,dad_level,isbottom,request_text,request_file,iscomplete,desc_text,remark,whocreateid_fx,createdate")] FLOW_MISSION fLOW_MISSION)
{
if (ModelState.IsValid)
{
db.Entry(fLOW_MISSION).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
List <FLOW_PRODUCT> categories_prod = FLOW_PRODUCT.GETALL();
ViewData["categories_prod"] = new SelectList(categories_prod, "id", "name");
List <FLOW_PROJECT> categories_proj = FLOW_PROJECT.GETALL();
ViewData["categories_proj"] = new SelectList(categories_proj, "id", "desc_text");
List <SYS_USER> category_user = SYS_USER.GETALL();
ViewData["category_user"] = new SelectList(category_user, "id", "cname");
List <FLOW_PROJMO> categories_projmo = FLOW_PROJMO.GETALL();
ViewData["categories_projmo"] = new SelectList(categories_projmo, "id", "name");
List <DD_MISSIONTYPE> missiontype = DD_MISSIONTYPE.GETALL();
ViewData["missiontype"] = new SelectList(missiontype, "code", "cvalue");
return(View(fLOW_MISSION));
}
// GET: FLOW_MISSION/Edit/5
public ActionResult Edit(int?id)
{
List <FLOW_PRODUCT> categories_prod = FLOW_PRODUCT.GETALL();
ViewData["categories_prod"] = new SelectList(categories_prod, "id", "name");
List <FLOW_PROJECT> categories_proj = FLOW_PROJECT.GETALL();
ViewData["categories_proj"] = new SelectList(categories_proj, "id", "desc_text");
List <SYS_USER> category_user = SYS_USER.GETALL();
ViewData["category_user"] = new SelectList(category_user, "id", "cname");
List <FLOW_PROJMO> categories_projmo = FLOW_PROJMO.GETALL();
ViewData["categories_projmo"] = new SelectList(categories_projmo, "id", "name");
List <DD_MISSIONTYPE> missiontype = DD_MISSIONTYPE.GETALL();
ViewData["missiontype"] = new SelectList(missiontype, "code", "cvalue");
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FLOW_MISSION fLOW_MISSION = db.FLOW_MISSION.Find(id);
if (fLOW_MISSION == null)
{
return(HttpNotFound());
}
return(View(fLOW_MISSION));
}
public ActionResult DeleteConfirmed(int id)
{
FLOW_MISSION fLOW_MISSION = db.FLOW_MISSION.Find(id);
db.FLOW_MISSION.Remove(fLOW_MISSION);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult submission([Bind(Include = "finish_text,productid_fx, missiontype, projmotid_fx, id, code, projectid_fx, fromwhoid_fx, towhoid_fx, fromdate, todate, dad_mission, dad_level, isbottom, request_text, request_file, iscomplete, desc_text, remark, whocreateid_fx, createdate")] FLOW_MISSION fLOW_MISSION)
{
if (ModelState.IsValid)
{
fLOW_MISSION.iscomplete = 1;
fLOW_MISSION.finishdate = DateTime.Now;
db.Entry(fLOW_MISSION).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(fLOW_MISSION));
}
public ActionResult Create([Bind(Include = "productid_fx,missiontype,projmotid_fx,id,code,projectid_fx,fromwhoid_fx,towhoid_fx,fromdate,todate,dad_mission,dad_level,isbottom,request_text,request_file,iscomplete,desc_text,remark,whocreateid_fx,createdate")] FLOW_MISSION fLOW_MISSION)
{
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_MISSION.Where(item => item.id >= 0);
int nowcode = 0, maxid = 0;
if (obj.Count <FLOW_MISSION>() > 0)
{
maxid = obj.Max(item => item.id);
nowcode = maxid + 1;
}
else
{
nowcode = 1;
}
fLOW_MISSION.code = "MIS" + nowcode.ToString().PadLeft(5, '0');
fLOW_MISSION.createdate = DateTime.Now;
fLOW_MISSION.whocreateid_fx = int.Parse(cuuserid);
fLOW_MISSION.fromwhoid_fx = int.Parse(cuuserid);
fLOW_MISSION.iscomplete = int.Parse("0");
if (ModelState.IsValid)
{
db.FLOW_MISSION.Add(fLOW_MISSION);
db.SaveChanges();
return(RedirectToAction("Index"));
}
List <FLOW_PRODUCT> categories_prod = FLOW_PRODUCT.GETALL();
ViewData["categories_prod"] = new SelectList(categories_prod, "id", "name");
List <FLOW_PROJECT> categories_proj = FLOW_PROJECT.GETALL();
ViewData["categories_proj"] = new SelectList(categories_proj, "id", "desc_text");
List <SYS_USER> category_user = SYS_USER.GETALL();
ViewData["category_user"] = new SelectList(category_user, "id", "cname");
List <FLOW_PROJMO> categories_projmo = FLOW_PROJMO.GETALL();
ViewData["categories_projmo"] = new SelectList(categories_projmo, "id", "name");
List <DD_MISSIONTYPE> missiontype = DD_MISSIONTYPE.GETALL();
ViewData["missiontype"] = new SelectList(missiontype, "code", "cvalue");
return(View(fLOW_MISSION));
}
public ActionResult subdetails(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FLOW_MISSION fLOW_MISSION = db.FLOW_MISSION.Find(id);
if (fLOW_MISSION == null)
{
return(HttpNotFound());
}
return(View(fLOW_MISSION));
}
