public ActionResult Create(Category categoryDTOModel)
{
try
{
if (ModelState.IsValid)
{
using (var dapperUnitOfWork = new DapperUnitOfWork())
{
dapperUnitOfWork.CategoryRepository.Add(new DataManagement.Entities.Categories
{
CategoryID = categoryDTOModel.CategoryID,
CategoryName = categoryDTOModel.CategoryName,
Description = categoryDTOModel.Description,
Picture = categoryDTOModel.Picture
});
dapperUnitOfWork.Commit();
return(RedirectToAction("Index"));
}
}
}
catch
{
// Log error
}
return(View());
}
public ActionResult Delete(int?id, FormCollection collection)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
try
{
using (var unitOfWork = new DapperUnitOfWork())
{
unitOfWork.ProductRepository.Remove(new Products {
ProductID = id.Value
});
unitOfWork.Commit();
return(RedirectToAction("Index"));
}
}
catch (Exception exc)
{
// Log Error
}
return(View());
}
public ActionResult Edit(Category categoryDTOModel)
{
try
{
if (ModelState.IsValid)
{
using (var unitOfWork = new DapperUnitOfWork())
{
var category = new Categories
{
CategoryID = categoryDTOModel.CategoryID,
CategoryName = categoryDTOModel.CategoryName,
Description = categoryDTOModel.Description,
Picture = categoryDTOModel.Picture
};
unitOfWork.CategoryRepository.Update(category);
unitOfWork.Commit();
return(RedirectToAction("Index"));
}
}
}
catch
{
// Log Error
}
return(View());
}
public void Commit_WillCallSaveChangesOnce()
{
// Arrange
var mockConnection = new Mock <IDbConnection>();
var mockTransaction = new Mock <IDbTransaction>();
var mockConnectionFactory = new Mock <IConnectionFactory>();
mockConnection.Setup(mc => mc.BeginTransaction()).Returns(mockTransaction.Object);
mockConnectionFactory.Setup(cf => cf.Connection).Returns(mockConnection.Object);
var dapperUnitOfWork = new DapperUnitOfWork(mockConnectionFactory.Object);
// Act
dapperUnitOfWork.BeginTransaction();
dapperUnitOfWork.Commit();
//// Assert
mockTransaction.Verify(x => x.Commit(), Times.Once);
}
public IActionResult Delete(int id)
{
try
{
int x;
using (DapperUnitOfWork uow = new DapperUnitOfWork(_connectionString))
{
if (uow.MovieRepository.GetById(id) == null)
{
return(NotFound());
}
x = uow.MovieRepository.Delete(id);
uow.Commit();
}
}
catch (Exception)
{
return(BadRequest());
}
return(NoContent());
}
public IActionResult Create([FromBody] Movie movie)
{
int x;
try
{
if (movie == null)
{
return(BadRequest());
}
using (DapperUnitOfWork uow = new DapperUnitOfWork(_connectionString))
{
x = uow.MovieRepository.Add(movie);
uow.Commit();
}
}
catch (Exception ex)
{
return(BadRequest());
}
return(Ok(x));
}
public ActionResult Edit(int id, Product model)
{
try
{
if (ModelState.IsValid)
{
using (var unitOfWork = new DapperUnitOfWork())
{
var product = new Products
{
CategoryID = model.CategoryID,
Discounted = model.Discounted,
ProductID = model.ProductID,
ProductName = model.ProductName,
QuantityPerUnit = model.QuantityPerUnit,
ReorderLevel = model.ReorderLevel,
SupplierID = model.SupplierID,
UnitPrice = model.UnitPrice,
UnitsInStock = model.UnitsInStock,
UnitsOnOrder = model.UnitsOnOrder
};
unitOfWork.ProductRepository.Update(product);
unitOfWork.Commit();
return(RedirectToAction("Index"));
}
}
return(RedirectToAction("Index"));
}
catch (Exception exc)
{
// TODO: Log
}
return(View());
}
public ActionResult Delete(int?id, Category categoryDTOModel)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
try
{
using (var unitOfWork = new DapperUnitOfWork())
{
unitOfWork.CategoryRepository.RemoveById(id.Value);
unitOfWork.Commit();
return(RedirectToAction("Index"));
}
}
catch (Exception exc)
{
// Log Error
}
return(View());
}
public ActionResult Create(Product model)
{
try
{
if (ModelState.IsValid)
{
using (var dapperUnitOfWork = new DapperUnitOfWork())
{
dapperUnitOfWork.ProductRepository.Add(new DataManagement.Entities.Products
{
CategoryID = model.CategoryID,
Discounted = model.Discounted,
ProductID = model.ProductID,
ProductName = model.ProductName,
QuantityPerUnit = model.QuantityPerUnit,
ReorderLevel = model.ReorderLevel,
SupplierID = model.SupplierID,
UnitPrice = model.UnitPrice,
UnitsInStock = model.UnitsInStock,
UnitsOnOrder = model.UnitsOnOrder
});
dapperUnitOfWork.Commit();
return(RedirectToAction("Index"));
}
}
return(RedirectToAction("Index"));
}
catch (Exception exc)
{
// Log
}
return(View());
}
public IActionResult Update(int id, [FromBody] Movie item)
{
try
{
if (item == null || item.Id != id)
{
return(BadRequest());
}
using (DapperUnitOfWork uow = new DapperUnitOfWork(_connectionString))
{
if (uow.MovieRepository.GetById(item.Id) == null)
{
return(NotFound());
}
int x = uow.MovieRepository.Update(item);
uow.Commit();
}
}
catch (Exception ex)
{
return(BadRequest());
}
return(NoContent());
}
