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();
}
}