public ActionResult Create(tbl_Project myProject) { ViewData["Status"] = new SelectList(statusdb.GetStatus(), "Status_ID", "Status"); if (!myProject.Project_Number.HasValue) ModelState.AddModelError("Project_Number", "Project Number is Required"); if (myProject.SAP_Number.Trim().Length == 0) ModelState.AddModelError("SAP_Number", "SAP Number is Required"); if (myProject.WBS.Trim().Length == 0) ModelState.AddModelError("WBS", "WBS is Required"); if (myProject.Project_Name.Trim().Length == 0) ModelState.AddModelError("Project_Name", "Project Name is Required"); if (!myProject.Status_ID.HasValue) ModelState.AddModelError("Status_ID", "Status is Required"); if (!ModelState.IsValid) { return View(); } try { db.Add(myProject); db.Save(); return RedirectToAction("Index"); } catch (Exception ex) { ModelState.AddModelError("", "Error: " + ex.Message); return View(); } }
private void detach_tbl_Projects(tbl_Project entity) { this.SendPropertyChanging(); entity.tbl_Status = null; }
public ActionResult Edit(tbl_Project myProject) { if (!myProject.Project_Number.HasValue) ModelState.AddModelError("Project_Number", "Project Number is Required"); if (myProject.SAP_Number.Length == 0) ModelState.AddModelError("SAP_Number", "SAP Number Required"); if (myProject.WBS.Trim().Length == 0) ModelState.AddModelError("WBS", "WBS Required"); if (myProject.Project_Name.Trim().Length == 0) ModelState.AddModelError("Project_Name", "Project Name Required"); if (!ModelState.IsValid) { ViewData["Status"] = new SelectList(statusdb.GetStatus(), "Status_ID", "Status", myProject.Status_ID); return View(myProject); } try { tbl_Project dbProject = db.GetProjectByID(myProject.Project_ID); dbProject.Project_Number = myProject.Project_Number; dbProject.SAP_Number = myProject.SAP_Number; dbProject.Project_Name = myProject.Project_Name; dbProject.WBS = myProject.WBS; dbProject.Status_ID = myProject.Status_ID; db.Save(); return RedirectToAction("Details", new { Project_ID = myProject.Project_ID }); } catch (Exception ex) { ModelState.AddModelError("", "Error: " + ex.Message); return View(); } }
partial void Updatetbl_Project(tbl_Project instance);
partial void Deletetbl_Project(tbl_Project instance);
public void Delete(tbl_Project myProject) { db.tbl_Projects.DeleteOnSubmit(myProject); }
partial void Inserttbl_Project(tbl_Project instance);
public void Add(tbl_Project newProject) { db.tbl_Projects.InsertOnSubmit(newProject); }