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