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 Delete(tbl_Project myProject)
{
db.tbl_Projects.DeleteOnSubmit(myProject);
}
public void Add(tbl_Project newProject)
{
db.tbl_Projects.InsertOnSubmit(newProject);
}
public void Add(tbl_Project newProject)
{
db.tbl_Projects.InsertOnSubmit(newProject);
}
private void detach_tbl_Projects(tbl_Project entity)
{
this.SendPropertyChanging();
entity.tbl_Status = null;
}
partial void Deletetbl_Project(tbl_Project instance);
partial void Updatetbl_Project(tbl_Project instance);
partial void Inserttbl_Project(tbl_Project instance);
