public JsonResult GetprojectValue(string getval) { ProjektiYlläpitoEntities2 entity = new ProjektiYlläpitoEntities2(); var singleProject = (from p in entity.Projektit3 where p.Nimi == getval select p).FirstOrDefault(); entity.Dispose(); string json = JsonConvert.SerializeObject(singleProject); return(Json(json, JsonRequestBehavior.AllowGet)); }
public JsonResult ModifyPost(string projectname, string leader, string employee) { ProjektiYlläpitoEntities2 entity = new ProjektiYlläpitoEntities2(); Henkilot3 henkilot = new Henkilot3(); henkilot.Etunimi = employee; henkilot.Esimies = leader; entity.Henkilot3.Add(henkilot); entity.SaveChanges(); entity.Dispose(); return(Json("success")); }
public JsonResult AddProject(string projectname, string leader, DateTime opened) { ProjektiYlläpitoEntities2 en = new ProjektiYlläpitoEntities2(); Projektit3 project = new Projektit3(); project.Nimi = projectname; project.Esimies = leader; project.Avattu = opened; en.Projektit3.Add(project); en.SaveChanges(); en.Dispose(); return(Json("Success")); }
public JsonResult GetProjects() { ProjektiYlläpitoEntities2 yllapito = new ProjektiYlläpitoEntities2(); var projects = (from p in yllapito.Projektit3 select new { ProjectName = p.Nimi, ProjectOpened = p.Avattu, ProjectLeader = p.Esimies }).ToList(); yllapito.Dispose(); string json = JsonConvert.SerializeObject(projects); return(Json(json, JsonRequestBehavior.AllowGet)); }
public JsonResult ClaimHours(string getval) { ProjektiYlläpitoEntities2 entity = new ProjektiYlläpitoEntities2(); var getusers = (from p in entity.Projektit3 join h in entity.Henkilot3 on p.Esimies equals h.Esimies where p.Nimi == getval select new { h.Etunimi, p.Nimi }).ToList(); entity.Dispose(); string json = JsonConvert.SerializeObject(getusers); return(Json(json, JsonRequestBehavior.AllowGet)); }
public JsonResult RemoveProject(string removestring) { ProjektiYlläpitoEntities2 en = new ProjektiYlläpitoEntities2(); var removeproject = (from p in en.Projektit3 where p.Nimi == removestring select p).FirstOrDefault(); if (removeproject != null) { ObjectContext oc = ((IObjectContextAdapter)en).ObjectContext; oc.DeleteObject(removeproject); oc.SaveChanges(); } en.Dispose(); return(Json("Success")); }
public JsonResult GetAllEmployees() { ProjektiYlläpitoEntities2 yllapito = new ProjektiYlläpitoEntities2(); var projects = (from h in yllapito.Henkilot3 join p in yllapito.Projektit3 on h.Esimies equals p.Esimies join t in yllapito.Tunnit3 on h.Henkilot_id equals t.Henkilot_id select new { Employee = h.Etunimi, ProjectName = p.Nimi, Hours = t.Tunnit }).ToList(); yllapito.Dispose(); string json = JsonConvert.SerializeObject(projects); return(Json(json, JsonRequestBehavior.AllowGet)); }
public JsonResult ClaimhoursPost(string projectname, string employee, int hours) { ProjektiYlläpitoEntities2 entity = new ProjektiYlläpitoEntities2(); var henkiloid = (from h in entity.Henkilot3 where h.Etunimi == employee select h.Henkilot_id).FirstOrDefault(); var projectid = (from p in entity.Projektit3 where p.Nimi == projectname select p.Projekti_id).FirstOrDefault(); Tunnit3 tunnit = new Tunnit3(); tunnit.Henkilot_id = henkiloid; tunnit.Projekti_id = projectid; tunnit.Pvm = DateTime.Now; tunnit.Tunnit = hours; entity.Tunnit3.Add(tunnit); entity.SaveChanges(); return(Json("success")); }