public async Task <ActionResult <IEnumerable <SchuelerModel> > > GetSchuelers() { try { //var x = conString; var data = await SchuelerProcessor.LoadSchuelerAsync(ConnectionString); List <SchuelerModel> ViewListeSchueler = new List <SchuelerModel>(); foreach (var item in data) { ViewListeSchueler.Add( new SchuelerModel() { Checkpersonnumber = item.Checkpersonnumber, NName = item.NName, VName = item.VName, EmailAdresse = item.EmailAdresse, Geschlecht = item.Geschlecht, Schuljahr = item.Schuljahr }); } return(ViewListeSchueler); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <ActionResult <SchuelerModel> > GetSchueler(string id) { try { await Task.Delay(10); SchuelerDLModel resultschueler = await SchuelerProcessor.GetByIdSchuelerAsync(ConnectionString, id); SchuelerModel schueler = new SchuelerModel { Checkpersonnumber = resultschueler.Checkpersonnumber, NName = resultschueler.NName, VName = resultschueler.VName, Geschlecht = resultschueler.Geschlecht, EmailAdresse = resultschueler.EmailAdresse, Schuljahr = resultschueler.Schuljahr }; return(schueler); } catch (Exception ex) { throw new Exception(ex.Message); } }
// GET: Schueler public async Task <IActionResult> Index() { var s = User; try { var data = await SchuelerProcessor.LoadSchuelerAsync(ConnectionString); List <SchuelerModel> ViewListeSchueler = new List <SchuelerModel>(); foreach (var item in data) { ViewListeSchueler.Add( new SchuelerModel() { Checkpersonnumber = item.Checkpersonnumber, NName = item.NName, VName = item.VName, EmailAdresse = item.EmailAdresse, Geschlecht = item.Geschlecht, Schuljahr = item.Schuljahr }); } return(View(ViewListeSchueler)); } catch (Exception ex) { return(View(ex.Message)); } }
public async Task <IActionResult> Details(string id) { try { SchuelerDLModel resultschueler = await SchuelerProcessor.GetByIdSchuelerAsync(ConnectionString, id); List <FaecherModel> ViewSchuelerFaecher = new List <FaecherModel>(); foreach (var item in resultschueler.Faecher) { ViewSchuelerFaecher.Add( new FaecherModel() { SkennZahl = item.Skennzahl, Fachbezeichnung = item.Fachbezeichnung }); } SchuelerModel schueler = new SchuelerModel { Checkpersonnumber = resultschueler.Checkpersonnumber, NName = resultschueler.NName, VName = resultschueler.VName, Geschlecht = resultschueler.Geschlecht, EmailAdresse = resultschueler.EmailAdresse, Schuljahr = resultschueler.Schuljahr, Faecher = ViewSchuelerFaecher }; return(View(schueler)); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <IActionResult> Delete_Post(string id) { try { await SchuelerProcessor.DeleteSchuelerAsync(ConnectionString, id); return(RedirectToAction("Index")); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <IActionResult> Edit(string id, SchuelerDLModel changedschueler) { try { var f = await SchuelerProcessor.SaveSchuelerAsync(ConnectionString, id, changedschueler); return(RedirectToAction("Index")); } catch (Exception ex) { return(View(ex.Message)); } }
public async Task <string> PutSchueler(string id, SchuelerDLModel schueler) { try { await Task.Delay(10); await SchuelerProcessor.SaveSchuelerAsync(ConnectionString, id, schueler); return("schueler_updated"); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <ActionResult <string> > DeleteSchueler(string id) { try { await Task.Delay(10); await SchuelerProcessor.DeleteSchuelerAsync(ConnectionString, id); return("schueler_deleted"); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <IActionResult> Create(SchuelerModel neuerschueler) { try { if (ModelState.IsValid) { await SchuelerProcessor.CreateSchuelerAsync(neuerschueler.Checkpersonnumber.ToString(), neuerschueler.NName, neuerschueler.VName, neuerschueler.Geschlecht, neuerschueler.EmailAdresse, neuerschueler.Schuljahr, ConnectionString); } return(RedirectToAction("Index")); } catch (Exception ex) { return(View(ex.Message)); } }
public async Task <ActionResult <string> > PostSchueler(SchuelerModel schueler) { try { await Task.Delay(10); await SchuelerProcessor.CreateSchuelerAsync( schueler.Checkpersonnumber.ToString(), schueler.NName, schueler.VName, schueler.Geschlecht, schueler.EmailAdresse, schueler.Schuljahr, ConnectionString); return("schueler_created"); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <IActionResult> Edit(string id) { try { SchuelerDLModel resultschueler = await SchuelerProcessor.GetByIdSchuelerAsync(ConnectionString, id); SchuelerModel schueler = new SchuelerModel { Checkpersonnumber = resultschueler.Checkpersonnumber, NName = resultschueler.NName, VName = resultschueler.VName, Geschlecht = resultschueler.Geschlecht, EmailAdresse = resultschueler.EmailAdresse, Schuljahr = resultschueler.Schuljahr }; return(View(schueler)); } catch (Exception ex) { return(View(ex.Message)); } }
public async Task <IActionResult> OnPostConfirmationAsync(string returnUrl = null) { returnUrl = returnUrl ?? Url.Content("~/"); // Get the information about the user from the external login provider var info = await _signInManager.GetExternalLoginInfoAsync(); if (info == null) { ErrorMessage = "Error loading external login information during confirmation."; return(RedirectToPage("./Login", new { ReturnUrl = returnUrl })); } if (ModelState.IsValid) { var user = new IdentityUser { UserName = Input.Email, Email = Input.Email }; var result = await _userManager.CreateAsync(user); if (result.Succeeded) { result = await _userManager.AddLoginAsync(user, info); if (result.Succeeded) { // If they exist, add claims to the user for: // Given (first) name // Locale // Picture if (info.Principal.HasClaim(c => c.Type == ClaimTypes.GivenName)) { string firstname = ""; string lastname = ""; string email = ""; string gender = ""; string userid = ""; bool IsTeacher = false; var claims = await _userManager.GetClaimsAsync(user); var x = await _userManager.AddClaimAsync(user, info.Principal.FindFirst(ClaimTypes.GivenName)); x = await _userManager.AddClaimAsync(user, info.Principal.FindFirst(ClaimTypes.Email)); x = await _userManager.AddClaimAsync(user, info.Principal.FindFirst(ClaimTypes.Surname)); x = await _userManager.AddClaimAsync(user, info.Principal.FindFirst(ClaimTypes.NameIdentifier)); foreach (var c in claims) { if (c.Type == ClaimTypes.NameIdentifier) { userid = c.Value; } if (c.Type == ClaimTypes.GivenName) { firstname = c.Value; } if (c.Type == ClaimTypes.Surname) { lastname = c.Value; } if (c.Type == ClaimTypes.Email) { email = c.Value; } //if (c.Type == ClaimTypes.Role && c.Value == "Teacher") // IsTeacher = true; } //var peopleinfo = await GetGoogleData.GetPeopleInfo(credential,userid); var schueler = await SchuelerProcessor.ExistsSchuelerByIdAsync(userid, ConnectionString); if (!schueler) { var breakpoint = 0; await SchuelerProcessor.CreateSchuelerAsync(userid, lastname, firstname, "M", email, 12, ConnectionString); } } // Include the access token in the properties var props = new AuthenticationProperties(); props.StoreTokens(info.AuthenticationTokens); props.IsPersistent = true; //TokenResponse tok = new TokenResponse //{ // AccessToken = props.GetTokenValue("accesstoken"), // TokenType = "Bearer" //}; //var credential = GoogleProviderHelper.CreateUserCredential(info.Principal); //var u = await GetGoogleData.GetClassroomUserProfile(credential); //if (u.VerifiedTeacher.Value) //x = await _userManager.AddClaimAsync(user, new Claim(ClaimTypes.Role, "Teacher")); await _signInManager.SignInAsync(user, isPersistent : false); _logger.LogInformation("User created an account using {Name} provider.", info.LoginProvider); ////// var dd = info.Principal; var userId = await _userManager.GetUserIdAsync(user); var code = await _userManager.GenerateEmailConfirmationTokenAsync(user); code = WebEncoders.Base64UrlEncode(Encoding.UTF8.GetBytes(code)); var callbackUrl = Url.Page( "/Account/ConfirmEmail", pageHandler: null, values: new { area = "Identity", userId = userId, code = code }, protocol: Request.Scheme); await _emailSender.SendEmailAsync(Input.Email, "Confirm your email", $"Please confirm your account by <a href='{HtmlEncoder.Default.Encode(callbackUrl)}'>clicking here</a>."); return(LocalRedirect(returnUrl)); } } foreach (var error in result.Errors) { ModelState.AddModelError(string.Empty, error.Description); } } LoginProvider = info.LoginProvider; ReturnUrl = returnUrl; return(Page()); }