// GET: Henkilot
public ActionResult Index()
{
PointSQLSrv1Entities entities = new PointSQLSrv1Entities();
List<Henkilot> model = entities.Henkilot.ToList();
entities.Dispose();
return View(model);
}
public ActionResult HaeTunnit(int id)
{
PointSQLSrv1Entities entities = new PointSQLSrv1Entities();
List<Tunnit> tunnit = (from tu in entities.Tunnit
where tu.Projekti_id == id
select tu).ToList();
//entities.Dispose();
List<Tuntiyhteenveto> result = new List<Tuntiyhteenveto>();
foreach (Tunnit tuntitapahtuma in tunnit)
{
Tuntiyhteenveto data = new Tuntiyhteenveto();
data.Pvm = tuntitapahtuma.Pvm.ToString();
data.Tunnit = tuntitapahtuma.Tunnit1.ToString();
result.Add(data);
}
return Json(result, JsonRequestBehavior.AllowGet);
}