public IActionResult GetAll([FromQuery] Models.Database.StoredProcedures.SP_Users_GetAll.Inputs filterParams)
{
filterParams.Token = User.GetToken();
var dbResult = _ctx.SP_Users_GetAll(filterParams);
return(FromDatabase(dbResult));
}
public void SP_Users_GetAll_WhenPassingInvalidData_ThrowsArgumentException(string token, int startIndex, byte pageSize)
{
var inputs = new Models.Database.StoredProcedures.SP_Users_GetAll.Inputs()
{
Token = token,
StartIndex = startIndex,
PageSize = pageSize
};
Assert.That(() => _dbCTX.SP_Users_GetAll(inputs),
Throws.ArgumentException);
}
public void SP_Users_GetAll_WhenPassingValidData_ItRunsCallMethod()
{
var inputs = new Models.Database.StoredProcedures.SP_Users_GetAll.Inputs()
{
Token = "TokenValue",
StartIndex = 1,
PageSize = 10
};
var sp = new Mock <Models.Database.ISP <Models.Database.StoredProcedures.SP_Users_GetAll.Inputs> >();
_dbCTX.SP_Users_GetAll(inputs, sp.Object);
sp.Verify(s => s.Call(inputs));
}
public void SP_Users_GetAll_WhenPassingValidData_ItReturnDBResult()
{
var inputs = new Models.Database.StoredProcedures.SP_Users_GetAll.Inputs()
{
Token = "TokenValue",
StartIndex = 1,
PageSize = 10
};
var sp = new Mock <Models.Database.ISP <Models.Database.StoredProcedures.SP_Users_GetAll.Inputs> >();
sp.Setup(s => s.Call(inputs)).Returns(new Models.Database.DBResult());
var result = _dbCTX.SP_Users_GetAll(inputs, sp.Object);
Assert.That(result, Is.Not.Null);
Assert.That(result, Is.TypeOf(typeof(Models.Database.DBResult)));
}
public IActionResult GetAll([FromBody] Models.Database.StoredProcedures.SP_Users_GetAll.Inputs filterParams)
{
try
{
_logger2.LogWarning("Warning! Get all start", filterParams);
if (!filterParams.IsValid())
{
return(StatusCode(400, filterParams.ValidationResults)); //Bad request
}
filterParams.Token = User.GetToken();
var dbResult = _ctx.SP_Users_GetAll(filterParams);
return(FromDatabase(dbResult));
}
catch (Exception e)
{
_logger.Add(e, "Error in UsersController.GetAll(filterParams)");
return(Problem(e.Message, e.StackTrace, 500, "Error in GetAll"));
}
}
public DBResult SP_Users_GetAll(Models.Database.StoredProcedures.SP_Users_GetAll.Inputs inputs,
ISP <Models.Database.StoredProcedures.SP_Users_GetAll.Inputs> sp = null)
{
if (inputs == null)
{
throw new ArgumentNullException("Invalid inputs data.");
}
if (!inputs.IsValid())
{
throw new ArgumentException("Invalid data.");
}
if (sp == null)
{
sp = new FTSS.DP.DapperORM.StoredProcedure.SP_Users_GetAll(GetConnectionString());
}
var rst = sp.Call(inputs);
return(rst);
}
