public bool Insert(SiempresaDTO siempresaDTO, int[] sirelempresas) { try { _uow.Begin(); var siempresa = _mapper.Map <Siempresa>(siempresaDTO); var id = _siempresaRepository.Save(siempresa, _uow.Connection, _uow.Transaction); if (id.HasValue) { foreach (var rel in sirelempresas) { _sitipempresaRepository.Save(new Sirelempresa { Emprcodi = id.Value, Tempcodi = rel }, _uow.Connection, _uow.Transaction); } _uow.Commit(); } { _uow.Rollback(); } } catch (Exception e) { _uow.Rollback(); } finally { _uow.Dispose(); } return(true); }
public async Task <IDeleteProductResponseObject> Handle(IDeleteProductRequestObject deleteProductRequestObject) { try { deleteProductRequestObject.Validate(); if (!deleteProductRequestObject.IsValid) { return(new DeleteProductResponseObject((int)HttpStatusCode.BadRequest, deleteProductRequestObject.ValidationNotifications)); } var product = await _unitOfWork.ProductRepository.GetById(deleteProductRequestObject.Id); if (product == null) { return(new DeleteProductResponseObject((int)HttpStatusCode.NotFound, new ValidationNotification(Messages.ProductIdError))); } _unitOfWork.ProductRepository.Delete(product); if (!_unitOfWork.Commit()) { return(new DeleteProductResponseObject((int)HttpStatusCode.InternalServerError, new ValidationNotification(Messages.DatabaseError))); } return(new DeleteProductResponseObject((int)HttpStatusCode.OK)); }catch (Exception e) { return(new DeleteProductResponseObject((int)HttpStatusCode.InternalServerError, new ValidationNotification(Messages.ServerError, e.Message))); } }
public IActionResult Create([FromBody] CustomersRequest customersRequest) { _unitOfWorkDapper.CustomersCommand.Add(customersRequest, 1); var result = _unitOfWorkDapper.Commit(); if (result) { return(Ok(new OkResponse("Movies Added Successfully !"))); } else { return(StatusCode(StatusCodes.Status500InternalServerError, "Something Went Wrong")); } }
public IActionResult MenuCategory(RequestMenuCategoryOrderVM request) { int preference = 1; var listofStoringOrders = new List <MenuCategoryStoringOrder>(); if (request.SelectedOrder != null) { foreach (int menuId in request.SelectedOrder) { listofStoringOrders.Add(new MenuCategoryStoringOrder() { RoleId = request.RoleId, SortingOrder = preference, MenuCategoryId = menuId }); preference += 1; } } _unitOfWorkDapper.OrderingCommand.UpdateMenuCategoryOrder(listofStoringOrders); _unitOfWorkDapper.Commit(); return(View()); }
public int?Save(Seequipo seequipo) { int?id; try { _unitOfWork.Begin(); id = _seequipoRepository.Save(seequipo, _unitOfWork.Connection, _unitOfWork.Transaction); _unitOfWork.Commit(); } catch (Exception e) { _unitOfWork.Rollback(); throw; } return(id); }
public IActionResult Create(CustomersViewModel customersViewModel) { if (ModelState.IsValid) { var userId = Convert.ToInt64(HttpContext.Session.Get <string>(AllSessionKeys.UserId)); _unitOfWorkDapper.CustomersCommand.Add(customersViewModel, userId); var result = _unitOfWorkDapper.Commit(); if (result) { _notificationService.SuccessNotification("Message", "Customer was added Successfully!"); return(Json(new { Result = "success" })); } else { return(Json(new { Result = "failed" })); } } return(Json(new { Result = "failed" })); }
public async Task <IUpdateProductResponseObject> Handle(IUpdateProductRequestObject requestObject) { try { requestObject.Validate(); if (!requestObject.IsValid) { return(new UpdateProductResponseObject((int)HttpStatusCode.BadRequest, requestObject.ValidationNotifications)); } var productExists = await CheckIfProductExists(requestObject.ProductId); if (!productExists) { return(new UpdateProductResponseObject((int)HttpStatusCode.NotFound, new ValidationNotification(Messages.ProductIdError))); } if (await DescriptionExists(requestObject.Description)) { return(new UpdateProductResponseObject((int)HttpStatusCode.BadRequest, new ValidationNotification(Messages.ProductDescriptionExistError))); } Product product = new Product(requestObject.ProductId, requestObject.Description, requestObject.Price); _uow.ProductRepository.Update(product); if (!_uow.Commit()) { return(new UpdateProductResponseObject((int)HttpStatusCode.InternalServerError, new ValidationNotification(Messages.DatabaseError))); } return(new UpdateProductResponseObject(product)); } catch (Exception e) { return(new UpdateProductResponseObject((int)HttpStatusCode.InternalServerError, new ValidationNotification(Messages.ServerError, e.Message))); } }
public async Task <IAddProductResponseObject> Handle(IAddProductRequestObject requestObject) { try { requestObject.Validate(); if (!requestObject.IsValid) { return(new AddProductResponseObject((int)HttpStatusCode.BadRequest, requestObject.ValidationNotifications)); } if (await DescriptionExists(requestObject.Description)) { return(new AddProductResponseObject((int)HttpStatusCode.BadRequest, new ValidationNotification(Messages.ProductDescriptionExistError))); } var product = new Product(Guid.NewGuid(), requestObject.Description, requestObject.Price); _uow.ProductRepository.Add(product); if (!_uow.Commit()) { return(new AddProductResponseObject((int)HttpStatusCode.InternalServerError, new ValidationNotification(Messages.DatabaseError))); } return(new AddProductResponseObject(product)); } catch (Exception e) { return(new AddProductResponseObject((int)HttpStatusCode.InternalServerError, new ValidationNotification(Messages.ServerError, e.Message))); } }