예제 #1
0
 public RMAItemDTO AddItemToRMA(CreateRMAItemDTO entityToCreate)
 {
     try
     {
         var rmaItemID = UOW.RMARepo.AddItemToRMA(entityToCreate);
         UOW.SaveChanges();
         return(UOW.RMARepo.GetRMAItemByID(rmaItemID));
     }
     catch (Exception ex)
     {
         UOW.RollbackChanges();
         throw ex;
     }
 }
예제 #2
0
        public int AddItemToRMA(CreateRMAItemDTO entityToCreate)
        {
            try
            {
                string query = @"
                INSERT INTO RMAItems(RMAHeaderID, OrderItemID, RMAItemStatusID, ReturnQty, ReturnToInventory, ReturnReason)
                VALUES(@RMAHeaderID, @OrderItemID, 1, @ReturnQty, @ReturnToInventory, @ReturnReason)

                SELECT SCOPE_IDENTITY()";

                var queryParameters = new DynamicParameters();
                queryParameters.Add("@RMAHeaderID", entityToCreate.RMAID);
                queryParameters.Add("@OrderItemID", entityToCreate.OrderItemID);
                queryParameters.Add("@ReturnQty", entityToCreate.ReturnQty);
                queryParameters.Add("@ReturnToInventory", entityToCreate.ReturnToInventory ? 1 : 0);
                queryParameters.Add("@ReturnReason", entityToCreate.ReturnReason);

                return(Connection.QueryFirst <int>(query, queryParameters, CurrentTrans));
            }
            catch (Exception ex)
            {
                throw SqlExceptionHandler.HandleSqlException(ex) ?? ex;
            }
        }
예제 #3
0
 public RMAItemDTO AddItemToRMA(CreateRMAItemDTO entityToCreate)
 {
     return(_rmaService.AddItemToRMA(entityToCreate));
 }
예제 #4
0
 public ActionResult <RMAItemDTO> AddItemToRMA(CreateRMAItemDTO entityToCreate)
 {
     try { return(_rmaManager.AddItemToRMA(entityToCreate)); }
     catch (BaseCustomException ex) { return(BadRequest(ex.Message)); }
 }