public IActionResult Insert([FromBody] Models.Database.StoredProcedures.SP_User_Insert.Inputs data)
{
data.Token = User.GetToken();
var rst = _ctx.SP_User_Insert(data);
return(FromDatabase(rst));
}
public void SP_User_Insert_WhenPassingInvalidData_ThrowsArgumentException(string token, string email, string lastName, string password)
{
var inputs = new Models.Database.StoredProcedures.SP_User_Insert.Inputs()
{
Token = token,
Email = email,
LastName = lastName,
Password = password
};
Assert.That(() => _dbCTX.SP_User_Insert(inputs),
Throws.ArgumentException);
}
public IActionResult Insert([FromBody] Models.Database.StoredProcedures.SP_User_Insert.Inputs data)
{
try
{
data.Token = User.GetToken();
var rst = _ctx.SP_User_Insert(data);
return(FromDatabase(rst));
}
catch (Exception e)
{
_logger.Add(e, "Error in UsersController.Insert(data)");
return(Problem(e.Message, e.StackTrace, 500, "Error in Insert"));
}
}
public void SP_User_Insert_WhenPassingValidData_ItRunsCallMethod()
{
var inputs = new Models.Database.StoredProcedures.SP_User_Insert.Inputs()
{
Token = "TokenValue",
Email = "email",
LastName = "lastName",
Password = "******"
};
var sp = new Mock <Models.Database.ISP <Models.Database.StoredProcedures.SP_User_Insert.Inputs> >();
_dbCTX.SP_User_Insert(inputs, sp.Object);
sp.Verify(s => s.Call(inputs));
}
public void SP_User_Insert_WhenPassingValidData_ItReturnDBResult()
{
var inputs = new Models.Database.StoredProcedures.SP_User_Insert.Inputs()
{
Token = "TokenValue",
Email = "email",
LastName = "lastName",
Password = "******"
};
var sp = new Mock <Models.Database.ISP <Models.Database.StoredProcedures.SP_User_Insert.Inputs> >();
sp.Setup(s => s.Call(inputs)).Returns(new Models.Database.DBResult());
var result = _dbCTX.SP_User_Insert(inputs, sp.Object);
Assert.That(result, Is.Not.Null);
Assert.That(result, Is.TypeOf(typeof(Models.Database.DBResult)));
}
public DBResult SP_User_Insert(Models.Database.StoredProcedures.SP_User_Insert.Inputs inputs,
ISP <Models.Database.StoredProcedures.SP_User_Insert.Inputs> sp = null)
{
if (inputs == null)
{
throw new ArgumentNullException("Invalid inputs data.");
}
if (!inputs.IsValid())
{
throw new ArgumentException("Invalid input data.");
}
if (sp == null)
{
sp = new FTSS.DP.DapperORM.StoredProcedure.SP_User_Insert(GetConnectionString());
}
var rst = sp.Call(inputs);
return(rst);
}
