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