public ActionResult <ToolsRequired> Post([FromBody] ToolsRequired model)
{
var serviceResult = _toolsRequiredService.Create(model);
if (serviceResult.Status == BrashActionStatus.ERROR)
{
return(BadRequest(serviceResult.Message));
}
return(serviceResult.Model);
}
public ActionResult <ToolsRequired> Delete(int id)
{
var model = new ToolsRequired()
{
ToolsRequiredId = id
};
var serviceResult = _toolsRequiredService.Delete(model);
if (serviceResult.Status == BrashActionStatus.ERROR)
{
return(BadRequest(serviceResult.Message));
}
return(serviceResult.Model);
}
public ActionResult <ToolsRequired> Put(int id, [FromBody] ToolsRequired model)
{
model.ToolsRequiredId = id;
var serviceResult = _toolsRequiredService.Update(model);
if (serviceResult.Status == BrashActionStatus.ERROR)
{
return(BadRequest(serviceResult.Message));
}
if (serviceResult.Status == BrashActionStatus.NOT_FOUND)
{
return(NotFound(serviceResult.Message));
}
return(serviceResult.Model);
}
public ActionResult <ToolsRequired> Get(int id)
{
var model = new ToolsRequired()
{
ToolsRequiredId = id
};
var serviceResult = _toolsRequiredService.Fetch(model);
if (serviceResult.Status == BrashActionStatus.ERROR)
{
return(BadRequest(serviceResult.Message));
}
if (serviceResult.Status == BrashActionStatus.NOT_FOUND)
{
return(NotFound(serviceResult.Message));
}
return(serviceResult.Model);
}
public void CreateUpdateDeleteFetch()
{
// file system
var path = "/shop/randomsilo/modern-web/backends/TodoList";
var project = "TodoList";
var outputPath = $"{path}/{project}.Infrastructure.Test/TestOutput/";
var databaseFile = GetDatabase(outputPath, MethodBase.GetCurrentMethod());
// logger
ILogger logger = GetLogger($"{outputPath}/{MethodBase.GetCurrentMethod().ReflectedType.Name}_{MethodBase.GetCurrentMethod().Name}.log");
// database setup
// - context
IDatabaseContext databaseContext = new DatabaseContext(
$"Data Source={databaseFile}"
, "TestDb"
, "TestSchema"
, $"{path}/sql/sqlite/ALL.sql"
);
Assert.NotNull(databaseContext);
// - manager
IManageDatabase databaseManager = new DatabaseManager(databaseContext);
Assert.NotNull(databaseManager);
// - create tables
databaseManager.CreateDatabase();
// - repository
var toolsRequiredRepository = new ToolsRequiredRepository(databaseManager, new ToolsRequiredRepositorySql(), logger);
Assert.NotNull(toolsRequiredRepository);
// faker
BrashActionResult <ToolsRequired> result = null;
var toolsRequiredFaker = new ToolsRequiredFaker(databaseManager, logger);
Assert.NotNull(toolsRequiredFaker);
// create
var toolsRequiredCreateModel = toolsRequiredFaker.GetOne();
result = toolsRequiredRepository.Create(toolsRequiredCreateModel);
Assert.True(result.Status == BrashActionStatus.SUCCESS, result.Message);
Assert.True(result.Model.ToolsRequiredId > 0);
// use model with id
toolsRequiredCreateModel = result.Model;
// update
var toolsRequiredUpdateModel = toolsRequiredFaker.GetOne();
toolsRequiredUpdateModel.ToolsRequiredId = toolsRequiredCreateModel.ToolsRequiredId;
result = toolsRequiredRepository.Update(toolsRequiredUpdateModel);
Assert.True(result.Status == BrashActionStatus.SUCCESS, result.Message);
// delete
result = toolsRequiredRepository.Delete(toolsRequiredCreateModel);
Assert.True(result.Status == BrashActionStatus.SUCCESS, result.Message);
// fetch
// - make fakes
var fakes = toolsRequiredFaker.GetMany(10);
// - add fakes to database
List <int?> ids = new List <int?>();
foreach (var f in fakes)
{
result = toolsRequiredRepository.Create(f);
Assert.True(result.Status == BrashActionStatus.SUCCESS, result.Message);
Assert.True(result.Model.ToolsRequiredId >= 0);
ids.Add(result.Model.ToolsRequiredId);
}
// - get fakes from database
foreach (var id in ids)
{
var model = new ToolsRequired()
{
ToolsRequiredId = id
};
result = toolsRequiredRepository.Fetch(model);
Assert.True(result.Status == BrashActionStatus.SUCCESS, result.Message);
Assert.True(result.Model.ToolsRequiredId >= 0);
}
}
public BrashActionResult <ToolsRequired> Delete(ToolsRequired model)
{
return(Repository.Delete(model));
}
public BrashActionResult <ToolsRequired> Fetch(ToolsRequired model)
{
return(Repository.Fetch(model));
}
