Guest User

Untitled

a guest
Jan 15th, 2018
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.62 KB | None | 0 0
  1. var connection = @"Server={myserver};
  2. Initial Catalog={mydb};Persist Security Info=False;
  3. User ID={myId};Password={mypassword};MultipleActiveResultSets=False;
  4. Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
  5.  
  6. services.AddDbContext<MyContext>(options => options.UseSqlServer(connection));
  7.  
  8. public class MyController : Controller
  9. {
  10. public MyController(MyContext context, SignInManager<MyUser> signInManager, ILogger<AuthController> logger)
  11. {
  12. _context = context;
  13. _signInManager = signInManager;
  14. _logger = logger;
  15. }
  16.  
  17. [HttpPost("myroute")]
  18. public async Task<IActionResult> CreateUser([FromBody] MyUser myUser)
  19. {
  20. try
  21. {
  22. var user = _context.MyUser
  23. .Where(y => y.UserName == myUser.UserName)
  24. .FirstOrDefault();
  25.  
  26. if (user != null)
  27. {
  28. var result = await _signInManager.UserManager.CreateAsync(myUser);
  29.  
  30. if (result.Succeeded) return Ok();
  31. }
  32. }
  33. catch (Exception ex)
  34. {
  35.  
  36. _logger.LogError($"Create User Error: {ex}");
  37. }
  38.  
  39. return BadRequest();
  40. }
  41. }
  42.  
  43. public class MyContext : DbContext
  44. {
  45. public MyContext(DbContextOptions<MyContext> options)
  46. : base(options)
  47. {
  48.  
  49. }
  50. public DbSet<MyApi.DataAccess.Entities.MyUser> MyUser { get; set; }
  51.  
  52. protected override void OnModelCreating(ModelBuilder builder)
  53. {
  54. builder.Entity<MyApi.DataAccess.Entities.MyUser>()
  55. .ToTable("dbo.MyUsers");
  56. }
  57. }
Add Comment
Please, Sign In to add comment