public AccessToken GenerateToken([FromBody] AccessVM access) { User user; using (var c = new SqlConnection(con.GetConnectionString())) { user = c.QueryFirstOrDefault <User>(Sql.GetUserByIndentity, access, commandTimeout: 3000); } if (user == null) { Response.StatusCode = StatusCodes.Status401Unauthorized; return(new AccessToken { Success = false }); } var claims = new[] { new Claim("Id", user.Id.ToString()), new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString()) }; var key = new SymmetricSecurityKey(Encoding.ASCII.GetBytes(configuration.SecretKey)); var creds = new SigningCredentials(key, SecurityAlgorithms.HmacSha256); var expiredOn = DateTime.Now.AddMinutes(configuration.TokenExpirationTime); var token = new JwtSecurityToken(configuration.ValidIssuer, configuration.ValidAudience, claims, expires: expiredOn, signingCredentials: creds); using (var c = new SqlConnection(con.GetConnectionString())) { c.Execute(Sql.AddJwt, new { UserId = user.Id, Token = new JwtSecurityTokenHandler().WriteToken(token), ExpirationDate = expiredOn }, commandTimeout: 3000); } return(new AccessToken { ExpireOnDate = token.ValidTo, Success = true, ExpiryIn = configuration.TokenExpirationTime, Token = new JwtSecurityTokenHandler().WriteToken(token) }); }
public ActionResult ActivateAllActiveCustomers() { AccessVM model = new AccessVM(); using (CastleClubEntities entities = new CastleClubEntities()) { //SiteDT site = entities.Sites.Where(s=> s.Active == true).ToList().Select(s => s.GetDT()).FirstOrDefault(); //var today = DateTime.Today.AddDays(-2); SiteDT site = SitesManager.GetSite(3); // List<CustomerDT> customers = entities.Customers.Where(c => c.StatusId == "ACTIVE" && c.SiteId == site.Id).ToList().Select(c => c.GetDT(false)).ToList(); List <CustomerDT> customers = entities.Customers.Where(c => c.SiteId == site.Id).ToList().Select(c => c.GetDT(false)).ToList(); //List<CustomerDT> customers = entities.Customers.ToList().Select(c => c.GetDT(false)).ToList(); /*List<int> idList = new List<int>() * { * };*/ string customerAutoPriceDiscount = ""; foreach (CustomerDT custom in customers) { try { /*if (idList.Contains(custom.Id) && custom.Status == DataTypes.Enums.CustomerStatus.ACTIVE) * { * //string response = CustomersManager.NewActivateMember(SitesManager.GetSite(custom.SiteId), custom, "CLOSED"); * string response = CustomersManager.NewActivateMember(SitesManager.GetSite(custom.SiteId), custom, "OPEN"); * } * else * if (idList.Contains(custom.Id) && custom.Status != DataTypes.Enums.CustomerStatus.ACTIVE) * { * string response = CustomersManager.NewActivateMember(SitesManager.GetSite(custom.SiteId), custom, "SUSPEND"); * customerAutoPriceDiscount += custom.Id.ToString() + " \n ,"; * } */ } catch (Exception e) { } // RootObject oMyclass = Newtonsoft.Json.JsonConvert.DeserializeObject<RootObject>(response); } return(View(model)); } }
public Access() { InitializeComponent(); BindingContext = new AccessVM(Navigation); }
public IActionResult Access(AccessVM accessvm) { int id = Int32.Parse(accessvm.strId); return(RedirectToAction("Edit", "RSVP", new { id = id })); }