public ActionResult Edit(int Project_ID)
{
tbl_Project myProject = db.GetProjectByID(Project_ID);
ViewData["Status"] = new SelectList(statusdb.GetStatus(), "Status_ID", "Status", myProject.Status_ID);
return(View(myProject));
}
public static ProjectModel ToProjectModel(tbl_Project dbModel)
{
return(new ProjectModel()
{
PMCID = dbModel.ProjectId.ToString(),
ProjectName = dbModel.ProjectName
});
}
public ActionResult Delete(int Project_ID)
{
try
{
tbl_Project dbItem = db.GetProjectByID(Project_ID);
db.Delete(dbItem);
db.Save();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ModelState.AddModelError("", "Error: " + ex.Message);
return(RedirectToAction("Details", new { Project_ID = Project_ID, Error = "Error deleting Project!" }));
}
}
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());
}
}
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());
}
}
public static tbl_Project listProjectById(int id)
{
project = db.tbl_Project.First(p => p.projectId == id);
return(project);
}
