Exemplo n.º 1
0
        /// <summary>
        /// Add or update item (NOT IMPLEMENTED)
        /// </summary>
        public Product AddEdit(Product entity)
        {
            var result = entity;

            using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
            {
                dataManager.ExecuteString = "[bot].[Product_AddEdit]";
                dataManager.Add("@ProductBarcode", SqlDbType.NVarChar, ParameterDirection.Input, entity.ProductBarcode);

                var id = dataManager.ExecuteScalar();

                result = Get((int)id);
            }

            return(result);
        }
Exemplo n.º 2
0
        /// <summary>
        /// Add or update item
        /// </summary>
        public Refusal AddEdit(Refusal entity)
        {
            using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
            {
                dataManager.ExecuteString = "[bot].[Refusal_AddEdit]";
                dataManager.Add("@Id", SqlDbType.Int, ParameterDirection.Input, entity.Id);
                dataManager.Add("@RefusalTypeId", SqlDbType.Int, ParameterDirection.Input, entity.RefusalTypeId);
                dataManager.Add("@RefusalComment", SqlDbType.NVarChar, ParameterDirection.Input, entity.RefusalComment);
                dataManager.Add("@UserId", SqlDbType.Int, ParameterDirection.Input, entity.UserId);
                dataManager.Add("@ProductId", SqlDbType.Int, ParameterDirection.Input, entity.ProductId);

                entity.Id = (int)dataManager.ExecuteScalar();
            }

            return(entity);
        }
Exemplo n.º 3
0
        /// <summary>
        /// Add or update item
        /// </summary>
        public RefusalWorkflowStatus AddEdit(RefusalWorkflowStatus entity)
        {
            var result = entity;

            using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
            {
                dataManager.ExecuteString = "[bot].[RefusalWorkflowStatus_AddEdit]";
                dataManager.Add("@ChatId", SqlDbType.BigInt, ParameterDirection.Input, entity.ChatId);
                dataManager.Add("@ProcessStage", SqlDbType.Int, ParameterDirection.Input, (int)entity.ProcessStage);
                dataManager.Add("@UserId", SqlDbType.Int, ParameterDirection.Input, entity.UserId);
                dataManager.Add("@ProductId", SqlDbType.Int, ParameterDirection.Input, entity.ProductId);

                var id = dataManager.ExecuteScalar();

                result = Get((int)id);
            }

            return(result);
        }