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));
}
