public string AddProject(projectDetails projDetails, int?sno) { projectEstimatorEntities e = new projectEstimatorEntities(); string message = "Project Details are saved successfully..!"; if (sno != null) { projectDetail p = new projectDetail(); p = (from pd in e.projectDetails where pd.sno == sno select pd).SingleOrDefault(); p.projectName = projDetails.ProjectName; p.devActivityHours = JsonConvert.SerializeObject(projDetails); p.Employee = ""; e.SaveChanges(); message = "Project Details are updated successfully..!"; } else { projectDetail p = new projectDetail(); p.projectName = projDetails.ProjectName; p.devActivityHours = JsonConvert.SerializeObject(projDetails); p.Employee = ""; e.projectDetails.Add(p); e.SaveChanges(); } return(message); // View(message, JsonRequestBehavior.AllowGet); }
public ActionResult EditProject(int sno) { projectDetail pd = new projectDetail(); projectEstimatorEntities pe = new projectEstimatorEntities(); pd = (from p in pe.projectDetails where p.sno == sno select p).FirstOrDefault(); return(Json(pd, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteProject(int projectID) { projectDetail p = new projectDetail(); projectEstimatorEntities pe = new projectEstimatorEntities(); p = (from pp in pe.projectDetails where pp.sno.Equals(projectID) select pp).FirstOrDefault(); pe.projectDetails.Remove(p); pe.SaveChanges(); return(Json("Project Deleted Successfully..!", JsonRequestBehavior.AllowGet)); }