public async Task <IActionResult> Edit(Int64 RoleID, [Bind("RoleI, RoleName, IsActive")] LGRole LGRole)
{
if (RoleID != LGRole.RoleID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(LGRole);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LGRoleExists(LGRole.RoleID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(LGRole));
}
public ActionResult <LGRole> Post([FromBody] LGRole model)
{
var serviceResult = _lGRoleService.Create(model);
if (serviceResult.Status == BrashActionStatus.ERROR)
{
return(BadRequest(serviceResult.Message));
}
return(serviceResult.Model);
}
public async Task <IActionResult> Create([Bind("RoleI, RoleName, IsActive")] LGRole LGRole)
{
if (ModelState.IsValid)
{
LGRole.RoleID = GetRandomNumber(1, 10000000);
_context.Add(LGRole);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(LGRole));
}
public ActionResult <LGRole> Delete(int id)
{
var model = new LGRole()
{
LGRoleId = id
};
var serviceResult = _lGRoleService.Delete(model);
if (serviceResult.Status == BrashActionStatus.ERROR)
{
return(BadRequest(serviceResult.Message));
}
return(serviceResult.Model);
}
public ActionResult <LGRole> Put(int id, [FromBody] LGRole model)
{
model.LGRoleId = id;
var serviceResult = _lGRoleService.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 <LGRole> Get(int id)
{
var model = new LGRole()
{
LGRoleId = id
};
var serviceResult = _lGRoleService.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/LoyalGuard";
var project = "LoyalGuard";
var outputPath = $"{path}/{project}.Infrastructure.Test/TestOutput/";
var databaseFile = GetDatabase(outputPath, MethodBase.GetCurrentMethod());
// logger
ILogger logger = GetLogger($"{outputPath}/{MethodBase.GetCurrentMethod()}.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 lGRoleRepository = new LGRoleRepository(databaseManager, new LGRoleRepositorySql(), logger);
Assert.NotNull(lGRoleRepository);
// - service
var lGRoleService = new LGRoleService(lGRoleRepository, logger);
Assert.NotNull(lGRoleService);
// faker
BrashActionResult <LGRole> serviceResult = null;
var lGRoleFaker = new LGRoleFaker(databaseManager, logger);
Assert.NotNull(lGRoleFaker);
// create
var lGRoleCreateModel = lGRoleFaker.GetOne();
serviceResult = lGRoleService.Create(lGRoleCreateModel);
Assert.True(serviceResult.Status == BrashActionStatus.SUCCESS, serviceResult.Message);
Assert.True(serviceResult.Model.LGRoleId > 0);
// use model with id
lGRoleCreateModel = serviceResult.Model;
// update
var lGRoleUpdateModel = lGRoleFaker.GetOne();
lGRoleUpdateModel.LGRoleId = lGRoleCreateModel.LGRoleId;
serviceResult = lGRoleService.Update(lGRoleUpdateModel);
Assert.True(serviceResult.Status == BrashActionStatus.SUCCESS, serviceResult.Message);
// delete
serviceResult = lGRoleService.Delete(lGRoleCreateModel);
Assert.True(serviceResult.Status == BrashActionStatus.SUCCESS, serviceResult.Message);
// fetch
// - make fakes
var fakes = lGRoleFaker.GetMany(10);
// - add fakes to database
List <int?> ids = new List <int?>();
foreach (var f in fakes)
{
serviceResult = lGRoleService.Create(f);
Assert.True(serviceResult.Status == BrashActionStatus.SUCCESS, serviceResult.Message);
Assert.True(serviceResult.Model.LGRoleId >= 0);
ids.Add(serviceResult.Model.LGRoleId);
}
// - get fakes from database
foreach (var id in ids)
{
var model = new LGRole()
{
LGRoleId = id
};
serviceResult = lGRoleService.Fetch(model);
Assert.True(serviceResult.Status == BrashActionStatus.SUCCESS, serviceResult.Message);
Assert.True(serviceResult.Model.LGRoleId >= 0);
}
}
public BrashActionResult <LGRole> Delete(LGRole model)
{
return(Repository.Delete(model));
}
public BrashActionResult <LGRole> Update(LGRole model)
{
return(Repository.Update(model));
}
public BrashActionResult <LGRole> Fetch(LGRole model)
{
return(Repository.Fetch(model));
}
