public ActionResult Edit() { if (ModelState.IsValid) { try { TB_Schedule tb_Schedule = new TB_Schedule { BId = Convert.ToInt32(Request.Params["BId"]), FId = Convert.ToInt32(Request.Params["FId"]), FinishDate = Convert.ToDateTime(Request.Params["FollowDate"]) //FinishDate = DateTime.Today }; db.TB_Schedule.Add(tb_Schedule); db.SaveChanges(); var lg = ((TB_LoginOn)Session["LoginName"]).AId; if (lg == 2) { TB_BugSubmit YN = db.TB_BugSubmit.Where(t => t.BId == tb_Schedule.BId).FirstOrDefault(); YN.YN = "Y"; db.SaveChanges(); } return(RedirectToAction("Index")); } catch (Exception ex) { return(RedirectToAction("Edit")); } } return(View()); }
public ActionResult Update(int id) { TB_Schedule tb = db.TB_Schedule.Find(id); if (tb != null) { int bid = tb.BId; TB_BugSubmit YN = db.TB_BugSubmit.Where(t => t.BId == bid).FirstOrDefault(); YN.YN = "Y"; db.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Details(int?id) { if (id == null) { return(View()); } SubBugEntities db = new SubBugEntities(); TB_BugSubmit follow = db.TB_BugSubmit.Find(id);//db.TB_BugSubmit.Include(t => t.Follow).Where(t => t.BId == id); //var follow =db.TB_Follow.Where(t => t.BId == id); if (follow == null) { return(HttpNotFound()); } return(View(follow)); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TB_BugSubmit tB_BugSubmit = db.TB_BugSubmit.Find(id); //ViewBag.BId = new SelectList(db.TB_BugSubmit.Where(t => t.YN == "N").Where(t => t.BId != t.Follow.FirstOrDefault().BId), "BId", "AppName"); ViewBag.LId = new SelectList(db.TB_LoginOn.Where(t => t.AId != 1), "LId", "LoginName"); if (tB_BugSubmit == null) { return(HttpNotFound()); } return(View(tB_BugSubmit)); }
public ActionResult Create([Bind(Include = "FinishDate,BId,FId")] TB_Schedule tB_Schedule) { if (ModelState.IsValid) { db.TB_Schedule.Add(tB_Schedule); var lg = ((TB_LoginOn)Session["LoginName"]).AId; if (lg == 2) { TB_BugSubmit YN = db.TB_BugSubmit.Where(t => t.BId == tB_Schedule.BId).FirstOrDefault(); YN.YN = "Y"; } db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BId = new SelectList(db.TB_BugSubmit, "BId", "AppName", tB_Schedule.BId); return(View(tB_Schedule)); }
public async Task <ActionResult> Create(TB_BugSubmit model) { if (Session["LoginName"] != null) { model.LId = ((TB_LoginOn)Session["LoginName"]).LId; model.Claimant = ((TB_LoginOn)Session["LoginName"]).LoginName; model.LPhone = ((TB_LoginOn)Session["LoginName"]).LPhone; model.ComputerNo = ((TB_LoginOn)Session["LoginName"]).ComputerNo; } else { if (ModelState.IsValid) { model.LId = 1; model.AppName = Request.Params["AppName"].ToUpper(); model.Describe = Request.Params["Describe"]; model.Claimant = Request.Params["Claimant"].ToUpper(); model.LPhone = Request.Params["LPhone"].ToUpper(); model.ComputerNo = Request.Params["ComputerNo"].ToUpper(); } } model.LIP = System.Web.HttpContext.Current.Request.UserHostAddress; model.SubDate = DateTime.Now; model.YN = "N"; using (SubBugEntities db = new SubBugEntities()) { try { db.TB_BugSubmit.Add(model); await db.SaveChangesAsync(); return(RedirectToAction("Index", "Home")); } catch { return(View()); } } }