コード例 #1
0
 public ImageModel Create(ImageModel ImageModel)
 {
     _dbReference.ImageModel.Add(ImageModel);
     _dbReference.SaveChanges();
     return(ImageModel);
 }
コード例 #2
0
 public CommentReactionModel Create(CommentReactionModel CommentReactionModel)
 {
     _dbReference.CommentReactionModel.Add(CommentReactionModel);
     _dbReference.SaveChanges();
     return(CommentReactionModel);
 }
コード例 #3
0
 public ReactionModel Create(ReactionModel ReactionModel)
 {
     _dbReference.ReactionModel.Add(ReactionModel);
     _dbReference.SaveChanges();
     return(ReactionModel);
 }
コード例 #4
0
 public FoodItemModel Create(FoodItemModel FoodItemModel)
 {
     _dbReference.FoodItemModel.Add(FoodItemModel);
     _dbReference.SaveChanges();
     return(FoodItemModel);
 }
コード例 #5
0
 public ReviewedRestaurantModel Create(ReviewedRestaurantModel ReviewedRestaurantModel)
 {
     _dbReference.ReviewedRestaurantModel.Add(ReviewedRestaurantModel);
     _dbReference.SaveChanges();
     return(ReviewedRestaurantModel);
 }
コード例 #6
0
ファイル: SqlTag.cs プロジェクト: shimanto7710/review-apis
 public TagModel Create(TagModel TagModel)
 {
     _dbReference.TagModel.Add(TagModel);
     _dbReference.SaveChanges();
     return(TagModel);
 }
コード例 #7
0
 public ReviewedIFoodModel Create(ReviewedIFoodModel ReviewedIFoodModel)
 {
     _dbReference.ReviewedIFoodModel.Add(ReviewedIFoodModel);
     _dbReference.SaveChanges();
     return(ReviewedIFoodModel);
 }
コード例 #8
0
ファイル: SqlBadge.cs プロジェクト: shimanto7710/review-apis
 public BadgeModel CreateBadge(BadgeModel BadgeModel)
 {
     _dbReference.Badge.Add(BadgeModel);
     _dbReference.SaveChanges();
     return(BadgeModel);
 }
コード例 #9
0
 public UserModel CreateUser(UserModel userModel)
 {
     _dbReference.User.Add(userModel);
     _dbReference.SaveChanges();
     return(userModel);
 }
コード例 #10
0
        public IActionResult Auth()
        {
            string Phone = "+8801686352645";

            if (Phone != null)
            {
                //var user = _dbReference.User.AsQueryable();

                var user = _dbReference.User.Where(i => i.PhoneNumber == (Phone));

                //var user=_dbReference.User.FirstOrDefault(user => user.PhoneNumber==Phone);
                //var user = _dbReference.User.FromSql("Select * from Students where Name = 'Bill'");


                // var user = _dbReference.User.FromSqlRaw("SELECT * FROM User Where PhoneNumber == +8801686352645").ToList();



                if (user != null)
                {
                    //create claims details based on the user information
                    var claims = new[] {
                        new Claim(JwtRegisteredClaimNames.Sub, _configuration["Jwt:Subject"]),
                        new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString()),
                        new Claim(JwtRegisteredClaimNames.Iat, DateTime.UtcNow.ToString()),
                        new Claim("PhoneNumber", Phone.ToString()),

                        /* new Claim("FirstName", user.FirstName),
                         * new Claim("LastName", user.LastName),
                         * new Claim("UserName", user.UserName),
                         * new Claim("Email", user.Email)*/
                    };

                    var key = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(_configuration["Jwt:Key"]));

                    var signIn = new SigningCredentials(key, SecurityAlgorithms.HmacSha256);

                    var token = new JwtSecurityToken(_configuration["Jwt:Issuer"], _configuration["Jwt:Audience"], claims, expires: DateTime.UtcNow.AddDays(1), signingCredentials: signIn);

                    return(Ok(new JwtSecurityTokenHandler().WriteToken(token)));
                    //return Ok(user);
                }
                else
                {
                    var newUser = new UserModel();
                    newUser.PhoneNumber = Phone;
                    newUser.BadgeId     = 1;

                    _dbReference.User.Add(newUser);
                    _dbReference.SaveChanges();

                    //create claims details based on the user information
                    var claims = new[] {
                        new Claim(JwtRegisteredClaimNames.Sub, _configuration["Jwt:Subject"]),
                        new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString()),
                        new Claim(JwtRegisteredClaimNames.Iat, DateTime.UtcNow.ToString()),
                        new Claim("PhoneNumber", Phone.ToString()),

                        /* new Claim("FirstName", user.FirstName),
                         * new Claim("LastName", user.LastName),
                         * new Claim("UserName", user.UserName),
                         * new Claim("Email", user.Email)*/
                    };

                    var key = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(_configuration["Jwt:Key"]));

                    var signIn = new SigningCredentials(key, SecurityAlgorithms.HmacSha256);

                    var token = new JwtSecurityToken(_configuration["Jwt:Issuer"], _configuration["Jwt:Audience"], claims, expires: DateTime.UtcNow.AddDays(1), signingCredentials: signIn);

                    return(Ok(new JwtSecurityTokenHandler().WriteToken(token)));
                }
            }
            else
            {
                return(BadRequest());
            }
        }