public IActionResult Get()
{
IActionResult ret = null;
List <Product> list = new List <Product>();
try
{
using (var db = new PtcDbContext())
{
if (db.Products.Count() > 0)
{
list = db.Products.OrderBy(p => p.ProductName).ToList();
ret = StatusCode(StatusCodes.Status200OK, list);
}
else
{
ret = StatusCode(StatusCodes.Status404NotFound, "Can't Find Products");
}
}
}
catch (Exception ex)
{
ret = HandleException(ex, "Exception trying to get all products");
}
return(ret);
}
public IActionResult Put([FromBody] Product entity)
{
IActionResult ret = null;
try
{
using (var db = new PtcDbContext())
{
if (entity != null)
{
db.Update(entity);
db.SaveChanges();
ret = StatusCode(StatusCodes.Status200OK, entity);
}
else
{
ret = StatusCode(StatusCodes.Status400BadRequest, "Invalid object passed to PUT method");
}
}
}
catch (Exception ex)
{
ret = HandleException(ex, "Exception trying to update product: " + entity.ProductId.ToString());
}
return(ret);
}
public IActionResult Delete(int id)
{
IActionResult ret = null;
Product entity = null;
try
{
using (var db = new PtcDbContext())
{
entity = db.Products.Find(id);
if (entity != null)
{
db.Products.Remove(entity);
db.SaveChanges();
}
ret = StatusCode(StatusCodes.Status200OK, true);
}
}
catch (Exception ex)
{
ret = HandleException(ex, "Exception trying to delete product: " + id.ToString());
}
return(ret);
}
public IActionResult Post([FromBody] Product entity)
{
IActionResult ret = null;
try
{
using (var db = new PtcDbContext())
{
if (entity != null)
{
db.Products.Add(entity);
db.SaveChanges();
ret = StatusCode(StatusCodes.Status201Created,
entity);
}
else
{
ret = StatusCode(StatusCodes.Status400BadRequest, "Invalid object passed to POST method");
}
}
}
catch (Exception ex)
{
ret = HandleException(ex, "Exception trying to insert a new product");
}
return(ret);
}
public IActionResult GetByName(string userName)
{
IActionResult ret = null;
AppUser entity = null;
try
{
using (var db = new PtcDbContext())
{
entity = db.Users.Include(item => item.Claims).Where(u => u.UserName == userName).FirstOrDefault <AppUser>();
if (entity != null)
{
ret = StatusCode(StatusCodes.Status200OK, entity);
}
else
{
ret = StatusCode(StatusCodes.Status404NotFound,
"Can't Find Product: " + userName);
}
}
}
catch (Exception ex)
{
ret = HandleException(ex, ex.Message);
}
return(ret);
}
public AppUserAuth ValidateUser(AppUser user)
{
AppUserAuth ret = new AppUserAuth();
AppUser authUser = null;
using (var db = new PtcDbContext())
{
// Attempt to validate user
var result = db.Users.Where(
u => u.UserName.ToLower() == user.UserName.ToLower() &&
u.Password == user.Password);
if (result.Count() > 0)
{
authUser = result.First();
}
}
if (authUser != null)
{
// Build User Security Object
ret = BuildUserAuthObject(authUser);
}
return(ret);
}
// [Authorize]
public IActionResult Get()
{
IActionResult ret = null;
List <Category> list = new List <Category>();
try
{
using (var db = new PtcDbContext())
{
if (db.Categories.Count() > 0)
{
// NOTE: Declare 'list' outside the using to avoid
// it being disposed before it is returned.
list = db.Categories.OrderBy(p => p.CategoryName).ToList();
ret = StatusCode(StatusCodes.Status200OK, list);
}
else
{
ret = StatusCode(StatusCodes.Status404NotFound,
"Can't Find Categories");
}
}
}
catch (Exception ex)
{
ret = HandleException(ex,
"Exception trying to get all Categories");
}
return(ret);
}
protected List <AppRole> GetUserRoles(AppUser authUser)
{
List <AppRole> list = new List <AppRole>();
try
{
using (var db = new PtcDbContext())
{
list.Add(new AppRole()
{
RoleId = 1, RoleName = "AdminUser", UserId = new Guid("898C9784-E31F-4F37-927F-A157EB7CA215")
});
list.Add(new AppRole()
{
RoleId = 2, RoleName = "SuperUser", UserId = new Guid("898C9784-E31F-4F37-927F-A157EB7CA215")
});
list.Add(new AppRole()
{
RoleId = 1, RoleName = "AdminUser", UserId = new Guid("4A1947EC-099C-4532-8105-64CF8C8B4B94")
});
}
}
catch (Exception ex)
{
throw new Exception(
"Exception trying to retrieve user claims.", ex);
}
return(list.Where(item => item.UserId == authUser.UserId).ToList());
}
public AppUserAuth ValidateUser(AppUser user)
{
var ret = new AppUserAuth();
AppUser authuser = null;
try
{
using (var db = new PtcDbContext())
{
authuser = db.Users.Where(
x => x.UserName.ToLower() == user.UserName.ToLower() &&
x.Password == user.Password
).FirstOrDefault();
}
if (authuser != null)
{
ret = BuildUserAuthObject(authuser);
}
}
catch (Exception ex)
{
throw new Exception("Exception while retreving a claim", ex);
}
return(ret);
}
public IActionResult Get(int id)
{
IActionResult ret = null;
Product entity = null;
try
{
using (var db = new PtcDbContext())
{
entity = db.Products.Find(id);
if (entity != null)
{
ret = StatusCode(StatusCodes.Status200OK, entity);
}
else
{
ret = StatusCode(StatusCodes.Status404NotFound,
"Can't Find Product: " + id.ToString());
}
}
}
catch (Exception ex)
{
ret = HandleException(ex,
"Exception trying to retrieve a single product.");
}
return(ret);
}
protected List <AppUserClaim> GetUserClaims(AppUser authUser)
{
List <AppUserClaim> list = new List <AppUserClaim>();
using (var db = new PtcDbContext())
{
list = db.Claims.Where(u => u.UserId == authUser.UserId).ToList();
}
return(list);
}
private List <AppUserClaim> GetUserClaims(AppUser user)
{
List <AppUserClaim> claims = new List <AppUserClaim> ();
try {
using (var db = new PtcDbContext()) {
claims = db.UserClaims.Where(claim => claim.UserId == user.UserId).ToList();
}
} catch (System.Exception ex) {
throw ex;
}
return(claims);
}
protected List <AppUserClaim> GetUserClaims(AppUser authUser)
{
List <AppUserClaim> list = new List <AppUserClaim> ();
try {
using (var db = new PtcDbContext()) {
list = db.Claims.Where(
u => u.UserId == authUser.UserId).ToList();
}
} catch (Exception ex) {
throw new Exception(
"Exception trying to retrieve user claims.", ex);
}
return(list);
}
public AppUserAuth ValidateUser(AppUser user)
{
AppUserAuth ret = new AppUserAuth();
AppUser authUser = null;
using (var db = new PtcDbContext())
{
authUser = db.AppUser.Where(u => u.UserName.ToLower() == user.UserName.ToLower() && u.Password == user.Password).FirstOrDefault();
}
if (authUser != null)
{
ret = BuildUserAuthObject(authUser);
}
return(ret);
}
protected List <AppUserClaim> GetUserClaimes(AppUser user)
{
List <AppUserClaim> list = new List <AppUserClaim>();
try
{
using (var db = new PtcDbContext())
{
list = db.Claims.Where(x => x.UserId == user.UserId).ToList();
}
}
catch (Exception ex)
{
throw new Exception("Exception while retreving a claim", ex);
}
return(list);
}
public AppUserAuth ValidateUser(AppUser user)
{
AppUserAuth userAuth = new AppUserAuth();
List <AppUserClaim> claims = new List <AppUserClaim> ();
try {
using (var db = new PtcDbContext()) {
var authUser = db.Users.FirstOrDefault(usr => usr.UserName.ToLower() == user.UserName && usr.Password == user.Password);
if (authUser != null)
{
userAuth = BuildUserAuthObject(authUser);
}
}
} catch (System.Exception ex) { // Check which one with ex or not that keeps the Call Stack
throw ex;
}
return(userAuth);
}
public AppUserAuth ValidateUser(AppUser user)
{
AppUserAuth ret = new AppUserAuth();
AppUser authUser = null;
using (PtcDbContext db = new PtcDbContext())
{
// Attempt to validate user
authUser = db.Users.FirstOrDefault(u =>
string.Equals(u.UserName, user.UserName, StringComparison.CurrentCultureIgnoreCase) &&
u.Password == user.Password);
}
if (authUser != null)
{
ret = BuildUserAuthObject(authUser);
}
return(ret);
}
public AppUserAuth AuthenticateUser(AppUser user)
{
AppUserAuth ret = new AppUserAuth();
AppUser authUser = null;
using (var db = new PtcDbContext())
{
// Attempt to validate user
authUser = db.Users.Where(u => u.UserName.ToLower() == user.UserName.ToLower() &&
u.Password == user.Password).FirstOrDefault();
}
if (authUser != null)
{
// Build User Security Object
ret = BuildUserAuthObject(authUser);
}
return(ret);
}
public AppUserAuth GetNewUserClaims(AppUser user)
{
AppUserAuth ret = new AppUserAuth();
AppUser authUser = null;
try
{
using (var db = new PtcDbContext())
{
if (user != null)
{
db.Users.Add(user);
db.SaveChanges();
authUser = db.Users.Where(
u => u.UserName.ToLower() == user.UserName.ToLower() &&
u.Password == user.Password).FirstOrDefault();
AppUserClaim userClaim = new AppUserClaim();
userClaim.UserId = authUser.UserId;
userClaim.ClaimType = "CanAccessMenu";
userClaim.ClaimValue = "true";
db.Claims.Add(userClaim);
db.SaveChanges();
if (authUser != null)
{
//build usersecurity object
ret = BuildUserAuthObject(authUser);
}
}
}
} catch (Exception ex) {
throw new Exception(
"Exception trying to create new user.", ex);
}
return(ret);
}
public CategoryController(PtcDbContext db)
{
this.db = db ?? throw new ArgumentNullException(nameof(db));
}
public SecurityManager(PtcDbContext db, JwtSettings _settings)
{
this.db = db ?? throw new ArgumentNullException(nameof(db));
this._settings = _settings ?? throw new ArgumentNullException(nameof(_settings));
}