public IActionResult putBook(mstBook data)
{
try
{
_mstDomain.UpdateData(data);
return(ApiResponse(ApiResullt.Ok, UpdateSuccessful));
}
catch (Exception)
{
return(ApiResponse(ApiResullt.Failed));
}
}
public IActionResult getBook(string description)
{
mstBook paramBook = new mstBook();
List <mstBook> listResult = new List <mstBook>();
try
{
paramBook.Description = description;
listResult = _mstDomain.ReadData(paramBook);
return(ApiResponse(ApiResullt.Ok, listResult));
}
catch (Exception)
{
return(ApiResponse(ApiResullt.Failed));
}
}
public void UpdateData(mstBook data)
{
var uow = new DapperUnitofWork();
try
{
uow.OpenSQLConnection(dbConn);
uow.BeginTransaction();
var repo = new mstBookRepository(uow);
repo.Update(data);
uow.CommitTransaction();
}
catch (Exception)
{
uow.RollbackTransaction();
throw;
}
}
public void DeleteData(string bookID)
{
var uow = new DapperUnitofWork();
var dataBook = new mstBook();
try
{
uow.OpenSQLConnection(dbConn);
uow.BeginTransaction();
var repo = new mstBookRepository(uow);
dataBook.SerialNo = bookID;
repo.Delete(dataBook);
uow.CommitTransaction();
}
catch (Exception)
{
uow.RollbackTransaction();
throw;
}
}
public List <mstBook> ReadData(mstBook parameter)
{
var uow = new DapperUnitofWork();
List <mstBook> listData = new List <mstBook>();
try
{
uow.OpenSQLConnection(dbConn);
var repo = new mstBookRepository(uow);
listData = repo.ReadByFilter(x => x.Description.Contains(parameter.Description)).ToList();
return(listData);
}
catch (Exception)
{
throw;
}
finally
{
uow.Dispose();
}
}
