public ActionResult Plus18Check() { DB_A42A9B_Aveleijn2018Entities4 db = new DB_A42A9B_Aveleijn2018Entities4(); ResultVM result = new ResultVM(); result.IndicatieB_id = ViewBag.indicatieB_id; result.Wet = ViewBag.wet; result.Kenmerken_inwoner = ViewBag.kenmerken_inwoner; result.Doel_ondersteuning = ViewBag.doel_ondersteuning; result.Ondersteuning = ViewBag.ondersteuning; result.IndicatieN_id = ViewBag.indicatieN_id; result.GedragsProblematiek = ViewBag.gedragsProblematiek; result.Context = ViewBag.context; result.Escalatie = ViewBag.escalatie; result.Motivatie = ViewBag.motivatie; result.OndersteuningN = ViewBag.ondersteuning; result.Veranderingen = ViewBag.veranderingen; //TODO: Advies if (ViewBag.totaalN) { } return(View(result)); }
// GET: Overzicht public ActionResult Index() { DB_A42A9B_Aveleijn2018Entities4 db = new DB_A42A9B_Aveleijn2018Entities4(); var r1 = db.Clients.Where(c => c.Behandelaar == User.Identity.GetUserId()); return(View(r1)); }
public ActionResult Inzien(string id) { DB_A42A9B_Aveleijn2018Entities4 db = new DB_A42A9B_Aveleijn2018Entities4(); var r1 = db.Formulier_tt.Where(f => f.Clientnummer == id); var r2 = r1.Where(r => r.endTime == null); return(View(r2)); }
public ActionResult SaveConfirm(string clientNummer, string voornaam, string achternaam, DateTime geboorteDatum, string commentaar) { DB_A42A9B_Aveleijn2018Entities4 db = new DB_A42A9B_Aveleijn2018Entities4(); clientnr = clientNummer; if (ModelState.IsValid) { Client client = new Client(); var thisClient = db.Clients.Where(c => c.clientnummer == clientNummer); if (!thisClient.Any()) { client.clientnummer = clientNummer; client.voornaam = voornaam; client.achternaam = achternaam; client.geboortedatum = geboorteDatum; client.Behandelaar = User.Identity.GetUserId(); db.Clients.Add(client); } client2 = client; Result result = new Result(); StringBuilder pickedBuilder = new StringBuilder(); foreach (var item in LocalSaveModel.DomeinBeschrijvingen1) { if (pickedBuilder.Length == 0) { pickedBuilder.Append(item); } else { pickedBuilder.Append("," + item); } } foreach (var item in LocalSaveModel.DomeinBeschrijvingen2) { if (pickedBuilder.Length == 0) { pickedBuilder.Append(item); } else { pickedBuilder.Append("," + item); } } foreach (var item in LocalSaveModel.DomeinBeschrijvingen3) { if (pickedBuilder.Length == 0) { pickedBuilder.Append(item); } else { pickedBuilder.Append("," + item); } } foreach (var item in LocalSaveModel.DomeinBeschrijvingen4) { if (pickedBuilder.Length == 0) { pickedBuilder.Append(item); } else { pickedBuilder.Append("," + item); } } foreach (var item in LocalSaveModel.DomeinBeschrijvingen5) { if (pickedBuilder.Length == 0) { pickedBuilder.Append(item); } else { pickedBuilder.Append("," + item); } } foreach (var item in LocalSaveModel.DomeinBeschrijvingen6) { if (pickedBuilder.Length == 0) { pickedBuilder.Append(item); } else { pickedBuilder.Append("," + item); } } result.pickedBoxes = pickedBuilder.ToString(); result.commentaar = commentaar; result.Indication = "" + LocalSaveModel.EersteDeelIndicatie + " " + LocalSaveModel.TweedeDeelIndicatie + ""; db.Results.Add(result); Formulier_tt formulier_tt = new Formulier_tt(); if (db.Formulier_tt.Any(r => r.Clientnummer == client.clientnummer)) { formulier_tt.result_id = result.result_id; formulier_tt.Clientnummer = client.clientnummer; formulier_tt.endTime = DateTime.UtcNow; formulier_tt.startTime = DateTime.UtcNow; } else { formulier_tt.result_id = result.result_id; formulier_tt.Clientnummer = client.clientnummer; formulier_tt.startTime = DateTime.UtcNow; } db.Formulier_tt.Add(formulier_tt); db.SaveChanges(); } return(new EmptyResult()); }