public bool RemoveSupplierLogin(SupplierLoginDTO removeEntity)
{
try
{
bool success = UOW.UserRepo.RemoveSupplierLogin(removeEntity);
UOW.SaveChanges();
return(success);
}
catch (Exception ex)
{
UOW.RollbackChanges();
throw ex;
}
}
public bool RemoveSupplierLogin(SupplierLoginDTO removeEntity)
{
try
{
string query = @"
DELETE FROM SupplierLogins
WHERE UserID = @UserID AND SupplierID = @SupplierID";
var queryParameters = new DynamicParameters();
queryParameters.Add("@UserID", removeEntity.UserID);
queryParameters.Add("@SupplierID", removeEntity.SupplierID);
int rowsDeleted = Connection.Execute(query, queryParameters, CurrentTrans);
return((rowsDeleted > 0) ? true : false);
}
catch (Exception ex)
{
throw SqlExceptionHandler.HandleSqlException(ex) ?? ex;
}
}
public async Task <IActionResult> Login(SupplierLoginDTO supplierLoginDTO)
{
var supplier = await _userManager.FindByEmailAsync(supplierLoginDTO.Email);
var result = await _signInManager.CheckPasswordSignInAsync(supplier, supplierLoginDTO.Password, false);
if (result.Succeeded)
{
var appSupplier = await _userManager.Users.FirstOrDefaultAsync(
s => s.Email == supplierLoginDTO.Email.ToUpper()
);
var supplierToReturn = _mapper.Map <SupplierReturnDTO>(appSupplier);
return(Ok(new
{
token = GenerateJwtToken(appSupplier).Result,
supplier = supplierToReturn
}));
}
return(Unauthorized());
}
public bool AddSupplierLogin(SupplierLoginDTO createEntity)
{
try
{
string query = @"
INSERT INTO SupplierLogins(UserID, SupplierID)
VALUES (@UserID, @SupplierID)
SELECT SCOPE_IDENTITY()";
var queryParameters = new DynamicParameters();
queryParameters.Add("@UserID", createEntity.UserID);
queryParameters.Add("@SupplierID", createEntity.SupplierID);
var returnID = Connection.QueryFirst <int>(query, queryParameters, CurrentTrans);
return(returnID > 0);
}
catch (Exception ex)
{
throw SqlExceptionHandler.HandleSqlException(ex) ?? ex;
}
}
