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 }));
}
