public void SP_Login_WhenPassingEmptyEmailOrPassword_ThrowsArgumentNullException(string email, string password)
{
var inputs = new Models.Database.StoredProcedures.SP_Login.Inputs()
{
Email = email,
Password = password
};
Assert.That(() => _dbCTX.SP_Login(inputs),
Throws.ArgumentNullException);
}
public void SP_Login_WhenPassingValidData_ItRunsCallMethod()
{
var inputs = new Models.Database.StoredProcedures.SP_Login.Inputs()
{
Email = "Username",
Password = "******"
};
var sp = new Mock <Models.Database.ISP <Models.Database.StoredProcedures.SP_Login.Inputs> >();
_dbCTX.SP_Login(inputs, sp.Object);
sp.Verify(s => s.Call(inputs));
}
public void SP_Login_WhenPassingValidData_ItReturnDBResult()
{
var inputs = new Models.Database.StoredProcedures.SP_Login.Inputs()
{
Email = "Username",
Password = "******"
};
var sp = new Mock <Models.Database.ISP <Models.Database.StoredProcedures.SP_Login.Inputs> >();
sp.Setup(s => s.Call(inputs)).Returns(new Models.Database.DBResult());
var result = _dbCTX.SP_Login(inputs, sp.Object);
Assert.That(result, Is.Not.Null);
Assert.That(result, Is.TypeOf(typeof(Models.Database.DBResult)));
}
public IActionResult Login([FromBody] Models.Database.StoredProcedures.SP_Login.Inputs inputs)
{
try
{
var rst = _ctx.SP_Login(inputs);
//Generate JWT
if (rst.ErrorCode == 200)
{
var jwt = Logic.Security.UserJWT.Get(rst, JWTKey, JWTIssuer, _mapper);
rst = new Models.Database.DBResult(200, "", jwt);
}
return(FromDatabase(rst));
}
catch (Exception e)
{
_logger.Add(e, "Error in UsersController.Login(filterParams)");
return(Problem(e.Message, e.StackTrace, 500, "Error in Login"));
}
}
public DBResult SP_Login(Models.Database.StoredProcedures.SP_Login.Inputs inputs,
ISP <Models.Database.StoredProcedures.SP_Login.Inputs> sp = null)
{
if (inputs == null)
{
throw new ArgumentNullException("Invalid inputs data.");
}
if (string.IsNullOrEmpty(inputs.Email) || string.IsNullOrEmpty(inputs.Password))
{
throw new ArgumentNullException("Email and Password could not be empty.");
}
if (sp == null)
{
sp = new FTSS.DP.DapperORM.StoredProcedure.SP_Login(GetConnectionString());
}
var rst = sp.Call(inputs);
return(rst);
}
